The Qlik Replicate Databricks endpoint has a limitation of 255 characters for STRING data type columns. This limit can be lifted using an Internal Parameter.

Resolution

To lift the limitation:

1. Go to the  Endpoint connection
2. Switch to the Advanced tab
3. Click Internal Parameters
4. Configure:
   
   Parameter: $info.query_syntax.truncate_too_long_data_in_column
   Value: false
   
   
   
   For more information about Internal Parameters and their use, see Qlik Replicate: How to set Internal Parameters and what are they for?

Environment

• Qlik Replicate 2022.11 or above

Qlik NPrinting Designer opens and throws this error message:

Can't find a supported reporting template editor for the file ..... Error Message: Interface not Supported.

The problem occurs only with Office reports. An Office instance is then opened, but not embedded inside the Qlik NPrinting designer.

• The problem occurs even if the zoom in the screen is set to 100% as per requirements
• The problem persists even after a complete un-installation and re-installation of Qlik NPrinting
• The problem can occur on single local machines while Qlik NPrinting Designer works on others

Resolution

To resolve the error:

1. Download and unzip the attached regtlibv12.zip file.
2. Copy regtlibv12.exe to C:\Program Files\Microsoft Office\Root\Office16
3. Open Command Prompt as administrator
4. In the elevated prompt, execute:

   cd  "C:\Program Files\Microsoft Office\Root\Office16"

5. After successfully changing the directory, run the following three commands.

   After each, verify that you receive a confirmation that the registration was successful.

   • regtlibv12.exe EXCEL.EXE

   • Run regtlibv12.exe MSWORD.OLB

   • Run regtlibv12.exe MSPPT.OLB

6. Restart the machine.
7. Verify that NPrinting Designer works.

Upon clicking Edit Report, Qlik NPrinting Designer opens and calls Excel, Word, or PowerPoint to embed the report. 

The communication between the Qlik NPrinting and the Office executables is enabled by type libraries (Typelib) in the Windows Registry (regedit).

By running regtlibv12.exe combined with, for example, EXCEL.EXE, you force Windows to register the type libraries on the registry.

Internal Investigation ID(s)

SUPPORT-584

Environment

• Qlik NPrinting

When using SAML or ticket authentication which started in Qlik Sense June 2019, some users belonging to a big number of groups see the error "Qlik Sense G3 Broker API" on the hub and cannot proceed further.

You may receive the following error when setting up the SAML virtual proxy: cachebust pending 

Environments:

• Qlik Sense Enterprise on Windows 
  All Version
  
  

Resolution/Workaround

The only known workaround in the above versions is to reduce the number of groups sent in the SAML response or ticket request.

The fix for this defect is included in the following versions, but additional steps may be necessary:

All Versions

The default setting will still be a header size of 8192 bytes. The fix adds support for a configurable MaxHttpHeaderSize.

Steps:

1. To configure add it at the top section of the file under [globals] (C:\Program Files\Qlik\Sense\ServiceDispatcher\service.conf)

   [globals]
   LogPath="${ALLUSERSPROFILE}\Qlik\Sense\Log"
   MigrationPort=4545
   (...)
   MaxHttpHeaderSize=65534

2. Once the change is done, save the file and restart the Qlik Service Dispatcher service.

Note: Above value (16384) is an example. You may potentially need to put more depending of the total number of characters of all the AD groups to which the user belongs. The max value is 65534.

Other Related Articles:
https://community.qlik.com/t5/Official-Support-Articles/Error-431-when-trying-to-access-the-Qlik-Sense-Management/ta-p/1789124 

Internal Investigation ID(s):

QB-234.

Qlik Sense patches can be downloaded from the Qlik Download page. Patches are cumulative, and only one patch can be installed at a time.

Example: Patch 4 for Qlik Sense February 2019 will include all fixes from 3, 2, and 1.

Before applying a patch:

• Read the Release Notes to locate any dependencies of new features or changes to features which can affect your environment
• Verify and record all customisations (manual changes to setting files or configuration files not otherwise represented in the GUI). While patches generally do not change settings or revert configuration files to default, a drastically changed feature (see release notes) can impact customisations.
• Previously installed patches on the same release track do not need to be uninstalled

To install:

1. Download the required patch 
2. Schedule a brief downtime as the server will need to be restarted
3. Execute the patch installation package and follow the on-screen instructions
4. Restart the Windows server host

To uninstall:

Executing a patch installation package will automatically uninstall the previous patch and install the new one. If you need to uninstall a patch manually:

