Microsoft Dynamics 365 Blog

Posts

[AX2012] [Workflow approval via email] Migrate from ACS to SAS – troubleshooting 

4 min read

Latest whitepaper & mobile connector downloading address – https://mbs.microsoft.com/customersource/northamerica/AX/news-events/news/MSDYN_MobileAppsAX When you migrate from ACS to SAS, you only need complete below 4 tasks listed in Appendix F: Apply the 2018 update to migrate from ACS to SAS. 1 Follow the steps in Appendix A: Create a new Service Bus namespace to create a new SAS…Read more

0 Comments

SSRS Report label shown as @SYSxxxx in AX2012 

2 min read

Here in this blog I will share two scenarios when this happening and basic troubleshooting steps when facing this issue. Issue: When you are rendering SSRS report, the data will load correctly, but all AX labels are not resolved: As we can see AOS has already processed the label resolve request, and all results has…Read more

0 Comments

Optional Additional Installation Script for Blocking Analysis with DynamicsPerf v2.0 

2 min read

In relation to the analysis scripts that come with DynamicsPerf (Performance Analyzer) v2.0, (based on the new extended events being used in place of the SQL profiler trace which featured in v1.20), i.e.: … —            BLOCKING_EVENTS — Blocking events sorted by TIME desc —————————————————————- SELECT TOP 100 * FROM (SELECT event_data.value(‘(event/@name)[1]’, ‘varchar(50)’) AS EVENT_NAME, DATEADD(hh, DATEDIFF(hh,…Read more

0 Comments

Clustered SQL Server instance – Example AX TEST environment configuration concepts and points of interest 

3 min read

Consider a scenario where you are running AX 2012 and your Dynamics AX databases are hosted on a Clustered SQL Server instance. I’ll discuss some concepts and points of interest below which are relevant when running AX 2012 RTM, R2 or R3. The screenshots are from a VM TEST environment with CONTOSO DEMO DATA that is…Read more

0 Comments

Check AOS event logs and SQL Server error logs for key messages using DynamicsPerf 

3 min read

As part of general monitoring of Dynamics AX overall system health and/or troubleshooting, you’ll want to check the Windows event logs in your AOS server(s) and SQL Server error logs. If you have DynamicsPerf (Performance Analyzer for Microsoft Dynamics) installed, you can quickly check for key messages and if necessary, export and move them all…Read more

0 Comments

Cannot select Category for condition in the purchase requisition workflow 

1 min read

We got a couple of issues when on the purchase requisition workflow how the [Purchase Requisition Lines.Category] is evaluated in workflow conditional statements. While we expect to see it like that: The issue is connected to DEL_ProductCategoryId field which also has label category and it is not connected to Category hierarchy For more details please…Read more

0 Comments

Analysis scripts for Performance Analyzer v2.0 

7 min read

Following on from my previous blog post regarding analysis scripts for the tool Performance Analyzer v1.20*, I am now publishing the scripts that come with the latest version, 2.0. (*Previous post: https://blogs.msdn.microsoft.com/axsupport/2014/08/31/microsoft-dynamics-ax-general-performance-analysis-scripts/) Download link: https://dynamicsperf.codeplex.com/ After downloading and extracting the tool from the above link, you can find these scripts in the following sub-folders: ..\DynamicsPerf\DynamicsPerf…Read more

0 Comments

Analysis scripts for Performance Analyzer v2.0 Page 10 

3 min read

This is page 10 of 10 of the general performance analysis scripts online for the Performance Analyzer 2.0 tool. See page 1 for the introduction. Use the links in the table below to navigate between pages. – General analysis Analyse SQL Configuration Page 1 Analyse SQL Indexes Page 2 Analyse SQL Queries Page 3 Analyse Blocking…Read more

0 Comments

Analysis scripts for Performance Analyzer v2.0 Page 2 

12 min read

This is page 2 of 10 of the general performance analysis scripts online for the Performance Analyzer 2.0 tool. See page 1 for the introduction. Use the links in the table below to navigate between pages. – General analysis Analyse SQL Configuration Page 1 Analyse SQL Indexes Page 2 Analyse SQL Queries Page 3 Analyse Blocking…Read more

0 Comments

Analysis scripts for Performance Analyzer v2.0 Page 3 

7 min read

This is page 3 of 10 of the general performance analysis scripts online for the Performance Analyzer 2.0 tool. See page 1 for the introduction. Use the links in the table below to navigate between pages. – General analysis Analyse SQL Configuration Page 1 Analyse SQL Indexes Page 2 Analyse SQL Queries Page 3 Analyse Blocking…Read more

0 Comments

Analysis scripts for Performance Analyzer v2.0 Page 4 

8 min read

This is page 4 of 10 of the general performance analysis scripts online for the Performance Analyzer 2.0 tool. See page 1 for the introduction. Use the links in the table below to navigate between pages. – General analysis Analyse SQL Configuration Page 1 Analyse SQL Indexes Page 2 Analyse SQL Queries Page 3 Analyse Blocking…Read more

0 Comments