Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Database sync failed -...
Finance forum
Suggested answer

Database sync failed - from sandbox env to dev - SECURITYROLEPRIVILEGERESOURCELICENSEMAP

Posted on by 643
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.
 
  • Suggested answer
    Navneeth Nagrajan Profile Picture
    Navneeth Nagrajan 1,339 on at
    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.
     
    Hope this helps. Happy to answer questions, if any.
     
  • Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    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 Profile Picture
    Shooowtek 643 on at
    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 Profile Picture
    Shooowtek 643 on at
    Database sync failed - from sandbox env to dev - SECURITYROLEPRIVILEGERESOURCELICENSEMAP
    Hello,
    I've posted the screen below.
     
     
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,696 Super User on at
    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 Profile Picture
    Shooowtek 643 on at
    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 Calavon Profile Picture
    André Arnaud de Cal... 287,696 Super User on at
    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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans