topic How to trigger a mail if job get failure in Talend Studio

How to trigger a mail if job get failure

Anonymous — Sat, 16 Nov 2024 06:03:01 GMT

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

Re: How to trigger a mail if job get failure

Anonymous — Thu, 18 Apr 2019 06:47:32 GMT

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

Re: How to trigger a mail if job get failure

Anonymous — Thu, 18 Apr 2019 07:38:30 GMT

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

Re: How to trigger a mail if job get failure

Anonymous — Thu, 18 Apr 2019 07:55:56 GMT

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

Re: How to trigger a mail if job get failure

Anonymous — Thu, 18 Apr 2019 08:19:42 GMT

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.

Re: How to trigger a mail if job get failure

Anonymous — Thu, 18 Apr 2019 08:47:30 GMT

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-authenticated-to-send-anonymous/d405bcb0-f40c-42fa-b1b2-477597100123

Re: How to trigger a mail if job get failure

Anonymous — Thu, 18 Apr 2019 08:54:08 GMT

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 🙂

Re: How to trigger a mail if job get failure

Anonymous — Thu, 18 Apr 2019 09:03:25 GMT

Transmit failed: general failure

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

Re: How to trigger a mail if job get failure

Anonymous — Thu, 18 Apr 2019 09:06:31 GMT

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-general-failure/53b05029-1da8-4f68-8eb4-221a343e97e1?page=3

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 🙂

Re: How to trigger a mail if job get failure

vapukov — Thu, 18 Apr 2019 14:45:18 GMT

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