topic Re: How to resolve the error on not null constraints? in Qlik Replicate

How to resolve the error on not null constraints?

desmondchew — Wed, 02 Apr 2025 09:19:15 GMT

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)

Re: How to resolve the error on not null constraints?

john_wang — Wed, 02 Apr 2025 09:40:53 GMT

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.

Re: How to resolve the error on not null constraints?

DesmondWOO — Wed, 02 Apr 2025 09:57:43 GMT

Hi @desmondchew ,

If the problem persists, please provide the following information:

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

Regards,
Desmond