Microsoft Dynamics AX Support

This blog contains posts by the Microsoft Dynamics AX Support Teams Worldwide

Prerequisites to allow cancelling a packing slip for WHS items

We’re very happy to announce that in AX 2012 R3 CU12 you are now able to reverse loads, cancel packing slip updates for sales orders and product receipts for purchase orders. This means you are now able to reverse the loads even when these updates have been done. This change will come through KB 3196554… Read more

Data Import/Export Framework “Group By” condition added

This post was written by David Cao Importing data using the Data Import/Export Framework by default bundles records into equal groups for processing by each thread. This leads to issues like update conflicts for similar grouped records like journals, sales orders etc. The change is required to allow bundling to be based on a specified… Read more

DIXF – AX 2012 R3 – KB3216243 – Assume service is on active SQL Server node

We recently released a DIXF Application Hotfix for AX 2012 R3 that you may want to take a look at if you are running a Clustered configuration / AlwaysOn configuration: The changes in the hotfix introduce a new option of “Assume service is on active SQL Server node” on the “Data import/export framework parameters” form…. Read more

SSRS Report label shown as @SYSxxxx in AX2012

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: Two known causes of this: SQL Server Reporting service version does not meet AX requirement. You… Read more

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

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

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

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

Serialising containers in X++

A problem I’ve hit a few times during troubleshooting is transferring containers from one environment to another. Importing a whole 100GB database to be able to access the results of a report packed into a 20MB container seems like a bit of an overkill. So, a natural idea would be to save the container to… Read more

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

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

Analysis scripts for Performance Analyzer v2.0

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

Analysis scripts for Performance Analyzer v2.0 Page 10

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