1. Open the Windows Add and Remove Programs menu
2. Click View installed updates from the left panel
3. Locate the Patch
4. Uninstall the Patch
5. Restart the Windows Server host

If uninstall through Control Panel is not possible:

1. Locate the Qlik_Sense_update.exe installer package in C:\ProgramData\Package Cache\[guid]\.
   
   If the package required for the uninstall has been removed or renamed, a possible workaround is to obtain an exact copy (same version, release) of the Qlik_Sense_update.exe from a different environment and manually replacing it.
   
   
2. Right click the Qlik_Sense_update.exe and click Uninstall

Related Content:

Custom configuration file changes not kept after Qlik Sense upgrade 

The following error is thrown in a full load when replicating data from Oracle source to Snowflake target in Qlik Talend Cloud Data Integration:

[TARGET_LOAD ]E: RetCode: SQL_ERROR SqlState: 22000 NativeError: 100144 Message: Invalid UTF8 detected in string '?*��?&??9?ʏ"?'

Cause

The columns datatype in Oracle is defined as Varchar(64) and has hash data. This causes replication to fail.

Resolution

Set the character set to UTF-8 to U+20 to resolve the issue

1. Go to Settings 
2. Open Character substitution
3. In Unsupported source characters by character set, configure:
   
   Character set: UTF-8
   Substitute character: U+ 20
   
   
4. Click OK
5. Reload the task

Environment

• Qlik Talend Cloud Data Integration

There is no option in SAML authentication to set the user timeout. However, you can still set the timeout by setting the current SAML authentication to FORM, then move it back to SAML authentication after setting the desired timeout. With this, the timeout set in the FORM method will also be applied to SAML authentication.

1. Change the current SAML authentication to FORM authentication:
   
   
   1. Open the command prompt as administrator
   2. Switch to the Enterprise Manager bin directory
      
      

      cd Program Files\Attunity\Enterprise Manager\bin

   3. To set the authentication method to Form, run:
      
      

      aemctl.exe configuration set --authentication_method form

      
      
      
      
2. Set the user timeout for FORM:
   
   

   aemctl.exe configuration set --authentication_method form --user_timeout <timeout in minutes>

   
   Set <timeout in minutes> to the numerical value at which point the users will be logged out. 
   
   Example:
   
   

   preaemctl.exe configuration set --authentication_method form --user_timeout 60

   

    

3. Verify the value of the user timeout for FORM:
   
   

   aemctl -d "data_folder " configuration show

   Example:

   aemctl -d "D:\Attunity\Enterprise Manager\data" configuration show

   
   

    

4. Set the authentication back to SAML:
    

   aemctl -d "data_folder" configuration set --authentication_method SAML --idp_url <URL> --idp_issuer <ISSUER> --idp_certificate_file <xxx.pem>

   
   Example:
   
   

   aemctl configuration set --authentication_method SAML --idp_url https://login.microsoftonline.com/12854727-3c42-4866-ab29-0c418b8310a1/saml2 --idp_issuer aemdevtest --idp_certificate_file AEMDevTest.pem

5. Restart the Qlik Enterprise Manager

Environment

• Qlik Enterprise Manager all version

In this article, we walk you through the requirements and process of how to upgrade and unbundle 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.

Using the Qlik Postgres Installer not only upgrades PostgreSQL; it also unbundles PostgreSQL from your Qlik Sense Enterprise on Windows install. This allows for direct control of your PostgreSQL instance and facilitates maintenance without a dependency on Qlik Sense. Further Database upgrades can then be performed independently and in accordance with your corporate security policy when needed, as long as you remain within the supported PostgreSQL versions. See How To Upgrade Standalone PostgreSQL.

Index

• Supported Scenarios
• Upgrades
• New installs
• Requirements
• Known limitations
• Installing anew Qlik Sense Repository Database using PostgreSQL
• Qlik PostgreSQL Installer - Download Link
• Upgrading an existing Qlik Sense Repository Database
• The Upgrade
• Next Steps and Compatibility with PostgreSQL installers
• How do I upgrade PostgreSQL from here on?
• Troubleshooting and FAQ
• Related Content

Video Walkthrough

Video chapters:

• 01:02 - Intro to PostgreSQL Repository
• 02:51 – Prerequisites
• 03:24 - What is the QPI tool?
• 05:09 - Using the QPI tool
• 09:27 - Removing the old Database Service
• 11:27 - Upgrading a stand-alone to the latest release
• 13:39 - How to roll-back to the previous version
• 14:46 - Troubleshooting upgrading a patched version
• 18:25 - Troubleshooting upgrade security error
• 21:15 - Additional config file settings

