RuntimeException: Null value in non-Nullable

[Anonymous]

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.

[Anonymous]

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.

[Anonymous]

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.