Any help would be appreciated.
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.
@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.
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?
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.
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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables