topic Re: tSendMail on Error in Talend Studio

tSendMail on Error

Anonymous — Tue, 17 Jan 2017 15:31:02 GMT

Hi,
I am trying to connect Subjob Error on the database. I tried connecting the tSendMail to the database but the database does not Connect to the tSendMail on Subjob Error. In my example, I have simple table with a duplicate primary key to check if I get the email from Talend but I do not get any Error Email. How can I connect the database to the tSendMail Error?

Re: tSendMail on Error

Anonymous — Wed, 18 Jan 2017 06:41:08 GMT

Hi,
How did you pass your error value into tsendmail component message body part? Did you use context value in it? Could you please show us your tsendmail component setting screenshot?
Best regards
Sabrina

Re: tSendMail on Error

Anonymous — Wed, 18 Jan 2017 14:33:42 GMT

Sorry wrote on this post by mistake, did not mean to comment here.

Re: tSendMail on Error

Anonymous — Wed, 18 Jan 2017 15:03:55 GMT

Thanks,

This is my sample table where ID is the primary key.

The database does not have subjob error connection available for the tsendmail.

Our company uses Outlook as our email and I have encapsulated the details in the screenshots.

As expected, the database threw out an error since the ID was repeated. How can I connect the database to the tSendMail so it emails me whenever an error occurs on the job.

Please provide assistance in this matter.

Thanks,

Re: tSendMail on Error

Anonymous — Thu, 19 Jan 2017 03:54:33 GMT

Hi,
We usually use tLogCatcher to capture the error message. The work flow should be:
tfileinputxxx-->tMap-->tPostgresqloutput
tlogcatcher-->tsendmail

Or do you need to redirect the full stack trace on console output to email?
Best regards
Sabrina

Re: tSendMail on Error

Anonymous — Thu, 19 Jan 2017 14:47:41 GMT

Thanks,
I want Talend to send an email to me whenever the job fails or an error occurs. This is the same job from yesterday with the same, duplicate primary key. I have connected the components as you have kindly suggested but I do not get any email.

How can I connect the tLogCatcher to the postgreSQLoutput?

I have a simple message in my email component as you could apparently view that,
"Hello
An Error has occurred. Please have a take a look at it."
Please provide your kind advice!!!!!!!
Colleen

Re: tSendMail on Error

Anonymous — Fri, 20 Jan 2017 07:27:34 GMT

Hi,
You cannot catch the error printed on console?
Usually, tLogCatcher component fetchs set fields and messages from Java Exception, tDie and/or tWarn. Have you already checked out "Die on error" option (It will stop job if there is any error )on tpostgreSQLoutput component?
Note:tlogcatcher cannot catch the full stack trace.
Best regards
Sabrina

Re: tSendMail on Error

Anonymous — Fri, 20 Jan 2017 10:07:49 GMT

Hi Colleen,

Have you tried connecting onComponentError from tpostgresqloutput component to tsendmail component ?(see attached screenshot) This way you may not have to use tLogCatcher as well although as Sabrina suggested it can catch Java exception, tDie and tWarn.

You dont have to connect tLogCatcher to postgresqloutput in case you use logcatcher.

Re: tSendMail on Error

Anonymous — Fri, 20 Jan 2017 15:10:29 GMT

Thanks Fashah,

I have connected the components as you have suggested, but it does not send me an email when the job threw out an error.

We use Outlook mail here and below are my settings. Can you please help me tackle this issue.

Re: tSendMail on Error

Anonymous — Sun, 22 Jan 2017 09:37:50 GMT

Hi,
The connection type"OnsubjobERROR" or "Oncomponenterror" is not triggered in your job.
Regardless the error message, are the 6 rows successfully loaded into your postgresql DB?
Best regards
Sabrina

Re: tSendMail on Error

Anonymous — Mon, 23 Jan 2017 14:17:07 GMT

Thanks,
The 6 rows do not load successfully because I have assigned the ID as a primary key in the tpostgresqloutput and since ID number 1 appears twice the job throws out an error.

Thanks again for your time!!!!!!