[Solved] SECURITYROLEPRIVILEGERESOURCELICENSEMAP DB sync error

Hi Folks,

The other day I was getting errors while doing build and DB sync. This error is quite strange when looking at the details in the Error List pane. Below is the error message(s).

Error message:

         

 

 

If you succeed to get some details from this error message 😊, you will see the issue with SECURITYROLEPRIVILEGERESOURCELICENSEMAP while you won’t get anything in AOT with this name.

 

 

Let’s try the SQL then. Open the SSMS and select AxDB then searches for dbo. SECURITYROLEPRIVILEGERESOURCELICENSEMAP and right-click to see the design. You may get some additional fields here, ideally, there should be below seven fields, (you should be double sure if anyone else in your team added anything)

And delete any additional fields from here.

 

 

Save your changes and go back to Visual Studio and try to do build and DB synch. It should work.

Enjoy!!!

-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta

QuickFix: Entity store doesn't refresh

Issue: I have made a change in an entity store(Power BI measures) but while refreshing it from System Admin> Entity store> select entity > hit refresh button.

 

Possible reason: Check if the batch service is up and running, try to restart the same. 

 

-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta