Error - SQL_ERROR SqlState: 22000 NativeError: 100072 Message: NULL result in a non-nullable column [1022502]

[vijay_panchanathan]

Facing the "NULL result in a non-nullable column" error in the Qlik task , I kept Oracle as the source and snowflake as the target.
This error only appears while inserting data to the snowflake table. I have checked all the columns in oracle and snowflake both has same structure (IS_NULLABLE). In oracle side I have enabled the ASM Configuration.

Can someone help on this ?

[yfimia]

are you getting this while QLIK is inserting into your "attrep_apply_exceptions" table...???

or while inserting into the target table?

[Barb_Fill21]

Hello @vijay_panchanathan 

Can you try the following? 

 Open the table from the bottom right of the Designer screen. Select Transform. On the screen that opens, click the Expression field for the column. Enter: CASE $ColumnName WHEN null Then ' ' Else $ColumnName END Actually this might work just as well: ifnull($ColumnName,' ')

Let me know if it helps.

Thanks

Barb