[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

Lets make Bicep(s) now

Hi Folks,

Let’s work on your Bicep(s) from now onwards. Not the physical musculus but the Logical one, I am talking about the Logic apps here.

The Bicep is a language for declaratively deploying Azure resources and is a domain-specific language (DSL), which means it's designed for a particular scenario or domain. You can use Bicep instead of JSON for developing your Azure Resource Manager templates (ARM templates). It helps to simplify the authoring experience by providing concise syntax, better support for code reuse, and improved type safety. It isn't intended as a general programming language for writing applications.

Here are some useful links for reference, so let’s build the Bicep now.

What is Bicep (Preview)?

Install Bicep

Cheers!!!

-Harry 

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

Quick Fix: Batch service didn't start Error 1064

Error message: Windows could not start Microsoft Dynamics 365 Unified operations: Batch management Service service on Local Computer. 

Error 1064: An exception occurred in the service when handling the control request.

Solution: Check if the system is under maintenance mode, if yes disable the same and try again.

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