Dynamics Community Forum Thread Details

Unable to delete duplicate SecurityUserRoleOrganizations

Hello,

Somehow we have some SecurityUserRoleOrganizations that are duplicated. I can see that this request returns multiple that differ only in etag.

GET <base_url>/data/SecurityUserRoleOrganizations?$filter=UserId eq 'SOME_USER'

{
"@odata.etag": "<etag>",
"UserId": "SOME_USER",
"SecurityRoleIdentifier": "<SecurityRoleIdentifier>",
"OrganizationType": "LegalEntity",
"OrganizationId": "LE1",
"OperatingUnitType": "None",
"HierarchyType": ""
},

{
"@odata.etag": "<a different etag>",
"UserId": "SOME_USER",
"SecurityRoleIdentifier": "<SecurityRoleIdentifier>",
"OrganizationType": "LegalEntity",
"OrganizationId": "LE1",
"OperatingUnitType": "None",
"HierarchyType": ""
}

The problem is that if we try to delete this object, Dynamics returns an error because we are trying to delete multiple entities at the same time.

DELETE <base_url>/data/SecurityUserRoleOrganizations(UserId='SOME_USER',SecurityRoleIdentifier='<SecurityRoleIdentifier>',OrganizationType=Microsoft.Dynamics.DataEntities.OMInternalOrganizationType'LegalEntity',OrganizationId='LE1')

{
"error": {
"code": "",
"message": "An error has occurred.",
"innererror": {
"message": "More than one resource was found when selecting for update.",
"type": "Microsoft.Dynamics.Platform.Integration.Services.OData.ODataArgumentException",

....

}

Is there a way to delete these duplicate with API call ?

Categories:

Dynamics 365 Human Resources

Hi,

The delete fails because the entity key (UserId, SecurityRoleIdentifier, OrganizationType, OrganizationId) is the same for both rows, so OData finds two matches and won't pick one. The only difference is the etag, which can't be used as a key. So this call won't work for these rows.

1. In the UI, go to System administration > Users, open the user, and remove then re-add the role / organization assignment. That may clear both rows.

2. Remove and re-add the role for the user via SecurityUserRoles, then check whether the duplicates are gone.

3. Delete the extra row by RecId using a small X++ job (the underlying table should be SecurityUserRoleOrganization). Test in a sandbox first.

4. If this is production, a Microsoft support case is worth raising.

It would also help to find out how the duplicates were created (e.g. an import or integration assigning the role twice), otherwise they may come back.

Hope this helps!
Thanks.

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL