Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

:: Talend ETL Exception Handling & Customized Logging ::

Hi Sabrina,
I new to the Talend ETL tool i have a requirement as below
1. I want to do it a customized logging for all transactions which ever get fails.
2. When i will run job if founds any DB exception then its going to dis connect and not handling Exception/Error
I want to handle it
Please help me out i need your suggestion ASAP, much appreciated.

Labels (1)
11 Replies
Anonymous
Not applicable

emaduddinsyed
tLogCatcher serves as a general try/catch handler, but nobody forces you to log the exception into the tLogRow (or other output), you're free to start your own job
g.
Anonymous
Not applicable

Hi,
 I think I've done fair bit of homework before drafting this post.If you have read my requirement properly you would easily understand that simply extending the reject flow to some file will not serve my purpose because the error message thrown by talend is too superficial and nobody would understand where exactly the error is and what exactly the error is !!
I'm trying to find a way to edit this error message and add an error code which can be easily understood by people involved in analyzing the error table/file.
Moroever if a record has say two fields (as given in the example) and in both the fields if there are some validation issue (malformed data) I would like to capture both (b;ma!rry >>>> b|b;ma!rry|NUMERIC_CHECK_FAILED|id has a bad value "b"
b|b;ma!rry|ALPHA_CHECK_FAILED|name has a bad value "b;ma!rry") and not just the first error.

Hope it clears my intention.

Have pretty much the same requirement. 
Any help is much appreciated.