Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Change for
("Deceased".equals(row1.STATUS)) ? ("".equals(row1.STATUS_DT) ? null : row1.STATUS_DT) : null
Change for
("Deceased".equals(row1.STATUS)) ? ("".equals(row1.STATUS_DT) ? null : row1.STATUS_DT) : null
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)
Check your schema in tmap if the destination column is a Nullable column