Question  

Is there a limit on how many task deployments I can have on Qlik Talend Runtime Server?

No, there is no fixed limit.

Qlik Talend Runtime Server does not have a numerical limit on the number of deployed Data Services or Routes. However, the actual number of services that can be deployed and run concurrently depends on the available system resources (CPU, Memory, etc.) 

Environment

Talend ESB 

After applying a valid Signed License Key (SLK), the QlikView Server (QVS) remains Unlicensed in the QlikView Management Console. This occurs while a network proxy is used on the QlikView server host.

Resolution

This solution requires QlikView May 2024.

1. Navigate to %ProgramData%QlikTech\ManagementService\QVPR\ 
   
   
2. Locate LicenseService.xml and open it in an editor (may require administrative permissions)
   
   
3. Find the <LicenseService> section and modify the following parameter values to localhost:
   
   (A) ServerAddress="https://localhost:9200/"
   (B) ServerName="LicenseService@localhost"
   
   
   
   
4. Save the changes to LicenseService.xml
   
   
5. Navigate to %ProgramData%QlikTech\QlikviewServer\
   
6. Locate Settings.ini and open it in an editor (may require administrative permissions)
   
   
7. Find the [Authentication] section and change the following parameter's value to localhost:
   
   (C) NxServiceConnectionString=http://localhost:9200
   
   
   
   
8. Find the [Settings 7] section and change the following parameter's value to localhost:
   
   (D) LicenseServiceUrl=http://localhost:9200
   
   
   
   
9. Still in the [Settings 7] section, add the following parameter:
   
   CustomLicenseServiceUrl=http://localhost:9200
   
   The CustomLicenseServiceUrl parameter is required to prevent the QlikView server from reverting to default license service settings. 
   
   For details, see How to Modify the QlikView Server Settings.ini file.
   
   
10. Restart all QlikView services

Cause

QlikView cannot reach the license server when a network proxy is configured on the host machine. 

Internal Investigation ID(s)

SUPPORT-6241, QV-23738, QV-23918

Environment

• QlikView all versions

This article briefly introduces how to do transformation for Key Columns in Talend Cloud Data Integration

How To

1. Select the Replication Task, open the task and apply Global Transformation rules by clicking on "Add Transformation Rule" for the Replace Column value. Apply transformation for the key column.

   TransformationRule

2. Add a rule in the expression builder.

   RuleExpressionBuilder

3. Rule gets added for the Primary key column because the PK is defined in the Source.

   Expression

4. Suppose if applying same rule for another table where PK is not defined.And you explicitly define PK in the UI, you can notice that Rule has not been applied to the Primary key Column because the Global Rules will look in the source if the PK is defined or not, if defined it will add the rule for the corresponding PK Column.

   Expression2

5. To add the rule for the column, you need to go to expression builder at the table level and add the condition.

   Condition

6. Now you can see the Rule been added to the PK column which explicitly defined.

   Expression3

Environment

• Qlik Replicate 
• Talend Cloud 

When running a silent installation, Qlik Sense is installed without dialog prompts. This means all features, properties, and user selections are set before performing a silent installation. All setup options available in the installer user interface can be performed with silent operators.

For details, see:

• Performing a silent installation
• Performing a silent upgrade

The installation can be broken down into three steps.

Step 1: Prepare the installation in accordance with the Qlik Sense system requirements

1. Set up a shared folder. 
2. Ensure the folder is shared with the service account.
3. The service account should be a local administrator.

Step 2: Prepare the configuration file 

This file will be used in the next step and includes all remaining configuration settings. This must be configured for the installation to complete successfully. See Shared persistence configuration file syntax (choose your respective version).

We have attached an example file. You'll need to change 'xxx' to the shared folder network path. Please consider using a hostname or DNS name instead of localhost. 

Step 3: Execute the silent installation

Run CMD as an administrator, then provide the installation command with the required arguments. When building the command, do not forget to confirm that you have read the EULA with the argument accepteula(1|0). Customer agreements can be found at Legal Agreements.

Example script to execute a silent install:

