Error in the Export Entity Store to Azure Data Lake functionality

(5) Share

Report

Posted on by Syed Amir Ali

215

Hi Experts,

I hope you are doing well.

I am trying to export the Entity Store (AxDW) data into Azure Data Lake. The setup has been completed and is working fine overall; however, for specific aggregate measures, an error is appearing on the Entity Store logs screen.

Error details:
"FOR XML could not serialize the data for node 'NoName' because it contains a character (0x0002) which is not allowed in XML. To retrieve this data using FOR XML, convert it to binary, varbinary or image data type and use the BINARY BASE64 directive."

Do you have any suggestions on how to fix or debug this issue?

Thank you in advance for your help.

MS Official Documentation I followed: https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/entity-store-data-lake

Screenshot:

Categories:

Dynamics 365 Finance

Microsoft Dynamics AX

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Deepak Agarwal 9,065 on at

Like (1)

Report
Copy link

Link copied!

You can try to export data in DMF for these entities and check for any special char which is not supported in XML. as this is std measure I am not expecting anything wrong with Measure itself, must be something with data.

Was this reply helpful? Yes No