Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Dual Write Failing for Warehouses because Main Refilling Warehouse ID doesn't Exist

(0) ShareShare
ReportReport
Posted on by 318 User Group Leader

I am trying to sync the Warehouses table and am getting an error initializing the synce because there is a filed "MainRefillingWarehouseID" that is related to the key "WarehouseID".  I have a warehouse ID 10 that is the refilling warehouse for a lot of other warehouse so I need to load the table with warehouse 10 the other records are created.

How can I handle an initialization like this? I'm sure this is a common pattern of "parent-child" relationships that comes up in other areas as well.

The map is below and is inherently mapped correctly once the data is loaded.

pastedimage1683314373115v1.png

  • Weaveriski Profile Picture
    Weaveriski 23,616 on at
    RE: Dual Write Failing for Warehouses because Main Refilling Warehouse ID doesn't Exist

    Nope, that is the approach, Dual Write struggles with referential data and always has. I am not aware of any solution for this at the moment. Your approach is the only real option!

  • Suggested answer
    MarcRohde Profile Picture
    MarcRohde 318 User Group Leader on at
    RE: Dual Write Failing for Warehouses because Main Refilling Warehouse ID doesn't Exist

    I couldn't find another option so I ended up altering the data to load the warehouse record.

    1. Remove the transit and refilling warehouse from the warehouse records.

    2. Load the warehouse records

    3. Reload the refilling and warehouse records.

    I don't know if there is a better approach for self-referential tables but this worked to get the dual write working in my test and prod environments.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans