idea Re: Email on failed load in Suggest an Idea

Email on failed load

markp201 — Wed, 25 Nov 2020 15:12:24 GMT

Every morning and throughout the day we have to MANUALLY check the tasks to see if anything failed.

yes, we have an extension (seems buggy from reviews) but this needs to be a STANDARD feature.

Geesh, how hard is this ? Add a setting (engine?) - done.

Qlikview has been doing this for YEARS.

Re: Email on failed load

markp201 — Fri, 04 Jan 2019 11:52:47 GMT

Apologies - reading about appenders. If this works, we can delete this suggestion

Re: Email on failed load

skenthroxai — Sun, 14 Apr 2019 04:46:23 GMT

Hi Markp201,

Have a look at www.pingalerting.com

You can create systems alerts as well as self service data alerts with Ping.

Regards,

Sunil

Re: Email on failed load

paulcalvet — Thu, 16 May 2019 19:42:00 GMT

Hi,

You can use this, it works very well !

https://itelligencegroup.com/dk/local-blog/qlik-local-blog/receiving-emails-notifications-when-tasks-fail-qlik-sense/

Paul

Re: Email on failed load

Lech_Miszkiewicz — Fri, 31 May 2019 03:43:24 GMT

Totally agree with Paul - it is already a native functionality!

Re: Email on failed load

simonaubert — Fri, 07 Jun 2019 10:18:27 GMT

Hello,

The xml thing may work but it's not exactly what I would call "user-friendly".

The settings should be available at least in QMC, just like you configure it in Nprinting.

Re: Email on failed load

markp201 — Fri, 07 Jun 2019 11:03:46 GMT

Agree - native functionality means its part of the UI, not a manual configuration. I don't believe there is even a default appender. You have to build it from scratch.

Re: Email on failed load

Lech_Miszkiewicz — Fri, 07 Jun 2019 11:22:44 GMT

No, native functionality means that it is officially supported! Thare are many things you need to do by altering config files. I understand that it makessetup probably little bit easier as you do everything in single console.

Re appender method: configuration with xml is down to putting recipients email address/cc, smtp server name or ip and credentials if required. The same info you will have to provide in qmc. Whole setup with xml takes 30 seconds so please dont judge this solution unless you have tried it.

On another note-notifications in qmc are already there in June 2019 TP - so hapy days

https://betahelp.qlik.com/en-US/sense/June2019/Subsystems/ManagementConsole/Content/Sense_QMC/system-notifications.htm

Re: Email on failed load

simonaubert — Fri, 07 Jun 2019 11:27:57 GMT

Correct me if I am wrong but don't you have to put a password in clear text in the xml file?

https://community.qlik.com/t5/Qlik-Sense-Enterprise-Documents/Sending-e-mail-alerts-in-Qlik-Sense-Enterprise-Task-Failures/ta-p/1488735/show-comments/true

Re: Email on failed load

Lech_Miszkiewicz — Fri, 07 Jun 2019 11:34:02 GMT

It all depends on your SMTP server settings. If your smtp does not require authentication and just listens say on port 25 then you dont need a password, nor username.

Below whole, XML just populate it with your smtp server, "from","to", you can add CC (details to documentation are on help.qlik.com )

<?xml version="1.0"?>
<configuration>
<!-- Mail appender-->
<appender name="MailAppender" type="log4net.Appender.SmtpAppender">
<filter type="log4net.Filter.LevelRangeFilter">
<param name="levelMin" value="ERROR" />
</filter>
<filter type="log4net.Filter.DenyAllFilter" />
<evaluator type="log4net.Core.LevelEvaluator">
<param name="threshold" value="ERROR"/>
</evaluator>
<param name="to" value="user@domain.dk" />
<param name="from" value="from@domain.com" />
<param name="subject" value="Qlik Sense Task Alert" />
<param name="smtpHost" value="smtp.domain.com" />
<param name="port" value="25" /> <!-- 25, 465, 567  -->
<param name="EnableSsl" value="false" /> <!-- True False -->
<param name="Authentication" value="none" />  <!-- None Basic NTML -->
<param name="username" value="yourloging" />
<param name="password" value="yourpassword" />
<param name="bufferSize" value="0" /> <!-- Set this to 0 to make sure an email is sent on every error -->
<param name="lossy" value="true" />
<layout type="log4net.Layout.PatternLayout">
<param name="conversionPattern" value="The Task '%property{TaskName}' failed at %date with the Errorlevel '%-5level' %newline%newlineThe App Name is '%property{AppName}' %newline%newlineThe Message was '%message' %newline%newline%newline" />
</layout>
</appender>
<!--Send mail on task failure-->
<logger name="System.Scheduler.Scheduler.Slave.Tasks.ReloadTask">
<appender-ref ref="MailAppender" />
</logger>
</configuration>

Re: Email on failed load

simonaubert — Fri, 07 Jun 2019 13:14:45 GMT

In many organization, I'm afraid this may be seen as a safeth thread.

(FYI, we're not even allowed to use mailing list )

Re: Email on failed load

skenthroxai — Fri, 07 Jun 2019 14:22:09 GMT

Here is an easy way to do it with the scripting:

https://youtu.be/IqM6L4Mzb8o

Re: Email on failed load - Status changed to: Coming Soon

Thomas_Hopp — Fri, 11 Oct 2019 10:00:02 GMT

Hi there,

thank you for adding this idea and your comments around that topic of notifications. We are currently working on a solution which will address this use case plus give you more flexibility in setting up notifications (not only via e-mail). This new capability is planned first to be shipped within our Qlik Sense Enterprise on Cloud Services & Qlik Sense Enterprise on Kubernetes deployment options.

Best regards,

Thomas

Re: Email on failed load

simonaubert — Sat, 12 Oct 2019 07:58:18 GMT

Hello @Thomas_Hopp

Good news. And nice to update the status on the idea 🙂

Re: Email on failed load - Status changed to: Open - In Development

John_Teichman — Wed, 18 Dec 2019 07:35:34 GMT

Re: Email on failed load

Sajid_Mahmood — Thu, 23 Apr 2020 12:18:48 GMT

Basic feature which is 110% required similar to qlikview

Re: Email on failed load

Oliver_F — Mon, 04 May 2020 13:47:59 GMT

@Thomas_Hopp I have just seen the announcement of Qlik Alerting. Is this feature still under development for Qlik Sense Cloud (short term) Qlik Sense Enterprise (Long Term) or will the development be dropped due to the new Alerting release?

Re: Email on failed load

jheasley — Fri, 08 May 2020 11:01:04 GMT

take a look at alerts through MS Teams:

Failure Alerts in MS Teams

Re: Email on failed load

marcel_olmo — Tue, 19 May 2020 17:24:21 GMT

Hi @John_Teichman , this functionality will come separatedly from the Qlik Alerting tool?

Best Regards, Marcel.

Re: Email on failed load

John_Teichman — Mon, 25 May 2020 06:56:00 GMT

Hello @marcel_olmo - No, this is not planned. The team is working on a better experience for scheduling in the Hub and monitoring via the QMC, but there is nothing concrete right now.