Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Email notification on reload failure

Hi All,

Is it possible to send a notification via SMTP to an email address for specific tasks?

The QMC enables you to set up SMTP recipients if there is a failure of ANY task. I want to notify an individual only if certain tasks fail.

Many thanks.

9 Replies
Not applicable

Email notification on reload failure

You can monitor within the load script for errors and send an email as required.

First of all you need to have set the 'Mail' settings for the 'User Preferences' .

Next, if you want to monitor certain statements, set monitoring on/off so that the load continues. For example:

before script lines to be monitored

SET ErrorMode=0; // ignore any script errors

......(script lines)

after loads script lines to be monitored

SET ErrorMode=1; // reset to default (halt and prompt)

Create an alert to be triggered if scriperrorcount <> 0. Note that mode is set off for interactive. With this checked a pop-up occurs with the plugin to ask if the email should be sent (I use v8.20 - is this a bug?)

Add a text object to display a suitable message (Layout> Show > Conditional 'ScriptErrorCount <> 0') in case of errors when interactive reload has been performed (which will not fire the alert)

Hope this helps!

Gordon



prieper
Honored Contributor II

Email notification on reload failure

Each application has - after refresh - the possibility to send email subject to certain conditions met. In order to supervise your applications, you may turn on the logfiles and build an application to read all logfiles, whether refreshed in time (you may also create your own alert-messages, subj to certain conditions met) and timestamps, when it was refreshed the last time.

Peter

Not applicable

Email notification on reload failure

Hi,

I could not find the window which is on this screenshot.

Could you explain, where is that alert settings?

Not applicable

Email notification on reload failure

I can not find that 'Mail' settings and the 'User Preferences'

Not applicable

Email notification on reload failure

It is under 'Settings' menu.

Not applicable

Email notification on reload failure

I go to settings => User Preferences than that user preferences is shown. But it is different from gordons.

Not applicable

Email notification on reload failure

That is alert tab where it is in tools menu.In mail tab you will be explained the defaults of your mail settings and after that you will create an alert for your document from alert tab.

Not applicable

Email notification on reload failure

This thread was very useful! Thanks Everyone!

Now one other quick question along the same lines. One other problem we are having is if the file is taking a long time to run we would like to recieve an email. For example, if we know a file takes approx 5 minutes to normally reload, but on a particular reload it has been running for over 30 minutes- would there be a way to be notified??

Not applicable

Email notification on reload failure

I have followed all your tips but no mail was sent; otherwise if i tick 'On open' a mail was succesfully sent (due to that i can exclude any connection problems). I'm using QlikView Desktop 10 SR3.

Any ideas?

Thanks..

Matteo A.

Community Browser