CData Sync

Connection error: The TCP/IP connection to the host <host>, port <port> has failed.

The following message is displayed when setting up a SQL Server destination connection in CData Sync.

Possible cause

There is an issue with CData Sync connecting to SQL Server.

Solution

• Open SQL Server Configuration Manager.

• Check the TCP Port number.

• Check if TCP/IP is set to Enabled for the Port. See the illustration below for an example.

  

Error: Database or disk is full

You may encounter errors while loading data using CData Sync. For example, when some of the tables have loaded successfully, but for the remaining tables an error message occurs indicating that the database or disk is full.

Possible cause

When CData loads data from your source system to Azure Blob, CData Sync temporarily stores the .csv for the task on the local disk on the server where CData is installed. This error might show up when there is is an issue with the local disk.

Note:

The location where the temporary .csv file is stored is located on C:\ drive. There is no option in CData Sync to configure or modify the storage location.

Possible solution

1. Check if the disk where CData Sync is installed has enough free space.

2. If the disk is (almost) full, check if the folder C:\Windows\ServiceProfiles\NetworkService\AppData\Local\Temp\cdata contains temporary folders with data.

   Note:

   The location might be different for older versions of CData Sync.

3. In case you see temporary folders, you can delete those manually to free up disk space. In you CData Sync connections, you can add the following to your connection under Miscellaneous > Other schemacacheduration=-1.

Possible solution

In case the steps above do not provide a solution to the problem, you could create a symbolic link from the CData Sync temporary directory to another disk with sufficient free disk space.

1. Open a command prompt on the server where CData Sync is installed.

2. Create the symbolic link using the following command:

mklink /J "C:\Windows\ServiceProfiles\NetworkService\AppData\Local\Temp\cdata" "D:\cdata_tmp"

Note:

Replace the drive letter, in this example D, with a drive that has sufficient disk space.