In this article, we walk you through the requirements and process of how to upgrade an existing Qlik Sense Repository Database (see supported scenarios) as well as how to install a brand new Repository based on PostgreSQL.

We will use the Qlik PostgreSQL Installer (QPI).

For a manual method, see How to manually upgrade the bundled Qlik Sense PostgreSQL version to 12.5 version.

Index

• Supported Scenarios
• Upgrades
• New installs
• Considerations
• Installing anew Qlik Sense Repository Database using PostgreSQL
• Qlik PostgreSQL Installer - Download Link
• Upgrading anexisting Qlik Sense Repository Database
• The Upgrade:
• Finalizing the Upgrade/Uninstalling the old Database Service:
• Compatibility with PostgreSQL installers
• Troubleshooting
• Related Content

Supported Scenarios

Upgrades

The following versions have been tested and verified to work with QPI 1.3.0 (May 2023): 

February 2022 to May 2023.

If you are on any version prior to these, upgrade to at least February 2022 before you begin.  

Note that November 2022 and later do not support 9.6, and a warning will be displayed during the Qlik Sense upgrade. 

New installs

The Qlik PostgreSQL Installer supports installing a new Qlik Sense Repository Database cluster on a new server, setting up a new environment or migrating an existing Database to a separate host.

Considerations

• This installer will not detect a standalone PostgreSQL database installed by any other means, other than through an official Qlik installer package.
• The user who runs the installer must be an administrator.
• The backup destination must have sufficient free disk space to dump the existing database  
• The backup destination must not be a network path or virtual storage folder. It is recommended the backup is stored on the main drive. 
• The installer itself does not provide an automatic rollback feature.
• There will be downtime during this operation, please plan accordingly 

Installing a new Qlik Sense Repository Database using PostgreSQL

1. Run the Qlik PostgreSQL Installer as an administrator 
   
   
2. Click on Install 
   
   
3. Accept the Qlik Customer Agreement 
   
   
4. Set your Local database settings and click Next. You will use these details to connect other nodes to the same cluster. 
   
   
5. Set your Database superuser password and click Next
   
   
6. Set the database installation folder, standard: C:\Program Files\PostgreSQL\14
   
   
7. Set the database data folder, standard: C:\Program Files\PostgreSQL\14\data
   
   
8. Review your settings and click Install, then click Finish
   
   
9. Start installing Qlik Sense Enterprise Client Managed. Choose Join Cluster option.
   
   The Qlik PostgreSQL Installer has already seeded the databases for you and has created the users and permissions. No further configuration is needed.
   
   
10. The tool will display information on the actions being performed. Once installation is finished, you can close the installer.  
    
    If you are migrating your existing databases to a new host, please remember to reconfigure your nodes to connect to the correct host. How to configure Qlik Sense to use a dedicated PostgreSQL database 
    

Qlik PostgreSQL Installer - Download Link

Download the installer here.

Qlik PostgreSQL installer version 1.3.0 Release Notes

Upgrading an existing Qlik Sense Repository Database

The following versions have been tested and verified to work with QPI 1.3.0 (May 2023): 

February 2022 to May 2023.

If you are on any version prior to these, upgrade to at least February 2022 before you begin.  

Note that November 2022 and later do not support 9.6, and a warning will be displayed during the Qlik Sense upgrade. 

The Upgrade:

1. Stop all services on rim nodes 
   
   
2. On your Central Node, stop all services except the Qlik Sense Repository Database 
   
   
   
   
3. Run the Qlik PostgreSQL Installer. An existing Database will be detected. 
   
   
   
   
4. Highlight the database and click Upgrade 
   
5. Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next.
   
   
   
   
6. Provide your existing Database superuser password and click Next.
   
   
7. Define your Database backup path and click Next.
   
   
   
   
8. Define your Install Location (default is prefilled) and click Next.
   
   
   
   
9. Define your database data path (default is prefilled) and click Next.
   
   
    
10. Review all properties and click Upgrade.
    
    
    
    
11. The upgrade is completed. Click Close.
     
12. Open the Windows Services Console and locate the Qlik Sense Enterprise on Windows services.
    
    You will find that the Qlik Sense Repository Database service has been set to manual. Do not change the startup method. 
    
    
    
    You will also find a new postgresql-x64-12 service. Do not rename this service. 
    
    
    
    
13. Start all services except the Qlik Sense Repository Database service. 
    
    
14. Start all services on your rim nodes.
    
    
15. Validate that all services and nodes are operating as expected. The original database folder in C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\X.X_deprecated

If the upgrade was unsuccessful and you are missing data in the Qlik Management Console or elsewhere, contact Qlik Support.  

Finalizing the Upgrade/Uninstalling the old Database Service:

No further steps are needed unless you plan to upgrade Qlik Sense Enterprise on Windows to the next major release. If you plan to upgrade to, for example, November 2022, the old Qlik Sense Repository Database service must be removed from the server.

Perform the following steps to delete the Qlik Sense Repository Database Service:

1. Open a command prompt and run the command:
   cd "C:\ProgramData\Package Cache"
   
   
2. From there, run:
   
   If 9.6:
   c:\ProgramData\Package Cache\dir /s PostgreSQL.msi
   
   If 12.5:
   c:\ProgramData\Package Cache\dir /s PostgreSQL125.msi
   
   
3. The folder containing the msi will be revealed.
   
   
4. Right-click on the msi file and select uninstall from the menu.

Compatibility with PostgreSQL installers

