Code Fix: Error occurs after installing K2 5.2 Fix pack 21, which results in the K2 Host Service not working.
KB003113
PRODUCT
Issue Description
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:
- ProviderInstanceID
- Name
- Value
Error Message
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."”
Cause
Issue introduced by K2 5.2 FP 21
Resolution
- 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.