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

Notifications

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,461
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... 301,146 Super User 2025 Season 2 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,461 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... 301,146 Super User 2025 Season 2 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,461 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... 301,146 Super User 2025 Season 2 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,461 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... 301,146 Super User 2025 Season 2 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,461 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans