Code Fix: An error occurs when multiple K2 Servers attempt to complete a sync

KB003189

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

1. Ensure you have K2 Five (5.2) installed.
2. Download and install the K2 Five (5.2) May 2019 Cumulative Update from K2 Partner and Customer Portal.
3. Download the K2 Five (5.2) May 2019 Cumulative Update FP1 from K2 Partner and Customer Portal.
4. Install the K2 Five (5.2) May 2019 Cumulative Update FP1 to apply the fix.