Null value in a non-null column

[suvbin]

Hi Team,

Column is not present in the transform tab , but getting the error. "Null value in a non-null column". 

When checked in the target db , the column is present. 

could you please help on this.

Source - SAP hana

Target - Azure SQL

Thanks

[aarun_arasu]

Hi @suvbin ,

Thanks for reaching out to Qlik community.

I would request you to provide more information on the issue, like error message and the column name ,etc 

Regards

Arun

[suvbin]

No its not complaining regarding the the column exist in the target or not. Its throwing error stating "cannot insert tbe value NULL into <column>, <table>.<column> does not allow null"

[SushilKumar]

hello @suvbin 

IN such cases you have to look into to table metadata and particular column. As QR is apply the Statement onto the Connecting database and  such constraints are managed by database itself 

if column is marked as not null then during insert or update you have to put some value in it , otherwise your insert statement fails. or Allow null value then you statement will succeed.

Regards,

Sushil Kumar