Qlik_Sense_setup.exe [-silent] {-log "path\filename"} {layout="path"} {accepteula=1|0}{desktopshortcut=1|0} {skipstartservices=1|0} {installdir="path"} {userwithdomain="domain\user"} {userpassword="password} {dbpassword="password"} {hostname="www.machinename.domain.com"} {sharedpersistenceconfig="configfilepath"} {senddata=1|0} {skipvalidation=1|0} {databasedumpfile="path"}

Environment

With a Unified license (formerly called Dual Use License) the legacy QlikView license is complemented with a Qlik Sense license that can be applied to the QlikView server as it includes QlikView entitlement license attributes. Such license needs to be activated with the Signed License Key (SLK). When a customer enters an Analytics Modernization Program (AMP, formerly known as Dual Use program), QlikView CALs (e.g. Named User CALs, Document CALS, Session CALs and Usage CALs) are converted into Professional User, Analyzer User,  and Analyzer Capacity User allocations based on the Analytics Modernization Program conversion ratios.

Here are two scenarios:

I. If a customer transitions to AMP with on-premise (client-managed) Qlik software (e.g. converts to the perpetual estate or convert to subscription Qlik Sense Enterprise on Windows), a Unified License containing the converted quantity of Professional Users, Analyzer Users and Analyzer Capacity would be delivered. This license contains a customized Qlik Sense Enterprise Signed License Key (SLK) which can also be deployed on QlikView Server and/or QlikView Publisher. If a user is assigned a Professional or Analyzer user license, this assignment information is synchronized to all Qlik Sense and QlikView deployments activated using this Unified License key. As such one user just needs one license to access the entire Qlik software platform (regardless if it is Qlik Sense or QlikView).

In this scenario, as long as the QlikView Server and Qlik Sense edition use the same Identity Provider (IdP) the user can access apps on both environments consuming only one user license allocation.

If the user license is reallocated in any of the systems to a different user, the same will occur across both QlikView and Qlik Sense environments.

II. If a customer transitions to AMP with Qlik Sense Enterprise SaaS add-on, a Qlik Sense Enterprise SaaS tenant may use a Unified License  for the on-premise deployment. The customer is able to upload QlikView document prepared by the on-premise QlikView software directly into Qlik Sense Enterprise SaaS for distribution.

A QlikView Server or a Qlik Publisher software can be activated in two ways:

1) Using a legacy method with 16-digit QlikView license key and the corresponding control number

2) Using a modern Unified License with Signed License Key containing needed QlikView Server and Publisher Service attribute(s). In this latter scenario, user license assignment (Professional/Analyzer) and analyzer capacity would be synchronized with other deployments using the same Signed License Key as it is done in the Unified License model

If the customer opts to remain in Perpetual licensing, the existing QlikView license model can be retained. Otherwise, if the customer opts for conversion into Subscription licensing model, a set of QlikView subscription license attributes mirroring the existing QlikView perpetual license key setup would be delivered such that the customer switch to the subscription QlikView keys without the need for an immediate migration project towards using Unified licensing.

Note: Please note that Qlik is no longer starting clients on the Perpetual license model. See End of Perpetual License Sales 

Environment:

• QlikView 
• Qlik Cloud 
• Qlik Sense Enterprise on Windows 
   

Related Content:

• How to Apply an unified Signed License Key for QlikView and Qlik Sense
• Qlik Multi-Cloud Frequently Asked Questions (FAQ)

After upgrading to Qlik Sense Enterprise on Windows May 2023 (or later), the Qlik Sense Repository Service may cause CPU usage spikes on the central node. In addition, the central Engine node may show an increased average RAM consumption while a high volume of reloads is being executed. 

The Qlik Sense System_Repository log file will read:

"API call to Engine service was successful: The retrieved 'StaticByteSize' value for app 'App-GUID' is: 'Size in bytes' bytes." 

Default location of log: C:\ProgramData\Qlik\Sense\Log\Repository\Trace\[Server_Name]_System_Repository.txt

This activity is associated with the ability to see the Base memory size in the Qlik Sense Enterprise Management Console. See Show base memory size of apps in QMC.

Resolution

The feature to see Base memory size can be disabled. This may require an upgrade and will require downtime as configuration files need to be changed.

Take a backup of your environment before proceeding.

1. Verify the version you are using and verify that you are at least on one of the versions (and patches) listed: 
   
   
   • May 2023 Patch 13
   • August 2023 Patch 10
   • November 2023 Patch 4 
   • February 2024 IR
     
