Code Fix: An error occurs when running a sync on an environment with SQL Server 2014
KB002962
PRODUCTK2 Five 5.2
K2 Five (5.2) Fix Pack 21
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”.
Resolution
- Ensure you have K2 Five (5.2) installed.
- Download the K2 Five (5.2) FP21 from K2 Partner and Customer Portal.
- Install the K2 Five (5.2) FP21 to apply the fix.