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