Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Data entity exports failing after upgrade

Posted on by

Our client is running D365 on-prem.

We have exports of several data entities to a BYOD (an Azure SQL DB), set up as daily batch jobs.

This was working in PU36.  After we’ve upgraded to PU39, the exports are failing.

For each entity there are two errors in the execution log, both on the Target stage:

  • Package Execution Failed for Entity Store
  • BYOD export failed on final attempt.  Could not generate export file for entity 'xxx' for job 'YYY’

 

Steps that I’ve done to try and solve:

  • Refreshed entity list
  • Republished entities, edited change tracking and republished.

None of these worked.

 

We’ve even created a new byod, published some entities and exported.  The errors still remain.

What is puzzling is that the staging tables are created in the byod upon publishing (so the connection is valid).  Checking the tables in the byod, there are some tables with data and some that doesn't have data in, however on D365 in data management the job shows as failed for each entity.

 

Has anybody had similar issues with exporting to a BYOD after an upgrade, or on PU39 specifically?

  • Ajit Profile Picture
    Ajit 8,755 on at
    RE: Data entity exports failing after upgrade

    so you see data in BYOD and also see errors in log for same execution id?

  • CelesteL Profile Picture
    CelesteL on at
    RE: Data entity exports failing after upgrade

    I've re-generated the mapping and validated the data entities.

    The data management export job still fails.

    There is however data showing in the BYOD, even though the errors on the execution log persists.

  • Ajit Profile Picture
    Ajit 8,755 on at
    RE: Data entity exports failing after upgrade

    Yeah but some times mapping gets messed up in data project. So please verify that once. 

  • CelesteL Profile Picture
    CelesteL on at
    RE: Data entity exports failing after upgrade

    There were no mapping changes required.  When you publish an entity, the staging table is created in the BYOD and D365 takes care of the rest.

    It worked in PU36, but since upgrading to PU39 we're experiencing errors.

  • Ajit Profile Picture
    Ajit 8,755 on at
    RE: Data entity exports failing after upgrade

    Please verify the mapping of that entity in Data Project.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans