topic Re: seeing error: NULL result in a non-nullable column in Qlik Replicate

seeing error: NULL result in a non-nullable column

schinta — Thu, 16 Nov 2023 00:46:59 GMT

Actually am seeing the error "NULL result in a non-nullable column" but as i verified the data for 4 Columns am seeing null value, So i verified Source data(Sql Serevr) which is null value is coming as the field also defined null's are accepted and Target is Snowflake when the table description is created as nulls are accepted but after full load its trying to insert but getting the error when cdc is running.

\Could you please help me on this

Re: seeing error: NULL result in a non-nullable column

Dana_Baldwin — Thu, 16 Nov 2023 18:50:08 GMT

Hi @schinta

We would need to check task settings and log files to troubleshoot this, so it would be best if you open a support case in order to avoid posting data here that is publicly available.

Thanks,

Dana

Re: seeing error: NULL result in a non-nullable column

john_wang — Fri, 17 Nov 2023 13:16:40 GMT

Hello @schinta ,

For further understand the issue, You may check if the column(s) value are NULL in the interim CSV file by set keepCSVFiles & keepErrorFiles to TRUE:

Repeat the error then check the generated CSV files (default location "C:\Program Files\Attunity\Replicate\data\tasks\<taskName>\data_files\").

Hope this helps.

John.