topic Re: NumberFormatException with TaggregateRow in Talend Studio

NumberFormatException with TaggregateRow

Anonymous — Sat, 16 Nov 2024 13:38:15 GMT

Hello,
i've got a problem with a tAggregateRow
I have the following error message :
"Exception in component tAggregateRow_1_AGGOUT
java.lang.NumberFormatException
at java.math.BigDecimal.<init>(Unknown Source)
at java.math.BigDecimal.<init>(Unknown Source)
at fauchon_alimentation.etape4_alimentation_faits_ca_0_1.Etape4_Alimentation_FAITS_CA.tMSSqlInput_1Process(Etape4_Alimentation_FAITS_CA.java:9700)
at fauchon_alimentation.etape4_alimentation_faits_ca_0_1.Etape4_Alimentation_FAITS_CA.runJobInTOS(Etape4_Alimentation_FAITS_CA.java:12560)
at fauchon_alimentation.etape4_alimentation_faits_ca_0_1.Etape4_Alimentation_FAITS_CA.main(Etape4_Alimentation_FAITS_CA.java:12434)"
I've tried all differents formats for the columns (double, BigDecimal, Float) but the error is always the same.
I have also replace the "," by "." in a tmap before the Taggregate, but it's not resolving my problem.
Thank you for your help

Re: NumberFormatException with TaggregateRow

Anonymous — Tue, 22 Dec 2009 08:53:13 GMT

Hello
Can you upload a screenshot of schema?
Best regards

shong

Re: NumberFormatException with TaggregateRow

Anonymous — Tue, 22 Dec 2009 09:58:09 GMT

This is then screenshot of the schema of the taggregate.
For Information, i've tested the job with a limited number of lines (2100 lines) and it works.
But when i launch the same job with the full table (4 000 000 lines) it failed at lines 9100.
Alaways with the same message :
Démarrage du jobEtape4_Alimentation_FAITS_CA_Init a 10:33 22/12/2009.
connecting to socket on port 3626
connected
Exception in component tAggregateRow_1_AGGOUT
java.lang.NumberFormatException
at java.math.BigDecimal.<init>(Unknown Source)
at java.math.BigDecimal.<init>(Unknown Source)
at fauchon_alimentation.etape4_alimentation_faits_ca_init_0_1.Etape4_Alimentation_FAITS_CA_Init.tMSSqlInput_1Process(Etape4_Alimentation_FAITS_CA_Init.java:11981)
at fauchon_alimentation.etape4_alimentation_faits_ca_init_0_1.Etape4_Alimentation_FAITS_CA_Init.runJobInTOS(Etape4_Alimentation_FAITS_CA_Init.java:18877)
at fauchon_alimentation.etape4_alimentation_faits_ca_init_0_1.Etape4_Alimentation_FAITS_CA_Init.main(Etape4_Alimentation_FAITS_CA_Init.java:18751)
disconnected
Job Etape4_Alimentation_FAITS_CA_Init terminé à 10:39 22/12/2009.

Thank you

Re: NumberFormatException with TaggregateRow

Anonymous — Tue, 22 Dec 2009 10:55:06 GMT

For Information i've done a select TOP 12000 on my table to put it on a csv file.
I have some values like this on my csv file : 1.3E-4
Could it be a problem ?
Thank you

Re: NumberFormatException with TaggregateRow

Anonymous — Wed, 23 Dec 2009 05:31:18 GMT

Hello

java.lang.NumberFormatException
at java.math.BigDecimal.<init>(Unknown Source)

1) Make sure there is no comma "," in the values.
2) try to filter the null value before tAggregateRow.
Best regards

shong