topic Re: java.lang.NullPointerException in Talend Studio

java.lang.NullPointerException

Anonymous — Fri, 12 Jul 2019 00:41:34 GMT

I'm using Talend Open Studio for Data Integration version 7.1.1. I'm trying to run a subjob with an output to Contact object in Salesforce. I'm getting this error when running:

Exception in component tMap_1 (STARS2)
java.lang.NullPointerException
at sagestars.stars2_0_1.STARS2.tDBInput_1Process(STARS2.java:5742)
at sagestars.stars2_0_1.STARS2.runJobInTOS(STARS2.java:15012)
at sagestars.stars2_0_1.STARS2.main(STARS2.java:14863)

tmap has a few Expressions with 'null' but i'm not sure if these are the issues?

("Deceased".equals(row1.STATUS))? (row1.STATUS_DT.equals("")?null:row1.STATUS_DT):null

("Deceased".equals(row1.STATUS))?null row1.STATUS_DT.equals("")?null:row1.STATUS_DT)

I don't know what else it could be?

Re: java.lang.NullPointerException

TRF — Fri, 12 Jul 2019 08:06:01 GMT

Change for

("Deceased".equals(row1.STATUS)) ? ("".equals(row1.STATUS_DT) ? null : row1.STATUS_DT) : null

Re: java.lang.NullPointerException

Anonymous — Fri, 12 Jul 2019 17:44:18 GMT

TRF: I changed to what you suggested but i'm still getting the error, should i be changing the other null expression as well? I now have as the two null expressions in the tmap:

("Deceased".equals(row1.STATUS))? ("".equals(row1.STATUS_DT)? null : row1.STATUS_DT): null

and

("Deceased".equals(row1.STATUS))?null row1.STATUS_DT.equals("")?null:row1.STATUS_DT)

Re: java.lang.NullPointerException

djugal — Mon, 13 Jul 2020 05:13:42 GMT

Check your schema in tmap if the destination column is a Nullable column