Share
Report
126Hello experts,
I am facing an issue with DualWrite and I hope to find solution here. I have modified the SalesOrderHeaderD365SalesEntity:
- Added a custom table (DemoSalesTable) in the data source of the entity (Table relation is SalesTable.RecId = DemoSalesTable.SalesTable).
- Added fields in the entity & staging table from custom table.
- The custom table has fields exposed on Sales order details form.
- The mapping of these fields is defined in the data entity fields mapping.
- The mapping of these fields is defined in the Dual write table fields mapping.
So, issue is:
- When standard fields of SalesTable are modified, DualWrite is syncing both standard and custom fields in the Dataverse
- But when custom fields from DemoSalesTable are modified, it is not syncing the sales order in the Dataverse for custom fields.
Steps taken so far:
- I have overridden DefaultCTQuery method of SalesOrderHeaderD365SalesEntity in CoC to include DemoSalesTable in its query.
- Enabled the custom query change tracking option from data entities list page for SalesOrderHeaderD365SalesEntity.
- Manually added a record in BusinessEventsDefinition table for DemoSalesTable & SalesOrderHeaderD365SalesEntity. I am not sure which process is adding records for business event so added record manually.
- Stop, Run, Pause DualWrite service for SalesOrderHeaderD365SalesEntity.
- Refresh data entities list.
- Also tried to use SalesOrderHeaderCDSEntity which is using SalesOrderHeaderV2Entity as a data source. I have modified SalesOrderHeaderV2Entity following the similar steps as described above.
All responses (
Answers (
