Qlik Community

Qlik Sense Enterprise Ideas

Ideas for Qlik Sense Enterprise.

Email on failed load

markp201
Contributor III

Email on failed load

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.

11 Comments
markp201
Contributor III

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

Partner
Partner

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 

 

Partner
Partner

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

Partner
Partner

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.

markp201
Contributor III

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.

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...

Partner
Partner

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-En...

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>

 

Partner
Partner

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

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