Finance | Project Operations, Human Resources, ...

Database sync failed - from sandbox env to dev - SECURITYROLEPRIVILEGERESOURCELICENSEMAP

(1) Share

Report

Posted on by Shooowtek

791

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

All responses (7)

Answers (0)

Suggested answer

Navneeth Nagrajan 1,954 Super User 2025 Season 1 on at

Like (0)

Report

Database sync failed - from sandbox env to dev - SECURITYROLEPRIVILEGERESOURCELICENSEMAP

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.
Hana Xue Microsoft Employee on at

Like (0)

Report

Database sync failed - from sandbox env to dev - SECURITYROLEPRIVILEGERESOURCELICENSEMAP

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

Like (2)

Report

Database sync failed - from sandbox env to dev - SECURITYROLEPRIVILEGERESOURCELICENSEMAP

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

DROP PROCEDURE IF EXISTS LICENSING_POPULATEROLEPRIVILEGELICENSEMAPV2
GO
Shooowtek 791 on at

Like (0)

Report

Database sync failed - from sandbox env to dev - SECURITYROLEPRIVILEGERESOURCELICENSEMAP

Hello,

I've posted the screen below.
André Arnaud de Cal... 295,912 Super User 2025 Season 1 on at

Like (0)

Report

Database sync failed - from sandbox env to dev - SECURITYROLEPRIVILEGERESOURCELICENSEMAP

Hi Shooowtek,

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

Like (1)

Report

Database sync failed - from sandbox env to dev - SECURITYROLEPRIVILEGERESOURCELICENSEMAP

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....
Suggested answer

André Arnaud de Cal... 295,912 Super User 2025 Season 1 on at

Like (0)

Report

Database sync failed - from sandbox env to dev - SECURITYROLEPRIVILEGERESOURCELICENSEMAP

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