Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Thanks