Data sync fails with deadlock error (opens in new tab)

Recently I have worked on cases where it is observed that data sync fails with deadlock error. Error: Database re-provisioning failed with the exception 'Transaction (Process ID ##) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. To investigate deadlocks, you can enable Extended Events by following the guidance provided here: A Sample deadlock graph looks below: Running the Data Sync Health Checker report also results in...