How to resolve the error on not null constraints?

[desmondchew]

Hi,

I have a new task trying to load the table but it failed to load successfully. Got an error on the following. How can I fix this in Snowflake as target endpoint?

00006060: 2025-04-02T01:29:37 [TASK_MANAGER ]W: Table 'TSCHEMA'.'20TABLE' (subtask 0 thread 1) is suspended. A NOT NULL constraint violation occurred on column 'DO'.
After resolving the issue, check for additional NULLs that might violate NOT NULL constraints. Then reload the table. (replicationtask.c:3152)

[john_wang · Accepted solution]

Hello Desmond, @desmondchew 

This error indicates that the column 'DO' in the table 'TSCHEMA'.'20TABLE' is defined with a NOT NULL constraint in Snowflake. Please verify the NULLABLE property of this column on both the source and target sides and check whether null values are being transferred to Snowflake.

One possible solution is to allow null values for this column on the target side.

Hope this helps.

John.

[DesmondWOO]

Hi @desmondchew ,

If the problem persists, please provide the following information:

1. Qlik Replicate version
2. Source endpoint type
3. DDL of the source table and target table
4. Sample data
5. Indicate whether the error occurs during the full load stage or the CDC stage.

Regards,
Desmond