Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

java.lang.NumberFormatException error

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.
Labels (4)
4 Replies
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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

0683p000009MCle.png
Anonymous
Not applicable
Author

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,
Anonymous
Not applicable
Author

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