Applies to Product - Dynamics 365 Supply Chain Management
What’s happening?
The "PayrollCalculationFrequency" table in the Finance and Operations environment is not synchronizing properly, resulting in errors during the synchronization process.
Reason:
The underlying cause of the synchronization issue is the need to enable additional indexes in the Finance and Operations environment.
Resolution:
- Enable additional indexes in the Finance and Operations environment as indicated in the error message.
- Ensure that the environment is not in Administration mode. If it is, disable Administration mode by:
- Logging on to Power Platform Admin.
- Selecting the environment with the problematic Synapse for Dataverse profile.
- Sliding the toggle button under "Administration mode" to disable it.
- Verify that change tracking is enabled for the tables/entities you want to export via Synapse.
- Check Azure resources networking configuration:
- Ensure public network access is enabled for the linked storage account.
- Allow all IP addresses access rule if linking to a Synapse Workspace.
- Confirm that the necessary permissions are in place:
- Dataverse System Administrator security role.
- Synapse Administrator role access if linking with a Synapse Workspace.
- Reader role access to the resource group with the storage account and Synapse workspace.
- Owner and Storage Blob Data Contributor role access for the Azure Data Storage account.
- If there are a large number of records (e.g., 12M records for one year), consider using append-only mode for the entity to avoid sync blocks.
- If facing slow or paused sync issues while adding a new table, remove and then re-add the table(s) with sync issues to mitigate transient profile sync issues.