Qlik Compose CDC: Cannot insert the value NULL into column

[till_bentz]

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!

[sureshkumar]

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