web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Unanswered

Dual Write not Allowing Owner Change on Records

(0) ShareShare
ReportReport
Posted on by 10
Hello,
 
We have a Dynamics Sales environment connected to F&O via Dual Write. On some records, we encounter errors when trying to change ownership of a record (these same erros also happen when trying to update other fields, but owner updates are the prime example). Below is the error we receive:
 
ExceptionFromPluginExecute: Microsoft.Dynamics.Integrator.DualWriteFpRuntime.Plugins.PreCommitPlugin
        ExceptionRetriable: False
        ExceptionSource: PluginExecution
        OriginalException: PluginExecution
        PluginTrace: roubleshooting see https://go.microsoft.com/fwlink/?linkid=2244045. - "}{"Write failed for entity SalesQuotationHeaderD365SalesEntity. Table validations errorFor information on troubleshooting see https://go.microsoft.com/fwlink/?linkid=2244045. - "}{"Write failed for entity SalesQuotationHeaderD365SalesEntity. Table validations errorFor information on troubleshooting see https://go.microsoft.com/fwlink/?linkid=2244045. - "}{"Write failed for entity SalesQuotationHeaderD365SalesEntity. Table validations errorFor information on troubleshooting see https://go.microsoft.com/fwlink/?linkid=2244045. - "}

Basically, we have determined that Dual Write will not change the owner because there are closed quotes on the record and cascading rulesare attempting to change the owner on a closed quotes and Dual Write does not allow this.
 
That said, we have attemped to change the cascading rules with no success, and we have been working with Microsfot for almost a year to try to resolve this with no luck. Microsoft suggested they try putting a filter on the cascading rules to bypass attempting to look at closed quotes and that seemed to work in our test environment, but there were concerns about pushing this to a production environment in case the status of quotes would be incorrect in F&O. Also, Microsoft determined this would not be a good fix. They then suggested all we neded to do was delete old Dual Write Runtime Configurations. We attempted this in our test environment and it had no effect other than to interfere with our current environment refresh.

Now we are back to the drawing board with Microsoft. This is a very common occurence for us as we often need to change ownership of records when salespeople leave or change territories and this is interfering with our commission payments. 
 
I am curious if anyone else has encountered this issue before as our CE/F&O setup really is pretty standard and not customzed as far as Dual Write is concerned. Does anyone have any suggestions for workarounds?
 
Any help would be appreciated. 
 
Thanks!
 
Bryan
Categories:
I have the same question (0)

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 153 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 109

#3
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 64

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans