Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

java.lang.NullPointerException

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 0683p000009MPcz.pngrow1.STATUS_DT.equals("")?null:row1.STATUS_DT)

 

I don't know what else it could be? 

 

Labels (2)
1 Solution

Accepted Solutions
TRF
Champion II
Champion II

Change for

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

 

View solution in original post

3 Replies
TRF
Champion II
Champion II

Change for

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

 

Anonymous
Not applicable
Author

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 0683p000009MPcz.pngrow1.STATUS_DT.equals("")?null:row1.STATUS_DT)

djugal
Contributor III
Contributor III

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