If an environment has SQL 2014 installed with large data in the 3 columns below, then the index (IX_SyncEngine_IdentityProperty_ProviderInstanceID_Name_Value) fails to create when the Entity Framework migration executes, which 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.3) installed.
- Download the K2 Five (5.3) FP1 from K2 Partner and Customer Portal.
- Install the K2 Five (5.3) FP1 to apply the fix.