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.
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!
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,239
André Arnaud de Cal... 903 Super User 2025 Season 2
Sohaib Cheema 604 User Group Leader
