article Email Alert for Qlik Sense task failed (Very easy) in Qlik Sense Documents

Email Alert for Qlik Sense task failed (Very easy)

Anil_Babu_Samineni — Wed, 01 Jul 2020 15:03:13 GMT

Hi Team,

This document can help about configuration for Task failure notification in Qlik Sense

Connector installation and configuration

This part only needs to be done once on all Qlik Sense nodes per environment.

Prerequisites: Anonymous authentication to the <Company> SMTP relay has been opened.

1. Download the Qlik Web Connectors March 2020 Patch 1 (currently installed) from the Qlik download site.
Go to www.qlik.com to log on with a registered customer or partner account, select Services > Customer Downloads, and then select the Qlik Connectors tab.

2. Before you unzip the file, check that the folder is not blocked by Windows security. To unblock the zip file, right click on the file, select Properties, then click on Unblock in the General tab. Click Apply.

3. Unzip QlikWebConnectorsX.X.zip (where X. X - is the version name) and place the unzipped files in a folder on the root directory of one of the nodes Windows server D:QlikWebConnector

4. Start up the Web connectors server in manual mode to configure it: open 😧 QlikWebConnectors\QlikWebConnectors.exe
If successful the following window will open.

5. Proceed to http://localhost:5555/web to configure the SMTP connector. Qlik SMTP connector is available on Connectors / Standard page. Click on the connector name to go to the connector Parameters page.

Fill in the details:

SMTP Server: Talk to windows team
Port: 25
SSL Mode: None
To: [Your Email Address to test]
Subject: Qlik Sense Failure Notification
Message: Qlik Sense Says Hi !!
HTML ON
From Email: Your From Address

Send a test email by clicking on Save Inputs & Run Table. You can see the result in Data Preview section and must receive the test email

6. Close the Web Connectors Page and the Qlik Web Connectors window to stop the connectors server.

7. Edit "Install Service. bat" file in D:QlikWebConnectors, Batch Files to configure the connectors as a service, so they auto start up with the Windows as follows:

REM *****************************
REM IMPORTANT - PLEASE READ:
REM * You should ensure than you have 'unblocked' the Qlik Web Connectors download zip file BEFORE unzipping it and running this.
REM * You need to change the following paths to match your .NET installation directory and QlikWebConnectorsSVC.exe location.
REM * You should run this file as Administrator (right click, 'Run as administrator').
REM *****************************
"%windir%\Microsoft.NET\Framework\v4.0.30319\installutil" "D:\QlikWebConnectors\QlikWebConnectorsSVC.exe"

pause

8. Save the batch file… Right click the Install Service bat file and select Run as administrator.

a. The batch file installs the Qlik Web Connectors as a Windows Service.

when the batch file finishes, press any key to close the command window

you should see an entry for Qlik Web connectors like

9. From the Windows start menu, type Services to open the Services dialog.
a Right click on the Qlik Web Connectors service entry
b. In the Qlik Web Connectors Properties dialog, click on the Start under the General tab to start the service.
Ensure that the Service status is Running.
Warning: Close the Click Web Connectors before you complete this step. If they are running when you press start, you will get a message saying that the service has started and then stopped.
c. Select the Recovery tab and set First failure to Restart the Service and set the time for Restart service after to zero (0) minutes.

Apply the changes and click OK.

10. The Qlik Web Connectors should be available at http: //localhost:5555/
11. Install and configure the connectors on all other Qlik Sense nodes. The easiest way to do it:
a. Stop the service and copy the folder D:QlikWebConnectors, to all other Qlik Sense nodes
b. Register the service on each of the nodes (steps 8-10).
c. Start the service which has been stopped at step (a).

12. Create new connection in every Qlik Sense environment not the nodes.
i. Data load editor - Create new connection - REST
ii. URL: Can be found from 5th point
iii. Authentication Schema: Anonymous.
iv. Skip server certificate validation: ON
v. Query parameters:
   1. to: your emal for test
   2. subject: test
   3. message: test
vi. Name: SendEmail
vii. By default the connection name created via the Data load edit will be something like "SendEmail (<usemame>)". Remove the user name from the connection name via QMC.

Till above the connection setup is done.

How to setup the email alert for existing dashboard and newly creating dashboard?

1) Let's say, I have an Qlik Sense application called QSAppName.qvf {QSAppName is Dashboard Name} and this dashboard created task either daily/weekly/monthly etc.

2) To create alert, Again one application required

a) Let's say, I've created an application called QSAppName_Failure_Notification.qvf

b) Go to Script / data load editor, And add the following script

LIB CONNECT TO 'SendEmail';// You can add multiple email's as well in the recipient with delimiter of semicolon (;)

