topic Re: Null value in a non-null column in Qlik Replicate

Null value in a non-null column

suvbin — Wed, 28 Feb 2024 05:08:18 GMT

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

Re: Null value in a non-null column

aarun_arasu — Wed, 28 Feb 2024 05:25:21 GMT

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

Re: Null value in a non-null column

suvbin — Wed, 28 Feb 2024 05:17:10 GMT

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"

Re: Null value in a non-null column

SushilKumar — Thu, 07 Mar 2024 08:47:52 GMT

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