Code Fix: An error occurs when multiple K2 Servers attempt to complete a sync
KB003189
PRODUCTK2 Five 5.2
K2 Five (5.2) May 2019 Cumulative Update
K2 Five (5.2) May 2019 Cumulative Update Fix Pack 1
Issue Description
An error occurs when multiple K2 Servers attempt to complete a sync via the SyncEngine.
Error Message
The following error occurs and is visible in the hostserver log file: “Violation of PRIMARY KEY constraint 'PK_Identity_IdentityMember'. Cannot insert duplicate key in object 'Identity.IdentityMember'”.
Resolution
- Ensure you have K2 Five (5.2) installed.
- Download and install the K2 Five (5.2) May 2019 Cumulative Update from K2 Partner and Customer Portal.
- Download the K2 Five (5.2) May 2019 Cumulative Update FP1 from K2 Partner and Customer Portal.
- Install the K2 Five (5.2) May 2019 Cumulative Update FP1 to apply the fix.