I have written couple of articles on Dual-Write lately. Mostly on issues that we've been facing lately and how we have come to fix them. These post is where I bring them all together. You can think of this blog post as a summary of all the issues and fixes until now and will continue to update the same in the future.
Also certain topics don't need a separate post. Will write about them here directly. Starting below with the posts that I have written previously.
Previous Posts
Unable to create a Quote in Dynamics 365 Sales App
This was because we were receiving an error
"Write failed for entity CDS sales quotation header with unknown exception - BOX API can't be used from non-interactive sessions."
Click here to read the post.
Privileges required for dual-write initial sync
There are certain security roles and privileges required to perform initial sync of tables via dual-write.
Click here to read the post.
Unable to delete postal addresses in Dynamics 365 Sales
This happened because there were related records, and I wasn't able to delete them too.
Click here to read the post.
Unable to create an order from a quote in Dynamics 365 Sales App
Here is the precise error that I was receiving.
"Write failed for entity CDS sales order lines V2 with unknown exception - Inventory dimension Site is mandatory and must consequently be specified.\nUpdate has been canceled."
Click here to read the post.
Other Issues
Unable to load the dual-write module in a Finance and Operations App
If you're unable to open Dual-write page by selecting the Dual Write tile in the Data management workspace, most likely data integration service is probably down.
For this you would need to create a MS support ticket and request a restart of the data integration service.
