Issue Description

When you run a sync via the Sync Engine on an environment with SQL Server 2014 or older, an error occurs.

Error Message

The following error occurs: “Operation failed. The index entry of length 922 bytes for the index 'IX_SyncEngine_IdentityProperty_ProviderInstanceID_Name_Value' exceeds the maximum length of 900 bytes”.


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