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 / Finance | Project Operations, Human Resources, ... / DMF data export to xml...
Finance | Project Operations, Human Resources, ...
Suggested Answer

DMF data export to xml failed

(0) ShareShare
ReportReport
Posted on by Muhammad Afsar Khan 2,676

I created custom data entity to export release products in xml format, there is around 60k product data in D365 but its fail at 48k and throwing me following error;

EXPORT_tstReleasedProductEntity-2020-10-06T10:07:29-6A7EE76BA2864C2784DD8D39762A9BAEXPORT_tstReleasedProductEntityEntity.LogAndThrowNonByodExceptionReleased Products DetailSource: Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper HResult: 0x80131500 Details: System.Exception: DMF005 ---> System.Xml.XmlException: '', hexadecimal value 0x19, is an invalid character. Line 1, position 117. at System.Xml.XmlTextReaderImpl.Throw(Exception e) at System.Xml.XmlTextReaderImpl.ParseText(Int32& startPos, Int32& endPos, Int32& outOrChars) at System.Xml.XmlTextReaderImpl.ParseText() at System.Xml.XmlTextReaderImpl.ParseElementContent() at System.Xml.XmlLoader.LoadNode(Boolean skipOverWhitespace) at System.Xml.XmlLoader.ParsePartialContent(XmlNode parentNode, String innerxmltext, XmlNodeType nt) at System.Xml.XmlElement.set_InnerXml(String value) at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFPackageController.GenerateReturnResult(DTSExecResult result) at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFPackageController.Run(String packagePath) --- End of inner exception stack trace --- at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFPackageController.Run(String packagePath) at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFPackageController.CreateAndExecutePackageForExport() at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFEntity.CreateAndExecutePackageForExport() at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFEntity.ExportDataImpl() Source: System.Xml HResult: 0x80131940 Details: System.Xml.XmlException: '', hexadecimal value 0x19, is an invalid character. Line 1, position 117. at System.Xml.XmlTextReaderImpl.Throw(Exception e) at System.Xml.XmlTextReaderImpl.ParseText(Int32& startPos, Int32& endPos, Int32& outOrChars) at System.Xml.XmlTextReaderImpl.ParseText() at System.Xml.XmlTextReaderImpl.ParseElementContent() at System.Xml.XmlLoader.LoadNode(Boolean skipOverWhitespace) at System.Xml.XmlLoader.ParsePartialContent(XmlNode parentNode, String innerxmltext, XmlNodeType nt) at System.Xml.XmlElement.set_InnerXml(String value) at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFPackageController.GenerateReturnResult(DTSExecResult result) at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFPackageController.Run(String packagePath)

  • Suggested answer
    Ramit Paul Profile Picture
    Ramit Paul 22,809 Most Valuable Professional on at

    Hello,

    Have you tried with lowering the export like 15k per export?

  • Muhammad Afsar Khan Profile Picture
    Muhammad Afsar Khan 2,676 on at

    No, how we can define this limit.

  • nmaenpaa Profile Picture
    nmaenpaa 101,172 Moderator on at

    Try to set some criteria in the export project. This way you can limit the size of the resultset.

  • Muhammad Afsar Khan Profile Picture
    Muhammad Afsar Khan 2,676 on at

    is there any limitation OOB about total records to export? any opinion other than record limit?

  • Muhammad Afsar Khan Profile Picture
    Muhammad Afsar Khan 2,676 on at

    i am wondering where i can find this issue:

    System.Xml.XmlException: '', hexadecimal value 0x19, is an invalid character. Line 1, position 117.

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,172 Moderator on at

    For now, let's just try to see if it's possible to export this entity without having the error. So, please try to add some criteria to reduce the size of the result set. This way we will learn if the issue might be related to the data volume or if it's a general issue.

    Also, you could try to export the standard Released product entity and see if you get similar error there or not.

  • Muhammad Afsar Khan Profile Picture
    Muhammad Afsar Khan 2,676 on at

    Hi Nikolas, you are right, i am able to export data from standard entity (all 60k records). Do you have any idea what is worng with my entity (in general)?

  • nmaenpaa Profile Picture
    nmaenpaa 101,172 Moderator on at

    Hi Muhammad, so far here's all the information that I have about your entity:

    - It's developed by you

    - It's used for exporting Released products

    Based on this information it's not possible to know what could be wrong with it. Did you manage to export any records with it? Or is it always failing?

  • Muhammad Afsar Khan Profile Picture
    Muhammad Afsar Khan 2,676 on at

    Yes i am able to export over 30k records with the new entity with some filters. this new entity is developed by other developer with no custom code. i had a request to export records based on this entity.

  • nmaenpaa Profile Picture
    nmaenpaa 101,172 Moderator on at

    Then the issue doesn't seem to be related to any particular detail in your entity. Perhaps you hit some file size / variable size limit.

    If you export in CSV instead of XML, can you export more records?

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 511 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 426 Super User 2026 Season 2

#3
CU-1234529-002 Profile Picture

CU-1234529-002 159

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans