Finance | Project Operations, Human Resources, ...

Database sync failed - from sandbox env to dev - SECURITYROLEPRIVILEGERESOURCELICENSEMAP

(1) Share

Report

Posted on by Shooowtek

845

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)

Sort by

Suggested answer

André Arnaud de Cal... 305,465 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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 845 on at

Like (1)

Report
Copy link

Link copied!

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... 305,465 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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 845 on at

Like (0)

Report
Copy link

Link copied!

Hello,

I've posted the screen below.

Was this reply helpful? Yes No
Shooowtek 845 on at

Like (2)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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,618 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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