Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
venkat_94b4
Creator
Creator

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)??

10 Replies
bwisealiahmad
Partner
Partner

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

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
Creator
Creator
Author

Hello Mark,

Thanks for the response.

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

Thanks,

venkat

fernandobibian
Partner
Partner

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
Contributor III
Contributor III

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
Contributor III
Contributor III

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

teiswamsler
Partner
Partner

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

waleeed_mahmood
Creator
Creator

Hello Teiswamsler,

I just have some questions:

1. Is it possible to send emails to multiple people? 

2. Is it possible to send alerts to specific people for specific apps?

3. for the username/password fields, is the username and password for QMC or the server the app is running on?

 

Thanks for your help.

teiswamsler
Partner
Partner

Hi Walled

Sorry for a very late reply, have been busy.

1. Yes it is possible, see the example below.

<param name="to" value="user1@domain.dk,user2@domain.dk,user3@domain.dk" />

2. No

3. It is the user and password (if needed) for the mail server or mail relay.

Br
Teis