Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
venkat_94b4
Contributor

Email Alerts for reload tasks failure in QlikSense

Hi Team,

I am planning to set up Email alerts for reload failures in Qliksense QMC. I have gone through some discussion over community and found that https://github.com/NickAkincilar/QlikSense-Task-Failure-Email-Alerts

Can any one help me with setting up this in my Qliksense server(Mine is Single node server)??

7 Replies
Partner
Partner

Re: Email Alerts for reload tasks failure in QlikSense

Hi,

I would have a look here and see if this helps:

https://www.youtube.com/watch?v=06IsKMG6irQ

and

Qlik Sense Sending Email Alerts - YouTube

Two part YouTube video.


Best,

Ali A

rittermd
Honored Contributor

Re: Email Alerts for reload tasks failure in QlikSense

I set it up on my system using a Qlik Connector (free one). 

Take a look at this You Tube.

https://www.youtube.com/watch?v=06IsKMG6irQ

venkat_94b4
Contributor

Re: Email Alerts for reload tasks failure in QlikSense

Hello Mark,

Thanks for the response.

My requirement is send alert emails for reload failures in QMC as part of admin monitoring.

Thanks,

venkat

Partner
Partner

Re: Email Alerts for reload tasks failure in QlikSense

Hello Venkat,

From the QMC in Tasks you can create a New App that reload when other reload fail, then you can use LLodi Writer Connector to send emails, sms, slack messages or your favourite communication app.

Once you have created the app, configure the alert is really easy, I think this video can be useful.

Best,

Fernando

mike_rowe
New Contributor II

Re: Email Alerts for reload tasks failure in QlikSense

Hi Venkat

Not sure if you have already found a solution to this but I have found this solution.

Reload Failure Email Alerts can be set up using a configuration file written in xml and placed in a specific folder location on the Sense Server:
 
C:\ProgramData\Qlik\Sense\Scheduler
 
The file has to be called 'LocalLogConfig.xml' so that it can be recognised by Qlik and you must have an SMTP server that can be used. We have exchange at our organisation, however, common mail providers can be used such as Gmail.
 
The file also has to be written in a precise structure as attached. This can be adapted to suit your needs.
 
If you would like to use an external mail account such as Gmail then I would suggest reading this article: https://community.qlik.com/t5/Qlik-Sense-Enterprise-Documents/Sending-e-mail-alerts-in-Qlik-Sense-En...
 
Let me know how you get on.
 
Kind regards
 
Mike Rowe
vicobi123
New Contributor III

Re: Email Alerts for reload tasks failure in QlikSense

Hi, Mike Im trying to use this method. I've followed the steps below. How would you then run the process after the file is in that directory?

 

Many thanks in advance

Highlighted
Partner
Partner

Re: Email Alerts for reload tasks failure in QlikSense

Hi venkat

This i just one of many solutions

  1. Get the following info:
    1. SMTP Server name
    2. Username/Password
    3. Port and TLS setting
    4. Alert Recipiants Emails Adresses
  2. Create a new xml file in %ProgramData%\Qlik\Sense\Scheduler called LocalLogConfig.xml and copy the code below
  3. Edit the following all higlighted code according to point 1, save and restart your Qlik Sense services:
<?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>

Br
Teis