topic Error - SQL_ERROR SqlState: 22000 NativeError: 100072 Message: NULL result in a non-nullable column [1022502] in Integration, Extension & APIs

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

vijay_panchanathan — Tue, 06 Sep 2022 07:46:47 GMT

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 ?

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

yfimia — Sat, 05 Nov 2022 00:43:32 GMT

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

or while inserting into the target table?

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

Barb_Fill21 — Sun, 26 Mar 2023 18:38:01 GMT

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