Finance | Project Operations, Human Resources, ...

Database sync failed - from sandbox env to dev - SECURITYROLEPRIVILEGERESOURCELICENSEMAP

(1) Share

Report

Posted on by Shooowtek

843

Hello,

After moving the database from the sandbox environment to dev, it gets strange errors about SECURITYROLEPRIVILEGERESOURCELICENSEMAP. I have never encountered this error before.
Could someone please help?

I have tried this before, but without success.

https://community.dynamics.com/blogs/post/?postid=9ed90dcf-4775-4bb4-a4a5-114f3ff2d606

https://community.dynamics.com/blogs/post/?postid=f1ca716d-14f9-4893-905d-a588835f2235

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

André Arnaud de Cal... 301,130 Super User 2025 Season 2 on at

Like (0)

Report

Hi Shooowtek,

Did you copy only the database or also the application objects? Was the application on the same version including possible customizations between the sandbox and the dev environment?

On the Security configuration form, there is a function called 'Repair'. Have you tried this job? This will recreate contents from some runtime security tables. See also: Security configuration - What is the 'Repair' button? - Dynamicspedia

Was this reply helpful? Yes No
Shooowtek 843 on at

Like (1)

Report

In this case, the database has been transferred. The application is the same version and includes all customizations.

I tried to use the "Repair" button, but without success.

I would like to paste here the list of errors I receive in VS, but for unknown reasons I can't do it....

Was this reply helpful? Yes No
André Arnaud de Cal... 301,130 Super User 2025 Season 2 on at

Like (0)

Report

Hi Shooowtek,

Are you able to copy the error first to notepad and then to a reply on this forum?

Was this reply helpful? Yes No
Shooowtek 843 on at

Like (0)

Report

Hello,

I've posted the screen below.

Was this reply helpful? Yes No
Shooowtek 843 on at

Like (2)

Report

I already have a solution. Run the following SQL script on the imported database:

DROP PROCEDURE IF EXISTS LICENSING_POPULATEROLEPRIVILEGELICENSEMAPV2
GO

Was this reply helpful? Yes No
Hana Xue Microsoft Employee on at

Like (0)

Report

Hi,
Thanks for sharing this solution, you can mark this as verified to help more people.
Best Regards,
Hana

Was this reply helpful? Yes No
Suggested answer

Navneeth Nagrajan 2,438 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Looks like this is an issue while assigning security roles to the user.

1. You can use the solution that @Shooowtek recommended dropping the Licensing_PopulateRolePrivilegeMapV2 which worked in my case too.

2. Refer to this KB Article that fixes this issue where some of the privileges and resource association to a security role has been fixed.

https://fix.lcs.dynamics.com/Issue/Details/1604746?kb=4602811&bugId=537928&dbType=3&qc=5bc5f821cc1249a543a44f7c30961799c8fc83a851f42c2b5844f1686999e12e

Hope this helps. Happy to answer questions, if any.

Was this reply helpful? Yes No