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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Labels (3)
3 Replies
Anonymous
Not applicable
Author

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

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

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