error in Tmap: NumberFormatException

One Star

error in Tmap: NumberFormatException

hi all,
i am executing a job and i have an error in a tmap component:
Exception in component tMap_6
java.lang.NumberFormatException: null
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at datawarehouse.customer_performance_acuorl_0_7.Customer_Performance_ACUORL.tHashInput_3Process(Customer_Performance_ACUORL.java:55797)
at datawarehouse.customer_performance_acuorl_0_7.Customer_Performance_ACUORL.tHashInput_1Process(Customer_Performance_ACUORL.java:36006)
at datawarehouse.customer_performance_acuorl_0_7.Customer_Performance_ACUORL.runJobInTOS(Customer_Performance_ACUORL.java:63941)
at datawarehouse.customer_performance_acuorl_0_7.Customer_Performance_ACUORL.main(Customer_Performance_ACUORL.java:63745)
disconnected

Can you please help to understand the meaning and see how can i solve it ?

Regards
Seventeen Stars

Re: error in Tmap: NumberFormatException

hi,
as error log say :
java.lang.NumberFormatException: null
...
Integer.parseInt(unknown)

you've got a null value.
and you try to use a method with a null value.
is it normal ? Smiley Happy
make some profiling about your source data.
correct source or/and filter null value .
and so on!
regards
laurent
One Star

Re: error in Tmap: NumberFormatException

Thank you !!
i fixed the issue by allowing null values for my columns.
Hope this solution will not have a bad impact.
regards
Seventeen Stars

Re: error in Tmap: NumberFormatException

hope so Smiley Wink
better to ask if value can be null , than waiting for some "bad thing" in future.
regards
laurent

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download