To debug the errors in Dual Write, in addition to the normal Error Log in Data Management, the following approach can be used.
- Open D365 FO as Admin-User
- Search for "Excel Workbook Designer" https://YOUR-FO-INSTANCE/?cmp=DE02&mi=ExportToExcelWorkbookDesigner
- Search for "dualwrite"
- Select "DualWriteProjectConfiguration"
- Select "All Fields"
- Click "Create workbook"
- Click "Download"
- Open the Excel file and click "Enable Editing"
- Authenticate with your D365 FO Admin user in the Dialog window (FO-Connector)
- Search for Entity Name in list of Projects (column B - External entity name)
- Search for column "IsDebugMode"
- Change both lines to "Yes"
- Remove all filters from Excel (column B)
- Click Publish
- Open Error Log Url in D365 FO https://YOUR-FO-INSTANCE/?mi=SysTableBrowser&TableName=DualWriteErrorLog
- Reproduce the issue in the application
- Reopen the URL (step 15 again) and click the Office icon in top right corner
The result contains the error messages in column "DetailedError Message".
Note: Dont forget to change "IsDebugMode" back to "No" after troubleshooting session.
Cheers!