This version of the upgrade tool is fully compatible with the official PostgreSQL installers from https://www.enterprisedb.com/downloads/postgres-postgresql-downloads.

If you have previously used the Qlik Postgres Installer (version 1.2.1 or earlier), you can simply install the latest PostgreSQL version (within your major release).

Example: You have used the old QPI to upgrade to 12.5. You can now easily upgrade to a later version in the same major release, such as 12.15.

Troubleshooting

1. If the installation crashes, the server reboots unexpectedly during this process, or there is a power outage, the new database may not be in a serviceable state. Installation/upgrade logs are available in the location of your temporary files, for example:
   
   C:\Users\Username\AppData\Local\Temp\2
   
   A backup of the original database contents is available in your chosen location, or by default in:
   
   C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\backup\X.X
   
   The original database data folder has been renamed to:
   
   C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\X.X_deprecated
   
   
2. Upgrading Qlik Sense after upgrading PostgreSQL with the QPI tool fails with:
   
   This version of Qlik Sense requires a 'SenseServices' database for multi cloud capabilities. Ensure that you have created a 'SenseService' database in your cluster before upgrading. For more information see Installing and configuring PostgreSQL.
   
   See Qlik Sense Upgrade fails with: This version of Qlik Sense requires a _ database for _.
   
   To resolve this, start the postgresql-x64-XX service.

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support. The video in this article was recorded in a earlier version of QPI, some screens might differ a little bit.

Related Content

Qlik PostgreSQL installer version 1.3.0 Release Notes  
Techspert Talks - Upgrading Qlik Sense Repository Service
Backup and Restore Qlik Sense Enterprise documentation
Migrating Like a Boss
Optimizing Performance for Qlik Sense Enterprise
Qlik Sense Enterprise on Windows: How To Upgrade Standalone PostgreSQL
How-to reset forgotten PostgreSQL password in Qlik Sense
How to configure Qlik Sense to use a dedicated PostgreSQL database
Troubleshooting Qlik Sense Upgrades

Qlik offers a wide range of channels to assist you in troubleshooting, answering frequently asked questions, and getting in touch with our technical experts. In this article, we guide you through all available avenues to secure your best possible experience.

For details on our terms and conditions, review the Qlik Support Policy.

Index:

• Support and Professional Services; who to contact when.
• Qlik Support: How to access the support you need
• 1. Qlik Community, Forums & Knowledge Base
• The Knowledge Base
• Blogs
• Our Support programs:
• The Qlik Forums
• Ideation
• How to create a Qlik ID
• 2. Chat
• 3. Qlik Support Case Portal
• Escalate a Support Case
• Resources

Support and Professional Services; who to contact when.

We're happy to help! Here's a breakdown of resources for each type of need.

(*) reach out to your Account Manager or Customer Success Manager

Qlik Support: How to access the support you need

1. Qlik Community, Forums & Knowledge Base

Your first line of support: https://community.qlik.com/

​Looking for content? Type your question into our global search bar:

The Knowledge Base

Leverage the enhanced and continuously updated Knowledge Base to find solutions to your questions and best practice guides. Bookmark this page for quick access!

1. Go to the Official Support Articles Knowledge base
2. Type your question into our Search Engine
   
   
   
   
3. Need more filters?
   1. Filter by Product
   2. Or switch tabs to browse content in the global community, on our Help Site, or even on our Youtube channel
      
      

Blogs

Subscribe to maximize your Qlik experience!

The Support Updates Blog
The Support Updates blog delivers important and useful Qlik Support information about end-of-product support, new service releases, and general support topics. (click)

The Qlik Design Blog
The Design blog is all about product and Qlik solutions, such as scripting, data modelling, visual design, extensions, best practices, and more! (click)

The Product Innovation Blog
By reading the Product Innovation blog, you will learn about what's new across all of the products in our growing Qlik product portfolio. (click)

Our Support programs:

Q&A with Qlik
Live sessions with Qlik Experts in which we focus on your questions.

Techspert Talks
Techspert Talks is a free webinar to facilitate knowledge sharing held on a monthly basis.

Technical Adoption Workshops
Our in depth, hands-on workshops allow new Qlik Cloud Admins to build alongside Qlik Experts. 

Qlik Fix
Qlik Fix is a series of short video with helpful solutions for Qlik customers and partners.

The Qlik Forums

• Quick, convenient, 24/7 availability
• Monitored by Qlik Experts
• New releases publicly announced within Qlik Community forums (click)
• Local language groups available (click)

Ideation

Suggest an idea, and influence the next generation of Qlik features!

Search & Submit Ideas
Ideation Guidelines

How to create a Qlik ID

Get the full value of the community.

Register a Qlik ID:

1. Go to: qlikid.qlik.com/register
2. You must enter your company name exactly as it appears on your license or there will be significant delays in getting access.
3. You will receive a system-generated email with an activation link for your new account. NOTE, this link will expire after 24 hours.
   
   If you need additional details, see: Additional guidance on registering for a Qlik account
   If you encounter problems with your Qlik ID, contact us through Live Chat!

2. Chat

Incidents are supported through our Chat, by clicking Chat Now on any Support Page across Qlik Community.

To raise a new issue, all you need to do is chat with us. With this, we can:

• Answer common questions instantly through our chatbot
• Have a live agent troubleshoot in real time
• With items that will take further investigating, we will create a case on your behalf with step-by-step intake questions.

3. Qlik Support Case Portal

Log in to manage and track your active cases in Manage Cases. (click)

