Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] Unparseable date: ""

Hi,
I'm getting the source data from the txt file and loading into the database table.
While loading I'm getting the below error.

java.lang.RuntimeException: java.text.ParseException: Unparseable date: ""
    at routines.TalendDate.parseDate(TalendDate.java:858)
    at routines.TalendDate.parseDate(TalendDate.java:802)
    at ext_ent.t_distributor_0_1.t_distributor.tFileInputDelimited_1Process(t_distributor.java:1360)

Source data and parseDate that I'm using in the tmap and below is the screenshot.
Can anyone please let me know if anything is wrong
1992/08/23  - TalendDate.parseDate("YYYY/MM/dd",distributor.DSTRB_STRT_DATE)
9999/12/31  - TalendDate.parseDate("YYYY/MM/dd",distributor.DSTRB_END_DATE)

01/25/94  - TalendDate.parseDate("MM/dd/yy",distributor.LAST_UPD_TSTMP)


0683p000009MH6W.png

Thanks

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

That is caused because the date you are trying to parse is an empty String. 

View solution in original post

2 Replies
Anonymous
Not applicable
Author

That is caused because the date you are trying to parse is an empty String. 
Anonymous
Not applicable
Author

Thank you!Resolved the problem