Capture date format error

Six Stars

Capture date format error

Hello everyone,
I want to log the rejected records and I have a problem that I can not solve.
I would like to capture date format error. I tried tUniqRow , tFilterRow and tSchemaComplianceCheck but no one of thoses components capture this error.
 

Any help would be appreciated.

 

Thanks.

log.PNG
Moderator

Re: Capture date format error

Hello,

Do you want to capture error printed on console?

Here are Logs & Errors components in talend. tStatCatcher component can gather the statistics log of Job execution and tLog component can operate as a log function triggered by one of the three: Java exception, tDie or tWarn, to collect and transfer log data.

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: Capture date format error

@xdshi: thank for your answer. I use tStatCatcher, tAssertCatcher and tLogCatcher but no one of those components catch this error.
I launched the job this morning, the job was successfully executed. The error message doesn't failed the job. it doesn't take account the first row of my excel file.

loc.PNGDate format errorlog.PNGLog file

 

Moderator

Re: Capture date format error

Hi,

From your attached screenshot, is your row 1 from tfileinputexcel component? Have you tried to drag "Rejects" row from it to see if this error message can be captured by rejects row?

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: Capture date format error

Hello @xdshi

 

From your attached screenshot, is your row 1 from tfileinputexcel component? No, it's my tStatCatcher file (log file) .

Have you tried to drag "Rejects" row from it to see if this error message can be captured by rejects row? i tried from tMap and tfileinputexcel , it doesn't work.

 

for information, the date I'm trying to insert is "31-04-2017". I know the April month have 30 days. I need to check invalid date and to capture date format error.

Ten Stars

Re: Capture date format error

Right-click your input component and select Row -> Reject.  Connect that to an output component.  The default schema should be the schema of the input component plus two columns; errorCode and errorMessage.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now