SQL Data Sync - Warning, Log

One of our agents is reporting "Warning" in the group details, and no data is being synced.

However, access to logs is not possible, because a click on the "LOGS" option results in a few minutes of "loading" screen, and then a blank page.

January 26th, 2015 6:26pm

Hi Christian,
 
You can use the following methods to check the log.

Check the Event Log entries on the box where you installed the SQL Data Sync Agent.

Event Viewer->Applications and Services Logs->SQL Azure Data Sync Preview or Event Viewer->Applications and Services Logs->Data Sync Service

Turning logging in verbose mode. Open LocalAgentHost.exe.config in notepad. This file should be present in your installation directory.

a) Uncomment the section that is currently commented < !-- < switches> < add name="SyncAgentTracer" value="4" /> < /switches> < trace autoflush="true" indentsize="4"> < listeners> < add name="myListener" type="Microsoft.SqlAzureDataSync.ClientLogging.DSSClientTraceListener, Microsoft.SqlAzureDataSync.ClientLogging, Version=2.0.0.0" initializeData="DSSAgentOutput.log" /> < remove name="Default" /> < /listeners> < /trace> -->

b) Stop and restart SQL Azure Data Sync Preview Windows Service. Now you would find the detailed logs in files named DSSAgentOutput*.log

There is a similar thread for your reference.
http://stackoverflow.com/questions/21297247/sql-data-sync-fails-and-no-logs-are-available


Thanks,
Lydia Zhang

If you have any feedback on our support, please click here.

Free Windows Admin Tool Kit Click here and download it now
January 27th, 2015 10:30am

Thank you, the extended log did show the problem, and we were able to solve it.
January 27th, 2015 11:19am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics