Issue Description

When running a sync via the SyncEngine, slow performance is experienced and an error is visible in the HostServer log file.

Error Message

The following error is visible in the HostServer log file: "Transaction (Process ID 54) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction".

Cause

When identities are synced and the provider (K2SQL, AAD, AD) returns users, groups or properties that was already synced, it was picked up as a change to the identity and in turn generated more and larger sql commands.

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.