General troubleshooting

This article provides general troubleshooting information for dual-write integration between finance and operations apps and Dataverse.

Enable and view the plug-in trace sign in Dataverse to view error details

Trace logs can be useful when troubleshooting dual-write live sync problems between Finance & Operations and Dataverse. The logs provide specific details to the teams who provide technical and engineering support for Dynamics 365. This article explains how to enable trace logs and how to view them. You manage trace logs in the Dynamics 365 Settings page and need administrator level privileges to change and view them.

Required role to turn on the trace log and view errors: System admin

Turn on the trace log

To turn on the trace log, follow these steps:

1. Sign in Dynamics 365, and then select Settings in the top navigation bar. On the Systems page, select Administration.
2. On the Administration page, select System Settings.
3. Select the Customization tab and plug-in, and then in the custom work flow activity tracing section change the dropdown to All. All activities are traced and a comprehensive set of data is provided to the teams who must review potential issues.

After the plug-in is enabled, trace logs continue to be collected until they're manually turned off by returning to this location and selecting Off.

View the trace log

To view the trace log, follow these steps:

1. On the Dynamics 365 Settings page, select Settings in the top navigation bar.
2. Select Plugin Trace Log in the Customizations section of the page.
3. You can find entries in the list of trace logs, based on Type Name and/or Message Name.
4. Open the desired entry to view the full log. The Message Block in the Execution section provides available information for the plug-in. If available, exception details are provided.

You can copy the contents of the trace logs and paste them into another application like Notepad or other tools to view logs or text files to more easily see all the content.

Enable debug mode to troubleshoot live synchronization problems in finance and operations apps

Required role to view the errors: System admin

Dual-write errors that originate in Dataverse can appear in the finance and operations app. To enable verbose logging for the errors, follow these steps:

1. For all project configurations in finance and operations apps, there's a flag IsDebugMode on the DualWriteProjectConfiguration table.
2. Open the DualWriteProjectConfiguration table by using the Excel add-in. To use the add-in, enable design mode in the finance and operations Excel add-in and add the DualWriteProjectConfiguration table to the sheet. For more information, see View and update entity data with Excel.
3. Set IsDebugMode to Yes on the project.
4. Run the scenario that generates errors.
5. The verbose logs are stored in the DualWriteErrorLog table.
6. To look up data on table browser use the following link: https://999aos.cloudax.dynamics.com/?mi=SysTableBrowser&tableName=DualWriteErrorLog, replacing 999 as needed.
7. Update again after KB 4595434, which is available for platform updates 37 and later. If you have this fix installed, the debug mode captures more logs.

Check synchronization errors on the virtual machine for the finance and operations app

Required role to view the errors: System administrator

1. Sign in to Microsoft Dynamics Lifecycle Services (LCS).
2. Open the LCS project that you chose to do the dual-write testing for.
3. Select the Cloud-hosted environments tile.
4. Use Remote Desktop to sign in to the virtual machine (VM) for the finance and operations app. Use the local account that is shown in LCS.
5. Open Event viewer.
6. Select Applications and Services Logs > Microsoft > Dynamics > AX-DualWriteSync > Operational.
7. Review the list of recent errors.

Dual write UI landing page shows blank

When you open the dual-write page in the Microsoft Edge or Google Chrome browser, the home page doesn't load. You see a blank page or an error such as "Something went wrong." In Devtools, you see an error in the console logs:

