Logs and History

Logs and History

The Sync application maintains a job history table containing the results of every job that has been executed in the past. In addition to the Job History, the execution details of a job are logged to multiple files. The logs can be configured to various levels of verbosity as described below and can be helpful in tracking connectivity errors or troubleshooting other problems in job execution.

Enable Logging

In the Logging tab, set the Logfile Verbosity property. By default, Job logging is turned on with the Verbosity set to the Info level. The following options are available:

Verbosity Level Description
None Logs are not recorded for this job.
Error This setting will log the query, the number of rows returned by the query, the start and end of execution, and any errors.
Info This setting will log everything at the Error log level, timing of HTTP requests and responses, and information and warnings on the replication process.
Transfer This setting will additionally log the headers and transfer data of HTTP requests and responses.
Verbose This setting will also log replication details as well as communication with the destination that may be helpful in troubleshooting problems.

Setting the Verbosity to Transfer or Verbose will expose the raw data being transferred between the source applications and the destination database.

Viewing Job History

After each Job run attempt, Sync will add an entry into the Job History table with the results of the run. Select the Logging tab to view previous history of the Job. Expanding the row will show the results of each separate task that ran.

Downloading Job Logs

A job run can produce 3 separate logfiles:

  1. Source: Logs any communication with the Source Connector including connection issues, metadata retrieval and errors related to raw data retrieval.
  2. Destination: Logs any communication with the Destination Connector including connection issues, metadata retrieval and errors related to bulk data loading.
  3. Replicate Engine: Logs operations handled by the Engine include communication with the CDATA_SYNC_STATUS table and the generated queries sent to the Source and Destination.

After clicking on the log file name next to the run in the Job History table, you can choose which logfile to download and review. Alternatively, select All to download all logfiles associated with the Job run.