hi,
I'm trying to add a group in another group and I get the following error:
[DM_GROUP_E_ERROR_UPDATING_SUBGROUPS]error: "Error updating subgroups of group grp_xxxxx to reflect changes in the group heirarchy."; ERRORCODE: 100; NEXT: DfException:: THREAD: main; MSG: [DM_OBJ_MGR_E_SAVE_FAIL]error: "save failed for object with handle 1200xxxxxxx33590 of type dm_group: table on which save failed was dm_group_r; error from database system was -- Object already exists -- STATE=23000, CODE=2601, MSG=[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'dbo.dm_group_r' with unique index 'd_1f00xxxxxxx00108'. The duplicate key value is (1200xxxxxxx33590, -940).
"; ERRORCODE: 100; NEXT: null
the problem is that when adding a group, the system tries to add a row in table dm_group_r on a position (-940) that is already used. the groups I'm adding is different than the group indicated on position -940 with id 1200xxxxxxx33590. the positions are managed internally so how to fix this?
thanks for any help