how to catch tMSSqlInput connection exception

Highlighted
Six Stars

how to catch tMSSqlInput connection exception

Hello,
I am trying to catch all exception or errors by using logCatcher component.
But when I have a database connection error. It didn't catch the exception.
May I know what the problem is and how to solve it?
Thanks!
    
Highlighted
Moderator

Re: how to catch tMSSqlInput connection exception

Hi,
Have you tried to catch tMSSqlInput exception by the global variable Smiley Sad(String)globalMap.get("tMSSqlInput_1_ERROR_MESSAGE"))?
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.
Highlighted
Forteen Stars

Re: how to catch tMSSqlInput connection exception

good to check - what also wrong, because - it work
try to disable all components after tLog in line and test
also - DO NOT use main connection for tSendMail - use OnSubJobOk connection
You want send whole file, after catch all errors, but not 1000 emails if You have 1000 wrong records
-----------
Highlighted
Six Stars

Re: how to catch tMSSqlInput connection exception

Thanks for all of your response!
I found out the problem. I tried to insert the error code into database. If I remove database input part, everything works back to normal. The email still can send out.
I can live with now. Thanks!
Highlighted
Moderator

Re: how to catch tMSSqlInput connection exception

Hi,
Great it has been fixed. Could you please mark this topic as resolved?
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.

2019 GARTNER 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

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog