[Solved] Your connection is not private, issue while browsing DEV box

Hi Folks, 

In case of this sunny morning, you tried to login into one of the dev box which you accessing after a long back you may get the below error on the browser 

Your connection is not private

Attackers might be trying to steal your information from

This issue was caused because of the expired SSL certificate on the server, as these VM are azure hosted and Microsoft takes care few things on their own, hence this once. To fix this, you need to log into LCS and select the project and the cloud hosted environment. 

Under maintain tab, select rotate certificate, 

Select Rotate SSL certificate (NOTE: This will restart your VM, pl save any of your work before performing this action.)

It may take some time to complete this action, you can monitor the progress on the right top corner of the environment page. Sometimes, the screen doesn't refresh automatically, you may need to refresh the browser after a few mins. This action normally takes 45 min.   

Once that is done and your environment is showing up and running on LCS you can try to access it. 

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

[Solved] Entity store not refreshing / Power Bi measure not refreshing

Hi Folks,

Power BI is amazing tool when it comes to reporting needs. You can easily create new BI measures for your project need. Recently I have been facing issues with the Entity store where it stopped refreshing and synching with AXDW database. Below are few steps you can try to resolve the issue.

1. Services: Check if all required windows services are up and running. Primarily batch job service

2. Batch groups: If this issue is coming after a recent change on the server like DB restore then check if the batch groups having a server assigned to it. 

Go to System Admin > Setup > Batch Group and check the Batch server tab there. There should be values in the selected server node,

3. Batch Jobs: Navigate to System admin > Inquiries > Batch Jobs. Here search for 'Full reset' job, 

(In case your UI looks different than the above screenshot, try to switch to enhanced view).

Click on job id and you should get below screen, 

-

Hope this post will help to resolve the entity refresh issue for you as well. 

Cheers!!!

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

[Solved] An internal error has occurred. Please contact your system administrator. File export using sys operation framework

Hi Folks,

Recently I have been using SysOperatioonFramework to export data in excel. While running the code out of batch its working fine but as soon as I am calling this from Sysopertionframewrok, the system doesn't show anything on front end while debugging its giving error

An internal error has occurred. Please contact your system administrator.

Well, it's a minor mistake in the controller class. You need to define the execution mode for your service class (code in controller class)

this.executionMode = SysOperationExecutionMode::Synchronous

Save | Build | Run

It should work for you as well. 

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

[Solved]Enum type 'RetailChannelAttributeModifier' for the field 'Modifier' is not

Error message:

Severity Code Description Project File Line Suppression State

Error Path: [dynamics://View/RetailSalesTableChannelAttributeView]:Enum type 'RetailChannelAttributeModifier' for the field 'Modifier' is not found. K:\AosService\PackagesLocalDirectory\ApplicationSuite\Foundation\AxView\RetailSalesTableChannelAttributeView.xml 0

Solution: 

Add a reference to the Retail package in your model. 

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

The item [ProjectPath].rnrproj has been cloaked.

Error: Below error occurs when adding the project to source control.

The item C:\VS2017Projects\<projectName>.rnrproj has been cloaked.

The item C:\VS2017Projects\<ProjectName>.rnrproj has been cloaked.

 

Solution:

Check the source control workspace mapping, there could be some additional mapping to this project, you need to delete this additional mapping (honestly, I couldn't figure out how this was added) and try to add your project to the source control again. 

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

QuickFix: Delete command button doesn't work as expected

Scenario: I've created a form with multiple data sources, one of the tab pages needs its own new, delete button. (Can not use design property). When adding command buttons for New and delete, New works fine but delete doesn't. 

Possible reason: There is a lot of commands which start with Delete, and probably you have chosen the 'Delete' command, while you need to choose 'Delete record' as this button spouse to delete a record (or multiple records). Try this.

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

[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

How to get meta data of an Data Entity MSDynD365

Hi Folks,

Here we got one awesome update on D365FO data management, now you get metadata of any data entity in a very useful format in an excel file.  You will get the below information for each data entity.

Let's see how to get that, go to the "Data management" workspace and click on the "Data entity" tile.

Select your data entity and in the menu bar select the "Get metadata" button.

The system will download the metadata in an excel file even for any custom field or entire custom data entity, pl find below a sample file for the Vendor Group.

Cheers!!!

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

QuickFix: Maintenance mode doesn't activate

Hi Folks,

While trying to bring your Tier-1 environments in maintenance mode using SSMS, system may take longer than expected even after multiple time ISS reset using CMD.

Try this, Open Visual studio (type DevEnv in windows search bar) and click 'Dynamics 365' menu then select ‘Restart IIS Express’ this will bring your system into maintenance mode immediately.

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

Dynamics Deployment Services [wsfed-enabled] not appearing on Azure portal

Hi Folks,

If you are also facing an issue while creating an Azure connector in LCS and not founding Dynamics Deployment Services [wsfed-enabled] user in IAM in Azure subscription. Pl try the below step

1. Go to project setting > Azure connector and Authorized 

Sometimes you may get issue while deploying the environment on the cloud, try below

 Try to give the below roles on the Azure portal to the user which you are currently logged in to LCS.

1. Owner

2. Contributor

Well, if it's not the end for you and you are still getting below error on some further screen,

Don't worry, it's the background services which maybe on a short break :), and taking a little longer to update the credentials. Give a try in a few min and you should be able to proceed,

Cheers!!!

Harry

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

Computed columns in Views - Dynamics AX

Hi Folks, 

I came across a useful blog on Computed columns in Views - Dynamics AX, however, its written for AX 2012 but fits pretty well with Dynamics 365FO as well. 

Have a look. 

Computed columns in Views - Dynamics AX 2012

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

QuickFix : Error on Data entity

Error message: 

Severity Code Description Project File Line Suppression State

Error Infolog diagnostic message: 'Datasource name <EntityName>not found in the view <EntityName>.' on category 'Error'. 0

Possible cause: Check if you are using any calculated field and that method for the field is calling the wrong entity. Also, check if it points to the wrong data entity method. 

Below is the syntax

 dataEntityName      = tablestr(<EntityName>);

        Filed1 = str2Int64(SysComputedColumn::returnField(DataEntityName, identifierStr(<Datasource name>), fieldstr(<Datasource name>, CustTransRecId)));

       

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