Please note: to create a new case, it is easiest to do so via our chat (see above). Our chat will log your case through a series of guided intake questions. 

​Your advantages:​

• ​Self-service access to all incidents so that you can track progress​
• Option to upload documentation and troubleshooting files
• Option to include additional stakeholders and watchers to view active cases​
• Follow-up conversations ​​

Escalate a Support Case

If you require a support case escalation, you have two options:

1. Request to escalate within the case, mentioning the business reasons.
   
   To escalate a support incident successfully, mention your intention to escalate in the open support case. This will begin the escalation process.
   
   
2. Contact your Regional Support Manager
   
   If more attention is required, contact your regional support manager. You can find a full list of regional support managers in the How to escalate a support case article.

Resources

A collection of useful links.

Qlik Cloud Status Page
Keep up to date with Qlik Cloud's status.

Support Policy
Review our Service Level Agreements and License Agreements.

Live Chat and Case Portal
Your one stop to contact us.

In Qlik Cloud Services (Qlik Sense Enterprise SaaS), it is possible to get the iFrame HTML code to embed a chart in a webpage by right-clicking that chart and choosing "embed chart".

However, just placing this code on a web page is not sufficient to handle the authentication part.

The information provided in this article provides an example of how this can be achieved. Further customization is likely necessary. For assistance, join our active community in the Integrations and Extensions forum or contact our Consulting Services for an engagement. 

Environments:

• Qlik Cloud Services April 2019 and later

Resolution:

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

Steps

1. Open the Qlik Tenant Management Console
2. Scroll to Integration Settings
3. Open Web
4. Click Create new 
5. Fill out the form:
   • Name: The name of the integration 
   • Add an origin: The allowed origins for the requests (such as the webserver hosting the integrations)
6. Click Create to confirm
7. Open Content Security Policy in the Integrations Settings section 
8. Click Add
9. Fill out the form:
   • Name: The name of the integration
   • Origin: The allowed origins for the requests (such as the webserver hosting the integrations)
   • Directive: Choose frame-ancestors
10. Click Add to confirm
11. Copy the script provided in this example:
    
    To handle the authentication and be able to see the chart on an external web page, the parent site needs to do a redirection and let the user authenticate, below is a code example of how to do that.
    

    <!DOCTYPE html>
    <html lang="en">
    
    <head>
      <meta charset="UTF-8">
      <meta name="viewport" content="width=device-width, initial-scale=1.0">
      <meta http-equiv="X-UA-Compatible" content="ie=edge">
      <title>Document</title>
      <script type="text/javascript">
        const webIntegrationId = "g-yrbnOz9wV5-YnIqYLZMgfAxf_iKg30";
        function login() {
          function isLoggedIn() {
            return fetch("https://yourtenant.eu.qlikcloud.com/api/v1/users/me", {
              method: 'GET',
              mode: 'cors',
              credentials: 'include',
              headers: {
                'Content-Type': 'application/json',
                'qlik-web-integration-id': webIntegrationId,
              },
            }).then(response => {
              return response.status === 200;
            });
          }
          return isLoggedIn().then(loggedIn => {
            if (!loggedIn) {
              // check login
                window.top.location.href = "https://yourtenant.eu.qlikcloud.com/login?qlik-web-integration-id=" + webIntegrationId + "&returnto=" + top.location.href;
              throw new Error('not logged in');
            }
          });
        }
    	login()
      </script>
    </head>
    
    <body style="height:600px;">
    	<iframe
        src="https://yourtenant.eu.qlikcloud.com/single/?appid=9539b869-1c84-4e6d-9129-4c5b031ca88a&obj=WJhPv&opt=ctxmenu,currsel"
        style="border:none;width:100%;height:100%;"></iframe>
    </body>
    
    </html>​

    
    
    
12. Paste it into a new file using Visual Studio Code and save it with the HTML extension
13. Replace all mentions of yourtenant in the script with the name of your Qlik Sense SaaS tenant
14. Copy the Web Integration ID from the Web Integration menu and paste it into the script at:
    

    const webIntegrationID = "IDGOESHERE";​

15. Add the link to the Qlik App Object you want to embed in the <iframe> section:
    

    <iframe>src="linktotheobjecthere"></iframe>

16.  Save the file and place it where your web server can read it. 

This article explains how the user can manage the queued reloads using automation by retrieving all the reloads in the tenant and viewing the reloads that are in queued state and can cancel the less important reloads.

Environment

• Qlik Application Automation

Automation Configuration

1. Retrieve all the Reloads using the Raw API request block of the Qlik cloud service connector by inputting reloads as a path.
2. Filter the reloads with the status Queued and Reloading by using a Filter block.
   
   
3. Retrieve the app details for the particular reloads using the Get App information block, retrieve the required information such as ReloadTaskID, AppName, AppID, and Status, Sec in Status, and store it in a Variable block.
   
   
   
   
4. Check if the space of the apps is empty or not and add the applicable space type to a variable.
   
   
5. Add the Reload task object to a variable.
   
   
   
   
6. Filter the reload apps in a Queued state in Private space using the Filter block with the condition SpaceType is equal to Private.
   
   
7. Check if the filter list is not empty, If yes, configure the Reloads IDs that are queued and use the Inputs block to make the IDs to be selected by the user to cancel them.
   
   
8. Use Raw API request to cancel the reloads and output them.
   
   

    

Example output

With Qlik SAP Connector version 8.0.2, when extracting data using  SAP BW Connector, decimal values are separated by comma instead of point. This issue occurs also in version 8.0.1.
The behavior may depend on regional settings

