Six Stars

NumberFormatException

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"

1 REPLY
Six Stars

Re: NumberFormatException

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

-----------------------------------------------------------------------------------------------------------
When you like my answer, please accept it as solution and send some kudos