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

[#1]

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

KB003430

PRODUCT

K2 Five 5.2 to 5.3

K2 Five (5.2) May 2019 Cumulative Update

K2 Five (5.2) May 2019 Cumulative Update Fix Pack 25 to K2 Five (5.3) Fix Pack 31

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.