Possible cause: A column is not found in the destination table.

Note Error message example: DTS-30019: Can not find column [name in srcDB, name in destDB ], target table: user.basic_info

This message indicates that the name column is not found in the user.basic_info table in the destination database.

Solutions:
  • Solution 1: (Recommended) Add the missing column to the table in the destination database and start the Data Transmission Service (DTS) task.
  • Solution 2:
    Important This solution cannot be used in the following scenarios: you perform two-way synchronization, other services except for DTS need to write data to the destination table, or the table in the destination database is the destination table of a one-way many-to-one synchronization task or multiple one-way synchronization tasks.
    1. Remove the table for which the error is reported from the objects to be synchronized and start the task again. For more information about how to remove an object from a data synchronization task, see Remove an object from a data synchronization task.
    2. Proceed by scenario:
      • If the data synchronization task includes schema synchronization, you need to only delete the table from the destination database.
      • If the data synchronization task does not include schema synchronization, delete the table from the destination database. Then, create a table that uses the same schema as the source table in the destination database.
    3. Add the table to the objects to be synchronized. For more information about how to add an object for a data synchronization task, see Add an object to a data synchronization task.

What to do next: DTS cannot synchronize DDL operations. Therefore, if you add a column to a table in the source database during data synchronization, this error occurs. In this case, add the column to the destination table before you add the column to the source table. This prevents the error.