2. Back up the following files:
   
   
   • C:\Program Files\Qlik\Sense\CapabilityService\capabilities.json
   • C:\Program Files\Qlik\Sense\Repository\Repository.exe.config
     
     *where C:\Program Files can be replaced by your custom installation path.
     
     
3. Stop the Qlik Sense Repository Service and the Qlik Sense Dispatcher Service
   
4. Open and edit the capabilities.json with a text editor (using elevated permissions)
   1. Open C:\Program Files\Qlik\Sense\CapabilityService\capabilities.json
   2. Locate: "enabled": true,"flag": "QMCShowAppSize"
   3. Change this to: "enabled": false,"flag": "QMCShowAppSize"
   4. Save the file  
5. Open and edit the repository.exe.config with a text editor (using elevated permissions)
   1. Open C:\Program Files\Qlik\Sense\Repository\Repository.exe.config
   2. Locate: </appSettings>
   3. Before the </appSettings> closing statement, add:
      <add key="AppStaticByteSizeUpdate.Enable" value="false"/>
   4. Save
6. Start all Qlik Sense services
7. Verify you can access the Management Console

If any issues occur, revert the changes by restoring the backed up files and open a ticket with Support providing the changed versions of repository.exe.config, capabilities.json mentioning this article. 

Related Content

Show base memory size of apps in QMC

Internal Investigation:

QB-22795
QB-24301

Environment

Qlik Sense Enterprise on Windows  May 2023, August 2023, November 2023, February 2024. 

You may encounter an error : 400 - Invalid SNI when calling Talend Runtime API (Job as service) after installed 2025-02 patch or later. In the past before the patch version R2025-02 of Talend Runtime Server, it did work well when using the same certificate for SSL connection with Talend Runtime Server and did not cause any issue. 

The SNI validation is active after 2025-02 patch or later.

Resolution

There are three options to slove this issue

1. Obtain and install a proper certificate that references the correct host name and then access it with the hostname rather than by IP.
2. Disable SNI host check.
3. Tell Talend component to resolve IP as hostname

Disable SNI Host Check

This has the same security risk as jetty before it was updated (low security)

In <RuntimeInstallationFolder>/etc/org.ops4j.pax.web.cfg file, please add

jetty.ssl.sniRequired=false

and 

jetty.ssl.sniHostCheck=false

Or configuring these jetty parameters in <RuntimeInstallationFolder>/etc/jetty.xml or jetty-ssl.xml file

• Find the <New class="org.eclipse.jetty.server.SecureRequestCustomizer"> block in your jetty.xml or jetty-ssl.xml 
  
  
• Edit the <Arg name="sniRequired" ...> and <Arg name="sniHostCheck" ...> lines so that the properties' defaults are set to false as shown below:
  
  

  <New id="sslHttpConfig" class="org.eclipse.jetty.server.HttpConfiguration">
  <Arg><Ref refid="httpConfig"/></Arg>
  <Call name="addCustomizer">
  <Arg>
  <New class="org.eclipse.jetty.server.SecureRequestCustomizer">
  <Arg name="sniRequired" type="boolean">
  <Property name="jetty.ssl.sniRequired" default="false"/>
  </Arg>
  <Arg name="sniHostCheck" type="boolean">
  <Property name="jetty.ssl.sniHostCheck" default="false"/>
  </Arg>
  <Arg name="stsMaxAgeSeconds" type="int">
  <Property name="jetty.ssl.stsMaxAgeSeconds" default="-1"/>
  </Arg>
  <Arg name="stsIncludeSubdomains" type="boolean">
  <Property name="jetty.ssl.stsIncludeSubdomains" default="false"/>
  </Arg>
  </New>
  </Arg>
  </Call>
  </New>

  

Resolve IP to Hostname

If the certification includes the domain name, you should use that domain name instead of the IP with the Jetty security updates in Talend Runtime Server.

But if your DNS server does not resolve the IP, you must call it by the IP address, so please check it at first to see if the workaround is feasible for your current situation.

In the examples the hostname is unresolvedhost.net and the IP is 10.20.30.40.

Try this API call at the command line:

