Installation Health Error
A fresh install of K2 blackpearl 4.7 fails on Installation Health with the following error appearing:
"Script execute failed: System.Exception: Script execution exception:
Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch.
The MERGE statement conflicted with the REFERENCE constraint "FK_Form_ControlTypeImplementation_ControlType". The conflict occurred in database "K2", table "Form.ControlTypeImplementation", column 'ControlTypeID'.
Group run failed with exception: System.Exception:
Target failed to execute: SourceCode.Data.Form_Form.inject.sql
Target did not complete successfully: Inject Scripts"
SymptomsThe Setup Manager created the K2 database on an SQL server instance which may not be of a supported collation and/or version.
Ensure that the SQL server adheres to the prerequisites of the K2 version you are installing.
You may refer to the following documentation for more details: