
Anonymous
Not applicable
2016-12-27
01:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
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.
365 Views
4 Replies

Anonymous
Not applicable
2016-12-27
02:53 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
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
365 Views

Anonymous
Not applicable
2016-12-27
05:01 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Sabrina,
Thanks for replying. Yes, I am facing issues converting the date field. below is the screen shot of the tMap.
Thanks for replying. Yes, I am facing issues converting the date field. below is the screen shot of the tMap.
365 Views

Anonymous
Not applicable
2016-12-27
05:14 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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,
java.lang.NumberFormatException: For input string: "null"
Thanks,
365 Views

Anonymous
Not applicable
2016-12-28
03:03 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Is there any "null" string in your row8.START_DATE? If so, you can try these code
Best regards
Sabrina
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
365 Views