Supported Scenarios

Upgrades

The following versions have been tested and verified to work with QPI (1.4.0): 

Qlik Sense February 2022 to Qlik Sense November 2023.

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

Qlik Sense November 2022 and later do not support 9.6, and a warning will be displayed during the upgrade. From Qlik Sense August 2023 a upgrade with a 9.6 database is blocked.

New installs

The Qlik PostgreSQL Installer supports installing a new standalone PostgreSQL database with the configurations required for connecting to a Qlik Sense server. This allows setting up a new environment or migrating an existing database to a separate host.

Requirements

• Review the QPI Release Notes before you continue

• Using the Qlik PostgreSQL Installer on a patched Qlik Sense version can lead to unexpected results. If you have a patch installed, either:

  • Uninstall all patches before using QPI (see Installing and Uninstalling Qlik Sense Patches) or
  • Upgrade to an IR release of Qlik Sense which supports QPI

• The PostgreSQL Installer can only upgrade bundled PostgreSQL database listening on the default port 4432.
• 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. 
• There will be downtime during this operation, please plan accordingly
• If upgrading to PostgreSQL 14 and later, the Windows OS must be at least Server 2016

Known limitations

• Cannot migrate a 14.8 embedded database to a standalone
• Using QPI to upgrade a standalone database or a database previously unbundled with QPI is not supported.
• The installer itself does not provide an automatic rollback feature.

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, default: C:\Program Files\PostgreSQL\14

   Do not use the standard Qlik Sense folders, such as C:\Program Files\Qlik\Sense\Repository\PostgreSQL\ and C:\Programdata\Qlik\Sense\Repository\PostgreSQL\.

7. Set the database data folder, default: C:\Program Files\PostgreSQL\14\data

   Do not  use the standard Qlik Sense folders, such as C:\Program Files\Qlik\Sense\Repository\PostgreSQL\ and C:\Programdata\Qlik\Sense\Repository\PostgreSQL\.

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 Release Notes

Upgrading an existing Qlik Sense Repository Database

The following versions have been tested and verified to work with QPI (1.4.0): 

February 2022 to November 2023.

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

Qlik Sense November 2022 and later do not support 9.6, and a warning will be displayed during the upgrade.  From Qlik Sense August 2023 a 9.6 update is blocked.

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.
    
    The review screen lists the settings which will be migrated. No manual changes are required post-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-14 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
    

     

16. Uninstall the old Qlik Sense Repository Database service.

    This step is required. Failing to remove the old service will lead the upgrade or patching issues.

    1. Open a Windows File Explorer and browse to C:\ProgramData\Package Cache
       
       
    2. From there, search for the appropriate msi file.
       
       
       
       If you were running 9.6 before the upgrade, search PostgreSQL.msi
       If you were running 12.5 before the upgrade, search PostgreSQL125.msi
       
       
    3. The msi will be revealed.
       
       
    4. Right-click the msi file and select uninstall from the menu.
       
       
       
       
    
    
17. Re-install the PostgreSQL binaries. This step is optional if Qlik Sense is immediately upgraded following the use of QPI. The Sense upgrade will install the correct binaries automatically. 
    

    Failing to reinstall the binaries will lead to errors when executing any number of service configuration scripts. 

    If you do not immediately upgrade:
    
    
    1. Open a Windows File Explorer and browse to C:\ProgramData\Package Cache
       
       
    2. From there, search for the .msi file appropriate for your currently installed Qlik Sense version
       
       
       
       For Qlik Sense August 2023 and later: PostgreSQL14.msi
       Qlik Sense February 2022 to May 2023: PostgreSQL125.msi
       
       
    3. Right-click the file
    4. Click Open file location
       
       
       
       
    5. Highlight the file path, right-click on the path, and click Copy
       
       
       
       
    6. Open a Windows Command prompt as administrator
       
       
    7. Navigate to the location of the folder you copied
       
       Example command line: 
       
       cd C:\ProgramData\Package Cache\{GUID}
       
       Where GUID is the value of the folder name.
       
       
    8. Run the following command depending on the version you have installed: 
       
       Qlik Sense August 2023 and later
       
       msiexec.exe /qb /i "PostgreSQL14.msi" SKIPINSTALLDBSERVICE="1" INSTALLDIR="C:\Program Files\Qlik\Sense"
       
       Qlik Sense February 2022 to May 2023
       
       msiexec.exe /qb /i "PostgreSQL125.msi" SKIPINSTALLDBSERVICE="1" INSTALLDIR="C:\Program Files\Qlik\Sense"
       
       This will re-install the binaries without installing a database. If you installed with a custom directory adjust the INSTALLDIR parameter accordingly. E.g. you installed in D:\Qlik\Sense then the parameter would be INSTALLDIR="D:\Qlik\Sense".
       
       
