Inserted Data Violates the Non-null Constraint

Cause Analysis

The task fails to be executed. The following information is displayed in the log:

Solution

Perform the following operations to resolve the issue:

• This field in the source table is set to null, but is set to a non-null value in the destination table. To resolve this issue, modify the field attributes in the source and destination tables to ensure consistency.
• A redundant table mapping is configured during task creation. Therefore, data in the source table with a similar name is collected to the destination table. As a result, empty data is written to the field. To resolve this issue, correctly configure the table mapping.
• In the redo logs generated by the Oracle database, the WHERE condition is missing in the field of the UPDATE statement. As a result, the value of this field is missing. To resolve this issue, add the WHERE condition to the field of the UPDATE statement.