Exporting multiple entities through DMF fails randomly

We’re exporting different portions of data from our Dynamics 365 F&O to a BYOD in different frequencies.

On several occasions – one might even call it frequently – we’ve been seeing the export failing on some entities (it changes in waves) with a limited level of error messages to troubleshoot from:

Error text:

Export execution failed for entity <Entity name>: Export failed while copying data from staging to destination

The result was the target database having changed records twice in the target table. A before and an after record.

The solution appears to be splitting the export job into a 1:1 setup with only one entity in each export.

I wish I had a more detailed explanation to this, but in this case it’s an I-don’t-see-the-bug-any-more-so-it-might-be-gone kind of thing.