Azure data sync error : Database re-provisioning failed with the exception

Question

Azure data sync error : Database re-provisioning failed with the exception

Burcu Belen 0

Hi,

I constanttly getting same error and I couldn't solve this issue. Error:

Database re-provisioning failed with the exception "Provisioning did not succeed because associated hub might be busy with other provisioning work. Sync Service will retry provisioning during next sync. For more information, provide tracing ID ‘3ad26f86-a691-44e2-b272-1ec002071e9d’ to customer support."

I deleted data sync group and all tables and related views from database and recreated data sync group again. It didn't worked.

I closed all automatic sync which has same server. That didn't work either.

Before I get this error, I tried to change data types of columns manually in Azure SQL database related this data sync group. I am not sure this caused to this error or not. I need to fix this issue urgently.

Could you please help me?

Thanks.

2 answers

Your answer

Answer 1

RahulRandive 10,486 Volunteer Moderator

Thanks for your question.

To get the exact and meaningful error or to know root cause of an issue, you can run

Azure SQL Data Sync Health Checker report

This PowerShell script will check if all the metadata of a hub and member is in place and also validate the scopes against the information we have on the sync metadata database (among other validations). This script will not make any changes, will just validate data sync and user objects. It will also gather some useful information for faster troubleshooting.

Burcu Belen 0 Reputation points

2023-03-11T15:06:27.3833333+00:00

Hi Rahul,

Thank you for responding. I know what member and hub credentials are but I am not sure what to set to Sync metadata database credentials. Could you please explain it ? Is it related with sync agent which I don't use right now ?
RahulRandive 10,486 Reputation points Volunteer Moderator

2023-03-11T15:40:55.94+00:00

The Sync Metadata Database contains the metadata and log for Data Sync. The Sync Metadata Database has to be an Azure SQL Database located in the same region as the Hub Database. The Sync Metadata Database is customer created and customer owned. You can only have one Sync Metadata Database per region and subscription.

Please check if it is same as your Hub Database.

Burcu Belen 0

I used Azure SQL Data Sync Health Checker and here is the result. I couldn't understand what to do.

WARNING: dss schema IS MISSING!
WARNING: TaskHosting schema IS MISSING!
WARNING: dss tables are MISSING!
WARNING: TaskHosting tables are MISSING!
WARNING: dss stored procedures are MISSING!
WARNING: TaskHosting stored procedures are MISSING!
WARNING: dss types are MISSING!
WARNING: TaskHosting types are MISSING!
WARNING: dss functions are MISSING!
WARNING: TaskHosting functions are MISSING!
WARNING: ##MS_SyncAccount## IS MISSING!
WARNING: DataSync_reader IS MISSING!
WARNING: DataSync_executor IS MISSING!
WARNING: DataSync_admin IS MISSING!
WARNING: no DataSyncEncryptionKeys were found!
WARNING: no DataSyncEncryptionCertificates were found!
ValidateSyncDB exception:
Exception calling "ExecuteReader" with "0" argument(s): "Invalid object name 'dss.syncgroup'."

******************************
   WARNINGS SUMMARY FOR HUB
******************************

An unexpected error happened during the validation.

Error: Exception calling "ExecuteReader" with "0" argument(s): "Invalid object name 'dss.userdatabase'."


*********************************
   WARNINGS SUMMARY FOR MEMBER
*********************************

An unexpected error happened during the validation.

Error: Exception calling "ExecuteReader" with "0" argument(s): "Invalid object name 'dss.userdatabase'."

How can I solve this?

Answer 2

GeethaThatipatri-MSFT 29,542 Microsoft Employee Moderator

@Burcu Belen This error is usually transient and comes when multiple scopes are being provisioned at once. It’s also possible that one of the sync groups failed in the middle of provisioning and did not clear up its state, Are you trying to do multiple provisioning at once? Please try with 1 Sync Group at once, if you are doing so.

Otherwise, we will need to manually de-provision any stuck scope_status for that you need to raise a support case please let us know if you have any issues raising a support case.

Regards

Geetha

Yaseen.Elmaandy 40 Reputation points

2025-04-29T13:22:54.4033333+00:00

Hi @GeethaThatipatri-MSFT ,
I have the same issue.
I had one sync group with multiple tables, then I created a second sync group as there was a table that causes timeout during sync, so I wanted this table to be in a separate sync group with different sync frequency.

But the second sync group was failing for credentials issue, so I deleted it, then I found my first original sync group is failing with the same exception :
"Provisioning did not succeed because associated hub might be busy with other provisioning work"
(I had already removed the table from the first sync group before adding it to the second one)

It has been failing for more than a day now, and I already deleted the second sync group, I'm trying to open a support case to check if it is a scope_status issue, but my support plan is basic and doesn't support technical tickets.
Do you know what can I do as it is an urgent matter ?

Thanks,

Share via

Azure data sync error : Database re-provisioning failed with the exception

2 answers

Your answer