Scenario
An error occurred while DTS was migrating full data based on a task that contains full data migration or synchronization. The following error message appears: getColumnList error.
Keywords
getColumnList error
Possible Causes
The corresponding table in the destination database has been deleted or has its struct changed before the full data migration is complete, or the table in the source database was renamed.
Solutions
Check whether the corresponding table exists in the destination database and whether its table struct is consistent with the struct of the corresponding table in the source database. Check whether a DDL statement related to this table has been executed on the source database during this period.
If a related DDL statement has been executed on the source database, do the following:
Recreate a migration task, and make sure that no DDL statements related to the table to be migrated are executed on the source database before the full data migration is complete.
If no related DDL statement has been executed on the source database and the table struct of the destination database was manually changed, do the following:
Obtain the statement that creates the table in the source database, and run the statement on the destination database. Then, restart the task.If this error persists, contact DTS technical support for troubleshooting.