topic Sending an error number by email in Talend Studio

Sending an error number by email

Boof1977 — Sun, 28 May 2017 13:59:41 GMT

I try to use tlogcatcher to catch an error and to send it by mail.

my problem is that its send multiple emails by the number of errors.

is there any solution for this .

Thanks

Re: Sending an error number by email

TRF — Sun, 28 May 2017 14:23:21 GMT

Hi,
Depends of your job design.
Please, share it and also precise what you expect: 1 email for the job or 1 email per error.

Re: Sending an error number by email

vapukov — Sun, 28 May 2017 14:25:46 GMT

For send global email about Job execution - use onSubJobOk connection

for send information about all errors but in single email - change tLogRow to tFileOutputDelimited and use this file as attachment

Re: Sending an error number by email

Boof1977 — Sun, 28 May 2017 14:27:29 GMT

1 email per job with all the errors that logcatcher will catch.

my job design look like:

tlogcatcher----> tjavarow--->tlogrow

onsubjobok

tsendmail

Re: Sending an error number by email

Boof1977 — Sun, 28 May 2017 14:31:49 GMT

Is there another way beside file attatchment?

Re: Sending an error number by email

vapukov — Sun, 28 May 2017 14:34:29 GMT

What is the problem?

as @TRF already wrote - all depend from what You try to achieve?

Re: Sending an error number by email

TRF — Sun, 28 May 2017 14:34:41 GMT

Replace tSend mail by tFileOutputDelimited or tHashOutput to memorize the informations you want to send. Then add a tPostJob subjob which will automatically starts when the job finishes and use tSendMail from this subjob.
This will work for errors and warnings, but for exceptions, probably you need to send email immediatly when the event is catched.

Re: Sending an error number by email

TRF — Sun, 28 May 2017 14:38:16 GMT

Regarding the content, if you don't want to attach files, you can construct friendly content using HTML tags.

Re: Sending an error number by email

Boof1977 — Sun, 28 May 2017 14:49:14 GMT

Thank for your answer . can you explain the last line?

Re: Sending an error number by email

TRF — Sun, 28 May 2017 15:03:47 GMT

Regarding the html content?
In the tPostJob subjob, use one or more global variables to prepare the content with html tags inside (for example to build list, change color and so on). Then in tSendMail, tick the option "HTML" and complete the content using the variables and what you want.
If you need a more detailed answer, share your use case with data sample and expected result.

Re: Sending an error number by email

Boof1977 — Sun, 28 May 2017 17:17:08 GMT

you said "This will work for errors and warnings, but for exceptions, probably you need to send email immediatly when the event is catched"

what do you mean?

Thank you

Re: Sending an error number by email

TRF — Sun, 28 May 2017 18:00:30 GMT

Probably if an exception is catched by tLogCatcher, you will decide to stop the process, not only to memorize the event for later use.

Re: Sending an error number by email

TRF — Thu, 01 Jun 2017 13:52:23 GMT

@Boof1977, did you succeed to do what you wanted?

Re: Sending an error number by email

Boof1977 — Sun, 04 Jun 2017 14:25:49 GMT

Yes.

Thank you