topic java.lang.NumberFormatException: null error in Talend Studio

java.lang.NumberFormatException: null error

Anonymous — Fri, 12 Jul 2019 18:33:13 GMT

I'm on version 7.1.1 I am passing data into Salesforce (Output)

I'm getting another error i can't figure out what's going on in the tmap:

Error:

java.lang.NumberFormatException: null
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.valueOf(Unknown Source)

I've taken a screen shot of the mapping....most are string to string.... it's just one column where both the input and output are type BigDecimal that is the only one I can think of that might have an issue with NumberFormatException? "0".equals(row16.YR_HSLD_INCOME)? null : row16.YR_HSLD_INCOME I added the "0".equals just in case that would fix it but it didn't. (I don't think I really need that).

Thanks!

Re: java.lang.NumberFormatException: null error

Anonymous — Fri, 12 Jul 2019 19:42:57 GMT

Hi,

I believe you are trying to do a string processing function to a numeric value. Could you please try below snippet and let us know the results?

row16.YR_HSLD_INCOME==0?null:row16.YR_HSLD_INCOME

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: java.lang.NumberFormatException: null error

Anonymous — Fri, 12 Jul 2019 19:49:58 GMT

It's actually a BigDecimal to a Big Decimal and when i tried your solution i got a pop up error instead

Re: java.lang.NumberFormatException: null error

Anonymous — Fri, 12 Jul 2019 20:00:12 GMT

Ok.. Lets try BigDecimal function then.

(row2.data.compareTo(BigDecimal.ZERO)== 0)?null:row2.data

Please try like above and let us know your results.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: java.lang.NumberFormatException: null error

Anonymous — Tue, 16 Jul 2019 17:52:20 GMT

so strange, i tried your BigDecimal version and still getting the Null error! All other Output columns are mostly string to string and one date to date. Any other ideas? I'm completely stuck. Thanks!