how to catch tMSSqlInput connection exception

[Anonymous]

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!
    

[Anonymous]

Hi,
Have you tried to catch tMSSqlInput exception by the global variable (String)globalMap.get("tMSSqlInput_1_ERROR_MESSAGE"))?
Best regards
Sabrina

[vapukov]

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

[Anonymous]

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!

[Anonymous]

Hi,
Great it has been fixed. Could you please mark this topic as resolved?
Best regards
Sabrina