Hi,

The sync group below has been stuck on processing since Feb 4th

Azure Product Subscription ID:
75cf1e6d-765b-443a-abe9-e6c4036bad2e

Sync Group ID:
021babc1-09b8-4d08-b847-db58d7cbd17e_East Asia

StatusProcessing

LAST SYNC
2015/2/4 12:12:25AM

Would you please help me to reset the status from backend? Thanks!

Regards,

Michael Yung

Hi Michael,

The Microsoft support engineer will help to solve the problem from backend. Sometime delay might be expected. Your patience is greatly appreciated. Thank you for understanding and support.

Any of the following can result in a sync group being stuck in the processing state.

a)The client agent is offline.
Be sure that the client agent is online then try again.

b)The client agent is uninstalled or missing.
If the client agent is uninstalled or otherwise missing:
1)Remove agent XML file from the SQL Data Sync (Preview) installation folder if the file exists.
2)Install the agent on same/another on-premise computer, submit the agent key from the portal generated for the agent thats showing offline.

c)The SQL Data Sync (Preview) service is stopped.
1)In the Start menu, search on Services.
2)Click Services in the Programs section of the search results.
3)Find the SQL Data Sync (Preview) service.
4)If the service status is Stopped right-click the service name and select Start from the dropdown menu.

Reference : http://msdn.microsoft.com/en-us/library/azure/hh667321.aspx#ProcessingError

If you have any feedback on our support, please click her

Hi Michael ,

For sync stuck, we have reset the status of the sync group from backend. Please take a check.

For the root cause, it is still in investigation. Will keep you update.

Thanks,

Gary

• Marked as answer by Michael Yung 1 hour 33 minutes ago

Hi Michael ,

For sync stuck, we have reset the status of the sync group from backend. Please take a check.

For the root cause, it is still in investigation. Will keep you update.

Thanks,

Gary

• Marked as answer by Michael Yung 1 hour 43 minutes ago

Hi Michael ,

For sync stuck, we have reset the status of the sync group from backend. Please take a check.

For the root cause, it is still in investigation. Will keep you update.

Thanks,

Gary

• Marked as answer by Michael Yung Wednesday, February 25, 2015 9:57 AM

Hi Michael ,

For sync stuck, we have reset the status of the sync group from backend. Please take a check.

For the root cause, it is still in investigation. Will keep you update.

Thanks,

Gary

• Marked as answer by Michael Yung Wednesday, February 25, 2015 9:57 AM

Hi Michael ,

For sync stuck, we have reset the status of the sync group from backend. Please take a check.

For the root cause, it is still in investigation. Will keep you update.

Thanks,

Gary

• Marked as answer by Michael Yung Wednesday, February 25, 2015 9:57 AM

Hi Michael ,

For sync stuck, we have reset the status of the sync group from backend. Please take a check.

For the root cause, it is still in investigation. Will keep you update.

Thanks,

Gary

• Marked as answer by Michael Yung Wednesday, February 25, 2015 9:57 AM

Hi Michael ,

For sync stuck, we have reset the status of the sync group from backend. Please take a check.

For the root cause, it is still in investigation. Will keep you update.

Thanks,

Gary

• Marked as answer by Michael Yung Wednesday, February 25, 2015 9:57 AM

I've more than 150 sync agents and sync groups and this happened to me every often.

And I've found out that whenever the client is offline during the syn is in progress (like the client switch off the computer when the syn is in progress), and their computer keep switched off for more than 7 days, when they back to online, 100% of time, sync group will just stuck in "processing" state.

Hope this information can help you to find the root cause.

Michael

Hi Michael ,

For sync stuck, we have reset the status of the sync group from backend. Please take a check.

For the root cause, it is still in investigation. Will keep you update.

Thanks,

Gary

• Marked as answer by Michael Yung Wednesday, February 25, 2015 9:57 AM