Finance | Project Operations, Human Resources, ...

Details of entity export errors

(1) Share

Report

Posted on by DYNUser121

I created a Custom Entity against RetailTransactionSalesTran table, and from this custom entity I did an Export in the application's Data Management workspace. However I did not get it fully success, it shows "Partially Succeed" with 9248 records exported and 7238 errors. I searched over the page UI and cannot find out where is the error details for those errors. And also I checked server side Event Viewer, and there is no error in Event Viewer. I wonder how do I find out what exactly those errors are ? I pasted the screentshot like below:

8424.pastedimage1591148420772v1.png

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

There is an execution log button in the upper left-hand side of your screenprint.

Have you checked this one and whether you can get some additional information from there what might have gone wrong?

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Shah Keyur 365 on at

Like (0)

Report

Check 'View Execution log', it should have relevant failure information.

Was this reply helpful? Yes No
Martin Dráb 237,795 Most Valuable Professional on at

Like (0)

Report

Title changed from "What is these Errors" to "Details of entity export errors".

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

if it's production then should check staging and target execution errors

if non production then can also see event log

Was this reply helpful? Yes No
DYNUser121 12 on at

Like (0)

Report

I have checked already, there is no message relevant, refer to the screenshot:

Was this reply helpful? Yes No
DYNUser121 12 on at

Like (0)

Report

I checked server side event view logs for AX-DIXFRuntime and AX-DIXFSSISRuntime, there is no errors there.

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi DYNUser121,

There is "View staging data" button on your screens (in blue box). Check if you have any errors there?

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 300,896 Super User 2025 Season 2 on at

Like (0)

Report

If the staging data is not giving any clue, then you can check if the data entity is created correctly. E.g. what is the primary entity key and what is the primary key of the staging table? Probably, there are some errors due to a duplicate key exception. Have you tried to export the data and bypassing the staging?

Was this reply helpful? Yes No
DYNUser121 12 on at

Like (0)

Report

Thank you for your reply. I am not quite sure on what you said "Bypassing the staging", do you mean when I doing export, I make the settings like below ?

Was this reply helpful? Yes No
André Arnaud de Cal... 300,896 Super User 2025 Season 2 on at

Like (0)

Report

Hi DYNUser121,

Yes, you can try this setting to skip the staging.

Was this reply helpful? Yes No