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 |
- Ensure you have the correct K2 version and/or Cumulative Update installed. See KB001893 to see what Fix Pack level you have installed.
- Download the latest Fix Pack using the links in the table above for the version you require.
- Install the Fix Pack to apply the fix.
- Run the Sync again.