Trying to access Qlik Sense Hub or Management Console (QMC) leads to the getting "refused to connect" on the web browser.

Investigating the issue with the command netstat | findstr :443 confirms there is not service listening on port 443 (or port QMC/Hub proxy is set to listen on).

Case 1:

An inspection of the System_Repository log located in C:\ProgramData\Qlik\Sense\Log\Repository\Trace shows an error message relating to being unable to remove soft deleted records. Sample:

Case 2:

The Repository Service to update fails on a table that iolates foreign key constraint.

• Qlik Sense Enterprise on Windows 

 

Cause:

In November 2017, February 2018, April 2018 and June 2018, when the Qlik Sense Repository Service initializes, it attempts to clean up the underlying Repository Database. If there are records which have broken referential integrity then the Repository Service will fail to initialize. This is a consequence of a change in behavior in November 2017/February 2018 where the Repository no longer does soft deletes.

This script can be obtained from the official Qlik site: Failed to remove soft deleted records. 
If logged on to our support site, it can be directly downloaded from the attachment. The attachment is unavailable for anonymous users. 

 

Resolution:

This article uses the recursive (recurse) cleanup sql script. After upgrading to Qlik Sense November 2017 or February 2018, the administrator is unable to access the Hub and/or QMC.

This article also fixes database issues and soft deletes, which cause numerous other problems besides being unable to access the QMC or HUB after an upgrade. This script is necessary to be run if upgrading from an older version to 11.14.3 or newer.
 

1. Stop all services but the Qlik Sense Repository Database
   • If using a stand-alone PostgreSQL server to host Qlik Sense content, then stop all Qlik Sense Services
2. Take a backup of the Qlik Sense Repository Database
   • Sample command using cmd.exe: cd / & mkdir QSR & "C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6\bin\pg_dump.exe" -h localhost -p 4432 -U postgres -b -F t -f "c:\QSR\QSR_backup_%date:~-4,4%%date:~-10,2%%date:~-7,2%.tar" QSR
     • This assumes that:
       • Qlik Sense is installed to C:\Program Files
       • That the site is not using a stand-alone PostgreSQL server
         • Make any necessary adjustments if neither of those assumptions are true
3. Download the attached .sql file and place it into the same directory as pg_dump.exe
4. Run the following command in cmd.exe (run them one at a time and hit Enter then continue with the next one):
   • cd C:\"Program Files"\Qlik\Sense\Repository\PostgreSQL\9.6\bin
   • SET PGCLIENTENCODING=utf-8
   • chcp 65001
   • psql.exe -h localhost -p 4432 -U postgres -d QSR -e -f recurse_cleanup.sql
     • Note: If Qlik Sense is installed to a non-default directory then make the necessary adjustments
5. Start all Qlik Sense Services
6. Validate that the error about Failed to remove soft deleted records is not present in the System_Repository log
7. If this does not resolve the issue then do contact Qlik Support for a more customized query

Show Less

NPrinting has a library of APIs that can be used to customize many native NPrinting functions outside the NPrinting Web Console.

 

Environment:

Qlik NPrinting 

 

An example of two of the more common capabilities available via NPrinting APIs are as follows

• Connection reloads
• Publish Task executions

These and many other public NPrinting APIs can be found here: Qlik NPrinting API

