< class="prominent-subhead ">

Code Fix: Error occurs after installing K2 5.2 Fix pack 21, which results in the K2 Host Service not working.


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."”


Issue introduced by K2 5.2 FP 21


  1. Ensure you have K2 Five (5.2) installed.
  2. Download the K2 Five (5.2) FP33 from K2 Partner and Customer Portal.
  3. Install the K2 Five (5.2) FP33 to apply the fix.