https://community.qlik.com/t5/Talend-Studio/how-to-catch-tMSSqlInput-connection-exception/m-p/2286241#M59863 Thanks for all of your response! <BR />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. <BR />I can live with now. Thanks! Thu, 09 Mar 2017 18:37:09 GMT Anonymous 2017-03-09T18:37:09Z https://community.qlik.com/t5/Talend-Studio/how-to-catch-tMSSqlInput-connection-exception/m-p/2286238#M59860 Hello, <BR />I am trying to catch all exception or errors by using logCatcher component. <BR />But when I have a database connection error. It didn't catch the exception. <BR />May I know what the problem is and how to solve it? <BR />Thanks! <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MDWs.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/153223i4061851EBAA01068/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MDWs.png" alt="0683p000009MDWs.png" /></span>&nbsp;&nbsp;&nbsp;&nbsp; <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MDcd.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/148550i0C942293A5247E17/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MDcd.png" alt="0683p000009MDcd.png" /></span> Wed, 08 Mar 2017 18:40:12 GMT https://community.qlik.com/t5/Talend-Studio/how-to-catch-tMSSqlInput-connection-exception/m-p/2286238#M59860 Anonymous 2017-03-08T18:40:12Z https://community.qlik.com/t5/Talend-Studio/how-to-catch-tMSSqlInput-connection-exception/m-p/2286239#M59861 Hi, <BR />Have you tried to catch tMSSqlInput exception by the global variable <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MPcz.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/157233iD1A564EF62DE3BC2/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MPcz.png" alt="0683p000009MPcz.png" /></span>(String)globalMap.get("tMSSqlInput_1_ERROR_MESSAGE"))? <BR />Best regards <BR />Sabrina Thu, 09 Mar 2017 06:44:34 GMT https://community.qlik.com/t5/Talend-Studio/how-to-catch-tMSSqlInput-connection-exception/m-p/2286239#M59861 Anonymous 2017-03-09T06:44:34Z https://community.qlik.com/t5/Talend-Studio/how-to-catch-tMSSqlInput-connection-exception/m-p/2286240#M59862 good to check - what also wrong, because - it work <BR />try to disable all components after tLog in line and test <BR />also - DO NOT use main connection for tSendMail - use OnSubJobOk connection <BR />You want send whole file, after catch all errors, but not 1000 emails if You have 1000 wrong records <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MDcn.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/137243iB5A48D211E364487/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MDcn.png" alt="0683p000009MDcn.png" /></span> Thu, 09 Mar 2017 09:05:28 GMT https://community.qlik.com/t5/Talend-Studio/how-to-catch-tMSSqlInput-connection-exception/m-p/2286240#M59862 vapukov 2017-03-09T09:05:28Z https://community.qlik.com/t5/Talend-Studio/how-to-catch-tMSSqlInput-connection-exception/m-p/2286241#M59863 Thanks for all of your response! <BR />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. <BR />I can live with now. Thanks! Thu, 09 Mar 2017 18:37:09 GMT https://community.qlik.com/t5/Talend-Studio/how-to-catch-tMSSqlInput-connection-exception/m-p/2286241#M59863 Anonymous 2017-03-09T18:37:09Z https://community.qlik.com/t5/Talend-Studio/how-to-catch-tMSSqlInput-connection-exception/m-p/2286242#M59864 Hi,<BR />Great it has been fixed. Could you please mark this topic as resolved?<BR />Best regards<BR />Sabrina Fri, 10 Mar 2017 09:22:01 GMT https://community.qlik.com/t5/Talend-Studio/how-to-catch-tMSSqlInput-connection-exception/m-p/2286242#M59864 Anonymous 2017-03-10T09:22:01Z