18. Finalize the process by updating the references to the PostgreSQL binaries paths in the SetupDatabase.ps1 and Configure-Service.ps1 files. For detailed steps, see Cannot change the qliksenserepository password for microservices of the service dispatcher: The system cannot find the file specified.

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

Next Steps and Compatibility with PostgreSQL installers

Now that your PostgreSQL instance is no longer connected to the Qlik Sense Enterprise on Windows services, all future updates of PostgreSQL are performed independently of Qlik Sense. This allows you to act in accordance with your corporate security policy when needed, as long as you remain within the supported PostgreSQL versions.

Your PostgreSQL database is fully compatible with the official PostgreSQL installers from https://www.enterprisedb.com/downloads/postgres-postgresql-downloads. 

How do I upgrade PostgreSQL from here on?

See How To Upgrade Standalone PostgreSQL, which documents the upgrade procedure for either a minor version upgrade (example: 14.5 to 14.8) or a major version upgrade (example: 12 to 14). Further information on PostgreSQL upgrades or updates can be obtained from Postgre directly.

Troubleshooting and FAQ

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 PostgreSQL Repository Troubleshooting
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 

AWS KMS-Managed Keys (SSE-KMS) should be disabled when "Server-Side Encryption" is disabled in component tS3Put, however, after comparing the generated code lines, KMS is still Enable.

As a result, the job will get an error. Even there is a workaround by explicitly disabling KMS in component setting, though it is hard to find what the job error is as the parameter is hidden.

Steps to reproduce

1. Drag tS3Put component from Palette into Designer and then generate the code to compare later in studio
2. Enable "Server-Side Encryption" and "Use KMS" by ticking checkbox and Save the current job
   KMSEnabled

    

   
   KMSEnabledCode

   
3. Disable "Server-Side Encryption" from component basic settings, save the current job and then compare the new generated code with the code in the step1. You can see KMS is still enabled in code.
   Server-sideEncryptionDisabledKMSDisabledCode
    

Resolution

Fix version of related bug was updated to: 8.0.1-R2025-03 

Cause 

It was a known bug and raised in an internal Issue: QTDI-1133

Related Content

For more information about tS3Put component setting, please see tS3put

For more information about the server-side encryption information, see Protecting Data Using Server-Side Encryption.

Internal Investigation ID(s)

Internal Investigation IDs : QTDI-1133

Environment

• Talend Studio 
• Talend Data Integration 

A Qlik Replicate task fails and stops with the error:

[INFRASTRUCTURE ]E: Json doesn't start with '{' [1003001] (at_cjson.c:1790)

Resuming the task may lead to this error message as the last saved file was improperly saved.

Resolution

Restart the task from a timestamp instead of resuming the task to regenerate the file:

1. Stop the task
2. Download the latest task log and look for this line of statement:
   
   [SORTER ]I: Final saved task state. Stream position 00000000.041081f1.00000001.0000.00.0000:686.102091.16, Source id 573451, next Target id 17, confirmed Target id 13, last source timestamp 1721397987000000 (sorter.c:782)
   
3. Copy the value of the 'Last source timestamp' and use a time conversion tool to convert the time. Example: https://www.epochconverter.com/
   
   Example: 1721397987000000 converts to Friday, July 19, 2024 10:06:27 AM EST
   
4. Input the value and retrieve the timestamp in the local time of your machine
5. Use the task's advanced run options and restart the task at the identified timestamp.

Cause 

If the target system uses files, such as ADLS or Databricks), a network disconnect occurring while a file is being pushed to the target can lead to an incomplete file being saved on the Qlik Replicate server. When the file is saved improperly, the task will not be able to use it to resume the task.

Regeneration of the last file will be needed.

Environment

• Qlik Replicate 

"RestConnectorMasterTable" General Script Error in statement handling

RestConnectorMasterTable:
20200826T102106.344+0000 0088 SQL SELECT
20200826T102106.344+0000 0089 "name",
20200826T102106.344+0000 0090 "value"
20200826T102106.344+0000 0091 FROM JSON (wrap off) "contactCustomData"
20200826T102106.344+0000 0092 WITH CONNECTION (
20200826T102106.344+0000 0093 URL "      ",
20200826T102106.344+0000 0094 HTTPHEADER "Authorization" "**Token removed for security purpose**"
20200826T102106.344+0000 0095 )
20200826T102106.967+0000 General Script Error in statement handling
20200826T102106.982+0000 Execution Failed
20200826T102106.986+0000 Execution finished.

