When attempting to follow the steps:
1. Create a new CSMRoot and Synchronize it into the UCIRoot table
2. Have some UNSAccountB, UNSGroupB, and memberships in the UNSAccountBInUNSGroupB table
3. Change the configuration on CSMRoot/UCIRoot to have all group types available and the concept: User stores memberships
4. Confirm that there is no data in any table UCIUser(In|Has)Group% tables
Instead of allowing the configuration change, the trigger on UCIRoot returns the following error:
Error running synchronization project (Universal Cloud Interface synchronization of ServiceNow via One Identity Starling Connect (SQLSERVER\IdentityManager))'s workflow (Provisioning).
[1777124] Error running synchronization step (Cloud applications) of synchronization configuration (Provisioning (Provisioning)).
[1777004] Method (Update object (Update)) could not be run successfully.
[810391] Error applying changes to database.
[810023] Error running statement: update UCIRoot set AlternatePropertyCaptions = N'<?xml version="1.0" encoding="utf-16"?>
<AlternatePropertyCaptions>
<Table Name="CSMContainer" />
<Table Name="CSMGroup" />
<Table Name="CSMItem" />
<Table Name="CSMGroup1" />
<Table Name="CSMUser" />
</AlternatePropertyCaptions>', GroupUsageMask = 3, UserContainsGroupList = 2, xdateupdated = GetUTCDate(), xuserupdated = N'Synchronization' where (UCIRoot.UID_UCIRoot = 'UID')
[810143] Database error 50000: UserContainsGroupList cannot be changed because data already exists.
[810143] Database error 50000: detected in (SRV=SQLSERVER, DB=IdentityManager) procedure UCI_TUUCIRoot Line 12
This is due to Defect 487056.
WORKAROUND: Please contact Support for a copy of the hotfix for Defect 487056.
STATUS: Waiting for a fix in a future version of Identity Manager.
© 2025 One Identity LLC. ALL RIGHTS RESERVED. Termini di utilizzo Privacy Cookie Preference Center