Example of expected behavior. 

Environment

• Qlik Sense Enterprise
• Qlik SAP Connector

Resolution

Bug QB-18820 reported to R&D was closed as fixed. A solution will be available in next release.

Information provided on this defect is given as is at the time of documenting. For up to date information, please review the most recent Release Notes, or contact support with the ID QB-18820 for reference.

Workaround:

Step 1: Download and apply the attached patch

1. Navigate to C:\Program Files\Common Files\Qlik\Custom Data\ 
2. Copy "QvSAPBWConnector" folder and save it on another location (ex: desktop). 
3. Delete "QvSAPBWConnector" folder 
4. Download file "qvsapbwconnector-1.5.3-6+0e8c250-manual-rel.zip" and extract this file  (you will get "qvsapbwconnector" folder) 
5. Rename this folder "qvsapbwconnector" to "QvSAPBWConnector" and paste it in C:\Program Files\Common Files\Qlik\Custom Data\ 
6. Test and if required, restart Qlik services

Step 2:

1. Create a new SAP BW connection
2. Check Connection String Properies and then BEx Legacy Mode (datatypes)

Cause

Product Defect ID: QB-18820

When using Qlik Map Object to display countries like Canada, France, Spain etc., their respective overseas territories will normally not be included.
The example below shows Canada, but the Overseas Territories (see yellow circled area) are not rendered as belonging to Canada