Environment

Qlik Sense Enterprise on Windows 

Resolution

To be able to catch the exact error and mitigate the issue they need to apply our recommended best practices for error handling in Qlik scripting using the Error variables
Error variables 
Script control statements 

Set to ErrorMode=0 it will ignore any errors and continue with the script. You can use the IF statement to retry the connection or move to another connection for a few attempts and then it will change it to ErrorMode=1 and fail or just disconnect on its own.

A sample script is located here, but further options can be added from the Help links already provided.
Qlik-Sense-fail-and-retry-connection-sample-script 

Note: QlikView scripting is the same in these functions for Qlik Sense unless otherwise stated, but there are some very helpful items in the links.
Best-Practice-Error-Handling-in-Script 

Cause 

Error with the fetch of the token with the rest call. If the number of rows in a table doesn't match or is less than expected, trigger the script to throw an error and have it try to load the table again for more records, or if the count is off, do a Loop until returns the correct number.

Internal Investigation ID(s) 

QB-3164

When running a Qlik Replicate CDC task from the Microsoft SQL Server source endpoint, you may get the below error, but the task continues to run despite being marked as errored. This is because the error is considered a recoverable error and the task eventually resumes fine once it finds the LSN in the next run.

Resolution

Edit the MS-SQL source endpoint setting and add the internal parameter afterConnectScript using the Qlik Replicate GUI.

1. Go to Manage Endpoint Connections
2. Open your MS-SQL source endpoint definition
3. Open the Advanced tab
4. Go to Internal Parameters 
5. Add the internal parameter: afterConnectScript and set it todbcc traceon(2537)
   
   This traceon code will allow the session to read LSNs still in the online log but marked as replicated and inactive.

The Qlik Replicate user configured to read the MS-SQL must be a SYSADMIN

Possible Cause

A possible reason for this is that the task might be behind, and the online log is truncated, but the Replicate in the recovery attempt can find the LSN in the online/Active logs.

Related Content

• Qlik Replicate: SQL Server Tasks Fails with Error: Invalid parameter passed to OpenRowset(DBLog, ...)
• Qlik Replicate Error: [SQL Server]Invalid parameter passed to OpenRowset(DBLog, ...)

Environment

• #Qlik Replicate  
• Microsoft SQL Server

Connecting to a local GeoAnalytics servers fails with Error: Invalid Key , Error Message Either your key is invalid or it has expired

The message Invalid Key can also be displayed on the map objects when using the GeoAnalytic extensions:

Environment:

Qlik GeoAnalytics 

Resolution

Using internal GeoAnalytics server:

The licenses for GeoAnalytics connector and map extensions must match the license applied to the GeoAnalytics server. If not, please re-license the connector or the server as instructed in the following articles: 

Installing Qlik GeoAnalytics server
Installing Qlik GeoAnalytics for Qlik Sense

However, in some circumstances, the license key may not take effect due to no connection to the Internet. Then, manual change needs to be done in the configuration files for GeoAnalytics connector, extensions, or server:

QlikSense server
GeoAnalytics connector:    C:\Program Files\Common Files\Qlik\Custom Data\QvIdevioConnector\IdevioGeoAnalyticsConnector.exe.config

Example:

<add key="licenseKey" value="0000000011111111:1654281610406"/>

GeoAnalytics extensions:   \\<file shared server>\QlikShare\StaticContent\Extensions\ideviomap\License.js

1. edit License file

Example

define([], function () {return "00000001111111"});

QlikView server
GeoAnalytics connector:    C:C:\Program Files\Common Files\QlikTech\Custom Data\QvIdevioConnector\IdevioGeoAnalyticsConnector.exe.config

Example:

<add key="licenseKey" value="0000000011111111:1654281610406"/>

QlikView GeoAnalytics extensions: 

C:\ProgramData\QlikTech\QlikViewServer\Extensions\Objects

or

C:\Users\YourAdminName\AppData\Local\QlikTech\QlikView\Extensions\Objects

or

Open the QV QMC  - Sytem - QlikView Servers -  Folders

Check the System Folder for "Alternate Extensions Path"

1. edit License file

Example

define([], function () {return '00000001111111';});

GeoAnalytics server
 C:\ProgramData\Qlik GeoAnalytics Server\server3\config\IdevioLicenses.lef

Please make sure all license information in the above files match. If not, please manually change it accordingly. 

Using Qlik GeoAnalytics Server:

