Microsoft SQL Data Sync - Cannot enumerate changes at the RelationalSyncProvider for table

Question

Hi, I have a Azure SQL Server Database with just one table with 1.75 million records. I'm trying to sync this table with one onpremise SqlExpress instance. This first Sync worked properly without any error. But the second time I tried the sync I started to receive the following erro:

"Sync failed with the exception "Cannot enumerate changes at the RelationalSyncProvider for table 'dbo.CiqData'. Check the inner exception for any store-specific errors.Inner exception: SqlException Error Code: -2146232060 - SqlError Number:-2, Message: Tempo Limite de Execução Expirado. O período de tempo limite terminou antes da conclusão da operação ou o servidor não está respondendo. Inner exception: O tempo limite de espera foi atingido For more information, provide tracing ID ‘be2e7575-d5bd-4c68-9c97-98cdd0e10925’ to customer support."

I made many searches about this without success. Hope here I can find help form one one you.

Answer 1

Hi Ubirajara Mendes •,

Welcome to Microsoft Q&A forum.

I addition to Alberto's answer, you can refer to the post here https://thewindowsupdate.com/2019/03/21/lesson-learned-78-datasync-cannot-enumerate-changes-at-the-relationalsyncprovider-for-table-customertable-execution-timeout-expired/

if the solution helps in your case.

Thanks

Answer 2

Please rebuild indexes and update statistics on the database and the SQL Data Sync may be able to sync successfully again. Try to do these maintenance tasks daily on the hub and member database.

You can also examine long running queries on the "Query Performance Insight" section of the Azure SQL Database (Azure Portal) and identify long running queries that may be related with the tables SQL Data Sync is replicating.

Verify also computing resources consumption is not getting 100% while Data Sync operates. If that is the case, you may need to scale up the service tier of the database.

Take in consideration SQL Server Express is able to use only 1.4 GB of RAM, try using Developer Edition.