how to catch tMSSqlInput connection exception

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!
    
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.
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
-----------
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!
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.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

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

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch