Since Jan 16 my sync is saying that is processing and when I check the log is saying that has processed a lot of rows but when I check the data nothing has sync between my on premise and Azure.  Below the information and the log:

STATUS
Processing
LAST SYNC
1/16/2015 10:23:03 AM
SYNC GROUP ID
1630394a-3db2-4028-9cae-5ac32cc5b329_East US
LOCATION
East US
SUBSCRIPTION NAME
Pay-As-You-Go
SUBSCRIPTION ID
399ba2d3-f357-4c7b-a52e-972bcb3cc2d7
CONFLICT RESOLUTION
Client Wins

3074 rows have been processed in 900 seconds.    For more information, provide tracing ID a58fec2c-49ae-409a-be90-2ecdd0eee687 to customer support.

31829 rows have been processed in 8101 seconds.    For more information, provide tracing ID 153badc7-6ffb-4df0-9cb7-cfd49d919484 to customer support.

Hi,

Thanks for posting here.

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

Girish Prajwal

Last night it gave me this error:

Sync failed with the exception "GetStatus failed with exception:Sync worker failed, checked by GetStatus method.
Failure details:An unexpected error occurred when applying batch file C:\Resources\directory\07eb40e27bc6414382cf30de457d7c69.NTierSyncServiceWorkerRole.LS1\DSS_368ccf32-f884-4a14-a0c0-ed61ce3df45c\770da842-797d-4be6-a8ac-01fc0fd290ea.batch.
See the inner exception for more details.
Inner exception: SqlException Error Code: -2146232060 - SqlError Number:10053, Message: A transport-level error has occurred when sending the request to the server.
(provider: TCP Provider, error: 0 - An established connection was aborted by the software in your host machine.)
Inner exception: An established connection was aborted by the software in your host machine"   
For more information, provide tracing ID 153badc7-6ffb-4df0-9cb7-cfd49d919484 to customer support.

I restart the service and try the Sync again

After I restart the agent again and restart the sync everything seems to be working now, but after I sync the first time the automated one is been running for over 20 minutes

• Edited by Juan J Pascual Tuesday, January 20, 2015 5:02 PM change in the status
• Marked as answer by Juan J Pascual Wednesday, January 21, 2015 3:27 PM

After I restart the agent again and restart the sync everything seems to be working now, but after I sync the first time the automated one is been running for over 20 minutes

• Edited by Juan J Pascual Tuesday, January 20, 2015 5:02 PM change in the status
• Marked as answer by Juan J Pascual Wednesday, January 21, 2015 3:27 PM

Hi,

From our backend it shows that your sync group is working fine. Could you please check it and let me know the latest status of your issue?

Regards,
Bowen

Verifying the status of the Sync after what I did the Sync came to his normal status and is working fine, thanks