Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / Details of entity expo...
Finance forum
Suggested answer

Details of entity export errors

editSubscribe (1) ShareShare
ReportReport
Posted on by DYNUser121 12

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

Categories:
Data Integration
Retail
Financial Management
Sales and Marketing
  • AS-30042044-0 Profile Picture
    AS-30042044-0 42 on at
    Details of entity export errors
    I am also facing the same issue Do you resolve this Issue?
    #CFMR
  • Andre Arnaud de Calavon Profile Picture
    Andre Arnaud de Cal... 283,375 Super User on at
    RE: Details of entity export errors

    Hi DYNUser121,

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

  • DYNUser121 Profile Picture
    DYNUser121 12 on at
    RE: Details of entity export errors

    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 ?

    pastedimage1591338165830v1.png

  • Suggested answer
    Andre Arnaud de Calavon Profile Picture
    Andre Arnaud de Cal... 283,375 Super User on at
    RE: Details of entity export errors

    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?

  • Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,081 on at
    RE: Details of entity export errors

    Hi DYNUser121,

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

  • DYNUser121 Profile Picture
    DYNUser121 12 on at
    RE: Details of entity export errors

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

  • DYNUser121 Profile Picture
    DYNUser121 12 on at
    RE: Details of entity export errors

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

    pastedimage1591221519933v1.png

  • Suggested answer
    Rahul Mohta Profile Picture
    Rahul Mohta 21,010 on at
    RE: Details of entity export errors

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

    if non production then can also see event log

  • Martin Dráb Profile Picture
    Martin Dráb 223,308 Super User on at
    RE: Details of entity export errors

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

  • Suggested answer
    Shah Keyur Profile Picture
    Shah Keyur 365 on at
    RE: What is these Errors

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

Helpful resources

Quick Links

Take the Community feedback survey!

Answer this brief 15-question survey about your Community experience…

Demystifying Copilot: Service Edition with Sundar Raghavan

Sundar answers more questions about Copilot for Service...

Dynamics 365 Business Central vs Finance and SCM

Take a look at the key differences between Business Central and…

more Community News

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,375 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 223,308 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,140

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans