Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Boof1977
Contributor
Contributor

Sending an error number by email

Hi

 

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

Labels (1)
  • v6.x

1 Solution

Accepted Solutions
TRF
Champion II
Champion II

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.

View solution in original post

13 Replies
TRF
Champion II
Champion II

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.
vapukov
Master II
Master II

For send global email about Job execution - use onSubJobOk connection

0683p000009Lu9G.png

 

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

Boof1977
Contributor
Contributor
Author

Hi

 

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

 

my job design look like:

 

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

      |

onsubjobok

      |

tsendmail

 

Boof1977
Contributor
Contributor
Author

Is there another way beside file attatchment?

vapukov
Master II
Master II

What is the problem?

 

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

 

 

TRF
Champion II
Champion II

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.
TRF
Champion II
Champion II

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

Hi

 

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

TRF
Champion II
Champion II

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.