Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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