curl -k -X GET --resolve unresolvedhost.net:9001:10.20.30.40 https://unresolvedhost.net:9001/services/

or

curl -k -X GET -H "Host: unresolvedhost.net" https://10.20.30.20:9001/services/

If this works, in your Talend component that makes the API call, go to "Advanced settings" or "Headers" table, add a row with Key: Host and Value: The hostname that matches your SSL certificate (e.g. unresolvedhost.net)

This will instruct Talend to send the correct Host header, which most HTTP clients (including Java's HttpClient) will also use as the SNI value during the TLS handshake.
 

Cause

The SNI enforcement is there for a security reason. With the 2025-02 patch, the Jetty components on Talend Runtime Server resolved a CVE security issue where they allowed a hostname to connect to a server that doesn't match the hostname in the server's TLS certificate.

Certificates require the URI not to be localhost or an IP address, and to have at least one dot, so a fully qualified domain name is best.

Related Content 

 https://stackoverflow.com/questions/69945173/org-eclipse-jetty-http-badmessageexception-400-invalid-sni

Environment

Talend ESB 

Your Shopify integration encounters the following extraction error:

HTTPError GraphQL request failed for stream 'order_refunds' with status 504 and X-Request-ID '...', Reason: Gateway Timeout - upstream request timeout.

Resolution

If this issue is recurring and disrupting your workflow, please contact Qlik Support. We also recommend reaching out to Shopify Support with the X-Request-ID included in the error message.

This dual approach is important because:

1. Qlik Support cannot discuss user-specific data with third-party services.
2. Shopify can provide detailed insight into the error, which may help R&D implement changes aligned with their best practices.

Cause

Shopify’s API is timing out due to the volume of data it needs to return in response to Stitch’s requests. This is most commonly observed with the orders and order_refunds streams, which tend to contain large amounts of data in many stores.

Environment

Stitch 

An SQL Server backup file is considered striped if it consists of multiple files or if it was generated from multiple files appended into a single bak file.

This means the backup files will contain the same LSNs for each of those files.

Qlik Replicate cannot process these multiple files with the same LSN.

The following error will occur when Qlik Replicate encounters striped backup files:

00012300: 2025-11-04T20:22:28:558929 [SOURCE_CAPTURE ]E: do_log_processing_direct(...) 2 multiple family members (=stripes) encountered in backup set while only 1 can be handled. [1020440] (sqlserver_log_processor.c:4685)

Resolution

Skip the LSN and start from another LSN or timestamp. Note that this will lead to a data gap for the LSN that was skipped.

You can also choose to do a full reload.

Cause

Striped backups are a result of SQL Server configurations. Please consult with your DBA on backup configurations.

Environment

• Qlik Replicate

Unable to resume Qlik Replicate tasks due to the error below:

00020080: 2023-08-16T13:55:07 [SOURCE_CAPTURE ]I: Start processing new RESETLOGS_ID 'xxxxxxxxx' that does not still have archived Redo logs (oradcdc_thread.c:430)

Resolution

The internal parameter supportResetLog is currently set to true. When a failover happens, the redo log ID will be reset to zero.

• With supportResetLog set to true, Qlik Replicate will search from zero when it cannot find the next redo log.
• With supportResetLog set to false, Qlik Replicate will keep searching for the next redo log until it appears or the task times out. This setting resolved the "Start processing new RESETLOGS_ID 'xxxxxxxxx' that does not still have archived Redo logs" error. 

To set the Internal Parameter:

1. Go to the Oracle Source Endpoint
2. Switch to the Advanced tab
3. Click Internal Parameters
4. Add:
   
   Parameter: supportResetLog
   Value: uncheck the box (set to false) 
   
   
   
   For more information on Internal Parameters, see Qlik Replicate: How to set Internal Parameters and what are they for?
   
   
5. Save and exit. The change will take effect once the tasks using this endpoint are stopped and resumed.

Environment

• Qlik Replicate
• Oracle Database as a Source

The goal of this article is to address the upcoming changes announced by Marketo regarding the deprecation of authentication via the access_token query parameter, which will no longer be supported after January 31, 2026. For further details, please refer to: Using an Access Token | Marketo Developer Guide.

Marketo specificities: "If your project uses a query parameter to pass the access token, it should be updated to use the Authorization header as soon as possible. New development should use the Authorization header exclusively".

The Stitch Marketo integration (V2) already handles authentication using access tokens, as outlined in Marketo’s documentation. Specifically, Stitch includes a Bearer token in the Authorization header of its API calls. This approach complies with Marketo’s authentication requirements, so no additional configuration is needed on your end.

For reference, please visit the integration's repository | github.com.

During the extraction process of your HubSpot integration, the following error was encountered:

requests.exceptions.HTTPError: 500 Server Error: Internal Server Error for url <CustomURL>

...

Giving up on request after {} tries with url {} and params {}

Resolution

This error may be transient. However, if it is recurring frequently enough to disrupt your workflow, please reach out to Qlik Support.

Cause 

The HubSpot API is having issues processing the amount of data compiled based on the request sent by Stitch.

Environment

• Stitch 

A space owner can edit apps owned by other users, but cannot edit the scripts. The option to access the Data Load Editor is not present:

Resolution

Explicitly assign the Can edit data in applications space role. See Working in shared spaces | help.qlik.com for details.

Cause

The Owner role implicitly gives access to all other actions on the space except this one. This is designed to prevent owners from accidentally accessing another user's script without them or another space manager taking explicit responsibility.

Environment

• Qlik Cloud Analytics

Qlik Sense Enterprise Client-Managed offers a range of Monitoring Applications that come pre-installed with the product.

Qlik Cloud offers the Data Capacity Reporting App for customers on a capacity subscription, and additionally customers can opt to leverage the Qlik Cloud Monitoring apps.

This article provides information on available apps for each platform.

Content:

• Qlik Cloud
• Data Capacity Reporting App
• Access Evaluator for Qlik Cloud
• Answers Analyzer for Qlik Cloud
• App Analyzer for Qlik Cloud
• Automation Analyzer for Qlik Cloud
• Entitlement Analyzer for Qlik Cloud
• Reload Analyzer for Qlik Cloud
• Report Analyzer for Qlik Cloud
• How to automate the Qlik Cloud Monitoring Apps
• Other Qlik Cloud Monitoring Apps
• OEM Dashboard for Qlik Cloud
• Monitoring Apps for Qlik Sense Enterprise on Windows
• Operations Monitor, License Monitor, and Content Monitor
• App Metadata Analyzer
• The Monitoring & Administration Topic Group
• Other Apps

Qlik Cloud

Data Capacity Reporting App

The Data Capacity Reporting App is a fully supported app distributed within the product. For more information, see Qlik Help.

Access Evaluator for Qlik Cloud

For more information, see Qlik Cloud Access Evaluator.

Answers Analyzer for Qlik Cloud

For more information, see Qlik Cloud Answers Analyzer.

App Analyzer for Qlik Cloud

For more information, see Qlik Cloud App Analyzer.

Automation Analyzer for Qlik Cloud

For more information, see Qlik Cloud Automation Analyzer.

Entitlement Analyzer for Qlik Cloud

The Entitlement Analyzer is a Qlik Sense application built for Qlik Cloud, which provides Entitlement usage overview for your Qlik Cloud tenant for user-based subscriptions.

The app provides:

• Which users are accessing which apps
• Consumption of Professional, Analyzer and Analyzer Capacity entitlements
• Whether you have the correct entitlements assigned to each of your users
• Where your Analyzer Capacity entitlements are being consumed, and forecasted usage

For more information, see The Entitlement Analyzer.

Reload Analyzer for Qlik Cloud

For more information, see Qlik Cloud Reload Analyzer.

Report Analyzer for Qlik Cloud

For more information, see Qlik Cloud Report Analyzer.

How to automate the Qlik Cloud Monitoring Apps

Do you want to automate the installation, upgrade, and management of your Qlik Cloud Monitoring apps? With the Qlik Cloud Monitoring Apps Workflow, made possible through Qlik's Application Automation, you can:

1. Install/update the apps with a fully guided, click-through installer using an out-of-the-box Qlik Application Automation template. 
2. Programmatically rotate the API key that is required for the data connection on a schedule using an out-of-the-box Qlik Application Automation template. This ensures that the data connection is always operational. 
3. Get alerted whenever a new version of a monitoring app is available using Qlik Data Alerts. 

For more information and usage instructions, see Qlik Cloud Monitoring Apps Workflow Guide.

Other Qlik Cloud Monitoring Apps

OEM Dashboard for Qlik Cloud

For more information and to download the app and usage instructions, see Qlik Cloud OEM Dashboard & Console Settings Collector.

With the exception of the Data Capacity Reporting App, all Qlik Cloud monitoring applications are provided as-is and are not supported by Qlik. Over time, the APIs and metrics used by the apps may change, so it is advised to monitor each repository for updates and to update the apps promptly when new versions are available.

If you have issues while using these apps, support is provided on a best-efforts basis by contributors to the repositories on GitHub.

Monitoring Apps for Qlik Sense Enterprise on Windows

Operations Monitor, License Monitor, and Content Monitor

The Operations Monitor loads service logs to populate charts covering the performance history of hardware utilization, active users, app sessions, results of reload tasks, and errors and warnings. It also tracks changes made in the QMC that affect the Operations Monitor. 

• Basic information can be found in Operations Monitor | help.qlik.com
• Detailed descriptions of sheets and visualizations are accessible in the About the Operations Monitor story available from the app overview page under Stories

The License Monitor loads service logs to populate charts and tables covering token allocation, usage of login and user passes, and errors and warnings.

• Basic information can be found in License Monitor | help.qlik.com  
• Detailed descriptions of sheets and visualizations are accessible in the About the License Monitor story available from the app overview page under Stories

The Content Monitor loads from the APIs and logs to present key metrics on the content, configuration, and usage of the platform, allowing administrators to understand the evolution and origin of specific behaviors of the platform.

• Basic information can be found in Content Monitor | help.qlik.com  
• Each sheet in the Content Monitor includes an About text box to describe its content. 
  

All three apps come pre-installed with Qlik Sense. 

If a direct download is required: Sense License Monitor | Sense Operations Monitor | Content Monitor (download page). Note that Support can only be provided for Apps pre-installed with your latest version of Qlik Sense Enterprise on Windows. 

App Metadata Analyzer

The App Metadata Analyzer app provides a dashboard to analyze Qlik Sense application metadata across your Qlik Sense Enterprise deployment. It gives you a holistic view of all your Qlik Sense apps, including granular level detail of an app's data model and its resource utilization.

Basic information can be found here: 

App Metadata Analyzer (help.qlik.com)

For more details and best practices, see: 

App Metadata Analyzer (Admin Playbook)

The app comes pre-installed with Qlik Sense.

The Monitoring & Administration Topic Group

Looking to discuss the Monitoring Applications? Here we share key versions of the Sense Monitor Apps and the latest QV Governance Dashboard as well as discuss best practices, post video tutorials, and ask questions.

Monitoring & Administration 

Other Apps

LogAnalysis App: The Qlik Sense app for troubleshooting Qlik Sense Enterprise on Windows logs 
Sessions Monitor, Reloads-Monitor, Log-Monitor 
Connectors Log Analyzer 

All Other Apps are provided as-is and no ongoing support will be provided by Qlik Support.

The existing 'has restricted view' space role can export data to Excel. If you do not wish for users with the 'has restricted view' space role to be able to export data, you will need to edit the User Default role to deny download for all users, and then create a custom role that allows it for specific users and groups.

Steps

1. Go to the Administration activity center
2. Go to Manage users
3. Go to Permissions 
4. Click User Default 
   
   
   
   
5. Expand Content Types
6. Expand Applications
7. Set In-app content download to Not Allowed 
8. Click Confirm 
   
   

   This has now changed the default user behavior across the tenant. Users will no longer be able to download in-app content.

9. Back in the Permissions view, click Create New
   
   
   
   

   This creates a new role that you will need to assign to any users who should have the permission to download in-app content.

10. Name your New Role, then expand Content Types
11. Expand Applications
12. Set In-app content download to Not Allowed 
13. Click Confirm
    
    
    
    
14. Assign users or groups to the new custom role 
    
    See Assigning security roles and custom roles to users for details.

There is no function to restrict downloading by apps or spaces.

Related Content

• Assigning security roles and custom roles
• Permissions in User Default and custom roles
• 'In-app content download' permission: Additional details
• Assigning security roles and custom roles to users

Environment

• Qlik Cloud Analytics

The following two items were deprecated in June 2025:

• Developer role
• Enable API keys toggle

The deprecation notice was communicated in an Administration announcement and documented on our What's New in Qlik Cloud feed. See Developer role and API key toggle deprecated | 6/16/2025 for details.

What products are affected by the removal of the role and toggle?

• Qlik Cloud Analytics
• Qlik Talend Cloud

What actions do I need to take?

To replace the deprecated built-in role, migrate your users away from the Developer role to a Custom Role with the required permissions (Manage API Keys).

To create and assign a replacement custom role:

1. In the Administration activity center, go to Manage users
2. On the Permissions tab, select Create new
3. Name the role using your organization's naming convention
4. Set Manage API keys to Allowed
5. Assign the role to users or groups who previously had the deprecated role
6. Remove the deprecated role from those users or groups

For additional reading on the Managed API Keys (set to Not allowed by default), see Permissions in User Default and custom roles | Permission settings — Features and actions.

When will the deprecated items be removed?

The Developer role and Enable API keys toggle will be removed in the coming weeks in line with the original announcement aiming for the end of 2025.

What will happen if we fail to migrate?

Once the Developer role has been removed, users who have not been updated to use the “Manage APK keys” = Allow permission will:

• Be unable to access the API keys UI in Profile > Settings
• Find their API keys disabled, resulting in 3rd-party integrations failing

API keys are not deleted from Qlik Cloud and will automatically be re-enabled once a user has been assigned the required Manage API Keys permissions.

To resolve this, a Tenant Administrator needs to act as outlined in What action do I need to take?

Environment

• Qlik Cloud Analytics
• Qlik Talend Cloud

Qlik Replicate SQL Server target faces the following truncation error:

Failed sending row to table SS.TABLE1
RetCode: SQL_SUCCESS SqlState: 22001 NativeError: 0 Message: [Microsoft][ODBC Driver 18 for SQL Server]String data, right truncation

Resolution

Increase precision enough for the target SQL Server column. This can be achieved in the Qlik Replicate UI transform tab in table settings, or by modifying it directly in the target DB:

ALTER TABLE [SS].[TABLE1]
ALTER COLUMN [AA] NUMERIC(9,4) NOT NULL;
ALTER TABLE [SS].[TABLE1]
ALTER COLUMN [BB] NUMERIC(12,4) NOT NULL;

Troubleshooting and Cause

Checked column precision control/transfer to target, the target precision is too small, which could not hold the numbers from the source, and causes the error.

==source ibm ==
UUBTCPP AA 19 DECIMAL 5
UUBTCPP BB 20 DECIMAL 8

DECIMAL(p) floating point

When you define a column with the DECIMAL(p) data type, it has a total of p (< = 32) significant digits. DECIMAL(p) has an absolute value range 10^-130 - 10^124.

DECIMAL(5,0): Could store a 5-digit whole number like (12345) or (-99999).
DECIMAL(5,5): Could store a number like 0.12345 or 0.00001

==target sqlserver ==
[AA] [numeric](7, 4) NOT NULL,
[BB] [numeric](8, 4) NOT NULL,

3-digit integer at maximum and 4-digit float --> (7,4)
4-digit integer at maximum and 4-digit float -->(8,4)

For example, the source column AA value=99999 , but the target can only hold a 3-digit integer, which will trigger the truncate mechanism. 

Environment

• Qlik Replicate

Creating a connection to Azure Databrics using Azure OAuth authentication mechanism fails with the error:

Code verification failed: Error making token request. An error occurred while sending the request

Resolution

1. Follow the steps in Create a Databricks connection, specifically Databricks configuration for OAuth.
2. Follow the steps in Configure an OpenID Connect OAuth application from Microsoft Entra app gallery | learn.microsoft.com.
3. Verify the following have been allowed on the Azure side:
   • https://login.microsoftonline.com/..../oauth2/authorize 
     You can verify the complete URL using your browser developer tool.
   • https://connector.qlik.com/auth/oauth/v2.htm/

Environment

• Qlik Sense Enterprise on Windows
• Qlik Cloud Analytics

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

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

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

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