Data Transmission Service

Table Not Exist in DML Statement Synchronization: Table xxx doesn't exist

2023-10-31 02:28:50

Scenario

An error occurred while DTS was synchronizing incremental data based on a task that contains incremental data migration or synchronization. The error log information contains "Table xxx doesn't exist".

Keywords

Table xxx doesn't exist

Possible Causes

The corresponding table has been deleted from the destination database.

Solutions

To fix this error, use one of the following methods:

Method 1: Contact the database O&M engineer to manually create the missing table in the destination database, and then restart the task.

**Note: **If the table in the source database contains data, data in the destination table can be inconsistent with the data in the source table after the task is resumed by using this method.

Method 2: Recreate a DTS synchronization task.


hYYcYPZ3vo4E