bundle.eed39124e62c58ef34d2.js:37 DOMException: Failed to read the 'sessionStorage' property from 'Window': Access is denied for this document. at t.storeInSessionStorage (https://dataintegrator.trafficmanager.net/bundle.eed39124e62c58ef34d2.js:16:136860 ) at new t (https://dataintegrator.trafficmanager.net/bundle.eed39124e62c58ef34d2.js:69:20103 ) at ci (https://dataintegrator.trafficmanager.net/bundle.eed39124e62c58ef34d2.js:37:44115 ) at Eo (https://dataintegrator.trafficmanager.net/bundle.eed39124e62c58ef34d2.js:37:58728 ) at jo (https://dataintegrator.trafficmanager.net/bundle.eed39124e62c58ef34d2.js:37:65191 ) at Nr (https://dataintegrator.trafficmanager.net/bundle.eed39124e62c58ef34d2.js:37:84692 ) at Or (https://dataintegrator.trafficmanager.net/bundle.eed39124e62c58ef34d2.js:37:85076 ) at Ss (https://dataintegrator.trafficmanager.net/bundle.eed39124e62c58ef34d2.js:37:91750 ) at vs (https://dataintegrator.trafficmanager.net/bundle.eed39124e62c58ef34d2.js:37:91130 ) at hs (https://dataintegrator.trafficmanager.net/bundle.eed39124e62c58ef34d2.js:37:90151 )

The UI uses browser 'session storage' to store some property values for loading the home page, so you need to allow third-party cookies in the browser for the site. The error shows that the UI can't access the session storage. You can encounter this problem in two scenarios:

1. You open the UI in an incognito mode of Microsoft Edge or Chrome and the browser blocks third-party cookies in incognito.
2. You block third-party cookies altogether in Microsoft Edge or Chrome.

Mitigation

Allow third-party cookies in browser settings.

Google Chrome browser

First Option:

1. Go to settings by entering chrome://settings/ in the address bar, and then navigate to Privacy and Security > Cookies and other site data.
2. Select Allow all cookies. If you don't want to allow all cookies, use the second option.

Second Option:

1. Go to settings by entering chrome://settings/ in the address bar, and then navigate to Privacy and Security > Cookies and other site data.
2. If Block third-party cookies in Incognito or Block third-party cookies is selected, go to Sites that can always use cookies and select Add.
3. Add your Finance & Operations apps site name - https://<your_FinOp_instance>.cloudax.dynamics.com. Make sure you select the checkbox for All cookies, on this site only.

Microsoft Edge browser

1. Navigate to Settings > Site permissions > Cookies and site data.
2. Turn off Block third-party cookies.

Unlink and link another Dataverse environment from a finance and operations app

Required role to unlink the environment: System administrator for either finance and operations app or Dataverse.

1. Sign in to the finance and operations app.
2. Go to Workspaces > Data management, and select the Dual Write tile.
3. Select all running mappings, and then select Stop.
4. Select Unlink environment.
5. Select Yes to confirm the operation.

You can now link a new environment.

Unable to view the sales order line Information form

When you create a sales order in Dynamics 365 Sales, clicking on + Add products might redirect you to the Dynamics 365 Project Operations order line form. There's no way from that form to view the sales order line Information form. The option for Information doesn't appear in the dropdown menu under New Order Line. This option is missing because Project Operations is installed in your environment.

To re-enable the Information form option, follow these steps:

1. Go to the Order Line table.
2. Find the Information form under the forms node.
3. Select the Information form and select Enable security roles.
4. Change the security setting to Display to everyone.

How to ensure data integration uses the most current finance and operations schema

You might face data problems in your data integration if you don't use the most up-to-date schema. The following steps help you refresh the entity list in finance and operations apps and the entities in the Data integrator.

Refresh entity list in finance and operations environment

1. Sign in to your finance and operations environment.
2. Select Data management.
3. Inside Data management, select Framework parameters.
4. On the Data import/export framework parameters page, select the Entity settings tab, and select Refresh entity list. The list might take more than 30 minutes to refresh, depending on the number of entities involved.
5. Go to Data management and select Data entities to check that the expected entities are listed. If the expected entities aren't listed, check that the entities appear in your finance and operations environment and restore the missing entities, if needed.

If the refresh doesn't resolve the problem, delete and re-add the entities

1. Select Data management in your finance and operations environment and select Data entities.
2. Search for entities with problems, and make a note of the target entity, staging table, entity name, and other settings. Delete the entity or entities from the list.
3. Select New and re-add the entity or entities by using the data from step 2.

Refresh entities in Data integrator

Sign in to Power Platform Admin Center and select Data integration. Open the project where the problems are occurring, and select Refresh entities.

How to enable and save network trace so that you can attach traces to support tickets

The support team might need to review network traces to troubleshoot some problems. To create a network track, follow these steps:

Google Chrome browser

1. In the opened tab, press F12 or select Developer tools to open the developer tools.
2. Open the Network tab and type integ in the filter text box.
3. Run your scenario and watch the requests being logged.
4. Right-click on the entries and select Save all as a HAR with content.

Microsoft Edge browser

1. In the opened tab, press F12 or select Developer tools to open the developer tools.
2. Open the Network tab.
3. Run your scenario.
4. Select save to export the results as HAR.