Qlik Map object is based on OpenStreetMap data (see https://www.openstreetmap.org/copyright) and Overseas Territories have special status.

Environment

• Qlik Sene Enterprise
• QlikView
• Qlik GeoAnalytics

When using GeoAnalytics Map Extension, you may need to avoid users to overwrite the "GeoAnalytics Server URL".

• GeoAnalytics Map Extension in Qlik Sense

• GeoAnalytics Map Extension in QlikView

Thus, to hide "GeoAnalytics  Server URL" when implementing app with map extension,

1. Navigate to the location where the GeoAnalytics extensions are located 
2. Open "IdevioMap" folder >> edit "settings.js" file 
3. Set "allowCustomServer" to "false".

Environment

• Qlik Sene Enterprise
• QlikView
• Qlik GeoAnalytics

The following error can occur when using SAP BW Connector to extract data from InfoProvider/CompositeProvider.
--------
[ERR] [QVX] RfcAbapException:JOB_CANCELLED
Job aborted, check log for Job /QTQVC/READ_MPDATA in Job Overview (transaction SM37)
---------

Environment

• Qlik SAP Connector

Resolution

Reported bug QB-18952 was closed by R&D as WAD(working as designed) .

Information provided on this defect is given as is at the time of documenting. For up to date information, please review the most recent Release Notes, or contact support with the ID  QB-18952  for reference.

Workaround

From the SAP System,

1. Go to transaction SE37 and execute function module /QTQVC/GET_METADATA. 
2. Check the concerned INFOPROVIDER

The allowed maximum width  is 8192 characters.

From the INFOPROVIDER, if the field is of, for example 15282 characters wide, a simple workaround would be to split the extraction into two or more extractions. Then in Qlik Sense or QlikView, depending on your data model, use JOIN / CONCATENATE.

Cause

Product Defect ID: QB-18952

After upgrading Qlik Replicate may cause scheduled jobs to fail due to changes in the Scheduler functionality.

Example error: 

[UTILITIES ]E: Command request 'RESUMETASK_REQ' (55) cannot be found. [1020111] (scheduler.c:270)

In this specific example, the scheduled job didn't run because it had selected the option to "RESUME TASK",  which has been removed in more recent versions of Replicate.

Environment

• Qlik Replicate 
  Example: Upgrade from 7.0 to 2021.1

Resolution

A quick solution is to export/import the repository, below are the steps:

1. Under Replicate server -> Logging -> Log File Management -> Uncheck any Log roll over you might have
2. Replicate Server -> Scheduler -> Take a screenshot here as you'll need to recreate the jobs
3. Disable all the scheduled jobs
4. Export repository by going on cmd to Replicate bin/ folder and running:
   

   repctl exportrepository

5. It's going to create a JSON file called Replication_Definition.json under Replicate/data/imports , please backup this file by renaming it
6. Edit it with notepad++ and empty the scheduler section, it should be like this:
   

   "scheduler": {
   
   },

7. Save it and make sure it's called Replication_Definition.json
8. Import repository by running under Replicate /bin folder:
   

   repctl importrepository json_file=Replication_Definition.json

   
   If you have a custom location of the data folder, make sure you specify it by adding the flag -d before the json_file.
9. Recreate the scheduled jobs
10. Test the schedule

With Qlik Application Automation, you can get data out of Qlik Cloud and distributing it to different users in formatted Excel. The workflow can be automated by leveraging the connectors for Office 365, specifically Microsoft SharePoint and Microsoft Excel. 

Here I share two example Qlik Application Automation workspaces that you can use and modify to suit your requirements. 

Content:

• Considerations
• Example 1: Scheduled Reports
• Example 2: On-Demand Reports
• Environment

Video:

Considerations

• This example is built on distributing a SharePoint link. It is also possible to use attachments with the Mail block (see Creating a Qlik Reporting Service report).
• Qlik Application Automation has a limit of 100,000 rows when getting data out of a Qlik Sense straight table object.
• The On-Demand example uses an extension in QSE SaaS to send data to the Automation. An update to the Qlik Sense Button object is expected soon, which will provide a native way to pass selections to an Automation.

Example 1: Scheduled Reports

1. Download the 'Scheduled Report.json' file attached to this document.
2. Create a new Automation in QSE SaaS, give it a name, and then upload the workspace you just downloaded by right clicking in the editor canvas, and selecting 'Upload workspace'.
3. Select the 'Create Binary File (Personal One Drive)' block, select 'Connection' in the block configurator to the right, and then create your connection to Microsoft SharePoint.
4. Select the 'Get Straight Table Data' block. Under 'Inputs' in the block configurator, lookup your the App Id, Sheet Id, and Object Id for the relevant QSE SaaS table you wish to output.
5. Select the 'Create Excel Table With Headers' block, select 'Connection' in the block configurator, and then create your connection to Microsoft Excel.
6. Select the 'Send Mail' block. Under 'Inputs' in the block configurator update the 'To' to reflect the addresses you wish to deliver to.
7. With the 'Send Mail' block still selected, select 'Connection' in the block configurator and add your Sender details.
8. To test, Save and then Run the Automation
9. If you receive any warnings or errors, navigate to the relevant blocks and ensure your Connection is selected in the block configurator. 
10. Select the 'Start' block. Under 'Inputs' in the block configurator, change Run Mode to Scheduled and define your required schedule. 

Example 2: On-Demand Reports

Note - These instructions assume you have already created connections as required in Example 1.

1. Download the 'On-Demand Report v3.json' file attached to this document.
2. Download and install the 'qlik-blends' extension. See: 
   https://github.com/rileymd88/qlik-blends/files/6378232/qlik-blends.zip
3. Create a new Automation in QSE SaaS, give it a name, and then upload the workspace you just downloaded by right-clicking in the editor canvas, and selecting 'Upload workspace'.
4. Ensure your Connections are selected in the block configurator for each of the following blocks, 'Create Binary File (Personal One Drive)', 'Create Excel Table With Headers', 'Add Rows To Excel Worksheet Table (Batch)', 'Create Sharing Link', and 'Send Mail'.  Save the Automation.
5. Select the 'Start' block and ensure Run Mode is set to Triggered. Make note of the of URL and Execution Token shown in the POST example. 
6. Open your chosen QSE SaaS application, and Edit the Sheet where you wish to add a Button to trigger an On-Demand report. 
7. Under 'Custom Objects' look for 'qlik-blends' from the Extensions menu and drag this into your Sheet.
8. Under the 'Blend' properties to the right, add-in your POST webhook URL and Token as noted in Step 5.
9. We will now add three measures to the 'qlik-blends' object. It is important you add them in the order described.  Add the first measure, using the following function in the expression editor: GetCurrentSelections()
10. Add the second measure, using the following function DocumentName()
11. The final measure will be the Object ID of the table you wish to use. To find the Object ID, select 'Done Editing'.  Then right click on the table, select 'Share', select 'Embed', then look for the Object ID under the preview. Copy this value, go back into Editing mode and paste this as your third measure value. 
12. With the 'qlik-blends' object selected, under Form select 'Add items'. For 'Item type' select Text. Under default value you can choose to add a default email address. For 'Label' and 'Reference'  type 'Email'. It is critical that Reference is updated to 'Email'.  Turn 'Required input' on. 
13. You can change the Appearance properties to suit your preferences, such as updating the Button label and message, enabling Dialog, and changing the Color under Theme.
14. Back in the Automation, under the Start Block. Set  'Run asynchronously' = yes to allow multiple requests to run at the same time (This will also increase the max run time from 1min to 60min)
15. Once happy, test the On-Demand report by entering an email and clicking the button.

This On-Demand Report Automation can be used across multiple apps and tables.  Simply copy the extension object between apps & sheets, and update the Object ID (Measure 3) for each instance. 

Environment

• Qlik Application Automation 
• Qlik Cloud 
• Microsoft Office 365

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

Starting at Qlik Sense Enterprise on Windows May 2021, the bundled PostgreSQL has been upgraded to version 12.5.

However, PostgreSQL 12.5 will only be deployed during a fresh installation of Qlik Sense Enterprise on Windows May 2021. This means that, if you are upgrading to Qlik Sense Enterprise on Windows May 2021, PostgreSQL will remain on 9.6.

For many organizations, running on the latest supported PostgreSQL version is a security requirement. To achieve this:

• Move Qlik Sense database to standalone PostgresSQL database in which case you will have control of which PostgreSQL version is deployed as long as it is supported by the system requirements
• Continue to use the bundled PostgreSQL with version 12.5 (see the process below)

Content:

• Step 1: Upgrading your Qlik Sense site
• Step 2: Backing up your Qlik Sense site
• Step 3: Uninstall Qlik Sense on the central node
• Step 4: Install Qlik Sense Enterprise on Windows May 2021 on the central node
• Step 5: Restoring your Qlik Sense site

The information in this article is provided as-is and to be used at your own discretion. Depending on the tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

This process requires a full reinstallation of the product. Despite the fact that a backup is being taken as part of the process, it is highly recommended to have a second backup plan in place such as a Virtual Machine snapshot and/or a Server Backup.

It is highly recommended to test this process in a test environment to get familiar with it.

Step 1: Upgrading your Qlik Sense site

The first step is to upgrade your environment to Qlik Sense Enterprise on Windows May 2021 following the steps and recommendations provided on this link.

Once the upgrade is done make sure your Qlik Sense site is completely operational.

Step 2: Backing up your Qlik Sense site

At this point, you have an operational Qlik Sense site running on Qlik Sense Enterprise on Windows May 2021, however, the bundled PostgreSQL is still on version 9.6.

The next step will be to backup your entire Qlik Sense site following these instructions (including the certificates) . The backup is essential as it will need to be restored later on.

Step 3: Uninstall Qlik Sense on the central node

You will now need to uninstall Qlik Sense from the central node following these instructions.

During the uninstall:

• Have all rim nodes stopped.
• Don't check the box Remove Qlik Sense demo apps, certificates, and data folders.
• After uninstall and before reinstall rename C:\programdata\qlik to C:\programdata\qlik.old and rename C:\program files\qlik to C:\program files\qlik.old (if you changed it on another drive adjust accordingly)

Step 4: Install Qlik Sense Enterprise on Windows May 2021 on the central node

Now that Qlik Sense Enterprise on Windows May 2021 is uninstalled on the central node, you will reinstall it as a result will deploy a bundled PostgreSQL 12.5. Instructions available here.

• select the same host name and database settings as before
• The file share can point at a temporary one since you will take the original one again after restoring the QSR database in step 5.

Do not check the box Start theQlik Senseservices when the setup is complete at the end of the installer.

Step 5: Restoring your Qlik Sense site

You now have a clean Qlik Sense Enterprise on Windows May 2021 deployed on your central node with PostgreSQL 12.5. You now need to restore your environment to retrieve all your configurations and apps.

Please follow the Restoring a Qlik Sense site (including the certificates).

Note: While restoring the database backup you will most likely receive the following error which can be ignored. This error is caused by the version discrepancies between the pg_dump that made the dump file and the pg_restore that's restoring it - in example files coming from PostgreSQL version 9.6 vs files coming from PostgreSQL version 12.5. QSR backup taken and restored with the same version of PostgreSQL will not produce that error.

pg_restore: while PROCESSING TOC:
pg_restore: from TOC entry 3; 2615 2200 SCHEMA public postgres
pg_restore: error: could not execute query: ERROR: schema "public" already exists
Command was: CREATE SCHEMA public;

pg_restore: warning: errors ignored on restore: 1

Once the environment is restored, you should be able to start your central node and rim nodes successfully.

Environment

Qlik Sense Enterprise on Windows May 2021 and later

Environment

• Qlik Sense Enterprise SaaS
• Qlik Application Automation

This article shows how to generate a report from a Qlik Sense app, upload the report to any cloud storage platform, create a sharing link, and send out an email with the link in the body. 

We can send the report as an attachment using the Send Mail block in the Mail connector, but this block only supports attachments of size 40MB. An alternative solution is to store reports in any of the cloud storage platforms that support the creation of sharing links and send emails with the links.

I will go through a few examples to show how this can be achieved using the following cloud storage connectors:

1. Dropbox
2. Microsoft OneDrive
3. Microsoft SharePoint
4. Amazon S3

I will not go through the steps on how to generate the report using Qlik Reporting blocks as it's already explained in this article.

The four automation files used in the examples are attached to this article. More information on importing automations can be found here.

Dropbox

The following steps explain how to create a public URL using the Dropbox connector.

1. Store the generated report on Dropbox using the "Copy File on Dropbox" block. Configure it to use the output from the "Generate Report" block as the Source File and set the Destination connector to Dropbox. Include the Path from the output of the "Generate Report" block in the Destination Path parameter to use the generated filename.
   
   
   
   
2. Add the "Create Sharing Link" block from the Dropbox connector to the automation and configure it to use the path of the file from the output of the "Copy File on Dropbox" block in the Path parameter.
   
   
   
   
3. Add the "Send Mail" block from Microsoft Outlook 365 connector to the automation. Configure the Content Body parameter to use the public URL generated in the step above.
   
   
   
   

Microsoft OneDrive

The following steps explain how to create a public URL using the Microsoft OneDrive connector.

1. Store the generated report on Microsoft OneDrive using the "Copy File on Microsoft OneDrive" block. Configure it to use the output from the "Generate Report" block as the Source File and set the Destination connector to Microsoft OneDrive. Include the Path from the output of the "Generate Report" block in the Destination Path parameter to use the generated filename.
   
   
   
   
2. Add the "Get Item By Path" block from the Microsoft OneDrive connector to the automation. Configure it to use the file path from the output of the "Generate Report" block in the File Path parameter to use the generated filename.
   
   
   
   
3. Add the "Create Sharing Link" block from the Microsoft OneDrive connector to the automation. Configure it to use the ID of the file from the output of the "Get Item By Path" block in the Item Id parameter.
   
   
   
   
4. Add the "Send Mail" block from Microsoft Outlook 365 connector to the automation. Configure the Content Body parameter to use the public URL generated in the step above.
   
   
   
   

Microsoft SharePoint

The following steps explain how to create a public URL using the Microsoft SharePoint connector.

1. Store the generated report on Microsoft SharePoint using the "Copy File on Microsoft SharePoint" block. Configure it to use the output from the "Generate Report" block as the Source File and set the Destination connector to Microsoft SharePoint. Include the Path from the output of the "Generate Report" block in the Destination Path parameter to use the generated filename. Use the do lookup functionality to find a Drive Id or a Site Id,  but do not specify both.
   
   
   
   
2. Add the "List Items On Drive By Site" or "List Items On Drive" block from the Microsoft SharePoint connector to the automation to get all the items on a drive/site. Use the do lookup functionality to find a Drive Id or a Site Id.
   
   
   
   
3. Add a "Filter List" block to retrieve the generated report stored in SharePoint based on the report name. Note that the report name is equivalent to the Path obtained from the output of the "Generate Report" block. Set the condition as shown in the screenshot below.
   
   
   
   
4. Add the "Create Sharing Link" block from the Microsoft SharePoint connector to the automation. Configure it to use Drive Id and Id from the output of the "Filter List" block in the Drive Id and Item Id parameter. Set the Scope parameter value to anonymous to provide access to the sharing link to anyone (including individuals outside your organization) without needing to sign in. Keep in mind that this won't work if the anonymous support is disabled by the SharePoint admin. More info about enabling the external sharing option can be found here. Also, configure the Expiration Date Time Parameter which indicates the expiration time of permission.
   
   
   
   
5. Add the "Send Mail" block from Microsoft Outlook 365 connector to the automation. Configure the Content Body parameter to use the public URL generated in the step above.
   
   
   
   

Amazon S3

The following steps explain how to create a public URL using the Amazon S3 connector.

1. Store the generated report on Amazon S3 using the "Copy File on Amazon S3" block. Configure it to use the output from the "Generate Report" block as the Source File and set the Destination connector to Amazon S3. Include the Path from the output of the "Generate Report" block in the Destination Path parameter to use the generated filename. Also, configure Region and Bucket parameters.
   
   
   
   
2. Add the "Create Presigned Object URL" block from the Amazon S3 connector to the automation and configure it to use the path of the file from the output of the "Copy File on Amazon S3" block in the Key parameter. Also, configure Region, Bucket, and Expiration parameters.
   
   
   
   
3. Add the "Send Mail" block from Microsoft Outlook 365 connector to the automation. Configure the Content Body parameter to use the public URL generated in the step above.
   
   
   
   

Related Content

• Qlik Reporting
• Multi app reports
• Microsoft Outlook 365 Connector

Can Qlik Replicate be integrated into a third-party monitoring tool, such as APM Agent?

Resolution

Qlik Replicate can be monitored using the Qlik Enterprise Manager API, but cannot be directly integrated into (for example) APM Agent for monitoring purposes.

For information on the Qlik Enterprise Manager APIs, see Qlik Enterprise Manager API guide . 

Environment

Qlik Replicate 

The below error is logged in the QlikView Server Event logs:

Error    System: file system LastWriteTimeException: Last write time for \ failed: LastWriteTimeException \ failed: boost::filesystem::last_write_time: The system cannot find the file specified: "\\servername\USA\QLIKVIEW\EXT\Document\zoomToFit\Definition.xml ": no such file or directory    550365d6-ae70-44a2-9ea8-aace5b5b8d38

For information on QlikView logs, see QlikView Services and Log Guide 

Environment

• QlikView 12.50

Resolution

Check the extension name (in red above) to make sure it is installed properly .

You can set the audit trail retention size and age using the CLI in Qlik Enterprise Manager.

The command: aemctl.exe audit_trail control [--age hours] [--size megabyte]

 See Setting the audit trail retention size and age for details.

Previous documentation versions of Qlik Enterprise Manager may refer to an incorrect syntax. Always use the most recent guide.

Scenario:

• An MSSQL to Snowflake via Logstream task
• Apply changes and store changes are both enabled
• Store before and after on update settings are used

Records are missing from the __CT table.

Resolution

An enhancement was introduced in Qlik Replicate (version 2022.11), adding a feature which forces Qlik Replicate always to write the change table entry. 

Enable the feature in the task settings:

1. Open the task settings
2. Click More Options
3. Add the following feature flag: writeEqualBeforeAndAfterImagesToChangeTable
4. Set it to On
   
   

Environment

Qlik Replicate 

Apply latency increases in a task. The target endpoint Snowflake Azure has a custom policy defined meant to mask/hide values for certain fields in the target. LOB support in the task is disabled. 

The following is logged:

00005856: 2023-04-02T00:08:37 [TARGET_APPLY ]I: Column 'Field_Name' is unsupported in table def 'table_XX' since the LOB support is disabled (metadatamanager.c:2632)

Resolution

The target table has a masking policy defined. This policy is not applied by Qlik Replicate.

Example: Field_Name VARCHAR(30) NOT NULL WITH MASKING POLICY #unknown_policy,

If there is masking policy in the target table, Qlik Replicate will consider it as a LOB column. Therefore, when LOB is support is disabled, we see the mentioned warning.

Field_Name is part of the Primary key. To prepare any update statement the PK columns, values are needed. Without them, Qlik Replicate cannot prepare the update statements.

If Qlik Replicate creates the table without a masking policy in the target table, then disabling LOB support will not impact this table to replicate all columns.

Environment

Qlik Replicate 

A Qlik Replicate task has stopped due to a Connection error at Kafka Target endpoint:

00003824: 2023-04-13T08:24:16 [TARGET_APPLY ]E: Failed to get Kafka metadata: Local: Broker transport failure. _TRANSPORT [1020401] (kafka_client.c:432)
00003824: 2023-04-13T08:24:16 [TASK_MANAGER ]E: Failed while preparing stream component 'st_0_INT_Bootstrap_Kafka_Target'. [1020401] (subtask.c:853)
00003824: 2023-04-13T08:24:16 [TASK_MANAGER ]E: Cannot initialize subtask [1020401] (subtask.c:1297)
00003824: 2023-04-13T08:24:16 [TARGET_APPLY ]E: Stream component 'st_0_INT_Bootstrap_Kafka_Target' terminated [1020401] (subtask.c:1565)
00003824: 2023-04-13T08:24:16 [TARGET_APPLY ]E: RDKAFKA - 3 - ERROR: [thrd:app]: QlikReplicate/2022.11/kafka#producer-1: sasl_ssl://URL:1921: error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed: broker certificate could not be verified, verify that ssl.ca.location is correctly configured or root CA certificates are installed (add broker's CA certificate to the Windows Root certificate store) (after 82ms in state CONNECT) [1022601] (kafka_client.c:236)
00003824: 2023-04-13T08:24:16 [TARGET_APPLY ]E: RDKAFKA - 3 - ERROR: [thrd:app]: QlikReplicate/2022.11/kafka#producer-1: sasl_ssl://URL:9093/bootstrap: SSL handshake failed: ssl\statem\statem_clnt.c:1921: error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed: broker certificate could not be verified, verify that ssl.ca.location is correctly configured or root CA certificates are installed (add broker's CA certificate to the Windows Root certificate store)

Resolution

Add broker's CA certificate to the Windows Root certificate store. Once this is done, put the cert file on the Qlik Replicate installation server and refer to the .pem at the CA path field.

After updating the EP settings with the above-mentioned, restart the task or stop and resume so the changes will take effect. First, test the connection using the test connection button.

Environment

Qlik Replicate 

When trying to use Qlik Data Transfer for the first time after a correct installation, you might have the below white screen:

Having a white screen basically means one of the Qlik DataTransfer micro service is not started and/or not working. This can be checked in the Windows Event Application (Source: Qlik Sense Service Dispatcher) or in the Qlik DataTransfer logs (C:\ProgramData\Qlik\DataTransfer\Log).

In the \DataUploadService logs you will see this error message:

localhost 6.0.0 Global INFO Responding certificates after reading it from defined location.
localhost 6.0.0 Global ERROR Unable to unlock the ReloadService, cannot continue.
localhost 6.0.0 Global ERROR Exception: Error: Unable to unlock the reload service.

Resolution

This error message is happening directly after the step of reading certificate:

INFO Responding certificates after reading it from defined location.

Verify the certificate:

Verify what certificates you have listed in the MMC console.

1. Are no certificates listed?
   
   
   
   

2. A group policy or other system security settings may have prevented certificates from being installed. Follow the Reset certificates steps found in the second half of the article after lifting potential restrictions on the account or machine which previously prevented the certificates from being installed. 

3. If you see some Qlik DataTransfer duplicate certificates (fig 1), duplicates must be deleted.
   
   fig 1
   
   
4. Delete the two duplicates (which have no Friendly Name listed. 
5. Restart the Qlik DataTransfer service.

Are other Qlik Products installed on the same server?

Installing Qlik Sense Enterprise on Windows (Desktop or otherwise) will also lead to compatibility issues, including certificate mismatches.

1. If the other product was previously uninstalled, the certificate may still be present.
2. Verify in the MMC console and navigate to Certificates (Local Computer) --> Personal -- Certificates to see if another QlikClient certificate is installed.
3. Remove it.
4. Then follow the Reset Certificates steps found below.

Are you using a Proxy?

A proxy system variable may be set in Windows. Example: https_proxy=http://PROXY:80 

Qlik Data Transfer does not support the use of a proxy. Delete the Windows variable.

Reset Certificates 

If only Qlik DataTransfer is installed on the machine, do the following:

1. In Windows Services, stop the Qlik DataTransfer service.

2. Navigate to C:\ProgramData\Qlik\DataTransfer\DataUpload\certificate and delete the certificates there.
   
   

3. Navigate to C:\Program Files\Qlik\DataTransfer\DataUploadService\install-utils.

4. Run Remove-Certificate.ps1 in PowerShell.

5. Delete the following folder: C:\ProgramData\Qlik\DataTransfer\DataUpload\certificate
   

6. Start the Qlik DataTransfer service.

7. Navigate to C:\ProgramData\Qlik\DataTransfer\DataUpload\certificate and confirm the following files are present:

   • client.pfx

   • server.pfx

If Qlik DataTransfer and Qlik Sense Enterprise on Windows are installed on the machine, do the following:

1. In Windows, Services, stop the Qlik DataTransfer service.

2. Navigate to C:\ProgramData\Qlik\DataTransfer\DataUpload\certificate and delete the certificates in the folder.
   
   

3. In the Windows Certificate Store, delete the following certificates:

   • Local Computer > Personal > QdtClient

   • Local Computer > Trusted Root Certification Authority > <hostname.domain> or <hostname>

   • Current user > Personal > QdtClient

   Alternatively, you can run Remove-Certificate.ps1 in PowerShell as the administrator.
   
   

4. Run Configure-Service.ps1 in PowerShell as the Qlik Sense services user.

   1. For the first input dataTransferCertificatePath, enter C:\ProgramData\Qlik\DataTransfer\DataUpload\certificate.

   2. For the second input qsefwPresent, enter Yes.

5. Navigate to C:\ProgramData\Qlik\DataTransfer\DataUpload\certificate and confirm the following files are present:

   • root.pfx

   • client.pfx

   • server.pfx

6. Restart the Qlik DataTransfer service.

Related Content 

Installing and Using Qlik DataTransfer  
Troubleshooting Qlik DataTransfer 

Environment

Qlik Data Transfer any release