Null pointer exception in tmap
You might have faced a common error in Talend i.e. the NullPointerException in tMap
"Exception in component tMap_1
java.lang.NullPointerException"
Solutions:
1) Make sure your columns are nullable when you define the schema.
2) The NullPointerException indicate there are some null value on lookup table, so you need to deal with the null value on corresponding columns on expression filed of tmap, for example:
!Relational.ISNULL(row13.abc)?
row13.xyz:row13.sss:null
"Exception in component tMap_1
java.lang.NullPointerException"
Solutions:
1) Make sure your columns are nullable when you define the schema.
2) The NullPointerException indicate there are some null value on lookup table, so you need to deal with the null value on corresponding columns on expression filed of tmap, for example:
!Relational.ISNULL(row13.abc)?
row13.xyz:row13.sss:null
Thank you very much for your useful information
ReplyDelete