Verify the license has been applied to the correct installation path. The extensions are stored in the StaticContent folder within the shared directory. To verify the path of the StaticContent folder, go to QMC > Service Cluster.

Run the license tool (C:\Program Files (x86)\QlikView\GeoAnalyticsLicenseTool) using Custom Installation with the path listed for Static Content root folder with '\extensions\' appended. 

Example: \\servername\Share\StaticContent\Extensions

After the license is applied successfully, go back to the app, refresh the page, and verify the map appears as expected.

When using Qlik Replicate 2024.5 Initial Release, SP01, and SP02, reading transactions from DB2 iSeries receivers and using ODBC driver 7.1.25 (aka iAccess13.64.25 and older), the decimal point in a Numeric/decimal fields in the target environment was in the wrong place. 

Example:

DB2 iSeries
     SOURCE Column:   ColA  decimal (9, 1) NOT NULL  
            Source Data  shows  20.0
            Target Data   shows 200.0 

Resolution

This is a known issue in Qlik Replicate starting with the version 2024.5 initial release. Qlik has supplied a fix in Qlik Replicate 2024.5 SP03.

Internal Investigation ID(s)

Product Defect ID: RECOB-8827 

Environment

• Replicate 2024.5 Initial Release
• Replicate 2024.5 SP01
• Replicate 2024.5 SP02

You are a prospective customer and are looking to purchase a Qlik Cloud subscription.

• See How to purchase Qlik Sense SaaS digital subscription.
• If you are looking to manage an active subscription, see Managing Your Subscription in My Qlik.

You are a prospective customer, having never purchased Qlik licenses before and are interested in learning more about Qlik products and making a purchase:

• Go to Qlik.com to browse our available offerings and engage in our Live Chat if you have questions.
• Or contact Sales directly.

You are an existing Customer, having previously purchased a license directly from Qlik and wish to purchase additional licenses or CALs:

• Please contact your Account Manager. If you are unsure who the Account Manager is for your company, contact Support using Live Chat.

You are an existing Customer and purchased your licenses through a third party (not directly from Qlik) and wish to purchase additional licenses or CALs:

• Please contact your Responsible Partner from which you previously purchased licenses. If you are unsure who your Responsible Partner is, contact Support using Live Chat.

Some script logs are not transferred to Archive log Folder.

Storage Locations:

Qlik Sense log folder:

C:\ProgramData\Qlik\Sense\Log\Script
Log names consist out of the AppID and a year, date, and timestamp.

Archived log Folder:

 \\SERVICECLUSTER-SHARE\ArchivedLogs\NodeName\Script
Log names consist out of the AppID and a year, date, and timestamp.

Environment:

• Qlik Sense Enterprise on Windows, all versions

Resolution:

By design, not all script logs are transferred to the Archived logs folder. Reloads executed from the hub are not transferred. 

1. When reloading data in app via hub, Script log will be left in Script log folder C:\ProgramData\Qlik\Sense\Log\Script

2. When reloading data via QMC/task, Script log will be transferred to Archived logs folder \\SERVICECLUSTER-SHARE\ArchivedLogs\NodeName\Script

Related Content:

• How to find the Script (Reload) logs in Qlik Sense Enterprise

PostgreSQL has identified a vulnerability (CVE-2025-1094) that allows for SQL injection under certain scenarios. For more information, see CVE-2025-1094: PostgreSQL quoting APIs miss neutralizing quoting syntax in text that fails encoding validation.

Resolution

To allow for quick mitigation of PostgreSQL vulnerabilities, Qlik offers the ability to run and manage your own PostgreSQL instance independently of what Qlik Sense Enterprise on Windows is shipped with. This allows for direct control of your PostgreSQL instance and facilitates maintenance without a dependency on Qlik Sense. Further Database upgrades can then be performed independently and in accordance with your corporate security policy when needed, as long as you remain within the supported PostgreSQL versions.

Recommendations

Upgrade PostgreSQL

If you have installed a standalone PostgreSQL database, or if you have used the Qlik PostgreSQL Installer (QPI) to upgrade and decouple your previously bundled database, then you can upgrade PostgreSQL at any time. This means you control maintenance and can immediately react to potential PostgreSQL security concerns by upgrading to a later service release or a later major version.

See Qlik Sense Enterprise on Windows: How To Upgrade Standalone PostgreSQL.

Verify your Qlik Sense Enterprise on Windows version's System Requirements before committing to a PostgreSQL version.

Unbundle and upgrade PostgreSQL 