Let vTo = 'to Address here';
Let vCc = 'CC Address here';
Let vSubject = 'QlikSense Dashboard Failure Notification';
Let vMessage = 'Your message'; // You can write in HTML also, If you likeEmailStatus:
SQL SELECT
"status",
"result",
"filesattached"
FROM CSV (header on, delimiter ",", quote """") "CSV_source"
WITH CONNECTION(
QUERY "to" "$(vTo)",
QUERY "cc" "$(vCc)",
QUERY "subject" "$(vSubject)",
QUERY "message" "$(vMessage)");

3) Create task for "QSAppName_Failure_Notification.qvf" on dependency of failure to "QSAppName.qvf"

Bingo, You achieved very powerful feature enjoy with your email's. I love to hear some question's, If any using Comment box

Regards,

Anil Samineni

Re: Email Alert for Qlik Sense task failed (Very easy)

AdamBSnotused — Fri, 03 Jul 2020 10:12:04 GMT

Thanks... adding to the above, I have a video on the same which can be found here

https://pomerolinsight.co.za/multi-media/

Re: Email Alert for Qlik Sense task failed (Very easy)

rockabs — Mon, 29 Mar 2021 20:14:50 GMT

@Anil_Babu_Samineni This is cool stuff and really good !

Re: Email Alert for Qlik Sense task failed (Very easy)

karivenkatesh143 — Mon, 29 Mar 2021 20:17:35 GMT

@Anil_Babu_Samineni What is the best practice when we have multi node setup with 12 nodes? Can we also do some web technologies to show more good in email?

Re: Email Alert for Qlik Sense task failed (Very easy)

Anil_Babu_Samineni — Wed, 31 Mar 2021 17:13:39 GMT

Hello, please refer 11th point where you find the same !

Re: Email Alert for Qlik Sense task failed (Very easy)

kdaniels-obrien — Thu, 29 Apr 2021 18:37:03 GMT

Great solution!! Does the STMP web connector require any additional licensing?

Re: Email Alert for Qlik Sense task failed (Very easy)

Anil_Babu_Samineni — Sat, 22 May 2021 16:06:11 GMT

@kdaniels-obrien If you have already Qlik Enterprise, You no need to buy anything. Comes to SMTP, Which is your gateway from your client domain.

Re: Email Alert for Qlik Sense task failed (Very easy)

tandrisani — Wed, 04 Aug 2021 15:33:46 GMT

This is fantastic. Thank you so much!

Re: Email Alert for Qlik Sense task failed (Very easy)

rathorep — Tue, 14 Sep 2021 04:54:20 GMT

Hello, can we get attached log file in email when the task fails?

Re: Email Alert for Qlik Sense task failed (Very easy)

VaidhyaGanesan — Wed, 15 Sep 2021 22:10:42 GMT

@Anil_Babu_Samineni - Thanks for spending time to write this. As per my understanding this solution work for 1 app. if i want to do the same for multiple apps/dashboard instead of recreating multiple alert apps, is there any solution to use single alert app for multiple dashboards

Re: Email Alert for Qlik Sense task failed (Very easy)

kdaniels-obrien — Wed, 15 Sep 2021 23:06:21 GMT

@VaidhyaGanesan Yes, you could just create a new trigger for each app you wish to be alerted about!

Re: Email Alert for Qlik Sense task failed (Very easy)

pcrocker — Mon, 18 Oct 2021 16:35:09 GMT

Hello, I am getting the following error when running the app (occurs at the end of the script):

20211018T113258.383-0400 4 fields found: status, result, filesattached, __extra_,
20211018T113258.390-0400 Error: CSV is not valid: columns number of row 8 is different from previous rows (1 and 3).
20211018T113258.390-0400 row: content="width=device-width, initial-scale=1, shrink-to-fit=no"
20211018T113258.404-0400 Execution Failed

Has anyone run into this and found a solution?

Thanks.

Re: Email Alert for Qlik Sense task failed (Very easy)

Anil_Babu_Samineni — Mon, 01 Nov 2021 08:08:44 GMT

@rathorep No, With this not possible, You have to alter some script which can attach the attachment.

Re: Email Alert for Qlik Sense task failed (Very easy)

Anil_Babu_Samineni — Mon, 01 Nov 2021 08:09:59 GMT

@VaidhyaGanesan That is based on script how you need it, For bulk you can refer Qlik Alerting.

Re: Email Alert for Qlik Sense task failed (Very easy)

Anil_Babu_Samineni — Mon, 01 Nov 2021 08:11:16 GMT

@pcrocker For me that is Source issue not above script, Did you checked first how your load statement and is that working?

Re: Email Alert for Qlik Sense task failed (Very easy)

haty — Wed, 10 Nov 2021 23:29:28 GMT

If you don't mind installing an app on your sever, I recommend using NickAkincilar/QlikSense-Task-Failure-Email-Alerts: Automated email alerts for failed Qlikse Alerts (github.com). Very easy to use and works well, have been using it for several years.

Re: Email Alert for Qlik Sense task failed (Very easy)

lijianqlik — Mon, 22 Nov 2021 21:11:23 GMT

I'm getting the same error as @pcrocker :

CSV is not valid: columns number of row 8 is different from previous rows (1 and 3). row: content="width=device-width, initial-scale=1, shrink-to-fit=no"

Re: Email Alert for Qlik Sense task failed (Very easy)

Aditya_Chitale — Mon, 09 May 2022 04:17:18 GMT

Is there any way to add the app name/id in my mail message ?

Re: Email Alert for Qlik Sense task failed (Very easy)

rockabs — Tue, 31 May 2022 02:40:05 GMT

@Aditya_Chitale Not really, But you can use Qlik alerting if required.

Or, Anyway, this is not global specific and it is Application specific, Hence you must use your own message or subject of the email which gives you a clue.

Let vSubject = 'QlikSense Dashboard Failure Notification';

Re: Email Alert for Qlik Sense task failed (Very easy)

Jaya15 — Tue, 16 Aug 2022 11:40:12 GMT

Dear All

Can you Please help me i this
I am trying to get more then one task failure notification but i am getting only one can you pleas help me to get more then one task failure
getting this now

want to get the 2nd table as well
using below code

Please help

Thanks

Jaya Sharma