Microsoft Dynamics AX Support

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

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

EntityStore – AX 2012 R3 – DMFIsInEntityDBPublishAndPublishAll object not initialized

I’ve seen this error a couple of times in the past month or so, and I’ve also noted that some people have asked about it on the Internet, too. I’ve just finished working on a case with a customer where we were able to reproduce this issue on a VM. We found that patching the… Read more

Data Management Framework: Export fails with no apparent details on the cause

In a recent issue, a customer was reporting a problem exporting data using the data management framework. The issue was that during the export they were leaving the “Skip staging” option to “Yes”, which is the default option. When the export of the entity was run, it reported that it had failed and there seemed… Read more

DIXF – Importing data using Excel and ODBC

Consider a scenario where you are running AX 2012 R3 and you want to import data from Excel files using ODBC. Having recently worked a case on this topic, I thought I’d share some of the details on how this can be set up. 1. Background The main reason we were looking into this way… Read more

DIXF – Compare Entities – SQL Server replication tool is not installed

Consider a scenario where you are running AX 2012 R3 and you want to compare entities between AX companies using DIXF, but you get an error telling you that the SQL Server replication tool is not installed. 1. The DIXF functionality On a CONTOSO Demo Data TEST environment, you can find the functionality by navigating… Read more

DIXF – How to manually add a missing mapping to the DMFASSETENTITY entity

I recently worked on a case with a Partner that reported that the ‘Name’ field for the DMFASSETENTITY entity did not get imported as expected into their AX 2012 R3 CU9 environment, so I thought I would share how we resolved that by manually adding the mapping, and how we tested the solution. 1. Repro… Read more

DIXF – AX 2012 R3 KB3061216 – Support for new DIXF entities

We released a useful DIXF Application Hotfix in October 2015 which you may not be familiar with, and as I’ve recently been looking into this for a customer, I thought I would share some details on this topic. If you are running AX 2012 R3, then you can install KB3061216 and add a large number… Read more

DIXF – Cannot Preview source file – CommunicationException – An error occurred while receiving the HTTP response from DMFServiceHelper.svc

Consider a scenario where you are importing data using DIXF, and you get an error when you try to “Preview source file”. 1. The error The error you see looks something like this: System.ServiceModel.CommunicationException: An error occurred while receiving the HTTP response to http://servernamehere:7000/DMFService/DMFServiceHelper.svc. This could be due to the service endpoint binding not using the… Read more

DIXF – Importing Data – How to use Auto-generated to import PartyNumber

Consider a scenario where you want to import data into AX 2012 R3 using DIXF, but you want a particular value to be auto-generated by the system rather than input from a text file. The following blog post aims to show how this can be done for a specific DIXF entity, so you have an… Read more