Incremental Phase Error: Can't DROP '%s'; check that column/key exists

Scenarios

During an incremental migration or synchronization, an error is reported, and the log information is as follows: service INCREMENT failed, cause by: Can't DROP ' %s'; check that column/key exists; sql is %s

Possible Causes

The possible causes are as follows:

• DDL is executed on the destination database table, causing the table structure in the destination database to be inconsistent with that in the source database.

Solution

Contact the O&M engineers of the destination database to change the table structure of the destination database to be the same as that of the source database. Then, in the task list, locate the target task and click Resume in the Operation column to resume the task.