I try to remove my sync group in Azure DataSync , but get a message "Cannot remove this sync group because one or more databases are currently provisioning, re-provisioning, de-provisioning, canceling sync or synchronizing. TracingId=cc4af9b5-f6c5-2ca9-9412-acbaee44f87b"

My sync group is Sync Group ID: b9dfb07f-5415-487d-a6c7-c7caccf473b8_East / Subscription ID: 31e2bcf5-8078-4bf3-8898-ba771ea860ac

And before I try to remove it, it has a trouble that Provisioning never finishes.
The provisioning was adding reference new servers and the provisioning is continuing for more than 10 days.

While removing the sync group, I had deleted all reference database other than the hub database, and applied DeprovisioningUtil.exe to the hub database.
In the sync group, all databases were Azure SQL.  The sync group didn't use sync agent.

The hub database seems to have no tables relating datasync like as "_dss" or "_traking" after I applied DeprovisioningUtil.exe.

I had no more idea to do other than waiting, any other ideas?

Best regards,

Hi Kamiyn,

Regarding to the error message and your description, it seems that you tried to remove sync group failed , I assume you only have one sync group, when you used DeprovisioningUtil tool, you should manually clean up all objects by running the deprovisioning utility from the same folder where the Data Sync Agent gets installed.

Here is a similar issue about this error, you can refer to the post.
http://social.msdn.microsoft.com/Forums/en-US/d0c50049-4d20-447e-85f9-904f7d146a40/cannot-remove-a-data-sync-group-even-dropping-the-involved-databases-and-servers?forum=ssdsgetstarted

Hope it is helpful for you.

Thanks,
Sofiya Li

Hi Kamiyn,

please refer to _http://msdn.microsoft.com/en-us/library/windowsazure/hh667321.aspx#bkmk_cantdeletesyncgroup

it may related to the following factors:
The client agent is offline
The client agent is uninstalled or missing
The SQL Data Sync (Preview) service is stopped
A database is offline
The sync group is provisioning or synchronizing

Thank you for a lot of advices,

A few days before, I decided to change the name of Hub database.

At this time, the troubling sync group has no connection to my databases.

On my Azure portal site "The sync group is provisioning" still remains.  I would like to clean up this troubling sync group.

Today, I try to delete to the sync group and succeed.

Some improvements are occurred.

Thank you for all engineering team!

• Marked as answer by Sofiya LiMicrosoft contingent staff, Moderator 6 hours 45 minutes ago

Today, I try to delete to the sync group and succeed.

Some improvements are occurred.

Thank you for all engineering team!

• Marked as answer by Sofiya LiMicrosoft contingent staff, Moderator 6 hours 57 minutes ago

Today, I try to delete to the sync group and succeed.

Some improvements are occurred.

Thank you for all engineering team!

• Marked as answer by Sofiya LiMicrosoft contingent staff, Moderator Wednesday, December 18, 2013 4:45 AM

Today, I try to delete to the sync group and succeed.

Some improvements are occurred.

Thank you for all engineering team!

• Marked as answer by Sofiya LiMicrosoft contingent staff, Moderator Wednesday, December 18, 2013 4:45 AM

Today, I try to delete to the sync group and succeed.

Some improvements are occurred.

Thank you for all engineering team!

• Marked as answer by Sofiya LiMicrosoft contingent staff, Moderator Wednesday, December 18, 2013 4:45 AM

Today, I try to delete to the sync group and succeed.

Some improvements are occurred.

Thank you for all engineering team!

• Marked as answer by Sofiya LiMicrosoft contingent staff, Moderator Wednesday, December 18, 2013 4:45 AM

Today, I try to delete to the sync group and succeed.

Some improvements are occurred.

Thank you for all engineering team!

• Marked as answer by Sofiya LiMicrosoft contingent staff, Moderator Wednesday, December 18, 2013 4:45 AM

Today, I try to delete to the sync group and succeed.

Some improvements are occurred.

Thank you for all engineering team!

• Marked as answer by Sofiya LiMicrosoft contingent staff, Moderator Wednesday, December 18, 2013 4:45 AM

Today, I try to delete to the sync group and succeed.

Some improvements are occurred.

Thank you for all engineering team!

• Marked as answer by Sofiya LiMicrosoft contingent staff, Moderator Wednesday, December 18, 2013 4:45 AM

Today, I try to delete to the sync group and succeed.

Some improvements are occurred.

Thank you for all engineering team!

• Marked as answer by Sofiya LiMicrosoft contingent staff, Moderator Wednesday, December 18, 2013 4:45 AM

Today, I try to delete to the sync group and succeed.

Some improvements are occurred.

Thank you for all engineering team!

• Marked as answer by Sofiya LiMicrosoft contingent staff, Moderator Wednesday, December 18, 2013 4:45 AM

Today, I try to delete to the sync group and succeed.

Some improvements are occurred.

Thank you for all engineering team!

• Marked as answer by Sofiya LiMicrosoft contingent staff, Moderator Wednesday, December 18, 2013 4:45 AM

Today, I try to delete to the sync group and succeed.

Some improvements are occurred.

Thank you for all engineering team!

• Marked as answer by Sofiya LiMicrosoft contingent staff, Moderator Wednesday, December 18, 2013 4:45 AM

Today, I try to delete to the sync group and succeed.

Some improvements are occurred.

Thank you for all engineering team!

• Marked as answer by Sofiya LiMicrosoft contingent staff, Moderator Wednesday, December 18, 2013 4:45 AM

Today, I try to delete to the sync group and succeed.

Some improvements are occurred.

Thank you for all engineering team!

• Marked as answer by Sofiya LiMicrosoft contingent staff, Moderator Wednesday, December 18, 2013 4:45 AM

Today, I try to delete to the sync group and succeed.

Some improvements are occurred.

Thank you for all engineering team!

• Marked as answer by Sofiya LiMicrosoft contingent staff, Moderator Wednesday, December 18, 2013 4:45 AM