topic Re: java.lang.NumberFormatException error in Talend Studio

java.lang.NumberFormatException error

Anonymous — Sat, 16 Nov 2024 10:10:57 GMT

Hi,
I am using Talend for the first time and upserting some data from Oracle to Salesforce. While using the tMap and working with date fields I am getting the error

java.lang.NumberFormatException: For input string: "25/0"
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at routines.system.FastDateParser$DateParser.parse(FastDateParser.java:127)
at java.text.DateFormat.parse(Unknown Source)
at routines.TalendDate.parseDate(TalendDate.java:881)
at routines.TalendDate.parseDate(TalendDate.java:839)
at ph.phupload_0_1.PHUpload.tOracleInput_4Process(PHUpload.java:3483)
at ph.phupload_0_1.PHUpload.tSalesforceConnection_1Process(PHUpload.java:5228)
at ph.phupload_0_1.PHUpload.tSetProxy_1Process(PHUpload.java:5373)
at ph.phupload_0_1.PHUpload.runJobInTOS(PHUpload.java:5594)
at ph.phupload_0_1.PHUpload.main(PHUpload.java:5451)

Exception in component tMap_1
java.lang.RuntimeException: java.text.ParseException: Unparseable date: "25/06/2014"
at routines.TalendDate.parseDate(TalendDate.java:895)
at routines.TalendDate.parseDate(TalendDate.java:839)
at ph.phupload_0_1.PHUpload.tOracleInput_4Process(PHUpload.java:3483)
at ph.phupload_0_1.PHUpload.tSalesforceConnection_1Process(PHUpload.java:5228)
at ph.phupload_0_1.PHUpload.tSetProxy_1Process(PHUpload.java:5373)
at ph.phupload_0_1.PHUpload.runJobInTOS(PHUpload.java:5594)
at ph.phupload_0_1.PHUpload.main(PHUpload.java:5451)

Caused by: java.text.ParseException: Unparseable date: "25/06/2014"
at java.text.DateFormat.parse(Unknown Source)
at routines.TalendDate.parseDate(TalendDate.java:881)

Please suggest,
Thanks.

Re: java.lang.NumberFormatException error

Anonymous — Tue, 27 Dec 2016 07:53:12 GMT

Hi,
There is data format issue in your job. Do you want to convert your date field?
Could you please post your job setting screenshots into forum? In this way, we can see if there is any wrong setting in your tMap component. More information will be preferred.
Best regards
Sabrina

Re: java.lang.NumberFormatException error

Anonymous — Tue, 27 Dec 2016 10:01:02 GMT

Hi Sabrina,
Thanks for replying. Yes, I am facing issues converting the date field. below is the screen shot of the tMap.

Re: java.lang.NumberFormatException error

Anonymous — Tue, 27 Dec 2016 10:14:31 GMT

I also get the below error if I test the expression TalendDate.parseDate("yyyy-MM-dd",row8.START_DATE)
java.lang.NumberFormatException: For input string: "null"
Thanks,

Re: java.lang.NumberFormatException error

Anonymous — Wed, 28 Dec 2016 08:03:34 GMT

Hi,
Is there any "null" string in your row8.START_DATE? If so, you can try these code

row8.START_DATE

.equals("null") ? "" : TalendDate.parseDate("yyyy-MM-dd",row8.START_DATE)

Best regards
Sabrina