Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Email on failed load

markp201
Creator III
Creator 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.

26 Comments
markp201
Creator III
Creator III

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

skenthroxai
Partner - Contributor III
Partner - Contributor III

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 

 

paulcalvet
Partner - Specialist
Partner - Specialist
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

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

simonaubert
Partner - Specialist II
Partner - Specialist II

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

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

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

simonaubert
Partner - Specialist II
Partner - Specialist II

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

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

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>

 

simonaubert
Partner - Specialist II
Partner - Specialist II

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

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