Data Sync has been failing for over a week

Peter Quinn 20 Reputation points
2026-06-08T14:52:49.0733333+00:00

Data Sync Sync_To_Reporting_Database on Database SDPriceIT has been failing for over a week, I have tried increasing the DTU settings to 3000 and it has still failed. Please advise what

Failure looks to be a timeout..

Check the inner exception for any store-specific errors.Inner exception: SqlException ID: a26359fc-c939-401a-bf69-34fd416e1fa3, Error Code: -2146232060 - SqlError Number:-2, Message: SQL error with code -2 Inner exception: The wait operation timed out For more information, provide tracing ID ‘4de4cd19-2508-490d-a9df-bfcc41cd3081’ to customer support."

Azure SQL Database

Answer accepted by question author

Manoj Kumar Boyini 17,950 Reputation points Microsoft External Staff Moderator
2026-06-18T10:11:02.0233333+00:00

Hi @Peter Quinn

Thank you for the update. Since the synchronization completed successfully after removing table from the Sync Group, this confirms that the issue was isolated to that table. If preserving the data is required, you may consider renaming the existing table to an archive table and creating a new table with the same schema before adding it back to the Sync Group. This approach avoids the need to copy a very large volume of data and can save considerable time while maintaining a backup of the original records.

Please let us know if you have any questions or concerns

Was this answer helpful?

3 people found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Mohamed Baioumy 0 Reputation points Microsoft Employee
    2026-06-10T13:31:58.18+00:00

    Thank you for your patience, and I really appreciate you sharing the details with us. I’ve taken some time to analyze the error along with the Azure SQL Database setup, and I’d like to walk you through what we’re seeing.

    What we’re observing

    The failure is happening during the change enumeration phase on the table dbo.SDFoxFndDocumentPriceDetailStaging.

    In simple terms, this is the stage where Data Sync tries to read and identify the changes that need to be synchronized. During this process, the underlying query is taking longer than expected and eventually hits a timeout (SQL error -2).

    This indicates a performance-related bottleneck, rather than a configuration issue or a functional problem with Data Sync itself.

    What could be contributing to this

    Based on the behavior and the table involved, this is most likely related to one or more of the following:

    • The table holds a large volume of data or is frequently updated
    • Indexes may be missing or not optimal, making the query slower
    • There could be blocking or concurrent activity affecting query execution
    • A large backlog of change tracking data that needs to be processed

    Initial checks we recommend

    To better understand the situation, it would be helpful to review:

    1. Table size

    SQL

    sp_spaceused 'dbo.SDFoxFndDocumentPriceDetailStaging'

    2. Change tracking volume

    SQL

    SELECT COUNT(*)

    FROM dbo.SDFoxFndDocumentPriceDetailStaging_tracking

    Design observation

    I also noticed that the database TPM_Reporting_Database is currently acting as both:

    • a member database, and
    • the sync metadata database

    While this is technically possible, it is not considered a best practice. For better performance and isolation, we recommend hosting the sync metadata database in a separate, dedicated Azure SQL Database.

    Summary

    Overall, this looks like a performance constraint during the change detection step, particularly for the staging table mentioned above. Focusing on table size, indexing, and workload patterns should help us pinpoint the exact cause and improve reliability.

    Please feel free to share the results from the checks above, and I’ll be more than happy to review them with you and suggest the next steps.

    Thanks again for your collaboration on this—happy to continue working together on it

    Was this answer helpful?

  2. Alberto Morillo 35,506 Reputation points MVP Volunteer Moderator
    2026-06-08T16:53:15.4466667+00:00

    Could you please perform index rebuild and update statistics on the production databases involved in the sync? You can use Ola Hallengren scriptsif you want. After that try to run the sync process again.

    If you still receive the same error, use sp_who2 or this article to see any blocking process not allowing the sync to work.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.