topic RuntimeException: Null value in non-Nullable in Talend Studio

RuntimeException: Null value in non-Nullable

Anonymous — Wed, 11 May 2016 17:14:26 GMT

Hi,

I created a job as follows: TPostgresInput ---> TMap ----> TfileOutputDelimited. I am trying using the TMap to filter Null or empty rows on COD_RGE

As we can see on the schema, the COD_RGE is Nullable.

This is my filter to catch the rejects.

When I execute, I get
Exception in component tPostgresqlInput_1
java.lang.RuntimeException: Null value in non-Nullable column

I checked all my non nullable columns and did not find null value.

Not sure how to resolve this issue. Please help. Thanks.

Re: RuntimeException: Null value in non-Nullable

Anonymous — Wed, 11 May 2016 20:16:53 GMT

The error should include the Java code line number.
Click on the Code tab and take a look.
This may help you to narrow down the issue.

Re: RuntimeException: Null value in non-Nullable

Anonymous — Thu, 12 May 2016 09:26:34 GMT

Thanks for the hint. Before checking, I saw on TaledForge a similar post where te suggestion was: check whether the schema columns and the source query columns are in same sequence. I did so and indeed there was a synchronisation problem.

After synchronisation, It now works OK.