If the environment has SQL 2014 and large data in the below 3 columns, then the index (IX_SyncEngine_IdentityProperty_ProviderInstanceID_Name_Value) fails to create when the Entity Framework migration executes, which then prevents the K2 server from starting up correctly.
In the SyncEngine.IdentityProperty table:
The following error occurs: “MigrateDatabase.Execute: Logged Error: Failed: System.Data.SqlClient.SqlException (0x80131904): Operation failed. The index entry of length 1050 bytes for the index 'IX_SyncEngine_IdentityProperty_ProviderInstanceID_Name_Value' exceeds the maximum length of 900 bytes.
Warning! The maximum key length is 900 bytes. The index 'IX_SyncEngine_IdentityProperty_ProviderInstanceID_Name_Value' has maximum length of 1540 bytes. For some combination of large values, the insert/update operation will fail.
The statement has been terminated."”
Issue introduced by K2 5.2 FP 21
- Ensure you have K2 Five (5.2) installed.
- Download the K2 Five (5.2) FP33 from K2 Partner and Customer Portal.
- Install the K2 Five (5.2) FP33 to apply the fix.