How to trigger a mail if job get failure

[Anonymous]

Hi guys,

how can we keep a email notification if any error occurs when the time of execution.

my job is data mapping from excel file to csv if the job face any error it should not stop in middle it should catch the exception and send an email notification

Like try catch in java

how can i do it? kindly explain me 

Regards,

Abisha

[Anonymous]

Hi @abishagopalan ,

You can use tlogcatcher component to solve this. tlogcatcher catches any error that occurs in your job, this can be connected to tsendmail component as shown below in screenshot. For more information on tlogcatacher please refer the below link.

https://help.talend.com/reader/hm5FaPiiOP31nUYHph0JwQ/pMRz1pl8Bv14KnTdRWjiTA

[Anonymous]

Hi,

My tSendmail is giving me an error like 

Exception in component tSendMail_1
javax.mail.MessagingException: Could not connect to SMTP host: smtp.gmail.com, port: 443;
nested exception

when I connect with outlook its gives 

com.sun.mail.smtp.SMTPSendFailedException: 530 5.7.57 SMTP; Client was not authenticated to send anonymous mail during MAIL FROM
The smtp server is smtp.office365.com
Port is 587 (Tried port 25 also - did not work)

why is it so can you help me with configuring send mail

[Anonymous · Accepted solution]

Hello @abishagopalan 

From your error message, it seems client was not authenticated to send anonymous mail during MAIL FROM. Have you checked "SSL Support" option in tSendmail component?

Please try to use these parameters:
SMTP setting
Server name: smtp.office365.com
Port: 587
Encryption method: TLS ?

Let us know if it works.

Best regards

Sabrina

[Anonymous]

hi,

I tried all those still it is same please find the screenshot

i am unable to send mail to neither gmail nor outlook kindly help me to understand the issue.

[Anonymous]

Hi @abishagopalan,

It might be the issue with smtp end point which you are using. Please see the below link which addresses the same issue.

"SMTP client submission endpoint (smtp.office365.com), which can't be used for direct send. For direct send, use the MX endpoint for your Office 365 tenant, which ends with "mail.protection.outlook.com." So, please let your admin check the MX record"

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_outlook-mso_winother/client-was-not-auth...

[Anonymous]

Hi,

    Could you please ping the server from the machine where you are running Talend for the specific port? Most probably your company firewall is stopping you from accessing the target server.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Transmit failed: general failure 

this is what I am getting when I call server from local machine

[Anonymous]

Hi,

    This proves that it is not a Talend issue but a connection related issue at your host server.

    Please refer the answer from Microsoft community on this issue. You may have to search Microsoft community pages to track this issue to closure.

https://answers.microsoft.com/en-us/windows/forum/windows_7-networking/resolved-ping-transmit-failed...

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[vapukov]

Hi @groupproductmanagement

unfortunately tLogCatcher - would not work as expected

tLogCatcher will catch errors only if generated by tWarm, tDie or if a component has enabled die at error checkbox, but if checkbox enabled - it will stop the job

which is unwanted

one more drawback - in case if more than 1 error or warning catched direct connection between tLogCatcher and tSendMail will send as many emails as events catched (like 10000)

as a variant - enable login log errors into file or database, then analyze if files are created or new rows in the database - send 1 email 

this is will work for errors or warnings

for the data - only clean data, like tSchemaCompliant or more complicated ways, filtered data send to file or table and again send single email at the end if new data detected

regards, Vlad