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
3 REPLIES
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