6 Replies Latest reply: Jun 15, 2017 11:40 AM by Robin Hausdörfer RSS

    Send alerts from QlikView server

    Manoj Kulkarni

      Hi ,

       

      I have configured alerts in Desktop version & is working, how to configure the same in Qlikview Server ?

       

      I have configured Mail Server in QMC and tested.

       

      Please share if any body has document to configure alerts in server & desktops. Suggestion is much appreciated

        • Re: Send alerts from QlikView server
          Robin Hausdörfer

          I think you have to activate batch mode when using alerts in combination with QlikView Server.

          This configuration works for me on server:

           

          • Re: Send alerts from QlikView server
            Chip Matejowsky

            The below is a publicly available article from Qlik Support: Hopefully it will answer your questions.

             

            Overview of email notification and alerts in QlikView Server, Publisher and Desktop

             

             

            Note: This article is intended for QlikView Server with a Publisher License only. QlikView Server without a Publisher license can only do reloads on User Documents, and there is a limited functionality in regards to alert and notification emails.

             

            Both QlikView Desktop and QlikView Publisher has a built-in email functionality, in order to send alerts and notifications according to some triggers. This article is intended to clarify and elaborate on the differences and the different options that exists with sending emails from within the QlikView products. In general, only "Alerts" in QlikView Desktop is transferred with a document to QlikView Publisher, and in some scenarios user-made macros and third party extensions. This means that this article only handles functionality that is part of the core product.

             

            This article assumes that the reader has some knowledge about how to create tasks in Publisher, what NTLM, NTFS, SMTP, QVB and QDS stands for, how to create and open documents and e.g. the difference between a reload and/or a distribution.

             

            QlikView Desktop

             

            Mail settings
            Under Settings > User Preferences > Mail, one can find the email settings for the QlikView Desktop program.

             

            Sender - Can be set to pretty much anything, as long as the user account running the services is trusted by the SMTP server to send emails.
            Server - Defines the SMTP server, which is usually outside QlikView control.
            Authentication method - defines by which user account the client can send emails. "None" means anonymous, and NTLM is mostly used in older domains. If you get an error message when using NTLM as the authentication method, try "None". If you are using a Active Directory Domain, you are already logged on and authentication on the domain, and the computer is a member of the domain. This means that the SMTP server recognizes the address being used as well as the computer, which allows you to send emails. This also means that you do not need to run QlikView Desktop with a domain user account in order to send emails, but this can instead depend on what your domain policies and SMTP server allow.

             

            Test mail
            Built into this Mail setting tab inside "User Preferences" is also "Test", which allows you to send a test mail. Due to the architecture of the product there are a few differences that might impact how it behaves in your environment, e.g. Test mail works, but an email from a Macro, an alert or extension does not work. It can also depend on the user account running the document at the time being, and if it is logged in or not.

             

            When do you use the email functionality in QlikView Desktop?
            Most built-in functionality that uses the mail settings inside QlikView Desktop can be found under "Tools" > "Alerts". Here one can define an email to be sent during certain circumstances, due to certain triggers. This "Alerts" functionality will be activated if used on QlikView Publisher/Server, but the email will be sent by the QVB process instead of the QDS. Configuration of email settings can be done for the settings.ini of the QVB, located at C:\Windows\System32\config\systemprofile\AppData\Roaming\QlikTech\QlikViewBatch . As mentioned, there are more ways to configure email notifications, which can transfer some email notification settings to QlikView Publisher, available for further development outside the core functionality, e.g. by Macros (Tools > Edit Module) or Extensions (e.g. Settings > Document Properties > Extensions).

             

            QlikView Publisher Settings

             

            Mail settings
            In the QMC, under System > Setup > Mail Server, one can find the email settings for the QlikView Publisher program.

             

            Location - Defines the SMTP server, which is usually outside QlikView control.
            Miscellaneous - "From adress" can be set to pretty much anything, as long as the user account running the services is trusted by the SMTP server to send emails. E-mail format can be of choice, either plain or HTML.
            Authentication method - defines by which user account the client can send emails. Anonymous does not try to authenticate towards the SMTP server, but works if the server is within the domain and/or the SMTP server allows anonymous emails to be sent. "Use Distribution Service account" let's you authenticate with the service account being used for the service, in case the SMTP server requires a domain account to be authenticated in order to send emails. Finally, "User name and password" lets you define custom credentials to an SMTP server. This is mostly used when using external mail servers like GMail and similar.

             

            Override E-mail
            For test purposes and not to spam other peoples inboxes when doing tests, one can set a single email address to be used to receive all email. Remember to change this back if being used.

             

            Test mail
            Built into this Mail Server settings tab also "Send test e-mail". Due to the architecture of the product there are a few differences that might impact how it behaves in your environment, e.g. Test mail works, but an alert email, a notification email or a distribution does not work. It can also depend on the user account running the document at the time being, and if it is logged in or not. The major difference, as of v11.20 SR10 is that the test email is sent by the QlikView Management Service and not the QlikView Distribution Service. If you have many servers used for QlikView in your environment, the test email might be sent from a different server than the alert email. The test functionality is also using a simple .NET SMTP client, and do not use the DSC to look up an email address, it just takes the email and sends it.

             

            Document Administrators Authorized to Distribute via E-mail
            Some users can be set to be QlikView Publisher Document Administrators, which are allowed to distribute documents via e-mail. You can ready more about Document Administrators in the QlikView Server Reference Manual, see here .

             

            QDS settings
            You may find general QDS setting for alert and notification emails under QMC > System > Setup > Distribution Services > QDS@servername. There are two tabs here, "Alert E-mail", which let's you define which system administrators who should receive an alert email whenever a distribution has a warning or an error. On the next tab you can define "E-mail templates", for attachments, notifications and alerts. The different types of emails is explaining in the next section. The email templates can be customized with different variables, found in Help, in the upper right corner. As of 11.20 SR6 and later, a few new variables have been added, e.g. [TaskLogHyperlink], [DocumentLogHyperlink] and [DocumentLog]. See the Release Notes for more information about the new variables, page 7.

             

            Different types of mails in QlikView Publisher:

             

            Distribution of Documents/PDF
            For this to work, a Publisher needs to be authorized to send PDFs, which is determined by the license, e.g. :
            PDF_GENERATION;YES;;
            QlikView Information Access Server and QlikView Extranet Server does not have this in their licenses. The QlikView Distribution Service is responsible for the email being sent in this feature, where the QDS gets a recipient list and looks it up with the help of the DSC. The recipients emails are based on their ID (e.g. DOMAIN\username) or a plain name (e.g. account@mail.com). This process also validates the email address to ensure it is valid. The email will contain the text template defined within the QDS settings with the PDF/QVW attached. The email distribution setting is to be found on the same tab as "Distribute to server" or "Distribute to folder":
            User-added image
            The QDS can distribute a PDF or a QVW to email addresses at the same time as it becomes available on the AccessPoint, meaning distribution is not limited to a single type of publication. The type of document of choice, a report via PDF or the full document via QVW, can be set under the "File Typ" subtab. Depending on the size of the QVW, limitations on the filesize may be subject to mail server settings. If you do not get the option to specify users or groups, no Mail Server has yet been configured.

             

            Notification emails
            Done by the QDS as well, with the same mechanism. When setting up a document in QlikView Publisher, one can configure a notification to be set, so that specific users are notified when there is a new version of a document on the AccessPoint. Under QMC > Documents > Source Documents > Document > Taskname (assumes the task has already been created) > Distribute > Notify, you can check whether or not the e-mail recipients should receive a notification or not.
            User-added image
            This is not intended to use for distribution, only notification, meaning the "Distribute via E-mail" does not need to be used, instead the end-user get's a notification when a document is distributed to a QVS or a folder. If there is an email-distribution as well, it is redundant to first send the QVW/PDF via email and subsequently an email with a notification, meaning no notification will occur. A major difference to the "Distribution via E-mail" is that the notification functionality uses a queue system, where the thread runs every 30 seconds to send mail.

             

            Alerts/Error in reloads
            The email functionality that is used most by far in QlikView Publisher, is the "Alerts email". Using a template defined in the QDS setting, the QDS sends an email to defined recipients in case of a failing task. After a task fail, the QDS runs a cleanup method where it checks if "Alerts" have any recipients. The recipients list, which mostly consists of QlikView Server Administrators, can be set in the QDS Settings > Alert "E-mail":
            User-added image
            For every task that is failing an email would be sent to the full list of administrators, along with an excerpt of the error message. The alert email functionality uses the same functionality as "Distribute via e-mail" and "Notification", meaning the QDS gets a recipient list and looks it up with the help of the DSC. The recipients emails are based on their ID (e.g. DOMAIN\username) or a plain name (e.g. account@mail.com).

             

            Troubleshooting

             

            I do not get any alert e-mails, but the test-email functionality works!
            Test-email does not confirm the email-addresses being used in the test, it simply sends an email. The alert email functionality matches the email address with the DSC to look it up. If you can't look up the email address under "Users", it might be possible that resolving email addresses is not working properly. You may also try to change the mail server authentication method from .e.g "Use Distribution Service account" (which might not have an email-address registered, is not allowed to send emails or does not have an account at the SMTP server), to the "Anonymous" checkbox. Some SMTP servers allows anonymous emails which could simplify sending emails. Using an account does thus force authentication towards the SMTP server which it doesn't accept.

             

            I do not get any notification emails!
            Wait for at least 30 seconds and see if it was in the outbox. If sending a lot of emails it might take some time before the email reaches the end-user. The advice here would be to wait a further 10 minutes to confirm it is just not a delay on the mailserver end. Confirm that the issue solely is located to notification emails by trying to distribute a document via email, and report to Qlik Support in case if further issues.