Qlik Compose CDC: Cannot insert the value NULL into column

till_bentz — Fri, 14 Mar 2025 20:49:07 GMT

I have a question about a Compose Task.

I have a mapping that creates a table in the data warehouse from a table in the landing zone. The full load works. Apparently a row with id = 0 and all other values NULL is created. If I now want to run this mapping as a CDC task, I always get the error message “Cannot insert the value NULL into column”. This message occurs when the task “Populating temporary table TTMP_5868_DwhKeys” is to be executed. How can I fix this error, since the NULL line is created by Compose?

Any tips are highly appreciated!

Re: Qlik Compose CDC: Cannot insert the value NULL into column

sureshkumar — Sat, 21 Sep 2024 19:40:54 GMT

Hello @till_bentz

When we run Full Load or CDC, the 1st row of the HUB table contains id=0 with the remaining columns as NULL.

Kindly check the DDL of the table once.

I would suggest Drop and Recreate the tables once.

Regards,

Suresh

topic Qlik Compose CDC: Cannot insert the value NULL into column in Qlik Compose

Qlik Compose CDC: Cannot insert the value NULL into column

Re: Qlik Compose CDC: Cannot insert the value NULL into column