NumberFormatException

RAJ6 — Sat, 16 Nov 2024 09:24:07 GMT

Hi Frnds,

I am facing "NumberFormatException" Error. Please tell me how to solve this issue?

ERROR:

Exception in component tAggregateRow_3_AGGOUT (LM2)
java.lang.NumberFormatException
at java.math.BigDecimal.<init>(Unknown Source)
at java.math.BigDecimal.<init>(Unknown Source)
at java.math.BigDecimal.<init>(Unknown Source)
at local_project___java.lm2_0_1.LM2.tFileInputExcel_2Process(LM2.java:21623)
at local_project___java.lm2_0_1.LM2.runJobInTOS(LM2.java:33940)
at local_project___java.lm2_0_1.LM2.main(LM2.java:33766)
[FATAL]: local_project___java.lm2_0_1.LM2 - tAggregateRow_3_AGGOUT null
java.lang.NumberFormatException
at java.math.BigDecimal.<init>(Unknown Source)
at java.math.BigDecimal.<init>(Unknown Source)
at java.math.BigDecimal.<init>(Unknown Source)
at local_project___java.lm2_0_1.LM2.tFileInputExcel_2Process(LM2.java:21623)
at local_project___java.lm2_0_1.LM2.runJobInTOS(LM2.java:33940)
at local_project___java.lm2_0_1.LM2.main(LM2.java:33766)
For input string: "STORE"
[ERROR]: local_project___java.lm2_0_1.LM2 - tFileInputExcel_4 - For input string: "STORE"
For input string: "TERM"
[ERROR]: local_project___java.lm2_0_1.LM2 - tFileInputExcel_4 - For input string: "TERM"
For input string: "TERM"
[ERROR]: local_project___java.lm2_0_1.LM2 - tFileInputExcel_4 - For input string: "TERM"
For input string: "TERM"
[ERROR]: local_project___java.lm2_0_1.LM2 - tFileInputExcel_4 - For input string: "TERM"

Re: NumberFormatException

Aukema — Thu, 17 Aug 2017 12:25:42 GMT

It looks like the field is a BigDecimal, but the data in the Excel file is String... The string "STORE" can not be converted to a BigDecimal causing this error.

Most likely something wrong in the selection or mapping in the job

topic NumberFormatException in Talend Studio

NumberFormatException

Re: NumberFormatException