web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / DIXF error during stag...
Microsoft Dynamics AX (Archived)

DIXF error during staging data export

(0) ShareShare
ReportReport
Posted on by Florian Hopfner 2,466
Hello,

while testing the export function for data in the staging tables (execution history, view staging data, "Export to file") of the Data Import/Export Framework, I get this error message in the log:
"System.Exception: Exception from HRESULT: 0xC0202009 at Microsoft.Dynamics.AX.DMF.ServiceProxy.DmfEntityProxy.DoWork[T](Func`1 work)The data was not exported."

The error message is retrieved from a CLRError that is thrown when executing the call to dmfEntityProxy.ExportData() in method generateFileData of class DMFGenerateSSISPackage.

CIL is compiled and event logs do not have entries during the time the error message is created.

Note that there are three AOS for three different systems running on their own servers, but connecting to the same SQL Server where the "Microsoft Dynamics AX Data Import/Export Framework Service" is running. I'm guessing that this could be part of the problem (different systems running against the same DIXF service).

Any ideas what I could do to find out what causes the error?

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,483 Super User 2026 Season 1 on at

    Hi FH-Inway,

    Did you install the server components of Data Import/Export Framework on all your AOS machines?

  • Florian Hopfner Profile Picture
    Florian Hopfner 2,466 on at

    Hi Andre,

    thanks for your Response. Yes, the DIXF AOS component was installed on all AOS during the CU7 update.

    Regards

    Florian

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,483 Super User 2026 Season 1 on at

    It could be related to security settings (accounts used) or probably compilation.

    Can you confirm you setup the user accounts correctly? Did you manage to do a successful full CIL compilation? You are talking about exporting. Is it possible to import data or do you then get a similar message?

    Did you upgrade DIXF from a previous version (e.g. CU6)?

  • Florian Hopfner Profile Picture
    Florian Hopfner 2,466 on at

    Due to three AOS Systems with their own account, a new account was created for the DIXF service. As far as I can tell, this account is set up correctly.

    Full CIL compilation was successful.

    Importing data (as well as other functions like preview or auto-mapping) is possible.

    Yes, we did upgrade DIXF from CU6 and we first uninstalled DIXF before the upgrade.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,483 Super User 2026 Season 1 on at

    Hi Florian,

    Did you removed the binaries from the older DIXF prior to the upgrade (Client, Server, Integration services)?

    The dll's that are shipped with CU7 are newer and do not overwrite the older versions.

    Can you otherwise try to explore the event viewer for possible errors or warnings?

  • Community Member Profile Picture
    Community Member on at

    Hi Andre, i am also working on the issue. The version of the files is 6.2.1000.4051. I already checked that with another working dmf cu7 Installation and they seem to be the newest.

    In the meantime i decompiled the whole stuff tracked it down to the line

    HRESULT: 0xC0202009

      bei Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSDesigntimeComponent100.ReinitializeMetaData()

      bei Microsoft.Dynamics.AX.DMF.SSISHelper.DMFFlatFilePackageExport.UpdateSourceProperties(IDTSComponentMetaData100 flatFileSourceComponent, CManagedComponentWrapper srcFlatFileInstance, String name, Package _Package) in Microsoft.Dynamics.AX.DMF.SSISHelper.pdb.source\Microsoft\Dynamics\AX\DMF\SSISHelper\DMFFlatFilePackageExport.cs:Zeile 598.

    The method ReinitalizeMetaData throws the exception but there is no more Information i can get. Seems to be some rights issue, but I cannot find the cause. We've already reinstalled dmf and it's now using the aos service account which is a local administrator at the moment....

    Any ideas?

  • Florian Hopfner Profile Picture
    Florian Hopfner 2,466 on at

    We are not quite sure why, but when we tried the export today, it worked as expected. Probably there was some issue with the export data, although we are using the contoso demo data.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,483 Super User 2026 Season 1 on at

    Hi Florian, AndiRudi,

    I have no clue what could have caused the error other than perhaps a compilation problem or some caching?

    Whenever you have the error again, please update this post again; probably with any information that could be usefull.

  • Florian Hopfner Profile Picture
    Florian Hopfner 2,466 on at

    Hi Andre,

    we will do that. Thanks for your time.

    Best regards

    Florian

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    This time i had the same error on another system / other customer. I played a bit around and it seems to print out the error if the entity mapping is not correctly configured. I just describe the way i did it for exporting vendors.

    First I created a definition group 'VendorsToStaging' to put the entities to staging on the source system. I configured the file format to AX. The I run the 'To Staging' and checked the staging files.

    Next I created a second entity 'VendorsCSV' to export the entities. I set the file format to CSV and created a "sample file" with all fields. I saved the sample file as Vendors-Sample.txt and set it in the sample path line (via UNC Path). I also clicked regenerate source definition and openden the source definition for a short check if the mappings are done.

    Then I switchend back to the first entity 'VendorsToStaging' and clicked export to file. In the (second) dialog I selected the VendorsCSV def group and then the data was exported correctly.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Sagar Suman Profile Picture

Sagar Suman 2 Super User 2026 Season 1

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans