Incremental Synchronization Error: dn_%s_%s: column '%s' contains null values

Scenarios

During incremental synchronization, an error is reported, and the log information is as follows: service INCREMENT failed, cause by: table %s execute the ddl failed ERROR: dn_ %s_ %s: column ' %s' contains null values.

Possible Causes

The possible causes are as follows:

• The destination GaussDB(DWS) database has the NOT NULL constraint, so the default value needs to be set.

Solution

Modify the DDL statement and manually run it in the destination database. Then contact Huawei engineers to skip the synchronization of this DDL statement.