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!
    
4 REPLIES
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.
Twelve 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.