Null value in non-Nullable column for an Integer field

jpohl — Sat, 16 Nov 2024 04:37:20 GMT

I am relatively new so please consider this if there is a obvious answer.
I have a simple job for which I am trying to move data from a MSSQL database to Redshift. In particular I am getting an error indicating tMSSqlInput_10 Null value in non-Nullable column. The flow is tMSSqlinput -> tmap -> tRedshiftoutput
Within the tmap I am checking for

row12.ClientInstitutionId = 0 ? 0 : row12.ClientInstitutionId

The system will not let me check for null (row12.ClientInstitutionId == null) as it appears that Java needs me to check for zero instead. My thinking being that I can let the value zero go to redshift if the source data is null (or zero), otherwise send over the value

I am ammending this a bit as I have replaced the tmap and tredshift components with the tlogrow component. I still get the same error message.

Re: Null value in non-Nullable column for an Integer field

jpohl — Thu, 19 Sep 2019 20:55:27 GMT

I answered my own question. The database schema had changed and I did not change that schema on my connection

topic Null value in non-Nullable column for an Integer field in Talend Studio

Null value in non-Nullable column for an Integer field

Re: Null value in non-Nullable column for an Integer field