This is the preferred method to gain direct control of your PostgreSQL instance. For instructions, see Upgrading and unbundling the Qlik Sense Repository Database using the Qlik PostgreSQL Installer.

Use a dedicated PostgreSQL database but retain the Qlik Postgre Service

The Qlik Sense Repository Database (QSR) can be moved to a dedicated standalone PostgreSQL instance not hosted on the same machine as other Qlik Sense Services. This will retain the Qlik Postgre Service. See How to configure Qlik Sense to use a dedicated PostgreSQL database for details.

Related Content

• System requirements for Qlik Sense Enterprise
• Qlik Sense Enterprise on Windows: How To Upgrade Standalone PostgreSQL 
• Upgrading and unbundling the Qlik Sense Repository Database using the Qlik PostgreSQL Installer 
• How to configure Qlik Sense to use a dedicated PostgreSQL database 

Internal Investigation ID(s)

SUPPORT-896

Environment

• Qlik Sense Enterprise on Windows

This video will demonstrate how to install and configure Qlik-CLI for SaaS editions of Qlik Sense.

Content:

• Requirements
• Installation method One
• Installation Method Two
• Enable the Completion Feature (optional, but useful)
• Use Qlik-CLI
• Related Content
• Transcript

Requirements

• The user has access to a Qlik Cloud tenant
• The user has a professional license assigned in the tenant
• The user has the developer role assigned (required for API access)
• An API key can be obtained

Installation method One

1. Download Qlik-CLI from GitHub
2. Copy the executable to a local directory
3. Add the Qlik-CLI as an Environment Variable Path. 
   1. Open your Windows Control Panel
   2. Navigate to System 
   3. Open Advanced system settings in the leftmost menu
   4. Click Environment Variables 
   5. Locate Path in the User's System variables 
   6. Click Edit
   7. Click New
   8. Add the path to Qlik-CLI for example C:\Tools\Qlik-QLI\Modify the User Environment. Add path to Qlik-CLI. ie "C:\Tools\Qlik-QLI\"
   9. Confirm with OK until all windows are closed
4. Confirm the Qlik-CLI location path to verify it the installation completed successfully 
   1. Open PowerShell
   2. Execute:
      

      get-command qlik​

   3. Closer PowerShell

Installation Method Two

1. Download and install Chocolatey as documented on chocolatey.org.
2. Open PowerShell
3. Execute:
   

   choco install qlik-cli

4. This completes the installation.

Enable the Completion Feature (optional, but useful)

1. Verify if a PowerShell profile exists or create a new one
   1. Open PowerShell
   2. Execute:
      

      if ( -not (Test-Path $PROFILE) ) {
         echo "" > $PROFILE
      }​

2. Open the profile with the command notepad $PROFILE:
   

   qlik completion ps > "./qlik_completion.ps1" # Create a file containing the powershell completion.
   . ./qlik_completion.ps1                      # Source the completion.​

3. Save it. 
4. Restart PowerShell

Use Qlik-CLI

Advanced and additional instructions as seen in the video can be found at Qlik-CLI on Qlik.Dev. Begin with Get Started.

This article provides some "tips" to troubleshoot issues related to Signing Commits and Tags with GPG in the standard Git storage mode.

To generate a trace

1. Create a file . options in the Talend Studio executable folder containing the following lines :

   # Main Debug Trace switch
   org.eclipse.egit.core/debug = true
   # General trace location for the EGit Core Plugin
   org.eclipse.egit.core/debug/core = true
   # Trace location for GPG signing
   org.eclipse.egit.core/debug/core/gpg = true
   # Trace location for the IndexDiffCache
   org.eclipse.egit.core/debug/core/indexdiffcache = true
   # Trace location for ResourceRefreshJob
   org.eclipse.egit.core/debug/core/refresh = true

2. Start the Studio from a cmd.exe using the command line :

   >Talend-Studio-win-x86_64.exe -debug

3. Check for a file named trace.log in the folder /.metadata
   
   <TalendStudioInstallation>\workspace\.metadata\trace.log

Resolution

Solution 1

Copy the file

                       <Users>\\.gnupg\pubring.kbx
into
                       <Users>\\AppData\Roaming\gnupg\pubring.kbx

Solution 2

Remove the folder %APPDATA%\gnupg

 rmdir C:\Users\\AppData\Roaming\gnupg 

Code used by org.eclipse.jgit.gpg.bc.internal.BouncyCastleGpgKeyLocator:

