topic Re: Mail on task failure in Qlik sense in App Development

Mail on task failure in Qlik sense

Thu, 26 Mar 2015 08:42:53 GMT

Hi,

Is it possible to send mail automatically from QMC when scheduled reload task gets failed in Qlik sense.

If yes please provide the steps to do so.

Thanks in advance,

Rajamani

Re: Mail on task failure in Qlik sense

korsikov — Fri, 27 Mar 2015 09:00:53 GMT

I have not heard about this opportunity. Perhaps it is in the road map server

Re: Mail on task failure in Qlik sense

haty — Fri, 26 Jun 2015 07:09:54 GMT

We are very keen to see this feature added to Sense also.

Re: Mail on task failure in Qlik sense

Anonymous — Mon, 21 Sep 2015 11:07:55 GMT

We would like this feature also.

It's pretty dificult to monitor errors in app's if you don't get notifications.

Re: Mail on task failure in Qlik sense

RSvebeck — Wed, 20 Apr 2016 13:41:34 GMT

This is very important for us. We have jobs running 24/7 in our current Publisher and we can not have staff monitoring possible failed reloads. Show stopper for a possible migration to Sense.

But thread is old - is it still not developed in Sense?

Re: Mail on task failure in Qlik sense

undergrinder — Wed, 20 Apr 2016 17:47:59 GMT

Hi Rajamani,

It isn't possible directly through QlikSense, but you can implement a workaround.

As far as I know reddys310‌, has an example for this.

I think the following methods can work:

Catch errors in script (set Errormode = 0, and use errorcode variable)
If you get an error then it create a batch file with errormessage, and with call an 3rd party email tool (or your own email tool)
Execute this batch

Or you can sniff in logs by custom implemented program.

I don't know, whether the repository database does contain this information. If yes, it is easier listen to the database.

Re: Mail on task failure in Qlik sense

Anonymous — Thu, 21 Apr 2016 05:56:04 GMT

It's good that Qlik has an API to code against. But it's sad, that functionality like this is not standard.

For an entreprise environment warnings are a must, we can't have an employee following up on this each morning.

If we need to code everything as API-calls the ROI of Qlik Sense fades out. It's very time consuming and expensive to make C# code and to understand the possibilities with the API's in Qlik Sense.

In my opinion this is a feature that must be standard.

Re: Mail on task failure in Qlik sense

RSvebeck — Thu, 21 Apr 2016 06:12:27 GMT

Thanks Rajamani, but our Publisher setup holds something like 1000+ tasks, and we have around 500+ documents. We need this in standard if we will ever move the complete installation to Sense.

Re: Mail on task failure in Qlik sense

reddy-s — Thu, 21 Apr 2016 08:23:40 GMT

Hi Rajamani,

As undergrinder‌ mentioned, you can actually read the log files using Python and look for errors. If you happen to find any errors, you can trigger a mail through your SMTP.

Thanks,
Sangram.

Re: Mail on task failure in Qlik sense

Anonymous — Thu, 21 Apr 2016 08:29:35 GMT

What log-file should we then look into?

Re: Mail on task failure in Qlik sense

undergrinder — Thu, 21 Apr 2016 08:35:23 GMT

There are script logs at C:\ProgramData\Qlik\Sense\Log\Script folder, the filename will be [unique ID of application].log

I can't dwelve into repository database at the moment, but you should take a look into, whether contains this information. (Qlik Tips: Connect to your Qlik Sense Repository)

Re: Mail on task failure in Qlik sense

reddy-s — Thu, 21 Apr 2016 08:52:42 GMT

As Undergrinder mentioned, you will find the log files in that location. So you will have to loop through the log files to read the errors.

Re: Mail on task failure in Qlik sense

RSvebeck — Fri, 22 Apr 2016 11:56:11 GMT

I have done a solution for our Environment that is "good enough" for a start for us, but it will not be a working solution in the long - this must be added in standard by Qlik. But at least we can continue to use Sense...

My solutuion is based on this :

1. An external VB-script file that send mail with standard CDO.Message object.

2. Setting ErrorMode=0 in the beginning of every app, so that we can catch all errors.

3. A Qlik Sub that is called in the end of every script on every app, that triggers if there is any errors, and sends a mail with the script log attached, and a body message with all error events. So the mail is sent right after the script is completed, but only if there is an error.

In fact this solution is more usefull than what we had in Qlik Publisher, beause in this solution, we get the actual script log file instead of that Publisher script dump that really did not help so much...

/Regards Robert

Re: Mail on task failure in Qlik sense

ergustafsson — Tue, 30 May 2017 15:24:22 GMT

I solved this by creating an Nprinting task instead.

Obviously requires a license, Qlik Sense task failure report with Nprinting

Cheers,

Erik

Re: Mail on task failure in Qlik sense

smadathil — Sat, 11 May 2019 18:57:35 GMT

Hi Robert,

Sending this after long time since you posted.

But will it be possible to share VB script and sub script you had prepared for the solution?

Thanks