topic Re: error in Tmap: NumberFormatException in Talend Studio

error in Tmap: NumberFormatException

Anonymous — Thu, 13 Dec 2012 11:07:56 GMT

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

Re: error in Tmap: NumberFormatException

Anonymous — Thu, 13 Dec 2012 20:40:19 GMT

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 ?
make some profiling about your source data.
correct source or/and filter null value .
and so on!
regards
laurent

Re: error in Tmap: NumberFormatException

Anonymous — Fri, 14 Dec 2012 09:11:27 GMT

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

Re: error in Tmap: NumberFormatException

Anonymous — Fri, 14 Dec 2012 09:46:51 GMT

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