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"
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
