I have a requirement to sync data between CRM and FO. I have a custom entity in FO that is the source of the data and I have created a custom entity in CRM for it to consume.
Below are all the pre-requisite things I have done to setup Dual Write:
- Create application users in CRM and AAD in FO as instructed by MS
- Installed both core and orchestration solutions in CRM
- Make sure all required plugins for dual write is enabled in CRM
- Turned on change tracking as All tables for the entity in FO
- Ran the initial sync from FO to CRM with query range (Everything that is supposed to go over to CRM is exported)
The problem that I'm currently getting is that dual write is not syncing SOME records from the FO entity even though it matches all the query range criteria to CRM, especially the newly created records after the initial sync. Most of the record that was exported by the initial sync is being tracked by Dual write for any changes, but not any newly inserted records are getting tracked in this entity in FO.
Now I have tried multiple times to recreate the mapping and sync, but still getting the same issue.