private static Path findGpgDirectory() {
        SystemReader system = SystemReader.getInstance();
        if (system.isWindows()) {
            // On Windows prefer %APPDATA%\gnupg if it exists, even if Cygwin is
            // used.
            String appData = system.getenv("APPDATA"); //$NON-NLS-1$
            if (appData != null && !appData.isEmpty()) {
                try {
                    Path directory = Paths.get(appData).resolve("gnupg"); //$NON-NLS-1$
                    if (Files.isDirectory(directory)) {
                        return directory;
                    }
                } catch (SecurityException | InvalidPathException e) {
                    // Ignore and return the default location below.
                }
            }
        }
        // All systems, including Cygwin and even Windows if
        // %APPDATA%\gnupg doesn't exist: ~/.gnupg
        File home = FS.DETECTED.userHome();
        if (home == null) {
            // Oops. What now?
            home = new File(".").getAbsoluteFile(); //$NON-NLS-1$
        }
        return home.toPath().resolve(".gnupg"); //$NON-NLS-1$
    }

Cause

1. The "home" used by Talend Studio may differ from the "home" used by the gpg.exe executable to store the keys generated, which may cause a Missing Signing Key error
   
   
   ErrorMissingSigningKey
      
   
   
2. Check the "home" used by Talend Studio :
   In the menu : Help > About > About Talend Studio
   Click the button "Installation details"
   Click the tab "Configuration"
   Enter "home" in the "type filter text" field
      
   HomeUsedbyTalendStudioandGPGExecution
3. Compare the key ID values in Studio and in GPG
   In the output console, identify the sec line, and copy the GPG key ID. It begins after the / character. In this example, the key ID is E3D14B0401F82F92 :

   sec   rsa3072/E3D14B0401F82F92 2023-09-29 [SC]
         458709B4010D7106D3A1D777E3D14B0401F82F92
   uid                 [ultimate] Denis SEGARD (--) 

   
   
   SigningKeySetting

4. After having called the external GPG program to generate the signature, the signature "returned" by the external program is verified. In order to verify the signature, jgit needs to access the KeyBoxFile

   pubring.kbx file is a keybox file used to store the public keys in a binary keyring. All public keys are stored in this file, whereas private keys are stored in individual files.

   On windows, If the folder %APPDATA%\gnupg exists , jgit will search for the KeyBoxFile in the folder %APPDATA%\gnupg.
   If the keys have been stored in a KeyBoxFile under /.gnupg instead of %APPDATA%\gnupg, this may lead to an error :

   
   ErrorCommittingChange
   
   In the Studio log:

   Caused by: java.io.IOException: External program failed ...
   ...
   Caused by: java.io.IOException: External GPG did not return a valid signature; got: ...

Related Content

For GPG key commit, please refer to Qlik Talend Help Documentation about:

signing-git-commits-and-tags-with-gpg

Environment

• Talend Data Integration 
• Talend Studio 

In this article, we will explain step by step in a scenario about How to Change the Secure Storage Directory in Talend Studio where Talend Studio is installed on a Windows machine.

1. Shutdown/ Stop Talend Studio
2. Add the following parameters to the first two lines of  Talend-Studio-win-x86_64.ini file
   When creating the keyring file, please make sure that the file type is a file.
   

   -eclipse.keyring (Set to override location of the default secure storage)
   {Path of your choice}\{File name of the key ring of your choice}

   
   
   For example, with the parameters added in step 2, the . ini file looks like the following:
   

   -eclipse.keyring
   configuration\.eclipse\org.eclipse.equinox.security\secure_storage(keyring.data)
   -vmargs
   -Xms512m
   -Xmx1536m
   -Dfile.encoding=UTF-8
   -Dosgi.requiredJavaVersion=17
   -Dtalend.studio.m2.clean=true
   -XX:+UseG1GC
   -XX:+UseStringDeduplication
   -XX:MaxMetaspaceSize=512m
   --add-modules=ALL-SYSTEM
   --add-opens=java.base/java.lang=ALL-UNNAMED

3. Start Talend Studio and check that the Storage location in Contents tab. It has been changed to the secure storage directory that you have specified in . ini file in step 2.
   Go to Window -> Preferences -> General (or Eclipse if you don't see General) -> Security -> Secure Storage -> Contents tab 

By default the secure storage file can be found at "~/.eclipse/org.eclipse.equinox.security/secure_storage" , but this can be changed, for details can refer to: How secure storage works . These values are encrypted based on secure store preference settings. 

Related Content

When you are failing with this issue 'A problem has occurred while accessing secure storage: no password provided'  please refer to this article here

Publishing-to-Talend-Cloud-A-problem-has-occurred-while-accessing=secure-storage

Environment

• Talend Studio 
• Talend Data Integration