Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Error message during D...
Finance | Project Operations, Human Resources, ...
Suggested answer

Error message during Dual Write Initial Sync between D365 Finance and Operations and Dataverse

(1) ShareShare
ReportReport
Posted on by PowerUser40
I'm attempting to perform an initial sync for the dual write between Finance and Operations and Dataverse but I am getting this error and the initial sync doesn't run.
I have looked at my Company table in Dataverse and its values are all unique - which makes this error message confusing.
 
Can anyone please help:
 
Reason: Precondition Failed, Header x-ms-client-request-id 67c35655-9203-4c91-8aff-b3a1379a169a, A record that has the attribute values Company already exists. The entity key Company requires that this set of attributes contains unique values. Select unique values and try again.
 
 
  • Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    Error message during Dual Write Initial Sync between D365 Finance and Operations and Dataverse
    Hi,
    You can check out this document which mentions related issues regarding dual write for financial operations. The article mentions a similar issue as shown in the screenshot. You can also try re-running the initial sync. Sometimes the problem may be temporary and rerunning the sync may succeed.
    Troubleshoot live synchronization issues - Finance & Operations | Dynamics 365 | Microsoft Learn

    Best Regards,
    Hana
  • Suggested answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Error message during Dual Write Initial Sync between D365 Finance and Operations and Dataverse
    Hi,
    The error message you're encountering indicates that there's a problem with uniqueness constraints in the Company entity during the initial sync between F&O and Dataverse. The error specifically states that a record with the attribute values for "Company" already exists, and the entity key "Company" requires that this set of attributes contains unique values.
    Here are some steps you can take to address this issue:
    Review Data in Finance and Operations: Ensure that in Dynamics 365 Finance and Operations, there are no duplicate records for the "Company" entity. Check if there are any records with identical attribute values.
    Review Data in Dataverse: Double-check the Company table in Dataverse to confirm that all values are indeed unique. It's possible that there might be a data inconsistency or an issue with the uniqueness constraints.
    Best regards,
    Kevin

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,540 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans