Five Stars

tmap error

Hi,

 

Can any one help me to resolve issue...While running a job i m getting a error like

 

Starting job MyFirstTalendJob at 13:08 26/11/2017.

[statistics] connecting to socket on port 3587
[statistics] connected
Unparseable date: "01-Mar-2012"
Unparseable date: "05-Jun-2010"
Unparseable date: "22-Jun-2010"
Unparseable date: "05-Apr-2010"
Unparseable date: "13-Sep-2009"
Unparseable date: "14-Dec-2011"
Unparseable date: "30-Feb-2011"
Unparseable date: "07-Nov-2009"
Unparseable date: "22-Dec-2012"
Unparseable date: "28-May-2011"
[statistics] disconnected
Job MyFirstTalendJob ended at 13:08 26/11/2017. [exit code=0]

3 REPLIES
Four Stars

Re: tmap error

You have to verify whether the date field is null or not.  For example:

yourDateColumn!=null && !"".equalsIgnoreCase(yourDateColumn)? TalendDate.parseDate("yyyy/MM/dd'T'hh:mm:ss",yourDateColumn) :null

Moderator

Re: tmap error

Hello,

Could you please post your current job design screenshots on forum which will be helpful for us to address your issue?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: tmap error

Hi

 

In your tmap leftside and rightside schema column has any date value, Just change Type-->Date and

Give DatePattern->"MM/dd/yyyy"(you can give date patern as you want).

Capture.PNG