seeing error: NULL result in a non-nullable column

[schinta]

Hi

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

[Dana_Baldwin]

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

[john_wang]

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.