Microsoft Dynamics AX Support

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

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

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

Compatibility statements – Patching the kernel only is not enough – you have to patch the application

From time to time we see questions about the compatibility statements and what they mean. The most common question relates to whether they apply to the kernel or the application. A common misconception is that you only need to patch the kernel rather than the application. This is not the case. For example, If the… Read more

IDMF – Archiving Restoring and Purging data from a custom table

Consider a scenario where you are running AX 2012 R3 and you want to archive or purge data from a custom table in AX using IDMF. The screenshots are from a VM TEST environment with CONTOSO DEMO DATA that is running AX 2012 R3 CU10 on SQL Server 2014 and the latest version of IDMF…. Read more

Announcing new LCS feature – Latest Kernels

Installing the latest AX kernel version has the advantage of improving the quality and stability of the product because the kernel bundles all fixes checked in up to the release date. Until recently, finding the latest AX kernel version required searching for hot-fixes to specific problems and installing the corresponding KB package. The new feature… Read more

Dynamics Online Payment Services – Common errors and troubleshooting steps

We are continuing to see a reoccurrence of very similar error messages when using Dynamics Online Payment Services (DOPS) with Microsoft Dynamics AX 2009 and 2012. The resolutions normally deal with the setup and configuration of either AX or DOPS. This blog is intended to cover some of the common errors encountered with the resolutions… Read more

Dynamics AX – 1099 Tax Updates for 2015

Once again, tax season is right around the corner. As such, I thought I would take a moment to let everyone know that we have released the 2015 1099 updates for Dynamics AX and share some of the changes we have made.   Supported versions: Version: AX 5.0 Hotfix: KB311849Location: http://hotfixv4.microsoft.com/Microsoft%20Dynamics%20AX%202009/sp1/KB3118498/5.0.1600.3540/free/488628_intl_i386_zip.exe Version: AX 6.0/6.1 – Due… Read more

How to proactively avoid parameter sniffing step-by-step

In the following blog post the so called „parameter sniffing“ is explained: http://blogs.msdn.com/b/axinthefield/archive/2014/01/09/sql-server-parameter-sniffing-with-dynamics-ax-just-plain-evil.aspx The purpose of this blog post is to explain the fix implementation steps a little more in detail: Notes: The kernel only hotfixes mentioned for MS Dynamics AX in the blog post above are minimum prerequisites. Because all kernels are cumulative I’d… Read more

Using Process Monitor (also known as ProcMon) for MS Dynamics AX client troubleshooting

The purpose of this blog post is to clarify the following 2 questions in order to get you started using Process Monitor: 1) What is Process Monitor (=ProcMon)? 2) How can I see the MS Dynamics AX client activity filtered in ProcMon ? in terms of 1) Process Monitor is a troubleshooting tool which allows… Read more