https://community.qlik.com/t5/Talend-Studio/java-math-BigDecimal-lt-init-gt-Unknown-Source/m-p/2280041#M55019 How did you solved it? Can you please explain a little bit more? Wed, 01 Aug 2018 20:17:11 GMT Tasfiahm 2018-08-01T20:17:11Z https://community.qlik.com/t5/Talend-Studio/java-math-BigDecimal-lt-init-gt-Unknown-Source/m-p/2280038#M55016 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!!! <BR />tarting job ig_letter at 17:09 05/10/2010. <BR /> connecting to socket on port 3857 <BR /> connected <BR /> connecting to socket on port 4339 <BR /> connected <BR />Exception in component tFileInputDelimited_1 <BR />java.lang.NumberFormatException <BR /> at java.math.BigDecimal.&lt;init&gt;(Unknown Source) <BR /> at java.math.BigDecimal.&lt;init&gt;(Unknown Source) <BR /> at routines.system.ParserUtils.parseTo_BigDecimal(ParserUtils.java:131) <BR /> at jim.ig_letter_0_1.ig_letter.tFileInputDelimited_1Process(ig_letter.java:2758) <BR /> at jim.ig_letter_0_1.ig_letter.runJobInTOS(ig_letter.java:3732) <BR /> at jim.ig_letter_0_1.ig_letter.main(ig_letter.java:3599) <BR /> disconnected <BR /> disconnected <BR />Job ig_letter ended at 17:09 05/10/2010. <BR />here is two of problem raw data, fyi. <BR />939818|Wayne &amp; Blandine|Mr. &amp; Mrs. Hardman|Mr. &amp; 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 <BR /> <BR />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.|||||||||||||| Sat, 16 Nov 2024 13:15:40 GMT https://community.qlik.com/t5/Talend-Studio/java-math-BigDecimal-lt-init-gt-Unknown-Source/m-p/2280038#M55016 Anonymous 2024-11-16T13:15:40Z https://community.qlik.com/t5/Talend-Studio/java-math-BigDecimal-lt-init-gt-Unknown-Source/m-p/2280039#M55017 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 Thu, 14 Oct 2010 05:59:27 GMT https://community.qlik.com/t5/Talend-Studio/java-math-BigDecimal-lt-init-gt-Unknown-Source/m-p/2280039#M55017 alevy 2010-10-14T05:59:27Z https://community.qlik.com/t5/Talend-Studio/java-math-BigDecimal-lt-init-gt-Unknown-Source/m-p/2280040#M55018 thanks alevy for your update, you are right. I have corrected them, it is working fine now. Thu, 14 Oct 2010 21:03:13 GMT https://community.qlik.com/t5/Talend-Studio/java-math-BigDecimal-lt-init-gt-Unknown-Source/m-p/2280040#M55018 Anonymous 2010-10-14T21:03:13Z https://community.qlik.com/t5/Talend-Studio/java-math-BigDecimal-lt-init-gt-Unknown-Source/m-p/2280041#M55019 How did you solved it? Can you please explain a little bit more? Wed, 01 Aug 2018 20:17:11 GMT https://community.qlik.com/t5/Talend-Studio/java-math-BigDecimal-lt-init-gt-Unknown-Source/m-p/2280041#M55019 Tasfiahm 2018-08-01T20:17:11Z