java.math.BigDecimal.<init>(Unknown Source)

Employee

java.math.BigDecimal.<init>(Unknown Source)

When I try to load .txt data into oracle, it give me the following message, I checked on line, one of posting showing me to get rid of comma, looks it is not right solution to my case. I also post one of problem raw data here, fyi. pls help. thanks in advance!!!
tarting job ig_letter at 17:09 05/10/2010.
connecting to socket on port 3857
connected
connecting to socket on port 4339
connected
Exception in component tFileInputDelimited_1
java.lang.NumberFormatException
at java.math.BigDecimal.<init>(Unknown Source)
at java.math.BigDecimal.<init>(Unknown Source)
at routines.system.ParserUtils.parseTo_BigDecimal(ParserUtils.java:131)
at jim.ig_letter_0_1.ig_letter.tFileInputDelimited_1Process(ig_letter.java:2758)
at jim.ig_letter_0_1.ig_letter.runJobInTOS(ig_letter.java:3732)
at jim.ig_letter_0_1.ig_letter.main(ig_letter.java:3599)
disconnected
disconnected
Job ig_letter ended at 17:09 05/10/2010.
here is two of problem raw data, fyi.
939818|Wayne & Blandine|Mr. & Mrs. Hardman|Mr. & Mrs. Hardman||1023137|2191993|E|PO BOX 24, GROUP 305|RR 3|||BEAUSEJOUR|MB|R0E0C0|Canada|Mail|2|Client |Accepted|1.57|19624|M|E|RAYMOND|PADUA|B.Comm Hons, CFP|Financial Consultant|Conseiller

938165|MR TIMOTHY GADDE AND MRS NANCY HUYNY-LO|MR TIMOTHY GADDE AND MRS NANCY HUYNY-LO|MR TIMOTHY GADDE AND MRS NANCY HUYNY-LO||1021555|2188466|E|ITF NATHAN WILLIAM GADDE|270 PICKFORD DR|||KANATA|ON|K2L3T5|Canada|Mail|2|Client |Accepted|1.57|2128|M|E|PAUL|VAILLANCOURT|CFP CSA CLU|Sr. Exec. Financial Consultant|Conseiller financier émérite principal|6137428018231|88|paul.vaillancourt@investorsgroup.com|430 - 1730 St. Laurent Blvd.||||Ottawa|ON|K1G5L1|Investors Group Financial Services Inc.||Services Financiers Groupe Investors Inc.||||||||||||||
Seven Stars

Re: java.math.BigDecimal.<init>(Unknown Source)

This means you've defined a column in your schema as a BigDecimal but the actual data does not fit the format of a BigDecimal
Employee

Re: java.math.BigDecimal.<init>(Unknown Source)

thanks alevy for your update, you are right. I have corrected them, it is working fine now.
Six Stars

Re: java.math.BigDecimal.<init>(Unknown Source)

How did you solved it? Can you please explain a little bit more?

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now