Updated on 2022-09-21 GMT+08:00

Incremental Phase Error: Data truncation: Data too long for column

Scenarios

During an incremental migration or synchronization, an error is reported, and the log information is as follows: service INCREMENT failed, cause by: Data truncation: Data too long for column ' %s' at row %s; sql is: %s

Possible Causes

The possible causes are as follows:

  • The DDL statement fails to be executed because the statement length is too long.

Solution

Contact destination database O&M engineers to check the structure of the table where the synchronization error occurs, adjust the length and data type of the column where the error is reported. Then, in the task list, click Resume in the Operation column of the corresponding task to retry the task.