In the Qlik Sense data load editor of your Qlik Sense app, two REST connections are required (These two REST Connectors must also be configured in the QlikView Desktop application>load where the API's are used. See Nprinting Rest API Connection through QlikView desktop)

• GET
• POST

 

Requirements of REST user account:

• Windows Authentication is required in both these connectors. The required user account is the NPrinting service account (which is also ROOTADMIN on the Qlik Sense server)
• This user account must also be a member of the NPrinting 'Administrators' Security Role on the NPrinting Server.

 

Creating REST "GET" connections

Note: Replace QlikServer3.domain.local with the name and port of your NPrinting Server

NOTE: replace domain\administrator with the domain and user name of your NPrinting service user account

 

Creating REST "POST" connections

Note: Replace QlikServer3.domain.local with the name and port of your NPrinting Server

NOTE: replace domain\administrator with the domain and user name of your NPrinting service user account

Ensure to enter the 'Name' Origin and 'Value' of the Qlik Sense (or QlikView) server address in your POST REST connection only.

Replace https://qlikserver1.domain.local with your Qlik sense (or QlikView) server address.

Ensure that the 'Origin' Qlik Sense or QlikView server is added as a 'Trusted Origin' on the NPrinting Server computer

 

Related Content

• Distribute NPrinting reports after reloading a Qlik App
• Extending Qlik NPrinting
• Run a Qlik NPrinting API POST command via QlikView reload script
• Troubleshooting Common NPrinting API Errors

 

NOTE: The information in this article is provided as-is and to be used at own discretion. NPrinting API usage requires developer expertise and usage therein is significant customization outside the turnkey NPrinting Web Console functionality. Depending on tool(s) used, customization(s), and/or other factors ongoing, support on the solution below may not be provided by Qlik Support.

 

Show Less

In this article, we detail the 12 steps necessary to successfully configure Qlik Sense Enterprise on Windows after an Active Directory Domain name change or moving Qlik Sense to a new domain.

Depending on how you have configured your platform, not all the steps might be applicable. Before updating any hostname in Qlik Sense, make sure that the original value is using the old domain name. In some case, you may have configured “localhost” or the server name without any reference to the domain so there is no need in these cases to perform any update.

Environment

• Qlik Sense Enterprise on Windows 

Scenario

In this scenario we are updating a three-node environment running Qlik Sense February 2021:

The domain has been changed from DOMAIN.local to DOMAIN2.local

The servers mentioned below are already part of the new domain name DOMAIN2.local and their Fully Qualified Domain Name (FQDN) is already updated as followed:

• QlikServer1.domain.local to QlikServer1.domain2.local: Central node
• QlikServer2.domain.local to QlikServer2.domain2.local: Rim node
• QlikServer3.domain.local to QlikServer3.domain2.local:  Dedicated Postgres and hosting the Qlik shared folder

All Qlik Sense services have been stopped on every node.

Step 1: Update the Postgres Configuration File

The first step is to update the postgres.conf file to listen on the correct hostname

1. Open the postgres.conf (make sure to make a copy) under
   • C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\<version> (for an environment running the native Qlik Sense Repository Database)
   • C:\Program Files\PostgreSQL\<version>\data (for an environment running a dedicated PostgreSQL database)
2. Search for the parameter listen_addresses and update the hostname value if required
   
   
   
   
3. Save the file, close it and start the Qlik Sense Repository Database or PosgresSQL service depending if you are using the native PostgreSQL or a dedicated instance

 

Step 2: Backup your Qlik Sense site

Before doing any further changes, it is important to take a backup of your Qlik Sense Platform

• Backing up a Qlik Sense site

Step 3: Rename Server Node in QSR database

Now we update the node names in the database with the new Fully Qualified Domain Name.

1. Connect to the Qlik Sense Database using Installing and Configuring PGAdmin4 to access the PostgreSQL
2. Open the QSR Database and navigate through Schemas -> public ->Tables
3. Right-click on ServerNodeConfiguration -> View/Edit Data -> All Rows
4. Modify the hostname of each node if required
   
   
   
   
5. Save by clicking on the below icon available in the toolbar
   
   
   
   
6. Close PGAdmin

Step 4: Rename User Directory for existing users

1. Connect to the Qlik Sense Database using Installing and Configuring PGAdmin4 to access the PostgreSQL
2. Right-click on the QSR Database and select “Query Tool”
3. Run the following query
   

   UPDATE public."Users"
   SET "UserDirectory" = 'DOMAIN2'
   WHERE "UserDirectory" = 'DOMAIN';​

4. Validate the change by running the following query
   

   SELECT * FROM public."Users"​

   
   The User Directory should be updated to the new domain:
   
   
   
   
5. Close PGAdmin

Step 5: Update Service Cluster configuration

1. On the central node run the program C:\Program Files\Qlik\Sense\Repository\Util\QlikSenseUtil\QlikSenseUtil.exe and Connect to Database
   
   
   
   
2. Once connected, click on Service cluster and then OK
3. Update the FQDN with the new domain if required and press Save
   
   
   
   
4. Close QlikSenseUtil.exe

Step 6: Update the repository Connection Strings

1. On the central node run the program C:\Program Files\Qlik\Sense\Repository\Util\QlikSenseUtil\QlikSenseUtil.exe
2. Select Connection String Editor and click on Read
3. Update the FQDN with the new domain if required and press Save Value in config file encrypted
   
   
   
   
4. Close QlikSenseUtil.exe
5. Repeat the above steps on every rim node

Step 7: Update the dispatcher services connection strings

Verify if a hostname update is required

1. On the central node, open File Explorer and navigate to C:\Program Files\Qlik\Sense\Licenses and open the appsetting.json
2. Check if the parameter host contains the old domain name. If it does then you need to follow the below steps to update it otherwise you can jump to the next section

Update hostname on all Qlik Sense Dispatcher subservices

1. Search for the file called Configure-Service.ps1
   
   In Qlik Sense February, there are 8 of these files placed in different Qlik Sense Dispatcher sub-services. We need to run each of these files with a specific argument. In the previous or later version of Qlik Sense, the list presented below may need to be adapted.
   
   
2. Run the following command in PowerShell ISE as Administrator
   

   cd "C:\Program Files\Qlik\Sense\NLAppSearch\install"
   .\Configure-Service.ps1 QlikServer3.domain2.local 4432 qliksenserepository <qliksenserepository_password>
   
   cd "C:\Program Files\Qlik\Sense\AppDistributionService"
   .\Configure-Service.ps1 QlikServer3.domain2.local 4432 qliksenserepository <qliksenserepository_password>
   
   cd "C:\Program Files\Qlik\Sense\HybridDeploymentService"
   .\Configure-Service.ps1 QlikServer3.domain2.local 4432 qliksenserepository <qliksenserepository_password>
   
   cd "C:\Program Files\Qlik\Sense\Licenses"
   .\Configure-Service.ps1 QlikServer3.domain2.local 4432 qliksenserepository <qliksenserepository_password>
   
   cd "C:\Program Files\Qlik\Sense\NotifierService\install"
   .\Configure-Service.ps1 QlikServer3.domain2.local 4432 qliksenserepository <qliksenserepository_password>
   
   cd "C:\Program Files\Qlik\Sense\MobilityRegistrarService\install"
   .\Configure-Service.ps1 QlikServer3.domain2.local 4432 qliksenserepository <qliksenserepository_password>
   
   cd "C:\Program Files\Qlik\Sense\PrecedentsService\install"
   .\Configure-Service.ps1 QlikServer3.domain2.local 4432 qliksenserepository <qliksenserepository_password>
   
   cd "C:\Program Files\Qlik\Sense\DataPrepService\install"
   .\Configure-Service.ps1 QlikServer3.domain2.local 4432 qliksenserepository <qliksenserepository_password>

3. Repeat the above steps on every node (Including the verification)

Step 8: Update the Qlik Logging Service

If you are using the Qlik Logging Service;

1. Run the following command in Command Prompt:
   

   cd "C:\Program Files\Qlik\Sense\Logging"
   Qlik.Logging.Service.exe validate​

2. If you get something like:
   
   Failed to validate logging database. Database does not exist or is an invalid version.
   
   Then it probably means that the hostname needs to be updated
   
   
3. If so, run the following command in Command Prompt:
   

   cd "C:\Program Files\Qlik\Sense\Logging"
   Qlik.Logging.Service.exe update -h QlikServer3.domain2.local​

4. Once done, run the validate command again to verify that the connectivity is working
   
   
   
   
5. Repeat the above steps on every rim node

Step 9: Update the service account running the Qlik Sense services

1. On the central node, open the Windows Service Console an update each Qlik Sense services with the new domain (DO NOT START THE SERVICE AT THIS POINT)
   
   
   
   
2. Repeat the above step on every rim node

Step 10: Update the host.cfg and remove the certificate

1. On the central node login as the service account
2. Backup the Qlik Sense certificate following Backing up certificates
3. Remove the certificate you have previous backed up from the MMC
4. Make a copy of %ProgramData%\Qlik\Sense\Host.cfg and rename the copy to Host.cfg.old
   • Host.cfg contains the hostname encoded in base64. You can generate this string for the new hostname using a site such as https://www.base64encode.org/ (You may want to decode the original string to see if it contains the old domain name.
5. Open Host.cfg and replace the content with the new encoded hostname.
6. Run Windows Command Prompt as Administrator and execute the following command:
   

   "C:\Program Files\Qlik\Sense\Repository\Repository.exe" -bootstrap -iscentral -restorehostname​

7. In parallel start the Qlik Sense Dispatcher services
8. When the command has completed successfully you should see the following message in command prompt:
   
   Bootstrap mode has terminated. Press ENTER to exit..
   
   
9. Start every Qlik Sense services on the central node and try to access the QMC with https://localhost/qmc

Step 11: Distribute the certificate on the rim node(s)

1. On the rim node(s) login as the service account
2. Backup the Qlik Sense certificate following Backing up certificates
3. Remove the certificate you have previous backed up from the MMC
4. Start the Qlik Sense services
5. On the central node, open the QMC and go to Nodes
6. After a few minutes the rim node should have the status The certificates has not been installed
   
   
   
   
7. Click on Redistribute and follow the instructions to redistribute the certificates on the rim node(s)
8. After a few minutes, the services should be running
   
   

Step 12: Additional updates

User Directory Connector

If you are syncing your users with a User Directory Connector you will need to change the LDAP path to point to the new domain.

1. In the QMC -> User Directory Connector
2. Edit your existing User Directory Connector, check the LDAP Path and update if necessary
   
   

 

Monitoring Application

You will need to update the monitoring apps and their associated data connection to use the new Fully Qualified Domain Name

• Configuring the Monitoring apps

Data Connections password

• Part of the steps followed earlier, the certificates had to be recreated. As a result, the passwords for the existing data connection needs to be re-typed and saved for all Data Connections and User Directory Connectors that include password information.

Security Rules and Licenses rules

It is possible that you have created rules based on the User Directory. As you have changed the domain name, the user directory has also changed in Qlik Sense so you will need to update those to reflect that. 

 

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.

Show Less

This article will outline how to successfully change the service account running Qlik Sense. 

 

Contents:

• Account Requirements: What the account needs access to.
• Prep work
• Changing Qlik Sense dependencies
• Change the service account
• External Dependencies
• Video Demonstration
• Related Content

 

Account Requirements: What the account needs access to.

1. Certificates
   • Access to the certificate(s) for the site
2. Files and file shares
   • Access to the installation path for Qlik Sense
   • Access to %ProgramData%
   • Access to C:\Program Files\Qlik
   • Access to the Service Cluster share
3. Access to external systems as data sources, e.g.
   • Databases
   • UNC shares to QVDs, CSVs, etc

Note: Many of the file level permissions would ordinarily be inherited from membership to the Local Administrators group. For information on non-Administrative accounts running Qlik Sense Services see Changing the user account type to run the Qlik Sense services on an existing site.

 

 

Prep work

Record the Share Path. Navigate in the Qlik Management Console (QMC) to Service Cluster and record the Root Folder.

Changing Qlik Sense dependencies

1. Stop all Qlik Sense services
2. Ensure permissions on the Program Files path (this should be provided by Local Administrator rights):
   1. Navigate to the installation path (default: C:\Program Files\Qlik)
   2. Select the Sense folder > Right Click > Properties > Security > Edit > Add
      1. Lookup the new service account
      2. Ensure that the account has Full control over this folder
3. Ensure permissions on the %ProgramData% path (this should be provided by Local Administrator rights):
   1. Navigate to the installation path (default: C:\ProgramData\Qlik)
   2. Select the Sense folder > Right Click > Properties > Security > Edit > Add
      1. Lookup the new service account
      2. Ensure that the account has Full control over this folder
4. Ensure access to the certificates used by Qlik Sense
   1. Start > MMC > File > Add/Remove Snap-In > Certificates > Computer Account > Finish
      1. Go into Certificates (Local Computer) > Personal > Certificates
      2. For the Qlik CA server certificate (under Certificates (Local Computer) > Personal > Certificates)
         • Right Click on the Server Certificate > All Tasks > Manage Private Keys > Ensure that the new service account has control
      3. If using a third party certificate, do the same
5. Ensure access to the Service Cluster path used by Qlik Sense
   1. Start > Computer Management > Shared Folders > Shares > Select the Share path
   2. Right click on the Share Path > Properties > Share Permissions > Add the new service account to have full control
   3. Open Windows File Explorer and navigate to the folder (e.g. C:\Share) > Right click on the folder > Security > Edit > Add the new service account to have full control
6. Ensure membership in the Local Groups that Qlik Sense requires:
   1. Start > Computer Management
   2. Navigate to Local Users and Groups > Local Groups
   3. Add the new service account as a member of:
      • Administrators (if using this configuration option)
      • Performance Monitor Users
      • Qlik Sense Service Users

 

Change the service account

1. Swap the account for all Qlik Services except the Qlik Sense Repository Database Service.
   1. Open the Windows Services Console
   2. Locate the services
   3. One by one open the Properties of the Service and change the accountover by using the Windows services control panel
2. Start all Qlik Sense Services
3. Access the QMC to validate functionality, preferably as a previously configured RootAdmin
4. Access the Data Connections section of the QMC
5. Toggle the User ID field and change the data connections used by the License and Operations Monitor apps to use the new user ID and password:
   
   
   
   
6. Add the RootAdmin role to the new service account*
   1. QMC > Users
   2. Filter on the new UserID > Edit
   3. Add RootAdmin role
      
      *If this account is not existing yet in Qlik Sense, you would need to try to connect to the Hub/QMC with this new account first, in order to be able to see it in QMC>Users.
      
      
7. Execute the License Monitor reload task
8. Inspect the configured User Directory Connectors and change the User ID and password combination if previously configured.

 

External Dependencies

1. Go into the QMC > Data Connections section and inspect all Folder data connections to determine all network shares that the service account needs access to. Either change them yourself or alert the necessary teams to provide both Share and NT level access to these shares.
2. Inspect all Data Connections and ensure that none use the old Service account and password. Follow up with necessary teams to provide access to data sources that used the old credentials.

 

Video Demonstration

 

 

Related Content

How to change the share path in Qlik Sense (Service Cluster) 

Show Less

This article provides the steps needed to successfully upgrade Qlik Replicate installed on a Windows Cluster.

Environment:

• Qlik Replicate 2021.5 upgrade to 2021.11
• Qlik Replicate upgrade 2021.11 to 2022.5 or 2022.11

 

Resolution

1. Stop all tasks. Note that some tasks could take up to 20 minutes or more to stop. Monitor the process before you continue.
2. Assuming we are on Active Node A: from the Cluster Manager, take the Attunity Replicate Server and Attunity Replicate UI server Offline
3. Take a backup of all your task definitions on Node A:Qlik Replicate Command Line Console as Administrator
4. Run:

   repctl -d "YOUR_DATA_DIRECTORY_PATH" exportrepository

   Example: ~Program Files\Attunity\Replicate\bin> repctl -d "S:\Programs\Qlik\Replicate\data" exportrepository
   This example writes the backup to the Replication_Definition.json file.
    
5. Back up your data directory by copying it to a folder location outside the Qlik Replicate directories. You can skip copying the \logs subfolder.
6. On Node A: verify the installed version of Attunity Replicate. This can be done by reviewing the program installed through the Windows Add/Remove programs feature. Note: attempting to “upgrade” with an identical version will lead to Attunity Replicate being uninstalled.
7. Verify what account the Attunity (or Qlik) Windows Services are run with. Note the account credentials (username and password). After the upgrade, the account may have been switched back to Local System and the account credentials will need to be entered again. 
8. On the active node: perform the upgrade by running a newer version of the Qlik Replicate executable.
   • Right-click on the executable and run as administrator.
   • Follow the on-screen instructions.
9. On Node A:
   • Verify that the Qlik Replicate Server and Qlik Replicate UI Server are stopped in the Cluster Manager
   • Verify that the Qlik Replicate Server and Qlik Replicate UI Server are stopped in the Windows Services 
10. Move the Cluster service (this is the role that manages your share drive/Qlik service/and client access point) to another node (Node B in our example). This is going to move the shared drive and service to the other node (Node B).
11. On Node B: run the same upgrade as previously done on Node A, repeating steps 8 to 9.
12. Repeat the upgrade steps on any additional nodes. 
13. Verify the account running the Attunity Replicate Services on all nodes, changing the account back to the account which was used before the upgrade (see step 7).
14. From the Windows Cluster, bring the Attunity Replicate Server and Attunity Replicate UI Server back online.
15. Resume the tasks. Note: resume tasks at a rate of five (maximum) at a time until all have been launched.

Show Less

Before you can start using Qlik Sense Desktop, you need to authenticate yourself against a Qlik Sense Enterprise server. You need to have a working network connection to enable authentication.

The following requirements need to be met:

• A functioning network connection to the Qlik Sense Enterprise Client-Managed Server or Enterprise SaaS/Business tenant.
• Use of a Professional license. Analyzer licenses do not support Desktop Authentication
  For legacy token license: User and Login Passes allow Desktop Authentication
• No TEST license. Test licenses disallow the use of authentication links 
• Compatibility must be met. See Qlik Sense Desktop patch process and compatibility with on-premise installs and Qlik Cloud .

After you have been authenticated once, internet access is not required to continue using Qlik Sense Desktop. However, you have to re-authenticate yourself if thirty days have passed since you last authenticated.

 

Environment

Qlik Sense Desktop 
Qlik Cloud 
Qlik Sense Enterprise on Windows 
Qlik Sense Business 

 

 

 

Related Content 

Starting Qlik Sense Desktop | Qlik Sense on Windows Help 
Starting Qlik Sense Desktop | Qlik Cloud Help
Configuring Qlik Sense Desktop authentication link 
How to authenticate Qlik Sense Desktop against SaaS editions 
How to authenticate Qlik Sense Desktop against a Qlik Sense Enterprise on Windows server  

 

 

Show Less

A published artifact fails to deploy on Talend ESB Runtime Server with the following error message:

org.apache.aries.blueprint.ComponentNameAlreadyInUseException: Name 'dataSourceReferenceList' is already in use by a registered component

 

Resolution

Republishing this artifact from Studio could resolve this issue.

 

Cause

This issue is caused by improper building. The Blueprint component registry does not allow duplicate component IDs.

This may happen if:

• The same bean or reference ID appears more than once in your blueprint XML files, possibly due to multiple bundles or duplicate blueprint definitions loaded together.
• A bundle is stopped and restarted without the registry being properly cleared, causing lingering definitions.
• Two bundles define a bean/reference with the same ID (e.g., dataSourceReferenceList).

 

Related Content 

How to publish jobs, Routes, and Data Services (artifacts)created in Talend Studio to Talend Cloud

 

Environment

• Talend ESB 
• Talend Studio 

Show Less

This article briefly introduces how to perform a clean-up to restore mistakenly deleted features for a damaged Remote Engine, without reinstalling and pairing the entire engine.

 

Before you begin

Your Remote Engine version must be v2.12.14 onwards.

 

How To

Solution 1: Graceful clean-up to repair a damaged Remote Engine

1. Stop the engine and please follow documentation about  running the graceful shutdown process of Remote Engine.
2. Remove the <RE_installation>/data/cache folder and restart the engine.
3. Alternatively, if your engine was installed using an archive delivery and used to be started by one of start-up scripts from <RE>/bin, such as start, karaf, trun, or run, please execute that script with the clean option to restart your engine. For example,

   ./trun clean

   The graceful cleanup process automatically identified the missing features required by a paired engine and re-install them.

 

Solution 2: Clean Remote Engine Cache

1. Stop remote engine

2. Delete the content in tmp folder <RE_installation>/data/tmp

3. Delete the content in cache <RE_installation>/data/cache

4. Restart remote engine

 

Related Content 

For more information about graceful cleanup remote engine, please refer to Help Documentation

graceful-cleanup-upon-engine-start-to-clean-up-and-repair-damanged-engine

 

Environment

Talend Cloud 

Show Less

This article provides a solution for the Qlik Replicate Endpoint server not starting as expected. Symptoms of this include:

• Endpoints are not listed in the Create new endpoint dialogue
• The message One or more Endpoint Servers cannot be reached is displayed
• The Endpoint Server appears in an "Error" state

About the Endpoint Server

The Endpoint Server is a Qlik Replicate JAVA subcomponent that will only start when an endpoint requiring it is enabled in the Qlik Replicate license. Most endpoints will not need it (as they are written in C). A list of those that do can be found in Endpoint Server | Supported Endpoints.

For more information about the Qlik Replicate Endpoint Server, see Endpoint Servers | help.qlik.com.

Symptoms

Sometimes, when enabling Qlik Replicate endpoints such as SAP, Salesforce, or MongoDB, either explicitly or by importing an all-open license, the Endpoint Server Component may not start up on a Linux Server.

One or more Endpoint Servers cannot be reached

When looking at Endpoint Servers in the Qlik Replicate UI and navigating to Server > Endpoints (A) > Endpoint Servers (B), you may see that it failed and might have even been registered on port 0 (C) : 

Endpoint not available at endpoint creation

The expected endpoint may not be available, even if it has been correctly enabled in the license. 

Resolution

1. Review the parameters with which the /tmp folder is mounted on the server:

   sh-4.4$ cat /proc/mounts | grep /tmp
   tmpfs /tmp tmpfs rw,nosuid,nodev,noexec,seclabel,size=32G,nr_inodes=1048576,mode=1777 0 0

2. Allocate a temporary folder in the Qlik Replicate file system and make sure it’s under the same owner as the rest of the product libraries. Generally, this will be the “attunity” user ID:

   sh-4.4$ mkdir /opt/attunity/tmp
   sh-4.4$ chown attunity:attunity /opt/attunity/tmp
   sh-4.4$ chmod 755 /opt/attunity/tmp

3. Take a backup of your current /opt/attunity/replicate/bin/site_arep_login.sh
4. Update the /opt/attunity/replicate/bin/site_arep_login.sh adding a line:

   export AT_JVM_OPT=-Djava.io.tmpdir=/opt/attunity/tmp

5. Stop the Qlik Replicate server
6. Load the new settings:

   sh-4.4$ cd /opt/attunity/replicate/bin
   sh-4.4$ source arep_ligin.sh

7. Start the Qlik Replicate server

If the endpoint enablement prerequisites have been fully fulfilled, you will now see the new endpoints in the endpoint list, and the endpoint server will appear active and assigned to a non-zero port on the server:

 

Cause 

This issue is typically caused by the default Linux /tmp file system being mounted with the noexec option, which prevents any executable (.so or .jar) from running from any sub-folder on this mount point.

 

Related Content 

Endpoint Servers

Endpoint Server Not Connecting on Linux based Qlik Replicate

 

Internal Investigation ID(s)

SUPPORT-4605 

 

Environment

• Qlik Replicate

Show Less

The Feature Manager within Studio 8 is used for applying patches and installing new features that may not have been installed, depending on the Monthly Patch that is applied at that moment. There may be 1 or 2 URL's within the Update Settings itself (Eclipse update system is based on a system named "p2", and one or two P2 URL can define the full update). .

Base URL: Original 8.0.1 content, which contains additional features and dependencies are not included in the default Studio instance (https://update.talend.com/Studio/8/base)

Update URL: Incremental updates which contain new/improved functionalities along with fixes (For example, https://update.talend.com/studio/8/updates/R2025-07v2/).

All Talend Studio Releases before R2024-05 must have the P2 Base URL, which is set by default to: https://update.talend.com/Studio/8/base

 

If the Studio instance(s) are in an air gapped environment, or a connection to above URLs (or in general) to our update site is not possible from where Studio is installed on, this article briefly introduces how users can work around these network issues in offline mode to update Talend Studio manually.

 

Offline or Manual Update Process

Updating older Studio 8.0.1 Patch releases to a target Patch Release prior to R2025-05

If the Studio instance(s) are in an air gapped environment, or a connection to above URLs (or in general) to our update site is not possible from where Studio is installed on, this article briefly introduces how users can work around these network issues in offline mode to update Talend Studio manually.

1. Download P2 repo archive
   The P2 Base can be obtained from either the TMC Downloads Page (within the "Continuous Integration (CI) for cloud" section) for cloud customers; For On-Prem Customers, at the bottom of the license email (Providing Download Links for the Modules), there is a section titled "Local update sites for installation without internet:". There is a link to download a zip file that includes the Full P2 Repository, which is called:
   

   Talend_Full_Studio_p2_repository-2021109_1610-V8.0.1.zip

2. To point the settings for the url to the archive file that is on the instance, please use the below format:
   

   jar:file:/<path to archive on disk>/Patch_20240621_R2024-03_v1-8.0.1.zip!/

   The extra / at the beginning and end as well as the !

    

Updating older patch releases of Studio 8.0.1 to target Patch Release R2024-05 or later

If the target Patch release for the Studio in question is R2024-05 or higher, the patch archive will act as both Base_URL and Update_URL; as the P2 base now has shifted to the specific patch being applied.

For all more recent patch releases, Studio will only need to use the above format for the Update_URL; additionally, users can follow alternatives instructions on Qlik's patch release notes, which will translate to the same format by the application:

1. Obtain the patch zip file from Qlik Support

2. Create a folder named "patches" in the Studio installation directory and copy the patch .zip file to this folder.

3. Restart the Studio instance.

4. If the Studio instance supports installing features using the Feature Manager wizard, log in to a project desired, and navigate to the wizard to proceed with the patch installation. Otherwise, click OK when prompted to install the patch.

 

Environment

Talend Studio 

Show Less

The following error is found in log when working on a Git project in Talend Studio:

org.talend.commons.exception.CommonExceptionHandler - Branches configuration is out of sync, can't find the specified branch ****, will try to recover it using it's remote branch. 

 

Resolution

In order to fix this, please modify the remote repository as well.
For example, if you delete the branch on Talend Studio, please delete it from the remote repository as well.
If you are using Github, it would mean deleting the branch on Github from the following link:

https://github.com/[repository name]/branches

or using Git command tools like Git Bash to delete the branch from the remote repository.

 

Cause

The git branch structure in Talend Studio does not match the repository in the actual Git repository.
This usually occurs when you modify the branch in the local project, but it is not modified the same way in the remote repository.

 

Environment

Talend Studio 

Show Less

By default, a Remote Engine uses the Java version of its environment to execute Jobs or Microservices. With Remote Engine v2.13 onwards, Java 17 is mandatory for engine startup, but compatibility with JDK 8 or 11 may still be necessary.
Importantly, although Java 17 is a mandatory requirement for the new engine to start, when it comes to running Jobs or Microservices, you retain the flexibility to either use the default Java 17 version or choose older Java versions, through straightforward configuration of the engine.

This article briefly introduces how to configure different Java versions to run Jobs or Microservices in Talend Remote Engine for compatibility configuration.

 

How To

1. Adaptive mode: Configuring Remote Engine to dynamically select Java version

   Recommended for engines starting from v2.13.9 (released in R2025-01): from that release, Remote Engine adopts a dynamic JVM selection mode. This mode automatically adapts the engine to the correct Java version to run Jobs or Microservices. See Adaptive mode: Configuring Remote Engine to dynamically select Java version

2. Specifying a Java version to run Jobs or Microservices 

   This approach provides an alternative to the adaptive mode if the Adaptive mode is not available to your engine version. It allows you to run the artifacts designed with Java versions older than Java 17. (a solution is to use Java 8 or Java 11 to execute the job even if the RE is using Java 17).

   JDK compiler compliance level in studio was used when code built and Remote Engine relies on JAVA_HOME. 

   If your engine is v2.13 or later but still older than v2.13.9, you cannot upgrade it to the latest version and follow this procedure to specify the Java version to be used for executions. 

   This approach is not dynamic and only one version can be specified. See Specifying a Java version to run Jobs or Microservices

 

Related Content

For more information about configuring java version for job execution or microservice execution, please refer to 

configure-java-versions-for-job-execution-or-microservice-execution

 

Environment

• Talend Cloud 
• Talend Studio 

 

 

Show Less

The PostgreSQL installation kit is included in the Qlik Enterprise Manager (QEM) installation package. However, this version may be outdated or contain known vulnerabilities. Which PostgreSQL versions are supported by Qlik Enterprise Manager?

The Qlik Enterprise Manager supported PostgreSQL version is documented in your version's Software Requirements.

While PostgreSQL is bundled with the QEM installation kit, we recommend installing a later version officially supported by PostgreSQL.

PostgreSQL is not a Qlik product. If your PostgreSQL version requires an upgrade due to the end of its support lifecycle, identified vulnerabilities, or other considerations, please refer to the PostgreSQL website for further instructions on how to upgrade.

Environment

• Qlik Enterprise Manager

Show Less

After following the Qlik article Configure Qlik Sense to use a dedicated PostgreSQL server and update the connection string to point to the new host, Qlik Sense appears to work fine at first. However, access by the Qlik Sense Service account to the old host is registered or errors are found in the logs similar to what is found in the example below:

In the AppDistributionService trace logs:

307308 20210104T170444.859+01:00 INFO QLIKSERVER 70 DOMAIN\serviceaccountname Retry attempt: 10/10. Previous result: "No such host is known". 304796
307309 20210104T170451.812+01:00 ERROR QLIKSERVER 70 DOMAIN\serviceaccountname Error processing message queue notifications. System.Net.Sockets.SocketException (11001): No such host is known
at System.Net.Dns.HostResolutionEndHelper(IAsyncResult asyncResult)

 

Resolution

There are a few new services starting on the September 2019 release of Qlik Sense which did not exist in June 2018. Some of them were also removed/replaced on the new release.

Option 1 (recommended): Updating the files using PowerShell:

1. Stop all the Qlik Sense services
2. Open a PowerShell command prompt in administrator mode and then, either run the following:
   
   

   # Set the Installation Directory for Qlik Sense
   $installDir = 'C:\Program Files\Qlik\Sense\'
   #change that to the new database server
   $newdatabasehostname='new database server'
   # Specify the new password for the qliksenserepository account
   $password = 'MyNewPassword'
   # Find all Configure-Service.ps1 scripts in the installation directory and execute them
   $files = Get-ChildItem -Path $installDir -Include Configure-Service.ps1 -Recurse
   foreach ($file in $files) {
       $ScriptToRun=$($file.FullName)
       &$ScriptToRun $newdatabasehostname 4432 qliksenserepository $password -postgresHome 'D:\Qlik\Sense\Repository\PostgreSQL\12.5'
   }​

   
   In case of having a custom path Qlik Sense installation, change the last line to:

 

&$ScriptToRun $newdatabasehostname 4432 qliksenserepository $password -postgresHome 'D:\Qlik\Sense\Repository\PostgreSQL\12.5'
}

 

Where "D:\Qlik\Sense" is Qlik Sense installed folder and where "12.5" is the Postgres version installed.

Option 2: Manually update each file

Change to the following directories with the commands below before running the Configure-Service.ps1 command listed further below.

Repeat the step for every subfolder mentioned below.

Note: If you previously upgraded you may find folders in your system which are not listed here. Ignore them. No steps need to be taken.

Qlik Sense February 2021 and later.

Locate Configure-Service.ps1 in C:\program files\Qlik\Sense\.

It lists all services that need to be changed.

Qlik Sense June 2018:

Qlik Sense September 2019:

 

Example:

For AppDistributionService...

PS C:\> cd 'C:\Program Files\Qlik\Sense\AppDistributionService'
PS C:\Program Files\Qlik\Sense\AppDistributionService> .\Configure-Service.ps1 DatabaseHost Databaseport DatabaseUser DatabasePassword

e.g. .\Configure-Service.ps1 newdatabasehostname 4432 qliksenserepository Password123!

The answer will look similar to this:

AppDistributionService configuration started.
WARNING: Skiping the database initialization. No superuser or password specified.
Reading the settings file.
Saving the modified settings.
Exporting the copy of the invocation parameters.
AppDistributionService configuration successful.

 

Related Content:

• Configure Qlik Sense to use a dedicated PostgreSQL server

Show Less

This article documents how to configure a Qlik tenant to send emails using MS365.

Prerequisite

An account with an active Office365 license is required for this setup.

 

MS365 Setup

First, we configure the MS365 tenant to support the configuration.

Once you have an account set up on the MS365 side, let's go to the Microsoft Tenant settings:

1. Open the Microsoft Entra admin center (Home - Microsoft Entra admin center)
   1. Go to Overview
   2. In the overview screen, you will see your Tenant ID. Copy this value, you will need it to configure your Qlik Cloud Tenant.
   3. Click Application to register an application
   4. Click + New registration
      
      
      
      
   5. Name your application
   6. Select the Supported account type that matches your needs
   7. Click Register to register your application
2. Create a Client Credential 
1. Click Certificates & Secrets
2. Click + New client secret
3. Describe (name) the client secret and select its expiration value
4. Click Add to finish this step
   
   
   
   
5. After creating your client secret, the following is displayed:
   
   
   
   
6. Copy the value and save it in a safe place. You will need it to complete your Qlik Cloud Tenant setup.
   
   
3. Enabling the right APIs:
   1. Go to API Permissions
   2. Click + Add Permission
   3. Select Microsoft Graph
   4. Select Application permissions
   5. In the Select permissions field look for Mail.Send
   6. Select the Mail.Send permission

      Setting Application permissions to Mail.Send grants the application to use any email address from your organization.

   7. Click Add permission
   8. Click Grant admin consent for <MS Tenant Name> to finish this step
      
      
      
      
4. Select an Owner for the application
   1. Click + Add Owner
   2. Type the name of the User who will be the Owner
   3. Mark the user and click Select 

 

Qlik Cloud Tenant Setup

1. Open your Administration activity center (see Accessing the Administration activity center)
2. Go to the Email Provider section
3. Select Microsoft 365
   
   
   
   
4. Insert all previously set information:
   1. Sender email address: Insert an email registered on Microsoft. This can be your email address or another dedicated account created specifically for this purpose. 
   2. Tenant ID: Obtained from the Microsoft Entra Overview section.
   3. Client ID: The Application (client) ID you previously created.
   4. Client secret: The Client secret value which you saved in the previous setup steps.
      
      
      
      
5. Save the changes
6. Send a test email

 

Environment

• Qlik Cloud Analytics
• Microsoft Office 365

 

The information in this article is provided as-is and will be used at your 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.

Show Less

Question: Does Qlik Sense Enterprise on Windows support being deployed on a KVM (Kernel-based Virtual Machine)?

Answer: Currently, Qlik Sense Enterprise on Windows does not support the use of a KVM. Refer to the System Requirements and Virtualization Best Practices In QlikView And Qlik Sense for details. 

 

Environment

• Qlik Sense Enterprise on Windows

Show Less

Question: If I have previously unbundled PostgreSQL from Qlik Sense Enterprise on Windows, can I host other databases on the same server?

Answer: While technically possible, Qlik does not advise running additional databases on the same host or from the same PostgreSQL instance. Qlik Sense Enterprise on Windows can create demanding read/write traffic against the database, meaning the PostgreSQL instance should remain dedicated.

For information on how to unbundle PostgreSQL from Qlik Sense Enterprise on Windows, see Upgrading and unbundling the Qlik Sense Repository Database using the Qlik PostgreSQL Installer.

 

Environment

• Qlik Sense Enterprise on Windows

Show Less

When attempting to run a task containing a SQLite component on Remote Engine, it receives the following error relating to SQLite connections: 

tDBConnection_2 Error opening connection java.sql.SQLException: Error opening connection at org.sqlite.SQLiteConnection.open(SQLiteConnection.java:283) at org.sqlite.SQLiteConnection.

Caused by: org.sqlite.NativeLibraryNotFoundException: No native library found for os.name=Linux, os.arch=x86_64, paths=[/org/sqlite/native/Linux/x86_64:/usr/java/packages/lib:/usr/lib/x86_64-linux-gnu/jni:/lib/x86_64-linux-gnu:/usr/lib/x86_64-linux-gnu:/usr/lib/jni:/lib:/usr/lib]

Resolution

To resolve this, please ensure that the system’s temp directory has both write and execute permissions for the user running the process. Configuring the JVM to use a custom temp directory with appropriate permissions by setting up the run profile.

For example:

-Djava.io.tmpdir=/media/local/temp    Where "media/local/temp" has executable permissions

 

Cause

This issue arises because the SQLite JDBC driver (such as sqlite-jdbc) includes native libraries (like libsqlitejdbc.so) within the .jar file. At runtime, these native libraries are extracted to a temporary directory (usually /tmp or the path defined by the java.io.tmpdir system property) and loaded by the JVM to enable the connection to the SQLite database. If the temporary directory does not have the appropriate executable permissions, the driver fails to load the native libraries, leading to a connection error.
 

 

Environment

• Talend Cloud 
• Talend Data Integration 

Show Less

This article describes how to resolve the NPrinting connection verification error:

 

x Qlik NPrinting webrenderer can reach Qlik Sense hub error

 

Environment

• NPrinting: all versions
• Qlik Sense: all versions
  • multi-node QS proxy environment
  • NLB (Network Load Balancer or Alias URL) server address used in front of cluster of Qlik Sense proxy nodes (which are linked to a Virtual Proxy. Proxy nodes will not work with NPrinting unless they are linked to a QS virtual proxy)

Resolution

• Although it is possible to use an NLB address in front of your QS proxy nodes that are used by NPrinting, the error generated in the NP connection verification process will appear as described in the article title
• This error can safely be ignored as this does not affect generation of NPrinting connections
• To eliminate the 'error' message, you would need to update your NPrinting connection to use a virtual proxy node address/computer name behind the NLB address . It must be the computer name and not an alias url).
• The proxy node used must be linked to a virtual proxy with the following required attribute
  
  • Microsoft Windows NTML authentication on the Qlik Sense proxy. (SAML and JWT are not supported. If your virtual proxy uses SAML or JWT authentication, you need to add a new virtual proxy with NTLM enabled for Qlik NPrinting connections).
  • A link between the proxy node and virtual proxy.
  • For all NPrinting to Qlik Sense requirements visit https://help.qlik.com/en-US/nprinting/Content/NPrinting/DeployingQVNprinting/NPrinting-with-Sense.htm#anchor-1
• If a DNS name is involved and the Qlik Sense certificates are generated using that DNS name, try disabling the "Apply Qlik Sense server certificate validation" checkbox.

 

Related Content

• https://help.qlik.com/en-US/nprinting/Content/NPrinting/Troubleshooting/Verify-connection-to-Sense-errors.htm
• https://help.qlik.com/en-US/nprinting/Content/NPrinting/DeployingQVNprinting/NPrinting-with-Sense.htm#Requirem

Internal Investigation ID

• QB-2871
• QB-25870

Show Less

The following release notes cover the Qlik PostgreSQL installer (QPI) version 1.2.0 to 2.1.0.

Content

• What's New
• 2.1.0 September 2025 Release Notes
• Known Limitations (2.1.0)
• 2.0.0 May 2025 Release Notes
• Known Limitations (2.0.0)
• 1.4.0 December 2023 Release Notes
• Known Limitations (1.4.0)
• 1.3.0 May 2023Release Notes
• Known Limitations (1.3.0)
• 1.2.0 Release Notes

 

What's New

• The PostgreSQL version used by QPI has been updated to 14.17
• An upgrade of an already upgraded external instance is now possible
• Support for an upgrade of the embedded 14.8 database was added
• Silent installs and upgrades are supported beginning with Qlik PostgreSQL Installer 1.4.0 and later. QPI can now be used with silent commands to install or upgrade the PostgreSQL database. (SHEND-973)

 

2.1.0 September 2025 Release Notes

Improvement / Defect	Details
SHEND-2519	QPI will run as administrator by default.
QCB-32208 / SUPPORT-4028	QPI supporting Qlik Sense custom path installations outside of the C drive.

 

Known Limitations (2.1.0)

• Rollback is not supported.
• The database size is not checked against free disk space before a backup is taken.
• Windows Server 2012 R2 does not support PostgreSQL 14.17. QPI cannot be used on Windows Server 2012 R2.
• QPI will only upgrade a PostgreSQL instance that only contains Qlik Sense Databases (QSR, SenseServices, QSMQ, Licenses, QLogs, etc.)

 

2.0.0 May 2025 Release Notes

Improvement / Defect	Details
SHEND-2273	Upgrade of Qlik Sense embedded PostgreSQL v 9.6, v 12.5, and v 14.8 databases to v 14.17. The PostgreSQL database is decoupled from Qlik Sense to become a Standalone PostgreSQL database with its own installer and can be upgraded independently of the installed Qlik Sense version. Upgrade of already decoupled standalone PostgreSQL databases versions 9.6, 12.5, and 14.8 to version 14.17.
QCB-28706	Upgraded PostgreSQL version to 14.17 to address the pg_dump vulnerability (CVE-2024-7348).
SUPPORT-335	Upgraded PostgreSQL version to 14.17 to address the libcurl vulnerability (CVE-2024-7264).
QB-24990	Fixed an issue with upgrades of PostgreSQL if Qlik Sense was installed in a custom directory, such as D:\Sense.

 

Known Limitations (2.0.0)

• Rollback is not supported.
• The database size is not checked against free disk space before a backup is taken.
• Windows Server 2012 R2 does not support PostgreSQL 14.17. QPI cannot be used on Windows Server 2012 R2.
• QPI will only upgrade a PostgreSQL instance that only contains Qlik Sense Databases (QSR, SenseServices, QSMQ, Licenses, QLogs, etc.)

 

1.4.0 December 2023 Release Notes

Improvement / Defect	Details
SHEND-1359, QB-15164: Add support for encoding special characters for Postgres password in QPI	If the super user password is set to have certain special characters, QPI did not allow upgrading PostgreSQL using this password. The workaround was to set a different password, use QPI to upgrade the PostgreSQL database and then reset the password after the upgrade. This workaround is not required anymore with 1.4.0 QPI, as 1.4.0 supports encoded passwords.
SHEND-1408: Qlik Sense services were not started again by QPI after the upgrade	QPI failed to restart Qlik services after upgrading the PostgreSQL database. This has been fixed now.
SHEND-1511: Upgrade not working from 9.6 database	In QPI 1.3.0, upgrade from PostgreSQL 9.6 version to 14.8 was failing. This issue is fixed in QPI 1.4.0 version.
QB-21082: Upgrade from May 23 Patch 3 to August 23 RC3 fails when QPI is used before attempting upgrade. QB-20581: May 2023 installer breaks QRS if QPI was used with a patch before.	Using QPI on a patched Qlik Sense version caused issues in the earlier version. This is now supported.

 

 

Known Limitations (1.4.0)

• QB-24990: Cannot upgrade PostgreSQL if Qlik Sense was installed in a custom directory such as D:\Sense. See Qlik PostgreSQL Installer (QPI): No supported existing Qlik Sense PostgreSQL database found.
• Rollback is not supported.
• Database size is not checked against free disk space before a backup is taken.
• QPI can only upgrade bundled PostgreSQL database listening on the default port 4432. Using QPI to upgrade a standalone database or a database previously unbundled with QPI is not supported.
• Cannot migrate a 14.8 embedded DB to standalone
• Windows Server 2012R2 does not support PostgreSQL 14.8. QPI cannot be used on Windows Server 2012R2.

 

1.3.0 May 2023 Release Notes

 

Show Less