Data Sync Issue in a sync group - Sync failed with the exception "Cannot enumerate changes at the RelationalSyncProvider for table

Question

How can I resolve this issue.It occurs frequenctly.This table has large volume of data

Answer 1

Hello @Nitya V

This error can occur when there is a lack of memory or when schema changes have been applied on the database.

Here are some steps you can take to resolve this issue:

1. Stop and delete the sync group related to the table specified in the error.
2. Recreate the sync group. If the table is large, consider putting it in a separate sync group.
3. Make sure the computer where the agent is installed has enough memory to handle SQL Data Sync activity.

If the problem persists, you might want to check for any connectivity issues between Azure and your on-premises SQL Server, ensure that the required ports are open and the firewall rules are correctly configured, verify that the Azure SQL database is up-to-date and there are no issues with the database itself, and check if there are any changes made to the credentials that are being used to authenticate the sync agent. Sometimes, restarting the sync agent service on the server where the agent is installed can resolve the sync issues.

Answer 2

Hi Nitya V •, Welcome to Micrsoft Q&A forum.

As I understand, you are getting Data Sync Issue in a sync group - Sync failed with the exception "Cannot enumerate changes at the RelationalSyncProvider for table.

This error message report that DataSync process is not able to complete the process to synchronize the data.

Refer to the troubleshooting steps mentioned here and follow the same:

https://thewindowsupdate.com/2019/03/21/lesson-learned-78-datasync-cannot-enumerate-changes-at-the-relationalsyncprovider-for-table-customertable-execution-timeout-expired/

Let us know if this helped.

Thanks