Announcements
Hi,
I have a strange error. I have published several standard entities to Azure SQL DB and they are also populated with the export job, but for some reason sales order lines v2 entity fails. I tried to export to xml-file and that was successfully completed. Does anyone have ideas where to seek the solution?
Thanks,
Migi
Hi Migi,
First of all, you should try to regenerate mapping (Data management - Data entities - Modify target mapping - Generate mapping), re-publish entity, re-add entity to the data project and try to export again.
Can you go to the execution history or staging details to find an error message?
Hi Sergei,
I did all the steps, but still the same problem. Error msg is a bit strange:
Hi, it just says it didn't run. There's no log....nothing else
What PU version are you using? I have the same issue before and it was related to fields in the entity disabled by configuration keys. If you marked "Skip staging" (can be added to the "Selected entities" grid via personalization), could try to unmark it and run export again?
seems some issue with schema difference between D365FO and BYOD
compare them using D365FO, republish and try export again
Agreed with Rahul & Sergei, normally when the error happens like: "An Error occurred in add data flow component for Entity Store", most of the case is because some issue with schema difference between D365FO and BYOD.
Un-publish & publish the entity from BYOD. Create new data project and add the entity to be exported. Once the entity is added to the project, have a check the mapping, remove the disabled fields from the mapping, remove the virtual field and use computed field instead of virtual field.
You can also have a try disable "skip staging".
let us know if dropping and republishing worked?
Dropping and republishing didn't work. I have created a support ticked to Microsoft.
Excellent...Thanks Sergei! I did the skip staging trick and found out the reason was crappy data. Almost half of the sales order lines had errors in validation so I changed the filter to run only the latest lines and....now it works :)
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 288 Super User 2026 Season 2
Martin Dráb 276 Most Valuable Professional
Anton Venter 225 Super User 2026 Season 2
