Code Fix: An error occurs when you run a Sync and an Azure Active Directory group name contains a space

Issue Description


An error occurs when you run a Sync via the SyncEngine, and an Azure Active Directory group name contains a space before or after the group name.

Error Message


The following error occurs: “Error 547, Level 16, State 0, Procedure SaveIdentities, Line 22The MERGE statement conflicted with the CHECK constraint "CK_Identity_Name_Label_FQN". The conflict occurred in database”.

Resolution

The fix is available in the following K2 versions:

K2 4.7 March 2018 Cumulative Update K2 Five (5.0) September 2018 Cumulative Update K2 Five (5.1) November 2018 Cumulative Update K2 Five (5.2) May 2019 Cumulative Update K2 Five (5.3)
X X X Fix Pack 25 Fix Pack 31
  1. Ensure you have the correct K2 version and/or Cumulative Update installed. See KB001893 to see what Fix Pack level you have installed.
  2. Download the latest Fix Pack using the links in the table above for the version you require.
  3. Install the Fix Pack to apply the fix.
  4. Run the Sync again.