Qlik Alerting November 2024 SR 1

 

Release Date: 28 Jan 2025

 

Update in this version

New Feature

Qlik Alerting on Windows should be able to connect to Qlik Sense Enterprise on Windows, November 2024 IR onwards.

Compatibility with related products

Recommended version of Qlik Sense Enterprise on Windows is May 2023 or later.

This version of Alerting is also supported with NodeJS 22.12.0 onwards.

For a detailed and updated list of supported mobile operating systems, devices, and compatibility with Qlik Sense Enterprise, please refer to Qlik Sense system requirements and supported browsers on help.qlik.com.

 

Downloads

Download this release from the Product Downloads page on Qlik Community.

 

Known Issues and Limitations

The following issues and limitations were identified at release time. The list is not comprehensive but includes all known major issues and limitations.

• User should use the same URL to access Qlik Alerting as the one used in External Product Sign-On in QMC.
• User should use the similar URL to access the Qlik Alerting which is used in External Product Sign in QMC. i.e., if it is configured using machine_name or IP/api_endpoints then one should use the same machine_name or IP while accessing the alerting server to setup the SSO.
  
  For example, in QMC if we have entries as https://domainname:4552/api/users/authQXSession then we should have accessed Qlik Alerting like https://domainname:4552 this instead of https://localhost:4552.
• There are some scenarios where it requires to make some virtual proxy settings for the new Security Approach taken by Qlik Alerting Extension. Please refer the documentation for configuration of virtual proxy and settings as mentioned in the document as there are some limitations on the Forms authentication.

 

General

• There are some instances where special characters in the virtual proxy prefix for Qlik Sense are not recognized. For example, the test data d/e/v for a virtual proxy prefix is not supported.
• When an alert, which is linked to a Qlik Sense application, is shared with a user who does not have access to the application, the accept link in the email results in an error message. The record is created and displayed in the user’s list of alerts. However, it will not trigger because it cannot connect to the application with that user’s credentials.

 

Web User Interface

The mobile app does not currently switch to landscape mode when the device is turned horizontally.

• Datetime fields are presenting differently in different browsers. This is the default behavior of the browser, but it might be difficult for a user to understand. For example, the format is YYYY-MM-DDTHH:MI: SS in Safari.
• In some browsers, the table is not refreshed when an alert is duplicated. You can refresh the browser and the new record with be shown with (copy)next to it.

 

Qlik Alerting Mobile Application

There seem to be some scenarios where the deep links to Qlik Sense mobile (QSM) or to the browser (where QSM is not installed) do not work fully. This could, for example, be caused by special characters in the dimension name.

• The mobile app deep links to Qlik Sense Mobile do not work correctly on the iPad Pro iOS.

 

 

About Qlik

Qlik converts complex data landscapes into actionable insights, driving strategic business outcomes. Serving over 40,000 global customers, our portfolio provides advanced, enterprise-grade AI/ML, data integration, and analytics. Our AI/ML tools, both practical and scalable, lead to better decisions, faster. We excel in data integration and governance, offering comprehensive solutions that work with diverse data sources. Intuitive analytics from Qlik uncover hidden patterns, empowering teams to address complex challenges and seize new opportunities. As strategic partners, our platform-agnostic technology and expertise make our customers more competitive.

qlik.com

 

 

Show Less

Table of Contents

• Improvements
• Resolved Defects
• Known issues and limitations
• Upgrade notes
• Downloads

 

The following release notes cover the versions of Qlik NPrinting released in May 2023 Service Release 7.

Improvements

Time zones updated to 2024b

Jira issue ID: OP-96047

The list of time zones is updated to IANA 2024b.

Qlik NPrinting Repository (PostgreSQL) updated

Jira issue ID: QB-30635

The Qlik NPrinting Repository service version of PostgreSQL is upgraded to 13.18-1

Resolved Defects

Internal server error (500) when trying to open Qlik NPrinting Designer

Jira issue ID: QB-30815

The error message "HTTP call error sending request...InternalServerError (500)” appeared when trying to edit any report in Qlik NPrinting Designer in an installation with approximately 65,000 or more user filters.

Customized session expiration time was not applied correctly

Jira issue ID: OP-96057

The customized value of the parameter session.expires in the webconsoleproxy.app.conf configuration file was not applied correctly by the Qlik NPrinting proxy after the Qlik NPrinting May 2023 Initial Release.

Password change experience improved

Jira issue ID: QB-31068

The changing password experience via user interface executed by a user with the related privilege was improved.

Password changes via users import task are excluded.

The first native Excel formula was modified

Jira issue ID: OP-10085

The first Excel native formula in a template was modified during the report generation resulting in incorrectly displayed data. The following formulas were calculated correctly.

Known issues and limitations

The following issues and limitations were identified at release time. The list is not comprehensive; it lists all known major issues and limitations. We expect to have these issues fixed in future versions.

Supported languages

The following languages are supported:

• English
• French
• German
• Spanish
• Brazilian Portuguese
• Japanese
• Italian
• Simplified Chinese

Other languages are not officially supported. There may be issues with other languages, particularly those with right-to-left script and non-Roman alphabets.

Qlik Sense custom size sheets

Qlik Sense custom size sheets are not supported. Custom size will not be maintained on export.
Alternate states
QlikView and Qlik Sense alternate states are not supported.

Alternate states

QlikView and Qlik Sense alternate states are not supported.

Qlik NPrinting must be installed only on C: drives

Jira issue ID: OP-6196
Qlik NPrinting Server, Engine, and Designer can only be installed on C: drives. Any attempt to install them on a different drive will result in task failures.

Image size settings are not respected when adding the same object twice

Jira issue ID: OP-5831
When you add the same object twice, using the Images node in Qlik NPrinting Designer, only the image size property of the first image is respected.

QlikView On-Demand reports cannot be connected to Qlik Sense

It is possible to select the “Enable” check box in On-Demand for reports using Qlik Sense app data. These reports are visible in the QlikView On-Demand menu of the QlikView On-Demand add-on. But if selected, they will not generate reports, and you will see an error message.

Qlik NPrinting Designer crashes sometimes with zoomed screen settings

If you experience random crashes when using Qlik NPrinting Designer, open your Windows Display Settings in the Control Panel and verify that Smaller – 100% (default) is selected. When settings of 125% or 150% are selected, Qlik NPrinting Designer may crash.

On-Demand works in Chrome and Firefox, but not in Internet Explorer (11 or older) or Edge

Jira issue ID: OP-5908
In some cases, when you use Qlik NPrinting On-Demand in Internet Explorer 11 or Edge, the “origin” HTTP header is not generated. This results in the error message “REVEL_CSRF: tokens mismatch”.
The workaround is to install Qlik NPrinting On-Demand on a Microsoft IIS server hosting QlikView Access point or use a different web browser.

Too many users and filters leads to Qlik NPrinting Designer errors

Jira issue ID: OP-4940
Qlik NPrinting Designer may be unable to open a report template if there are too many filters associated with a connection in the report's app. The following error message displays: “A task was canceled”.
This typically happens when more than 4000 filters are using fields from a connection. Sometimes, higher numbers can work. For example, 7000 filters have worked in some situations.
The workaround is:
1. Split the Qlik NPrinting app into separate apps.
2. Split the connections (possibly by using multiple connections to the same documents in different apps).
3. Split the filters across apps (so that the filter count per app is lower).

Task fails with the error 'Exceeded maximum number of retries'

Jira issue ID: OP-4839
Some Qlik NPrinting tasks fail with the error message: “Exceeded maximum number of retries”. This is due to a performance issue in QlikView that appears when it exports large unfiltered files to Excel.

Verify connection freezes during “Initializing…” status

Jira issue ID: OP-5278
In some rare circumstances, pressing the Verify connection button will cause the screen to freeze on the “Initializing…” status and the spinning wheel cursor. This happens when a Qlik NPrinting Engine goes offline and Verify connection is pressed before the Qlik NPrinting Scheduler is aware that it is offline. It can take up to 20 seconds before the Qlik NPrinting Scheduler determines the offline status of a Qlik NPrinting Engine.

User filters are excluded from matching and object filters

Jira issue ID: OP-5914
When you:

• Open Qlik NPrinting Designer
• Import a report

The filters associated with each user are not uploaded, or displayed, for performance reasons. Waiting for all filters for thousands of users to import would take a long time. In most cases, importing this information is unnecessary, because filters created for users often contain something like the user IDs. You can change this behavior and make all filters visible by uncommenting the line <!--<add key="include-user-filters" />--> in the webengine.config file.
To make a specific filter visible in the lists, remove its association to all users, or create a new filter with the same fields and values not linked to any user.

Cancelling an upgrade results in a corrupted environment

Jira issue ID: OP-3986
The rollback that follows a Qlik NPrinting Server or Engine upgrade cancellation may corrupt the related Qlik NPrinting installation. A rollback is triggered by errors or by clicking the cancel button during the upgrade execution. After a corruption caused by a rollback, services may be uninstalled or cannot be started.
To restore a Qlik NPrinting Server to its original status:

• Retrieve a recent backup
• Uninstall Qlik NPrinting Server
• Perform a clean installation of the same Qlik NPrinting Server of the backup
• Restore the backup

You should always create a backup before starting an update. In any case, a backup is automatically created in the folder "%ProgramData%\NPrinting" at the beginning of the upgrade process. To restore a Qlik NPrinting Engine to original status:

• Uninstall Qlik NPrinting Engine
• Perform a clean installation of Qlik NPrinting Engine

Adding a title to a Sense object with Assistance on generates an error on preview or task

Jira issue ID: OP-7560
Add title functionality is not supported on Qlik Sense objects with Assistance mode enabled. The workaround to restore the Add title functionality is to disable Assistance mode for the chart in Qlik Sense. Then reload the metadata of the connection.

Cannot export tables, columns, and cells from Qlik Sense objects made using chart suggestions

Jira issue ID: OP-7568
Qlik Sense objects made in Assistance mode cannot be used as tables, columns, or cells in Qlik NPrinting. To restore them, disable Assistance mode on the chart in Qlik Sense; then reload the metadata of the connection. Furthermore, if a Qlik Sense object made with Assistance mode is exported as a table, column, or cell using Qlik NPrinting APIs, the request will fail.

Open Type Fonts (*.otf) are not supported

Jira issue ID: OP-7165
Open Type Fonts (*.otf) are not supported in PixelPerfect templates. Generated reports will use a different font, and not look as expected.

Qlik Sense tables with conditionally shown columns have limited functionality

Jira issue ID: OP-7747
The following functionalities are not supported for Qlik Sense tables that have a "Show column if" condition set on one or more of their columns: levels, single column export, and keep source formats.

Qlik Sense On-Demand reports with selections on calculated dimensions fails

Jira issue ID: OP-8382
Qlik Sense On-Demand reports with selections applied on calculated dimensions will fail. However, you can apply selections on dimensions based on Qlik Sense fields. The workaround is to move the formula to the load script and use the calculated fields to apply selections to your On-Demand reports.

Qlik Sense histograms cannot be add into the Tables node

Jira issue ID: OP-8985
Due to the internal way of exporting Qlik Sense histograms, you cannot add them to the Qlik NPrinting Designer Tables node. If you add a Qlik Sense histogram to the Tables node, you will not receive any errors or warning messages, but the exported data will be wrong.

QlikEntities limitation with Qlik Sense entities

Jira issue ID: OP-8921
QlikEntity reports support Qlik Sense objects with the following limitations:

• Containers are not supported, but you can use all the objects that are inside containers.
• Qlik Sense sheets can be added to QlikEntity reports and exported as images. The "Extend Sheet" feature does not work.
• Export in PDF and TIFF is not supported.

Embedding Excel worksheets into PowerPoint templates is not supported

Jira issue ID: OP-9087
You cannot embed an Excel worksheet in a PowerPoint report template. This will cause a Qlik NPrinting Designer crash. The workarounds are to insert the Excel worksheet without using the Qlik NPrinting Designer:

• Create a .pptx file by using PowerPoint without involving the Qlik NPrinting Designer. Insert the Excel worksheet and save the .pptx. Then use the .pptx file as a report template.
• If you have already created the PowerPoint template, export it, open the .zip file generated by Qlik NPrinting and double-click the .pptx file inside. Insert the Excel worksheet, save the resulting PowerPoint and overwrite the exiting Qlik NPrinting template by uploading the updated .zip.

Qlik Sense dynamic views limitations

Jira issue ID: OP-9067
Dynamic views is a new Qlik Sense feature starting from June 2020.
If you connect Qlik NPrinting to a Qlik Sense app that contains a chart used to generate dynamic views, the chart and the containing sheet are excluded from the Qlik NPrinting connection cache and cannot be used in reports.
You can connect Qlik NPrinting to a Qlik Sense app containing dynamic views. However, after a dynamic view refresh, the connection will stop working.

Reports size limit

Jira issue ID: OP-9628
Starting from November 2020, RabbitMQ Server (deployed as Qlik NPrinting Messaging Service) has been updated to version 3.8.3. It has an internal limit, not configurable, about messages size of 512MB. Previous limit was 2GB. As consequence, is not possible to generate Qlik NPrinting reports bigger than 512MB.

Excel print area with more than one range

Jira issue ID: OP-9766
Excel worksheet print areas can contain more than one range if the generation of the report does not expand the print area. If it expands, you will see an error: “Invalid Cell Name”. For example, the default setting of the Expand Range option in a Qlik NPrinting table causes the print area to change during report production, and an error is received.

Searching in Cyrillic characters is case sensitive

Jira issue ID: OP-9518
Using Cyrillic characters in the Search form of the Qlik NPrinting user interface is case sensitive.

The percentage "%" format is not kept in Excel reports

Jira issue ID: OP-9995
The percentage “%” format is not kept in Excel reports when using QlikView 12.50 (12.50.20000) or newer due to a QlikView issue. You can solve this by upgrading to QlikView May 2021 SR2 (12.60.20200) or newer.

Run verification does not check if the installed version of QlikView Desktop supports QVF

Jira issue ID: OP-95599

If you start a Run Verification on a connection to a QlikView document in QVF format, Qlik NPrinting cannot confirm whether the QlikView Desktop version installed locally on each Qlik NPrinting Engine is compatible with QVF file format. The check mark next to "QlikView can open the document" may be green, even if a version of QlikView that does not support QVF is installed. This is because verification only checks file permissions. If the installed QlikView Desktop does not support QVF format, metadata generation will fail.

 QlikView objects with many fields with the same label are not supported

Jira issue ID: OP-95682

QlikView objects with many different fields with exactly the same label are not supported. Duplicated labels cause an exception during the connection cache generation. To solve this issue, ensure that each field has a unique label.

Images defined by URL in Qlik Sense tables are exported as text

Jira issue ID: OP-95797

Images linked by using URLs in Qlik Sense tables are exported as text. This affects only Qlik Sense connections. A workaround exists for PixelPerfect templates.

Microsoft Sensitivity Labels Are Not Supported

Jira issue ID: HLP-17139

The sensitivity labels feature in Microsoft Office is not supported. If used, report generation and preview will fail with errors.

As a workaround to the issue, block the Active Directory domain policy that pushes the sensitivity labels requirement to domain users.

Upgrade notes

To upgrade to Qlik NPrinting May 2023 SR7, you must start from one of the following versions:

• May 2023 SR6 (23.20.16)
• May 2023 SR5 (23.20.13)
• May 2023 SR4 (23.20.11)
• May 2023 SR3 (23.20.9)
• May 2023 SR2 (23.20.5)
• May 2023 SR1 (23.20.3)
• May 2023 IR (23.20.1)
• May 2022 SR5 (22.15.16)
• May 2022 SR4 (22.15.14)
• May 2022 SR3 (22.15.11)
• May 2022 SR2 (22.15.8)
• May 2022 SR1 (22.15.5)
• May 2022 (22.15.2)
• May 2022 Technical Preview (22.15.0)
• May 2021 SR5 (21.14.10)
• May 2021 SR4 (21.14.8)
• May 2021 SR3 (21.14.7)
• May 2021 SR2 (21.14.5)
• May 2021 SR1 (21.14.4)
• May 2021 (21.14.3)
• May 2021 Technical Preview (21.14.1)
• February 2021 (21.0.0)
• February 2021 Technical Preview (20.50.1)
• November 2020 SR1 (20.39.4)
• November 2020 (20.39.3)
• November 2020 Technical Preview (20.39.1)
• September 2020 (20.31.2)
• September 2020 Technical Preview (20.31.1)
• June 2020 SR1 (20.19.5)
• June 2020 (20.19.3)
• June 2020 Technical Preview (20.19.0)
• April 2020 (20.10.2)
• April 2020 Technical Preview (20.10.0)
• February 2020 SR1 (20.0.3)
• February 2020 (20.0.2)
• February 2020 Technical Preview (20.0.0)
• November 2019 SR1 (19.40.4)
• November 2019 (19.40.3)
• November 2019 TP (19.40.0)
• September 2019 (19.29.3)
• September 2019 TP (19.29.0)
• June 2019 (19.19.4)
• June 2019 Technical Preview (19.19.0)
• April 2019 (19.9.5)
• April 2019 Technical Preview (19.9.0)
• February 2019 SR1 (19.0.4)
• February 2019 (19.0.3)
• February 2019 Technical Preview (19.0.0)
• November 2018 (18.39.6.0)
• November 2018 Technical Preview (18.39.0.0)
• September 2018 SR2 (18.29.9.0)
• September 2018 SR1 (18.29.8.0)
• September 2018 (18.29.7.0)
• June 2018 (18.19.6)
• June 2018 Technical Preview (18.19.0)
• April 2018 (18.9.5)
• April 2018 Technical Preview

If you have a version of Qlik NPrinting older than April 2018, you must upgrade to Qlik NPrinting April 2018 before you can upgrade to Qlik NPrinting May 2023 SR7.

If you have a version of Qlik NPrinting older than 17.3, you must first upgrade to Qlik NPrinting 17.3. Then you must upgrade to a version from April 2018 to May 2021 SR4 before you can upgrade to Qlik NPrinting May 2023 SR7.

If you are upgrading from a version older than February 2018, all metadata caches (QlikView and Qlik Sense) will be marked as "not generated". This is due to a breaking change in the format of the metadata cache. All connection caches must be regenerated before you can edit a template or create a new connection.

You must back up your data before you proceed. Data can become damaged if a problem occurs during the
upgrade. If data is damaged, a backup is required to restore the repository. See: Backup and restore of a repository.
After backup, you must follow the instructions for upgrading on the help site page Qlik NPrinting upgrade.

Upgrade to November 2018 or newer

If you are upgrading to May 2023 SR7 from September 2018 SR2 or older you must:
• Open port 4997 outbound on Qlik NPrinting Server and inbound on all Qlik NPrinting Engines.
• Reinstall all your Qlik NPrinting Engines and provide a password for certificate exchange.
• Open the Engine manager in the Web Console.
• Open the detail page for each Engine and send the certificate after inserting the same password you used during the engine’s reinstallation.
Qlik NPrinting Engines stay offline until the certificate exchange is performed. Older Engine versions cannot connect to a Qlik NPrinting May 2023 SR5 Server.

Downloads

Setups are available at https://community.qlik.com/t5/Downloads/tkb-p/Downloads

About Qlik

Qlik converts complex data landscapes into actionable insights, driving strategic business outcomes. Serving over 40,000 global customers, our portfolio provides advanced, enterprise-grade AI/ML, data integration, and analytics. Our AI/ML tools, both practical and scalable, lead to better decisions, faster. We excel in data integration and governance, offering comprehensive solutions that work with diverse data sources. Intuitive analytics from Qlik uncover hidden patterns, empowering teams to address complex challenges and seize new opportunities. As strategic partners, our platform-agnostic technology and expertise make our customers more competitive.

qlik.com

Show Less

Table of Contents

• Improvements
• Resolved Defects
• Known issues and limitations
• Upgrade notes
• Downloads

 

The following release notes cover the versions of Qlik NPrinting released in February 2024 Service Release 4.

Improvements

Time zones updated to 2024b

Jira issue ID: OP-96047

The list of time zones is updated to IANA 2024b.

Qlik NPrinting Repository (PostgreSQL) updated

Jira issue ID: QB-30635

The Qlik NPrinting Repository service version of PostgreSQL is upgraded to 13.18-1

Resolved Defects

Internal server error (500) when trying to open Qlik NPrinting Designer

Jira issue ID: QB-30815

The error message "HTTP call error sending request...InternalServerError (500)” appeared when trying to edit any report in Qlik NPrinting Designer in an installation with approximately 65,000 or more user filters.

Customized session expiration time was not applied correctly

Jira issue ID: OP-96057

The customized value of the parameter session.expires in the webconsoleproxy.app.conf configuration file was not applied correctly by the Qlik NPrinting proxy after the Qlik NPrinting May 2023 Initial Release.

Password change experience improved

Jira issue ID: QB-31068

The changing password experience via user interface executed by a user with the related privilege was improved.

Password changes via users import task are excluded.

The first native Excel formula was modified

Jira issue ID: OP-10085

The first Excel native formula in a template was modified during the report generation resulting in incorrectly displayed data. The following formulas were calculated correctly.

Known issues and limitations

The following issues and limitations were identified at release time. The list is not comprehensive; it lists all known major issues and limitations. We expect to have these issues fixed in future versions.

Supported languages

The following languages are supported:

• English
• French
• German
• Spanish
• Brazilian Portuguese
• Japanese
• Italian
• Simplified Chinese

Other languages are not officially supported. There may be issues with other languages, particularly those with right-to-left script and non-Roman alphabets.

Qlik Sense custom size sheets

Qlik Sense custom size sheets are not supported. Custom size will not be maintained on export.
Alternate states
QlikView and Qlik Sense alternate states are not supported.

Alternate states

QlikView and Qlik Sense alternate states are not supported.

Qlik NPrinting must be installed only on C: drives

Jira issue ID: OP-6196
Qlik NPrinting Server, Engine, and Designer can only be installed on C: drives. Any attempt to install them on a different drive will result in task failures.

Image size settings are not respected when adding the same object twice

Jira issue ID: OP-5831
When you add the same object twice, using the Images node in Qlik NPrinting Designer, only the image size property of the first image is respected.

QlikView On-Demand reports cannot be connected to Qlik Sense

It is possible to select the “Enable” check box in On-Demand for reports using Qlik Sense app data. These reports are visible in the QlikView On-Demand menu of the QlikView On-Demand add-on. But if selected, they will not generate reports, and you will see an error message.

Qlik NPrinting Designer crashes sometimes with zoomed screen settings

If you experience random crashes when using Qlik NPrinting Designer, open your Windows Display Settings in the Control Panel and verify that Smaller – 100% (default) is selected. When settings of 125% or 150% are selected, Qlik NPrinting Designer may crash.

On-Demand works in Chrome and Firefox, but not in Internet Explorer (11 or older) or Edge

Jira issue ID: OP-5908
In some cases, when you use Qlik NPrinting On-Demand in Internet Explorer 11 or Edge, the “origin” HTTP header is not generated. This results in the error message “REVEL_CSRF: tokens mismatch”.
The workaround is to install Qlik NPrinting On-Demand on a Microsoft IIS server hosting QlikView Access point or use a different web browser.

Too many users and filters leads to Qlik NPrinting Designer errors

Jira issue ID: OP-4940
Qlik NPrinting Designer may be unable to open a report template if there are too many filters associated with a connection in the report's app. The following error message displays: “A task was canceled”.
This typically happens when more than 4000 filters are using fields from a connection. Sometimes, higher numbers can work. For example, 7000 filters have worked in some situations.
The workaround is:
1. Split the Qlik NPrinting app into separate apps.
2. Split the connections (possibly by using multiple connections to the same documents in different apps).
3. Split the filters across apps (so that the filter count per app is lower).

Task fails with the error 'Exceeded maximum number of retries'

Jira issue ID: OP-4839
Some Qlik NPrinting tasks fail with the error message: “Exceeded maximum number of retries”. This is due to a performance issue in QlikView that appears when it exports large unfiltered files to Excel.

Verify connection freezes during “Initializing…” status

Jira issue ID: OP-5278
In some rare circumstances, pressing the Verify connection button will cause the screen to freeze on the “Initializing…” status and the spinning wheel cursor. This happens when a Qlik NPrinting Engine goes offline and Verify connection is pressed before the Qlik NPrinting Scheduler is aware that it is offline. It can take up to 20 seconds before the Qlik NPrinting Scheduler determines the offline status of a Qlik NPrinting Engine.

User filters are excluded from matching and object filters

Jira issue ID: OP-5914
When you:

• Open Qlik NPrinting Designer
• Import a report

The filters associated with each user are not uploaded, or displayed, for performance reasons. Waiting for all filters for thousands of users to import would take a long time. In most cases, importing this information is unnecessary, because filters created for users often contain something like the user IDs. You can change this behavior and make all filters visible by uncommenting the line <!--<add key="include-user-filters" />--> in the webengine.config file.
To make a specific filter visible in the lists, remove its association to all users, or create a new filter with the same fields and values not linked to any user.

Cancelling an upgrade results in a corrupted environment

Jira issue ID: OP-3986
The rollback that follows a Qlik NPrinting Server or Engine upgrade cancellation may corrupt the related Qlik NPrinting installation. A rollback is triggered by errors or by clicking the cancel button during the upgrade execution. After a corruption caused by a rollback, services may be uninstalled or cannot be started.
To restore a Qlik NPrinting Server to its original status:

• Retrieve a recent backup
• Uninstall Qlik NPrinting Server
• Perform a clean installation of the same Qlik NPrinting Server of the backup
• Restore the backup

You should always create a backup before starting an update. In any case, a backup is automatically created in the folder "%ProgramData%\NPrinting" at the beginning of the upgrade process. To restore a Qlik NPrinting Engine to original status:

• Uninstall Qlik NPrinting Engine
• Perform a clean installation of Qlik NPrinting Engine

Adding a title to a Sense object with Assistance on generates an error on preview or task

Jira issue ID: OP-7560
Add title functionality is not supported on Qlik Sense objects with Assistance mode enabled. The workaround to restore the Add title functionality is to disable Assistance mode for the chart in Qlik Sense. Then reload the metadata of the connection.

Cannot export tables, columns, and cells from Qlik Sense objects made using chart suggestions

Jira issue ID: OP-7568
Qlik Sense objects made in Assistance mode cannot be used as tables, columns, or cells in Qlik NPrinting. To restore them, disable Assistance mode on the chart in Qlik Sense; then reload the metadata of the connection. Furthermore, if a Qlik Sense object made with Assistance mode is exported as a table, column, or cell using Qlik NPrinting APIs, the request will fail.

Open Type Fonts (*.otf) are not supported

Jira issue ID: OP-7165
Open Type Fonts (*.otf) are not supported in PixelPerfect templates. Generated reports will use a different font, and not look as expected.

Qlik Sense tables with conditionally shown columns have limited functionality

Jira issue ID: OP-7747
The following functionalities are not supported for Qlik Sense tables that have a "Show column if" condition set on one or more of their columns: levels, single column export, and keep source formats.

Qlik Sense On-Demand reports with selections on calculated dimensions fails

Jira issue ID: OP-8382
Qlik Sense On-Demand reports with selections applied on calculated dimensions will fail. However, you can apply selections on dimensions based on Qlik Sense fields. The workaround is to move the formula to the load script and use the calculated fields to apply selections to your On-Demand reports.

Qlik Sense histograms cannot be add into the Tables node

Jira issue ID: OP-8985
Due to the internal way of exporting Qlik Sense histograms, you cannot add them to the Qlik NPrinting Designer Tables node. If you add a Qlik Sense histogram to the Tables node, you will not receive any errors or warning messages, but the exported data will be wrong.

QlikEntities limitation with Qlik Sense entities

Jira issue ID: OP-8921
QlikEntity reports support Qlik Sense objects with the following limitations:

• Containers are not supported, but you can use all the objects that are inside containers.
• Qlik Sense sheets can be added to QlikEntity reports and exported as images. The "Extend Sheet" feature does not work.
• Export in PDF and TIFF is not supported.

Embedding Excel worksheets into PowerPoint templates is not supported

Jira issue ID: OP-9087
You cannot embed an Excel worksheet in a PowerPoint report template. This will cause a Qlik NPrinting Designer crash. The workarounds are to insert the Excel worksheet without using the Qlik NPrinting Designer:

• Create a .pptx file by using PowerPoint without involving the Qlik NPrinting Designer. Insert the Excel worksheet and save the .pptx. Then use the .pptx file as a report template.
• If you have already created the PowerPoint template, export it, open the .zip file generated by Qlik NPrinting and double-click the .pptx file inside. Insert the Excel worksheet, save the resulting PowerPoint and overwrite the exiting Qlik NPrinting template by uploading the updated .zip.

Qlik Sense dynamic views limitations

Jira issue ID: OP-9067
Dynamic views is a new Qlik Sense feature starting from June 2020.
If you connect Qlik NPrinting to a Qlik Sense app that contains a chart used to generate dynamic views, the chart and the containing sheet are excluded from the Qlik NPrinting connection cache and cannot be used in reports.
You can connect Qlik NPrinting to a Qlik Sense app containing dynamic views. However, after a dynamic view refresh, the connection will stop working.

Reports size limit

Jira issue ID: OP-9628
Starting from November 2020, RabbitMQ Server (deployed as Qlik NPrinting Messaging Service) has been updated to version 3.8.3. It has an internal limit, not configurable, about messages size of 512MB. Previous limit was 2GB. As consequence, is not possible to generate Qlik NPrinting reports bigger than 512MB.

Excel print area with more than one range

Jira issue ID: OP-9766
Excel worksheet print areas can contain more than one range if the generation of the report does not expand the print area. If it expands, you will see an error: “Invalid Cell Name”. For example, the default setting of the Expand Range option in a Qlik NPrinting table causes the print area to change during report production, and an error is received.

Searching in Cyrillic characters is case sensitive

Jira issue ID: OP-9518
Using Cyrillic characters in the Search form of the Qlik NPrinting user interface is case sensitive.

The percentage "%" format is not kept in Excel reports

Jira issue ID: OP-9995
The percentage “%” format is not kept in Excel reports when using QlikView 12.50 (12.50.20000) or newer due to a QlikView issue. You can solve this by upgrading to QlikView May 2021 SR2 (12.60.20200) or newer.

Run verification does not check if the installed version of QlikView Desktop supports QVF

Jira issue ID: OP-95599

If you start a Run Verification on a connection to a QlikView document in QVF format, Qlik NPrinting cannot confirm whether the QlikView Desktop version installed locally on each Qlik NPrinting Engine is compatible with QVF file format. The check mark next to "QlikView can open the document" may be green, even if a version of QlikView that does not support QVF is installed. This is because verification only checks file permissions. If the installed QlikView Desktop does not support QVF format, metadata generation will fail.

 QlikView objects with many fields with the same label are not supported

Jira issue ID: OP-95682

QlikView objects with many different fields with exactly the same label are not supported. Duplicated labels cause an exception during the connection cache generation. To solve this issue, ensure that each field has a unique label.

Images defined by URL in Qlik Sense tables are exported as text

Jira issue ID: OP-95797

Images linked by using URLs in Qlik Sense tables are exported as text. This affects only Qlik Sense connections. A workaround exists for PixelPerfect templates.

Microsoft Sensitivity Labels Are Not Supported

Jira issue ID: HLP-17139

The sensitivity labels feature in Microsoft Office is not supported. If used, report generation and preview will fail with errors.

As a workaround to the issue, block the Active Directory domain policy that pushes the sensitivity labels requirement to domain users.

Upgrade notes

To upgrade to Qlik NPrinting February 2024 SR4, you must start from one of the following versions:

• February 2024 SR3 (24.4.14)
• February 2024 SR2 (24.4.10)
• February 2024 SR1 (24.4.7)
• February 2024 IR (24.4.5)
• February 2024 TP (23.49.1)
• May 2023 SR7 (23.20.21)
• May 2023 SR6 (23.20.16)
• May 2023 SR5 (23.20.13)
• May 2023 SR4 (23.20.11)
• May 2023 SR3 (23.20.9)
• May 2023 SR2 (23.20.5)
• May 2023 SR1 (23.20.3)
• May 2023 IR (23.20.1)
• May 2022 SR5 (22.15.16)
• May 2022 SR4 (22.15.14)
• May 2022 SR3 (22.15.11)
• May 2022 SR2 (22.15.8)
• May 2022 SR1 (22.15.5)
• May 2022 (22.15.2)
• May 2022 Technical Preview (22.15.0)
• May 2021 SR5 (21.14.10)
• May 2021 SR4 (21.14.8)
• May 2021 SR3 (21.14.7)
• May 2021 SR2 (21.14.5)
• May 2021 SR1 (21.14.4)
• May 2021 (21.14.3)
• May 2021 Technical Preview (21.14.1)
• February 2021 (21.0.0)
• February 2021 Technical Preview (20.50.1)
• November 2020 SR1 (20.39.4)
• November 2020 (20.39.3)
• November 2020 Technical Preview (20.39.1)
• September 2020 (20.31.2)
• September 2020 Technical Preview (20.31.1)
• June 2020 SR1 (20.19.5)
• June 2020 (20.19.3)
• June 2020 Technical Preview (20.19.0)
• April 2020 (20.10.2)
• April 2020 Technical Preview (20.10.0)
• February 2020 SR1 (20.0.3)
• February 2020 (20.0.2)
• February 2020 Technical Preview (20.0.0)
• November 2019 SR1 (19.40.4)
• November 2019 (19.40.3)
• November 2019 TP (19.40.0)
• September 2019 (19.29.3)
• September 2019 TP (19.29.0)
• June 2019 (19.19.4)
• June 2019 Technical Preview (19.19.0)
• April 2019 (19.9.5)
• April 2019 Technical Preview (19.9.0)
• February 2019 SR1 (19.0.4)
• February 2019 (19.0.3)
• February 2019 Technical Preview (19.0.0)
• November 2018 (18.39.6.0)
• November 2018 Technical Preview (18.39.0.0)
• September 2018 SR2 (18.29.9.0)
• September 2018 SR1 (18.29.8.0)
• September 2018 (18.29.7.0)
• June 2018 (18.19.6)
• June 2018 Technical Preview (18.19.0)
• April 2018 (18.9.5)
• April 2018 Technical Preview

If you have a version of Qlik NPrinting older than April 2018, you must upgrade to Qlik NPrinting April 2018 before you can upgrade to Qlik NPrinting February 2024 SR4.

If you have a version of Qlik NPrinting older than 17.3, you must first upgrade to Qlik NPrinting 17.3. Then you must upgrade to a version from April 2018 to May 2021 SR4 before you can upgrade to Qlik NPrinting February 2024 SR4.

If you are upgrading from a version older than February 2018, all metadata caches (QlikView and Qlik Sense) will be marked as "not generated". This is due to a breaking change in the format of the metadata cache. All connection caches must be regenerated before you can edit a template or create a new connection.

You must back up your data before you proceed. Data can become damaged if a problem occurs during the
upgrade. If data is damaged, a backup is required to restore the repository. See: Backup and restore of a repository.
After backup, you must follow the instructions for upgrading on the help site page Qlik NPrinting upgrade.

Upgrade to November 2018 or newer

If you are upgrading to February 2024 SR4 from September 2018 SR2 or older you must:
• Open port 4997 outbound on Qlik NPrinting Server and inbound on all Qlik NPrinting Engines.
• Reinstall all your Qlik NPrinting Engines and provide a password for certificate exchange.
• Open the Engine manager in the Web Console.
• Open the detail page for each Engine and send the certificate after inserting the same password you used during the engine’s reinstallation.
Qlik NPrinting Engines stay offline until the certificate exchange is performed. Older Engine versions cannot connect to a Qlik NPrinting February 2024 SR3 Server.

Downloads

Setups are available at https://community.qlik.com/t5/Downloads/tkb-p/Downloads

About Qlik

Qlik converts complex data landscapes into actionable insights, driving strategic business outcomes. Serving over 40,000 global customers, our portfolio provides advanced, enterprise-grade AI/ML, data integration, and analytics. Our AI/ML tools, both practical and scalable, lead to better decisions, faster. We excel in data integration and governance, offering comprehensive solutions that work with diverse data sources. Intuitive analytics from Qlik uncover hidden patterns, empowering teams to address complex challenges and seize new opportunities. As strategic partners, our platform-agnostic technology and expertise make our customers more competitive.

qlik.com

Show Less

Table of Contents

• What's new in Qlik Gold Client 8.7.2025.02
• System requirements notes
• Downloads

 

The following release notes cover the versions of Qlik Gold Client released in February 2025. For questions or comments, post in the Product Forums or contact Qlik Support.

What's new in Qlik Gold Client 8.7.2025.02

• Delete ALL Data Snap IDs button added to Configuration -> Administration ->Reports & Cleanup Utilities -> Export ID Manager screen to resolve No unique Export ID's available message (QGC-222)
• Gold Client Number Range Utility will automatically flush the number range buffer (QGC-819) 
• Import Options button now available on Client Exporter screen (QGC-898) 
• Gold Client related transaction codes are now associated with Gold Client security activities to prevent unauthorized direct access (QGC-844)
• Blank value now allowed in Qualifier Value field of Data Transformation Rule (QGC-813)
• Setup Confirmation Utility screen now shows if Gold Client Security is active or inactive (QGC-810) 
• PERNR Sync Exceptions Utility added to Configuration -> Additional Tools to allow maintenance of table /HTG/NOPERNRSYNC (QGC-803) 
• Improved file handling for tables /HTG/CCSEXPFILES and /HTG/EXPFILEPROG in method TRANSFER_DATA_FILES to avoid missing file entries in PASS file (QGCB-356)  
• Resolve deadlock issue with table /HTG/GCSEXPFILES during Gold Client data deletion  (QGCB-351) 
• Schedule Job window layout changes in Data Wave (QGC-852) 
• Field Layout changes on Installation Setup screen (QGC-849)
• Layout of Conflicting Data Report in Client Construct changed to match Data Echo version layout (QGC-846)
• Create/Delete Data Type Utility changed to allow new datatypes to be set as primary, add key fields to Data Snap config screen, and assign Data Snap record limit (QGC-796) 
• Parent Data Types button added to the Data Snap screen (QGC-795) 
• Gold Client folder available space remaining displayed on Configuration -> Administration -> Installation/Setup -> Setup Confirmation screen (QGC-793) 
• Text records with multiple spaces now written to export file correctly (QGC-554) 
• Client Construct R3Trans exports no longer visible in Delete Data screen (QGCB-373) 
• When user exit /HTG/GLC_UTL_C_27 for STXL table is active, message will be displayed if Text /HTG/ANYTHING for Text ID 'ST" is not configured (QGC-528) 
• Report /HTG/GCS_ECC_EXP_P_00 changed to accept 3-digit job interval value to avoid export job runtime looping  (QGC-915)  
• New validations for column length (offsets) in data type linkages (STRING + SSTRING) and AND/OR or Operator Parenthesis in the where clause (QGCB-355) 
• Resolved "Could not Generate Subroutine /HTG/LFXXXU0F03 <TABLE NAME> must be a flat structure" message by calling FM '/HTG/GET_INITIALIZER_RECORDS' instead of FM '/HTG/GET_HEADTABLE_RECORDS_NEW'.  The new FM avoids SUBROUTINE POOLS completely and is the one used for getting record count from Data Snap. (QGCB-358) 

 

System requirements notes

SAP system must be on SAP_BASIS 740 or higher

Downloads

Download this release from the Product Downloads page on Qlik Community.

 

About Qlik

Qlik converts complex data landscapes into actionable insights, driving strategic business outcomes. Serving over 40,000 global customers, our portfolio provides advanced, enterprise-grade AI/ML, data integration, and analytics. Our AI/ML tools, both practical and scalable, lead to better decisions, faster. We excel in data integration and governance, offering comprehensive solutions that work with diverse data sources. Intuitive analytics from Qlik uncover hidden patterns, empowering teams to address complex challenges and seize new opportunities. As strategic partners, our platform-agnostic technology and expertise make our customers more competitive.

qlik.com

Show Less

Table of Contents

• What's new in Qlik Web Connectors February 2025
• Deprecated Connectors
• Known issues and limitations
• System requirements notes
• Downloads

 

The following release notes cover the versions of Qlik Web Connectors released in February 2025. For questions or comments, post in the Product Forums or contact Qlik Support.

What's new in Qlik Web Connectors February 2025

The following updates have been made to the Qlik Web Connectors Core and Web UI as well as the connectors listed.

Core Engine

• Updated Font Awesome to 6.7.2
• Updated react to 19.0.0
• Updated react-dom to 19.0.0
• Updated react-router-dom to 7.1.3
• Updated axios to 1.7.9
• Updated CsvHelper to 33.0.1

Qlik Azure Storage Connector

• Updated to use API version 2025-01-05

Qlik Dropbox Connector

• Added the following columns to AccountInfo: name_abbreviated_name, disabled
• Added the following columns to ListSharedLinks: link_permissions_effective_audience_tag, link_permissions_link_access_level_tag, link_permissions_can_set_password, link_permissions_can_remove_password, link_permissions_require_password, link_permissions_can_use_extended_sharing_controls, link_permissions_can_sync, link_permissions_can_request_access, expires.
• Added the following columns to List: is_downloadable, sharing_info_read_only, sharing_info_shared_folder_id, sharing_info_parent_shared_folder_id, sharing_info_traverse_only, sharing_info_no_access.
• Added the following columns to Metadata: is_downloadable, sharing_info_read_only, sharing_info_shared_folder_id, sharing_info_parent_shared_folder_id, sharing_info_modified_by, media_info_metadata_location_latitude, media_info_metadata_location_longitude.
• Added the following columns to Revisions: is_downloadable, sharing_info_read_only, sharing_info_parent_shared_folder_id, sharing_info_modified_by.
• Added the following columns to Search and SearchV2: metadata_sharing_info_read_only, metadata_sharing_info_shared_folder_id, metadata_sharing_info_parent_shared_folder_id, metadata_sharing_info_modified_by, metadata_is_downloadable.

Qlik Facebook Insights Connector

• POSSIBLE BREAKING CHANGE: Updated to Facebook API v21.0.

Qlik Google Ad Manager Connector

• Upgraded API from v202405 to v202411. See Google release notes here and here for changes.
• BREAKING CHANGE: Renamed the Line_Item table field endDateTime to servingEndTime.

Qlik Google Ads Connector

• Upgraded API from v17 to v18. See Google release notes here for changes.

Qlik Helper Connector

• Added allowed paths check for tokens file input parameter in ReplaceTokensInFile table.

Qlik JIRA Connector

• Added ServerInfo table.

Qlik OData Connector

• Added V4GetSchemas, V4GetEntities and V4GetProperties tables.
• Use 'fully qualified' types (namespace and entity type name) to cater for large multi-schema models.
• Added V4 max column limit to avoid excessive resource consumption for large models.
• Optimized column calculation for JsonV4GetDataCollection table.

Qlik SugarCRM Connector

• Added "Concatenate multiple values" parameter to CustomModule table.

Qlik SurveyMonkey Connector

• Ignore empty nodes when parsing responses for GetResponses table.

Qlik Sentiment140 Connector

• BREAKING CHANGE: removed support for processParamsBatch option for Sentiment table.

 

Deprecated Connectors

When upgrading connectors to the latest APIs, unfortunately the changes can be so extensive that we are unable to modify the existing connector. When this happens we will create a new version of the connector and put the existing one into a ‘Deprecated’ state. This means that at some point in the future it will no longer be available and after entering the deprecated status, it will no longer be updated. The date is normally determined by the underlying API which will often have its own expiry date, after which the connector using it will no longer work.

You can see connectors affected under the Deprecated tab in Qlik Web Connectors. Three connectors are still noted as deprecated in this release:

• Qlik AYLIEN News Connector V2
• Qlik Amazon S3 Connector
• Qlik MeaningCloud Connector

No connector is removed in this release.

Known issues and limitations

IP v6 addresses are not supported when you enter an IP v6 address for the purpose of white listing.

Load Balancing is not supported.

System requirements notes

Qlik Web Connectors requires .NET Framework 4.8.1.

Downloads

Download this release from the Product Downloads page on Qlik Community.

 

About Qlik

Qlik converts complex data landscapes into actionable insights, driving strategic business outcomes. Serving over 40,000 global customers, our portfolio provides advanced, enterprise-grade AI/ML, data integration, and analytics. Our AI/ML tools, both practical and scalable, lead to better decisions, faster. We excel in data integration and governance, offering comprehensive solutions that work with diverse data sources. Intuitive analytics from Qlik uncover hidden patterns, empowering teams to address complex challenges and seize new opportunities. As strategic partners, our platform-agnostic technology and expertise make our customers more competitive.

qlik.com

Show Less

Table of Contents

• What's new in Qlik Connector for use with SAP NetWeaver v8.1.0
• General
• BAPI Connector
• BW Connector
• Extractor Connector
• SQL Connector
• Resolved Defects
• General
• BW Connector
• General
• Script parsing fixes
• Extractor Connector
• SQL Connector
• Upgrade notes
• Downloads

 

The following release notes cover the versions of SAP NetWeaver, released in v8.1.0.. For questions or comments, post in the Product Forums or contact Qlik Support.

What's new in Qlik Connector for use with SAP NetWeaver v8.1.0

General

Potential BREAKING CHANGE:
The BEx Connector and the InfoProvider Connector have been removed. The BW Connector is fully compatible and should be used instead.

The SAP Connectors have been updated with general bug fixes and improvements, specifically error handling has been improved when some SAP objects raise uncaught errors.

 

BAPI Connector

• Update of .Net Framework to version 4.8.1
  
  

BW Connector

• Improved BEX_LEGACY datatype processing
• Support for navigational attributes in the filter section
• Updated descriptions of connection properties
• Support for alternate condition field name for ADSO
• Reduced memory usage of metadata objects
• Updated .Net Framework to v4.8.1
  
  

Extractor Connector

• Updated .Net Framework to v4.8.1
• One new script property: IGNORESYSID, which will send NULL as sysId when starting an Extractor job. Default is FALSE, to send the sysId. The property should be used only if a job gets an unknown timeout error or the following error message:
  "Unknown error in Receiver Loop: No transaction handler is installed. Unable to process tRFC/qRFC requests."
  Put the property in the script section next to e.g. UPDMODE or TFRMETHOD.
  Example:
  IGNORESYSID T // (T=true)
  
  

SQL Connector

• Updated .Net Framework to v4.8.1
• Reduced memory usage of metadata objects
  
  

Resolved Defects

General

Improved handling of ADSO errors that resulted in infinite loops when errors were raised (8.1.0)

Enhanced logging added to the SAP BW connector to improve information about authorization errors related to specific BW composite objects (8.0.3).

Resolved issue with some conversion routines not being carried out during the extraction jobs for some fields, resulting in incorrect formatting of data. This was updated in both SQL and BW connectors (8.0.3).

In SAP BW InfoProvider support for INT8 data types has been added (8.0.3).

BW Connector

General

• Improved error handling when an info provider returns no data due to an error
• SncSso always disabled when using SNC
• Removed help link from connect dialog in hub.
• Fixed sorting order for InfoProvider fields when fetching data
• Removed compounding infoobject prefix master data object
  
  

Script parsing fixes

• Support slash ‘/‘ in BEx query names
• Support '+' char in BEx variable values
• Support dash ‘-‘ in InfoProvider condition values and be less strict in condition values requiring quoting ‘”’
• Allow ‘@‘ character in BEx query and from names
• Allow '&' char in BEx query variables
• Support '.' dot characters in BEx variable values
• Allow spaces for variable values in BEx queries
  
  

Extractor Connector

• In some cases, the SAP system couldn't find the transaction handler and there was a timeout as no packages were sent to the Qlik SAP Network Server Service
  
  

SQL Connector

• SncSso always disabled  when using SNC
• Fix bcd/packed number datatype handling, Convert to double in connector so regional settings doesn't impact how it's converted
• Removed help link from connect dialog in hub.
• DEC types included also when FLTP_LEGACY switch is enabled. The switch changes data type mapping to send data as texts instead of parsed doubles.

 

Upgrade notes

See the online help on Installing the connectors, and the attached Installation Guide.

 

Downloads

Download this release from the Product Downloads page on Qlik Community.

 

About Qlik

Qlik converts complex data landscapes into actionable insights, driving strategic business outcomes. Serving over 40,000 global customers, our portfolio provides advanced, enterprise-grade AI/ML, data integration, and analytics. Our AI/ML tools, both practical and scalable, lead to better decisions, faster. We excel in data integration and governance, offering comprehensive solutions that work with diverse data sources. Intuitive analytics from Qlik uncover hidden patterns, empowering teams to address complex challenges and seize new opportunities. As strategic partners, our platform-agnostic technology and expertise make our customers more competitive.

qlik.com

Show Less

Table of Contents

• What's new
• Migration and upgrade
• Upgrade paths
• Licensing
• Migrating from Compose for Data Lakes
• Compatibility with related Qlik products
• End of Life/Support and deprecated features
• Resolved issues
• Service Release 1: Issues resolved since Qlik Compose December 2024 Initial Release
• Initial Release: Issues resolved in Qlik Compose December 2024 Initial Release
• Known issues
• Downloads

What's new

Learn about new features and improvements in Qlik Compose.

Resolved issues

Service Release 1: Issues resolved since Qlik Compose December 2024 Initial Release

The following issues have been resolved since Qlik Compose December 2024 initial release:

Jira issue: RECOB-9113 

Salesforce case: 322990 

Type: Issue 

Component/Process: Server 

Description: During Full Load, in rare scenarios, the wrong Replicate task status would be shown in the Compose monitor. 
 

Jira issue: RECOB-9257 

Salesforce case: 335597 

Type: Issue 

Component/Process: Data Mart Validation 

Description: During data mart validation, when the fact table contained an OID column belonging to a deleted relation, the following error would be shown: 

SYS,GENERAL_EXCEPTION, Object reference not set to an instance of an object 

 

Jira issue: RECOB-9327 

Salesforce case: 345805 

Type: Issue 

Component/Process: Data Mart - Snowflake on AWS 

Description: When running a data mart task, the following error would occur: 

sqlstate 42000, errorcode 904, message SQL compilation error 

 

Jira issue: RECOB-9508 

Salesforce case: 355592 

Type: Issue 

Component/Process: ETL Statements 

Description: When a filter and a data quality cleansing rule were defined on the same column, the data warehouse task would fail with the following error (excerpt): 

Incorrect syntax near the keyword 

Initial Release: Issues resolved in Qlik Compose December 2024 Initial Release

The following issues have been resolved in Qlik Compose December 2024 Initial Release:

Jira issue: RECOB-8771 

Salesforce case: 173509 

Type: Issue 

Component/Process: Workflows 

Description: Validation checks for complex workflow would be excessively long before running the first operation. 

 

Jira issue: RECOB-8899 

Salesforce case: 303295 

Type: Issue 

Component/Process: Data Lake Project – ETL Statement 

Description: If a record was updated in a partition that was still open after the CDC task started, the record would sometimes not be archived. 

 

Jira issue: RECOB-8885 

Salesforce case: 310095 + 310451 

Type: Issue 

Component/Process: Data Marts (SQL Server Target) 

Description: Data mart generation would sometimes fail with a “Duplicate columns detected” error. 

 

Jira issue: RECOB-8922  

Salesforce case:  309076 

Type: Issue 

Component/Process: Data Marts 

Description: An incorrect fact INSERT statement would be generated if the fact contained type 2 entities and a transaction date. 

 

Jira issue: RECOB-8808  

Salesforce case: 297099 

Type: Issue 

Component/Process: ETL Statements 

Description: When two instances of the same task ran in parallel, one of the tasks would fail as it would try to access a temp table which was deleted by the other task. 

 

Jira issue: RECOB-9032 

Salesforce case: 317354 

Type: Issue 

Component/Process: Amazon Redshift, ETL Statements 

Description:  Due to a driver limitation, when inserting more than 2 billion records, the data warehouse task would sometimes fail with the following error: 

Parameter MappingCount_E12309_M001 has no value 

The issue was resolved using the latest JDBC driver: redshift-jdbc42-2.1.0.30 

 

Jira issue: RECOB- 9031 

Salesforce case: 317518 

Type: Issue 

Component/Process: Microsoft SQL Server Target 

Description: Using a Transactional Fact with Type 1 dimensions that contained a filter would result in an incorrect statement being generated. 

 

Jira issue: RECOB-8991 

Salesforce case:  308524 

Type: Issue 

Component/Process: Snowflake Target 

Description: When using key pair authentication, the key would break after deployment. 

 

Jira issue: RECOB-8727 

Salesforce case: 296636 

Type: Issue 

Component/Process: Project documentation 

Description: When trying to generate project documentation, the following error would sometimes occur:  

The given key was not found in the dictionary 

 

Jira issue: RECOB-8776 

Salesforce case: 165516 

Type: Issue 

Component/Process: Security vulnerability 

Description: The index.html and demo.html files were removed from the Compose installation to address vulnerability CVE-2019-10768. 

 

Jira issue: RECOB-8567 

Salesforce case: 171604 

Type: Issue 

Component/Process: Data Marts 

Description: Data mart generation would fail when the Date dimension was created manually. 

 

Jira issue: RECOB-8569 

Salesforce case: 166504 

Type: Issue 

Component/Process: Workflows 

Description: When a workflow with a parallel split failed, the monitor would still show it as running. 

 

Jira issue: RECOB-8622 

Salesforce case: 170800 

Type: Issue 

Component/Process: Logging  

Description: Not all files were deleted from <INSTALL-DIR>\java\data\projects\<project-name>\logs, even though the log retention policy was configured to delete them. 

 

Jira issue: RECOB-8639 

Salesforce case: 173669 

Type: Issue 

Component/Process: Data Marts  

Description: During the initial run of data mart tasks with transactional facts, Compose would try to update the table instead of just inserting the data. 

 

Jira issue: RECOB-8197 

Salesforce case: 139123 

Type: Issue 

Component/Process: UI - Monitor  

Description: The task would be shown as completed successfully (in the monitor and in the log), but the progress bar would show that some of the ETL statements had still not been completed.

 

Jira issue: RECOB-8673 

Salesforce case: 292717 

Type: Issue 

Component/Process: Data Marts, ETL Statements  

Description: When attempting to augment an aggregated fact with a dimension through the 'Add to Star Schema' option, the system would sometimes generate the following error: 

Invalid column name _OID 

 

Jira issue: RECOB-8690 

Salesforce case: 172614 

Type: Issue 

Component/Process: Data Warehouse CDC Task

Description: Generating a data warehouse CDC task would take a long time when a project was configured to use the same database (for landing and archiving, for example), but with a different schema. 

 

Jira issue: RECOB-8383 

Salesforce case: 161351 

Type: Enhancement 

Component/Process: UI Monitor 

Description: Complex workflow validation will now be skipped to improve monitor performance. 

 

Jira issue: RECOB-8472 

Salesforce case: 164789 

Type: Issue 

Component/Process: CLI 

Description: Data mart tables would be dropped while executing the following command: 

ComposeCli.exe generate_project 

 

Jira issue: RECOB-8462 

Salesforce case: 165355 

Type: Issue 

Component/Process: Cloudera Data Platform (CDP) 

Description: When there were multiple records with the same ID and From Date, Compose would not pick up the latest Change Table record. 

 

Jira issue: RECOB-8494 

Salesforce case: 167502 

Type: Issue 

Component/Process: UI 

Description: Task search would not work as expected. 

 

Jira issue: RECOB-8517 

Salesforce case: Qlik Internal 

Type: Issue 

Component/Process: UI 

Description: When a custom ETL contained special characters, the export_csv command would fail. 

 

Jira issue: RECOB-8287 

Salesforce case: 154357

Type: Issue

Component/Process: Metadata Manager

Description: Checking the metadata when adjusting the data mart would sometimes be excessively slow.

 

Jira issue: RECOB-8333 

Salesforce case: 158494

Type: Issue

Component/Process: CLI

Description: The ComposeCli.exe generate_project command would complete without any errors when the data warehouse was not synced with the model.

 

Jira issue: RECOB-7821 

Salesforce case: 151213

Type: Issue

Component/Process: Security 

Description: Google Guava was upgraded from 31.0.1 to 33.1.0, which fixes vulnerability CVE-2023-2976.

 

Jira issue: RECOB-8074

Salesforce case: 151213

Type: Issue

Component/Process: Security

Description: Removed the postgresql-42.6.0.jar from Compose to address vulnerability CVE-2024-1597.

 

Jira issue: RECOB-7860

Salesforce case: 151213

Type: Issue

Component/Process: Security

Description: The org.eclipse.jetty:jetty-http web server component was upgraded to a version that fixes the following vulnerabilities: CVE-2023-36478, CVE-2023-36479, and CVE-2023-40167

 

Jira issue: RECOB-8319

Salesforce case: 158765

Type: Issue

Component/Process: Data Marts

Description: Retroactive changes would create too many obsolete records in the dimension tables.

 

Jira issue: RECOB-8378

Salesforce case: 154292

Type: Issue

Component/Process: Connectivity, Microsoft Azure Managed SQL Server 

Description: Data warehouse tasks would sometimes fail to complete.

 

Jira issue: RECOB-8096 

Salesforce case: 147298

Type: Issue

Component/Process: SQL Server

Description: Compose would fail to connect to SQL Server when using Windows Authentication.

 

Jira issue: RECOB-8154 

Salesforce case: 129455

Type: Issue

Component/Process: Logging

Description: Debugging messages related to connection issues would fill up the data mart task log and severely impact disk space.

 

Jira issue: RECOB-8202 

Salesforce case: 129455

Type: Issue

Component/Process: Data Marts

Description: When two different dimensions used the same data warehouse table with self-reference tables, data mart generation would fail with a "duplicate columns detected" error. 

 

Jira issue: RECOB-8162

Salesforce case: 151211

Type: Issue

Component/Process: Metadata Manager, Google BigQuery

Description: When using the NUMERIC data type with non-default size and precision, the scale and precision would be incorrectly converted.

 

Jira issue: RECOB-8100

Salesforce case: 142698

Type: Issue

Component/Process: Databricks Delta

Description: The Databricks SQL Warehouse ETL statement for CDC would sometimes fail with a casting error when querying the attrep_cdc_partitions control table.

 

Jira issue: RECOB-8233

Salesforce case: Qlik Internal

Type: Issue

Component/Process: Data Marts, ETL Statements

Description: In rare scenarios, the data mart ETL would fail with an "Incorrect syntax error near COALESCE" error. 

 

Jira issue:  RECOB-7871 

Salesforce case: 126374

Type: Issue

Component/Process: Data Marts, Compose Log File

Description: A redundant "Data mart ID does not exist" log message would be repeatedly written to the Compose log file.

 

Jira issue:  RECOB-7948 

Salesforce case: 133345

Type: Issue

Component/Process: Data Marts

Description: Multiple column support has been added to the Synapse HASH distribution key. This resolves the following error: "SYS,GENERAL_EXCEPTION, An item with the same key has already been added"

 

Jira issue: RECOB-7211

Salesforce case: 87096

Type: Enhancement

Component/Process: UI Monitor - Data Lake Projects

Description: Added the ability to sort columns in the Manage Data Storage Tasks and Monitor Details windows.

 

Jira issue: RECOB-8011

Salesforce case: 139471

Type: Issue

Component/Process: Task Commands   

Description:  A "Failed to start task" error would sometimes be encountered after upgrading.

 

Jira issue: RECOB-8004

Salesforce case: 129455

Type: Enhancement

Component/Process: Connectivity

Description: To optimize connection recovery, a retry functionality was added when writing to Control tables.

 

Jira issue:  RECOB-8006

Salesforce case: 139471

Type: Issue

Component/Process: Data Marts, ETL Statements

Description: When generating a data mart task, a "Duplicate columns detected" error would sometimes be encountered due to incorrect handling of multi-path attributes.

 

Jira issue: RECOB-8020

Salesforce case: 137863

Type: Issue

Component/Process: Data Marts

Description: An incorrect "Attribute used in expression does not exist in the model" error would sometimes be encountered during data mart validation.

Note: The fix uses a "max_transactional_date_tree_depth" parameter to determine the depth of the dimension tree. As this requires a change in the project's repository, please contact Qlik Support for assistance If you think you might have encountered this issue.

   

Jira issue: RECOB-8022

Salesforce case: 140252

Type: Issue

Component/Process: ETL Statements, Performance, SQL Server

Description: The hashing process for CDC would sometimes consume excessive memory and significantly lengthen task completion time. To benefit from this fix, you need to regenerate the task ETLs after installing the patch.

 

Jira issue: RECOB-7859

Salesforce case: 127377

Type: Issue

Component/Process: Data Warehouse Adjust 

Description: When adjusting the data warehouse after a change in the model, the following error would sometimes occur:

SYS,GENERAL_EXCEPTION, Sequence contains no elements

 

Jira issue: RECOB-7803

Salesforce case: 104948

Type: Issue

Component/Process: Data Mart Performance on Snowflake

Description: Data mart performance issues would be encountered after upgrading. This version reverts the changes to the code that caused the performance issues.

 

Jira issue:  RECOB-7840

Salesforce case:  121509

Type: Issue

Component/Process: ETL Statements, Source Consolidation

Description: ETL generation would sometimes fail when Consolidate uniform sources was enabled and the source type was View.

 

Jira issue:  RECOB-7637

Salesforce case:  113806

Type: Issue

Component/Process: ETL Statements

Description: When a long "From date" column name was defined in the project settings, the following error would be encountered when automatically adjusting the data warehouse:

Input string not in correct format

 

Jira issue: RECOB-7387

Salesforce case: 97736

Type: Issue

Component/Process: Documentation

Description: When a Compose project contained environment variables, the following error would occur when generating the product documentation:

Length cannot be less than zero. Parameter name: length

 

Jira issue: RECOB-7842

Salesforce case: 127234 

Type: Issue

Component/Process: UI

Description: Discovering tables from a MySQL source would sometimes cause the UI to hang.

 

Jira issue: RECOB-7927

Salesforce case: 129455

Type: Issue

Component/Process: Database Connections

Description: Connections to the database would not be reestablished when a task was paused and resumed.

 

Jira issue: RECOB-7951

Salesforce case: 132765

Type: Issue

Component/Process: Data Marts, Upgrade

Description: Upgrading from Compose May 2022 removed all links from facts to dimensions.

Downloads

Download this release from the Product Downloads page on Qlik Community.

About Qlik

Qlik’s vision is a data-literate world, where everyone can use data and analytics to improve decision-making and solve their most challenging problems. A private SaaS company, Qlik offers an Active Intelligence platform, delivering end-to-end, real-time data integration and analytics cloud solutions to close the gaps between data, insights and action. By transforming data into Active Intelligence, businesses can drive better decisions, improve revenue and profitability, and optimize customer relationships. Qlik does business in more than 100 countries and serves over 50,000 customers around the world.

qlik.com

Show Less

Table of Contents

• What's new in Sense November 2024
• Visualizations & Dashboard
• Data & Platform
• Resolved Defects
• November 2024 Patch 8
• November 2024 Patch 7
• November 2024 Patch 6
• November 2024 Patch 5
• November 2024 Patch 4
• November 2024 Patch 3
• November 2024 Patch 2
• November 2024 Patch 1
• November 2024
• Known issues and limitations
• Clients
• Dynamic views
• Managing a Qlik Sense site
• Qlik Sense Desktop
• Connectors
• Cloud deployments and Multi-Cloud
• Upgrade notes
• Important Notice for Android Mobile Users
• System requirements notes
• Downloads

 

The following release notes cover the versions of Qlik Sense Enterprise on Windows released in November 2024. For questions or comments, post in the Product Forums or contact Qlik Support.

 

What's new in Sense November 2024

Please refer to the What’s new sections of the online help for further information about the new and updated features of the Qlik Sense Enterprise on Windows November 2024 release:

What's new in Qlik Sense November 2024 (Users)

What's new in Qlik Sense November 2024 (Developers)

What's new in Qlik Sense November 2024 (Administrators)

 

Visualizations & Dashboard

Action to set active cyclic dimension field

The button got another action for controlling cyclic dimensions. Use Set active field to go to a specific field in the group.

Images in tables

Images can now be embedded in the new straight table and pivot table in the visualization bundle. The images can be sourced from the media library or from a URL.

Improvements to sheet navigation, interaction and the left asset panel

• The sheet navigation has moved to the left asset panel for easier navigation, alongside Bookmarks.
• Grouping of sheets makes sheets easier to organize and find.
• Pinning and resizing of the left asset panel makes the panel more readable and flexible.

Navigation menu

With our new navigation menu, you can style it as you prefer.

New UI settings

App settings now include options to toggle individual items and buttons in the app navigation bar, toolbar and sheet header, allowing greater customization of the end user experience.

Tab container

The new tab container is an improvement the old container object with a new name and styling settings for labels, tabs and icons.

Selection bar improvements

• Labels: If the user has provided a label to a master dimension, then that label will be used rather than the field name in the underlying data model. This will improve usability and make it easier to create multilingual applications.
• Styling with custom themes: The selection bar can now be styled using custom themes. Style the selection bar and listboxes with custom definitions for the dataColors properties.

Context menu for visualizations

Introducing a new context menu for visualizations toggle in Qlik Sense, enhancing app customization and user experience by allowing flexible control over the context menu visibility within app properties.

Straight table styling improvements

New style settings e.g. background color and image, font and grid styling.

Modifiers and expression based text styling in the new straight table

• Text styling by expression using tags <b>,<i>,<u> and<s>.
• Modifiers: turn your measure into an accumulation, a moving average, a difference, or a relative number with a single drop down.

Chart exploration for straight tables embedded in layout and tab containers

Chart exploration in the new straight table is now supported in layout container and the new tab container.

Combo chart improvements

• Added labels to markers and a setting to toggle the grid.
• Option to display labels on stacked measure segments.
• Chart animations

Chart background image by URL

Chart background by URL offers huge potential to style and build up a highly dynamic and stylish app. Useful for:

• Linking images from external sources.
• Building up dynamic images using an expression with inline SVG as a Data URI.
• Fetching images from the media library with an expression and the API.

General styling of bundled charts

The remaining charts in the visualization and the dashboard bundle are getting general styling including font styling of titles, background color and image options and border and shadow settings.

 

Data & Platform

Enable and disable autocomplete in script and expression editors

Users can now enable or disable autocomplete hints when writing Qlik script in the script editor, data load editor, and expression editor.

Expressions in field labels

You can now have expressions in field labels for drill-down and cyclic dimensions. This lets you for example enable translation of labels in multi-language apps.

Improved usability of the Data load editor

• Data preview feature, allowing Qlik Sense users to get better insight when writing script to load data.
• Visual wizards have been added to easily write Store statements or include QVS files.
• Usability improvements such as resizable panels and the possibility to preview the content of the included QVS files.

Improved usability and support of QVS script files

• View and include QVS files in load scripts.
• Improved usability of QVS files promotes scripting best practices

Search and replace in expression editor

Users can now search and replace text within the expression editor. This includes a "replace all" option, allowing for quick bulk edits within a single complex expression.

Expanded Qlik Cloud distribution

Qlik now enables all customers to distribute Qlik Sense apps to a Qlik Cloud tenant, regardless of their license. This update particularly benefits clients on a QAP (Qlik Analytics Platform) license, who can now distribute apps to the cloud—a capability that was previously unavailable to them.

CSRF protection extended to Websockets and add-ons

Extended CSRF protection to Websocket requests and added support for CSRF to add-on products.

If you are using mashups or have cross-site domain setups, add the following response headers to enhance security and control access. These headers help protect against Cross-Site Forgery (CSRF) attacks:

• Access-Control-Allow-Origin: https://localhost:8080
• Access-Control-Allow-Credentials: true
• Access-Control-Expose-Headers: qlik-csrf-token

Postgres database support

Added support for Postgres versions 15 and 16.

 

Resolved Defects

November 2024 Patch 8

Key	Title	Description
QCB-31331	Qlik Sense Enterprise on Windows: Data Load Editor not loading data connections	Fixed a regression introduced with the May 2024 release of Qlik Sense Enterprise on Windows. This error resulted in the server node ID of the engine used by the Data Load Editor not being communicated to backend services, which prevented the Data Load Editor from successfully loading, resulting in the display of a spinner control in place of the connection list in DLE. This occurrence was characterized by continuous traffic on the Qlik Engine web socket with the remote procedure calls to CreateSessionObject with a parameter value of 'LoadModelList'.

 

November 2024 Patch 7

Key	Title	Description
QB-29590	Restricted About APIs - proxy returns 302 for an anonymous access	Proxy redirects with 302(for authentication) for the below restricted APIs: /api/about/v1/systeminfo /api/about/v1/components /api/about/v1/thirdparty
QB-29696	Ensure that there is no attempt to try to open or write files outside whitelisted folders	Fixed security issue where Engine would try to read and write to any path specified against Engine API. Solution of the fix adds path restrictions (with whitelisted folders) on e.g. OpenDoc and ExportApp, and restrictions to how relative paths are used in folder connections and lib references in the script. Relative paths should not be allowed to point outside of the scope set. It's not recommended to disable this fix, but can be disabled in case of emergency. To disable the fix, you need to add EnableQvfPathValidation=0 into Engine's Settings.ini file.
QB-31031	Reload Script download in Hub	Reload Script download was throwing error with introduction to xrf-key. We have introduced xrf-key in the reload script download URL.
QB-31249	Qlik Sense Data Manager: Virtual proxy prefix was missing on /qrs/appcontent-related requests	The virtual proxy prefix was missing on requests related to /qrs/appcontent. As a result, a login dialog was displayed when uploading and deleting files in Data Manager. This has been fixed so uploading and deleting files no longer requires an additional login.

 

November 2024 Patch 6

Key	Title	Description
QB-30855	Qlik Sense: 404 error in browser console	This fix removes a bug where a 404 error was shown in the web browser developer tools when loading an app.
QB-31101	Sheet navigation for anonymous users	There was an issue where anonymous users could not navigate between sheets using the sheet buttons. This has been fixed.
QB-30758	Geo Analytics: After upgrade to Qlik Sense Nov 2024 the GA Plus connection hangs	After upgrading to Qlik Sense November 2024, the Geo Analytics Plus connection would indefinitely show "Please wait - analyzing the selected data". This was due to an issue in the field selection dialog which has been fixed.

 

November 2024 Patch 5

Key	Title	Description
QB-30779	Qlik Sense: Issue with locked fields and section access after reload	Fixes an issue where locking a selection in an app with a section access caused the field to be included in the section access after a reload or partial reload, and the only available values after the reload were the ones that have been locked.
SHEND-2285	Update node.js to the latest patch version with fixes	Qlik Sense November 2024 Patch 5 updates the version of NodeJS to pick up recent patches.
QB-30798	Non-deterministic subset of rows loaded from Parquet file	Fixed an issue where Parquet files would not load all rows for particular nested structures. The files had to contain a column with repeated pairs of data. Additionally, the number of repeats had to be changing over the file.
QB-31060	Qlik Sense: Qlik embed error when using a virtual proxy with prefix	Fixed a problem that occurred when embedding a UI with an iframe using a server with a virtual proxy prefix as host in the embed config. The problem was caused by fetching a javascript used to register a service worker without the virtual proxy prefix.

 

November 2024 Patch 4

Key	Title	Description
QB-30811	Fix for app thumbnail alt tag	The app thumbnail was missing an alt tag. Since the thumbnail is purely decorative, an empty alt tag has been added.
QB-30760	Selection bar contrast issue	In sheet view in an app, the background of the selection bar was dark enough to give the text low contrast. By brightening the background, the contrast has been increased, increasing readability of text.
QB-30629	Qlik Sense: Unable to open tables with empty header in Excel	Exporting tables to Excel while "Table formatting" is enabled but with an empty header definition would make the resulting file corrupted and unable to be opened in Excel. This issue has been fixed.
TLV-630	Sheet and Bookmarks accessible directly in Qlik Sense toolbar	'Sheets' and 'Bookmarks' have been re-added as items in the default configuration of the app toolbar. This setting can be configured by opening the app settings, and selecting 'UI settings'.

 

November 2024 Patch 3

Key	Title	Description
QB-30730	Qlik Engine: Display error for null date or time values in Excel	When exporting a table containing null date or time values from an app into Excel, those values would be displayed using the wrong character. The values were incorrectly exported as numerical data instead of dates but the issue has been resolved.
NLC-124	Qlik Sense: Issue with Insight Advisor Chat in Portuguese	In the context of a multi-cloud deployment, some modules and libraries were not loading correctly and created issues with the Insight Advisor Chat when set to languages other than English, such as Portuguese. Missing libraries now load properly.

 

November 2024 Patch 2

Key	Title	Description
QB-29911	Qlik Sense: Engine times out when calculating dimensions in large applications	When trying to allocate large chunks of the local heap (between 1.2 GB and 2.4 GB) a bug would cause an infinite loop that could hang the engine process. The bug has been fixed.
QB-30110	Qlik Cloud Services: Fuzzy search using Latin characters returns Chinese characters first	Searching a term in a file using Latin characters would return terms with Chinese characters first in the results, even though they don't match. This was due to non-ascii characters, such as Chinese, not being supported for fuzzy search. The bug has been fixed and searches should now return the expected results.
QB-29868	Visualizations: Adding access to clear all and delete buttons via keyboard	We have added the ability to navigate to the clear all and delete buttons using the keyboard, and announcing what they do through the screen reader.

 

November 2024 Patch 1

Multi-Language Support Available in Insight Advisor Chat
A drop-down button has been added that allows users in Insight Advisor Chat to change the language used when having natural language interactions. Supported Languages are here.

 

November 2024

Key	Title	Description
QB-29903	"Not found" error on file preview and reload for some SFTP connections.	Depending on SFTP server, some valid connections returned the "not found" error on selecting file on preview or file reloading. This degrade is now fixed.
QB-29610	Qlik Engine: New optional parameter Hint for XIRR Aggregation function	When a Hint argument is provided, XIRR will pick the numerically closest valid answer it can find, which can be either a positive or a negative one. If no hint value is provided, it will always pick a positive solution before a negative one.
QB-29492	Qlik Sense Visualizations: Variance Waterfall fails to export as PDF or image	Fixed a problem introduced with the February 2024 release which prevented the exporting Variance waterfall to PDF or image.
QB-29401	Visualizations: Problem replacing invalid dimensions / measures master items	Fixed a problem where replacing dimensions or measures would sometimes fail if they were linked to a non-existing master dimension.
QB-29232	Qlik Sense Visualizations: The 'More' menu in the filter pane displayed incorrectly	The 'More' menu in filter panes displayed incorrectly under other objects or the assets panel.
QB-29043	Qlik Engine: Distinct count on key fields incorrectly handling key subsets in reports	In reporting mode, a set expression with a distinct count over a key field was not always calculated correctly. The calculation outcome depended on the table load order and the subset relation of the key in the tables. The reporting calculation now builds an invariant and well-determined field and table state.
QB-29033	Qlik Sense Platform: WebSocket connection lost	Fixed a problem that would, in some cases, throw an exception that caused the loop WebSocket listener to terminate.
QB-29018	Qlik Sense Engine: Incorrect library function used for deleting an element from object array	While updating the properties cache for DeleteChild operation, the library function used to remove an element from the childlist object array causes the last element to be moved to the deleted element index. This causes the original order of remaining elements to be changed. Fix is added to use the library function which preserves the order of remaining elements.
QB-29009	Visualizations: Problems with sheet navigation	Fixed a problem that intermittently prevented opening apps, adding new sheets, and navigating existing sheets. This was solved by optimizing the reranking of sheets whenever there are rank conflicts.
QB-28873	Qlik License: Captcha box not always visible on the the Signed License Definition	Fixed a problem where the Captcha box was not always visible on the Signed License Definition site.
QB-28865	Qlik Sense Visualizations: Cannot set or unset bookmark as default	Fixed a problem that prevented the setting or unsetting of the default bookmark within an app.
QB-28864	Qlik Engine: Window script function converts Nulls to text	Fixed a problem where the window function would incorrectly translate loaded null fields to '-' which could then be selected. With this fix, the handling of null values is corrected and null fields remain null.
QB-28741	Qlik Sense Visualizations: The listbox 'More' menu for tables and pivot tables closed without changes	When selecting one of the options in the listbox 'More' menu, it closed without applying the changes. The selections are now applied correctly instead of closing the menu.
QB-28727	Visualizations: Not possible to search for bookmark	Now validating bookmark creation date before the formatting date.
QB-28658	Visualizations: Sheet styles not working for newly created apps	Fixed a problem where sheet styles did not persist on new apps. Properties are now bound to the visual elements which show the changes.
QB-28630	Visualizations: Incorrect position of data points on a line chart	Fixed a problem that caused data points to be incorrectly positioned on small screens or when zooming to 125%.
QB-28611	Qlik Engine: Lineage data API is not working when using Preceding LOAD	Fixed a problem where the /v1/apps/{appId}/data/lineage API returned an empty discriminator for Load From statements with a preceding load.
QB-28589	Qlik Sense Visualizations: Field titles missing in Chart Exploration	Alternative columns were initially shown without proper titles in the new Qlik Sense straight table's chart exploration. This happened during sheet editing and when users worked with the exploration feature to add and remove columns.
QB-28453	Qlik Sense Engine: Dynamic scripts in charts did not add or replace values in the correct rows	When evaluated in a chart, the dynamic scripts did not have access to the context information used to access the source rows. Therefore, they only used one row for all additions and replacements.
QB-28451	Qlik Sense Engine: Dynamic scripts were not evaluated when expected	The engine only checked if a chart contained expressions when determining if it should be evaluated as a table or a hypercube. This meant that any hypercube modifiers such as dynamic scripts were ignored if the chart did not contain an expression.
QB-28426	Qlik Enterprise Connectors: Amazon Redshift populating duplicate columns	This enhancement addresses an issue where duplicate columns were being fetched when schemas with the same name existed in both the external schema and the Datashare schema. Now, columns are retrieved only from the selected database schema, ensuring accurate data retrieval and eliminating duplicate columns.
QB-28406	Qlik Sense: Axios security issue	Fixed a security issue caused by Qlik Sense using an old version of Axios. The was resolved by updating the version of Axios used by Qlik Sense.
QB-28395	Qlik Sense: Tooltips do not display for selected dimensions	Fixed a problem that prevented the display of tooltips for selected dimensions in Associative insights. This was due to a missing attribute which has now been restored.
QB-28392	Qlik Enterprise Connectors: Google Big Query Connector - Select dialog	Changing the catalog from dropdown did not refresh the list of databases.
QB-28299	Qlik Sense Engine: The Concat function resulted in a faulty lineage	In some cases, when the Concat function was used in combination with the FROM load statement, the Concat function did not add the correct sources for a field, resulting in an faulty lineage graph. The faulty graph assumed that the sources were present and therefore incremented an internal index, which resulted in incorrect relations between nodes. Support for the Concat function has been added for lineage and it will now properly add the sources.
QB-28201	Qlik Engine: Iterator is shown as a non-integer when using large values	Fixed a problem with the string conversion method used in a FOR loop, which caused formatting issues when handling large values.
QB-28142	Qlik Sense Engine: Missing privileges for connections	Fixed a problem where connections that were fetched using REST API were missing privileges. This would cause the Add data button to be missing from the connection Attached Files.
QB-27988	Qlik Engine: Syntax error on tab during script execution	Fixed a LOAD script parsing problem when the WHERE clause contains "(".
QB-27933	Qlik Sense: Date picker library is outdated	Updated momentJS to the latest version.
QB-27902	Qlik Sense Engine: Hypercube modifier REPLACE LOAD sourced data incorrectly and added rows to chart	When REPLACE LOAD was used in a dynamic chart script, it was using only one row for the source data regardless of the actual number of source rows. It also incorrectly added rows to the chart.
QB-27821	Resolved UI issue: Restored internal menu functionality in Dev Hub	In the Mashup editor in Dev Hub, the 'Menu' button in the toolbar was inadvertently replaced with a 'Help' button. The issue is resolved and access to the 'Menu' button has been restored.
QB-27754	Qlik Sense: CORS error blocks external API requests	Fixed an issue with CORS (Cross-Origin Resource Sharing) requests that were blocked when making external API requests. The issue was related to the handling of the "withCredentials" option in the requests.
QB-27751	Qlik Sense Visualizations: Overflow on button labels was not displaying correctly with ellipses	The button labels were missing settings for text overflow. CSS settings were added and now the labels work as expected.
QB-27657	Qlik Sense Engine: Parquet file not deleted	Parquet files were in some cases not deleted after being used. This has been fixed by not using the MemoryMap option when opening Parquet files for reading when the files have been downloaded using a web connector.
QB-27639	Schedule reload task using custom schedule	When adding a custom filter, some valid format options produced an error.
QB-27632	Qlik Sense Engine: Incorrect format when exporting a table containing dates	When exporting a table containing dates to Microsoft Excel, the date fields were exported in numeric format, instead of formatted date/time. This has been fixed by treating unformatted date/time values as formatted Excel date/time fields, using default formats that adjust to the viewer's locale.
QB-27623	"Show totals above" option is missing when converting native Pivot table to Pivot table (Visualization bundle)	An issue was identified in which the "Show totals above" option" is not shown when converting a native Pivot table to the Pivot table from the Visualization bundle. The issue has been resolved by adjusting a setting for indent mode.
QB-27565	Qlik Sense Visualizations: Added sanity check for invalid column width values, preventing view data crashing	Possibly due to converting a table to a pivot table, the, the values stored in the pivot table properties for column widths were incorrect. When the view data mode was selected, those incorrect values caused the chart to crash. A sanity check has been added to prevent the crash.
QB-27477	Qlik Engine: Tables with the same expression show different results	Fixed a problem when SET analysis constraints did not correctly limit the number of rows in the hypercube, leading to inconsistent results for the same expression.
QB-27393	Visualizations: Filter pane selection options are not displayed	Fixed a problem where expanding a filter pane caused the buttons for making different selection options (such as more, clear selection, cancel, and confirm)  were not displayed.
QB-27352	Qlik sense Visualizations: Selection popup and bar is blank when using getGlobal method in a mashup	Fixed a problem where listboxes within mashups could stop working. This problem occurred specifically for mashups created using the Capability API and calling the qlik.getGlobal function.
QB-27348	Qlik Enterprise Connectors: Invalid Session Token error for Amazon Athena connections	Resolved an issue with the Amazon Athena connector when using a proxy with user name and password to authenticate the connection. The resolution involved fixing the authentication process so that the Proxy Username value entered by the user is properly forwarded to the driver.
QB-27277	Qlik Sense Visualizations: Data Manager custom association field preview not working	Fixed a problem that caused the preview of the custom association fields to stop working when selecting which fields to associate the tables with.
QB-27237	Qlik Sense: Custom Trigger with double digits causes custom filter validation error	Custom filter now allows the use of double digits for the hourly position for Tasks in the Qlik Management Console.
QB-27227	Bar chart label incorrect when the result is 1.95	Fixed floating error on formatting.
QB-27147	Qlik Sense Visualizations: Qlik Sense icon not showing in apps on May 2024 IR	Fixed a problem that caused the favicon to disappear on some apps.
QB-27108	Visualizations: Exporting object with styling fails	Fixed a problem where exporting any object with shadow values as an image would fail. This was solved by disabling chart shadows on server printing.
QB-27008	Qlik Sense Visualizations: "Color by expression"  not working in a dimensionless barchart	Fixed an issue where you could not switch to "Color by expression" in a dimensionless barchart and instead it defaulted to single color.
QB-27006	Qlik Sense Visualizations: Incorrect CSS for overflowing content	When the content of a multi KPI could not fit in the height of the object, the data could end up inaccessible to users. By correcting the CSS, the data can always scrolled to the data.
QB-26965	Qlik Sense Visualizations: Incorrect rendering of heatmap	Fixed a floating error in calculating the number of rows and columns that caused heatmaps to render incorrectly.
QB-26946	Qlik Mobile zooming issue	Prevented users from interacting with a chart in a small device if the browser is zoomed in.
QB-26936	Qlik Sense Engine: Select and search methods fail to parse search strings starting with certain characters	Search strings starting with any of the following characters: <>\"~()='[] would not be parsed correctly when the user was expecting an exact search. A fix was added which will allow users to force an exact search by adding an extra backslash "\" before any of the special characters (for example, to search for "<x>" enter the search string "\<x>"). This fix is disabled by default. To enable it, update the Settings.ini file to include "EnableSpecialCharacterEscapingInSearch = 1".
QB-26902	Qlik Sense Visualizations: The button object was unclickable in a mashup if the label was too long	Buttons with long labels are now clickable within a mashup.
QB-26880	Qlik Web Connectors: Files stored in a team folder are inaccessible through the Dropbox connector	A new connection parameter was added to access Dropbox team folders and files. The root parameter allows the selection of team root if it's available for authenticated users.
QB-26872	Qlik Sense Engine: Resolving issues from open app performance enhancements	There were some issues with connection deletion behavior after implementing performance enhancements for opening apps. These have been resolved.
QB-26840	Qlik Sense Engine: The <CreatorDoc> tag is empty in QVDs created with Qlik Sense February 2024	Fixed a problem where the <CreatorDoc> tag in the metadata of QVD files created with Qlik Sense February 2024 was empty, instead of showing the app ID that generated the QVD. <CreatorDoc> tags are now written from the STORE statement, even if the format spec is omitted.
QB-26786	Qlik Sense Visualizations: Alternative measure & dimension dropdown was not updating correctly	The alternative measure & dimension dropdown did not update correctly when a user edited a chart. This issue has been fixed.
QB-26669	Qlik Sense Engine: Problem exporting straight table to Excel	Fixed a problem with handling the pre-generated format string for Euro during Excel export from the Qlik Engine.
QB-26657	Qlik Sense Visualizations: Qlik extensions lost custom properties after server restart	Three extensions did not have the version specified correctly: - sn-layout-container - sh-shape - sn-text The versions are now updated properly in all files for these extensions
QB-26613	Qlik Engine: Dimension created with Aggr function does not fully support selection	Fixed an issue that would cause some apps to have a limited ability to make selections in a dimension created using the Aggr function.
QB-26558	Qlik Engine: Connector performance reload issues in Qlik Sense February 2024	The Select Statement Lineage for Sense Server has been disabled as it served no purpose in Qlik Sense Enterprise on Windows. This was causing issues with some connectors by making irrelevant calls in Sense Server.
QB-26530	Qlik Sense: Custom Cache Control settings not maintained with server reboot	Enhanced the Hub service to use a retry mechanism, allowing it to wait for the QRS API's /ContentCacheControl endpoint to respond.
QB-26504	Qlik Cloud Engine: Line Chart not showing all values for X-axis	Fixed an issue that would, in some apps, exclude the highest magnitude dimension value from a chart using a continuous x-axis. This could happen when the data point's x-axis value was encoded using more than the 15-digit precision used in the QIX Engine
QB-26486	Qlik Sense on Windows: Straight table columns unusable with auto width	Fixed a problem where columns in straight tables using auto width became unusable. The minimum width has been increased to 120px.
QB-26447	Visualizations: Some table column headers do not wrap	Due to an indexing error in the table code, the showing/hiding header icons and wrapping header text, were based on the wrong column. These calculations now use the correct index and the text wrap and icons are shown correctly.
QB-26407	Qlik Sense: Node.js updated	Node.js has been updated to version 18.20.4.
QB-26392	Qlik Sense on Windows: Failing requests to fetch custom brand spam console	Fixed a problem where requests specific to the Qlik Cloud Services offering were made on Qlik Sense Enterprise for Windows deployment causing the failing requests to spam the console.
QB-26205	Visualizations: Cannot rearrange columns in the new Straight Table	Fixed a problem where columns could not be rearranged in the new straight table if the table had conditional columns.
QB-26199	Visualizations: Undo button not working	Fixed a problem where the undo button was unresponsive after unlinking a master dimension.
QB-26192	Connection issues after access token expiration	Dependent connection parameters were not being properly passed when re-authenticating after access token expiration for several connectors, and the default values for these parameters were being used instead. This fix correctly passes in the necessary parameters. This issue affected the Azure Storage, MSCRM, OneDrive, Office365, and Outlook365 connectors.
QB-26106	Qlik Engine: HypercubeEvaluator calculation error	Fixed a problem in a hypercube calculation that returned a row even when the selection result was empty. After the fix now rows should be returned.
QB-26098	Scatter plot labels	Fixed a problem with the rendering of the scatter plot during changes in viewing data.
QB-25981	Incorrect translation: Japanese	Corrected the Japanese translation for "Sorting in search" when working with pivot tables.
QB-25920	Qlik Engine: Unable to filter text values of QVD in Data Manager	Fixed a problem where the filtering of a text field for QVD files was not working. If the field type was a string but the filter value was a number (for example: 1), the filter would not work. This has been fixed by forcing the columns to be interpreted as text.
QB-25909	Qlik Sense on Windows: Unsupported trigger time zone reported as (GMT + 0000)	This adds a fix for setting Daylight Savings Time to Permanent Standard Time if the time zone is not supported by the Qlik Management Console (QMC).
QB-25871	Qlik Engine: Cannot reference iterator value using $() in chart script	In a chart script, the iterator in a "For… Next" loop could not be used in a dollar expansion expression. This has now been fixed.
QB-25773	Visualizations: Inconsistent behavior when pressing home/end keys	Fixed a problem that caused inconsistent behavior when pressing the home/end in the search listbox of a filter pane.
QB-25730	Qlik Sense Engine: Inner set expression issue when outer set expression is present	Fixed an issue that caused the miscalculation of inner set expressions when outer set expressions were present. The inner set expression {<Field1=StateA::Field1>} will now read Field1 correctly from StateA even when an outer set expression is present.
QB-25031	Qlik Web Connectors: Unable to load data from Odata database via Qlik Odata connector	Fixed a problem where a "System.OutOfMemoryException" would be thrown if the OData connector returned a large response. This was solved by accepting smaller values in the Max depth parameter. Additionally, new tables have been added to retrieve information (V4GetSchemas, V4GetEntities, and V4GetProperties).
QB-25016	Qlik Sense: Issue with display scaling on Qlik Sense on Windows February 2024	Fixed a problem with scaling present on high DPI monitors.
QB-24997	Qlik Sense on Windows: Exception importing sheets to NPrinting May 2023	Fixed a problem on the main-web-container component shipped with QSEoW that caused NPrinting exports of extended Sense sheets to fail when a Sense app carded theme was used.
QB-24968	Qlik Web Connectors: Error when importing a table using the Qlik ODATA connector	Fixed a problem that caused an error ("Sequence contains no elements") when retrieving data from the JsonV4GetData table. With this fix, paces in path parameter values are now processed correctly.
QB-24536	Data Prep & Insights: Import from SharePoint fails with error message	For some connectors, the same QVD ID (file name) was generated for two table sources, resulting in an error message ("Data could not be added to Data Manager"). We have changed how the QVD ID is generated by adding a load statement and including it in the text to generate the hash.
QB-23881	Qlik Sense: User details exposed in WebSockets (CWE-200	Fixed a vulnerability problem where user details were exposed in WebSockets (CWE-200 information exposure). This was solved by hiding the owner data for Anonymous User Context in AppPropList and the Owner data in the Hub App Card for Anonymous User Context.
QB-23565	Improved HTTP header validation	Improved HTTP communication by providing additional header validations.

 

Known issues and limitations

The following issues and limitations were identified at release time. The list is not comprehensive but lists all known major issues and limitations.

Clients

• Third-party extensions are currently not supported on mobile devices, and the Qlik Trusted Extension Developer program does not accredit extensions for use on mobile devices. Generated items might not be visualized properly on a mobile device, depending on individual device specifications, mobile OS, and the size of the Qlik Sense app.
• When you consume Qlik Sense apps using the Microsoft Edge browser on touch/hybrid devices, the long-press action does not work. This prevents you from accessing functions such as an object’s context menu, which requires a long press in touch mode. This is a Microsoft Edge issue.
  Workaround: If you use a hybrid device, turn off touch mode, and then turn it back on again.
• Export as Anonymous does not work for mashups deployed in a domain that is different from the domain where Qlik Sense is installed. Export only works for Anonymous if the mashup is deployed in the same domain as Qlik Sense.
• When using the new Load Extension syntax in the load script, the Data Load Editor syntax completion does not work well after the keyword “Extension” when trying to write the call to an SSE function (AAI function). The script still executes correctly.
• Legend does not show dimension values after row number 3000.
• Limitations when exporting a story to PowerPoint:   
  • Titles are not rescaled as HTML. Font settings are not exported.
  • Storytelling effects are not applied.
  • Exported charts might show fixed scroll bars, depending on the export resolution.
• It is not possible to open the context menu of an org chart on a touch device.
• When you choose to view data in the context menu in a dynamic chart and make a new selection in the app, you need to refresh the browser for the chart to be displayed again.
• New/Updated - Android mobile devices: Customers using Android mobile devices via the Qlik Sense mobile app need to update their QSM-CM Android app to 1.30.1 which is now on play store.

 

Dynamic views

• Dynamic views that you delete from one app are also deleted from every other app that was using the same view. There is no workaround for this issue. Avoid deleting views that might already be in use by other apps.
• When you create a new dynamic view in the assets pane, the dropdown menu item does not automatically change to show the charts of the newly created dynamic view if there are any existing dynamic views. You must click on the dropdown menu to choose the newly created view.
• The data for a dynamic view is automatically refreshed whenever you open a sheet that contains charts for the view. The same happens when you enter and then return from the global selections pane, and when you add a new chart for the view. Refrain from performing these actions on the base app to prevent triggering refreshes.
• The view of a dynamic chart is cleared and shows a message indicating a view constraint violation whenever you change the selection state of the base app in a way that violates the view's constraints. Refrain from changing the selection state of the base app until it has finished making use of the data in any of the dynamic view charts.
• The ‘Go to source’ option on a snapshot slide (available on right-click) for a dynamic chart does not select the actual dynamic chart when you change the view to the base app sheet.
• Changes to chart settings for dynamic view charts using the Exploration menu are lost after refreshing the view.
• Dynamic views do not support the Trellis extension.

 

Managing a Qlik Sense site

• The Edit pane under Custom properties in the Qlik Management Console (QMC) can currently handle a limited number of custom properties. If you want to edit custom property values in the QMC, we recommend keeping the number of custom property values to a maximum of 500. If you want to apply values without modifying them, the QMC can handle up to 10,000 custom property values.
• When you remove app objects from an application via the QMC interface, deleted objects are not removed from the application’s binary file stored on the file system.
• It is not possible to use a security rule on the HubSection_* resource to hide the ‘Open hub’ link from the navigation menu when accessing an app as an anonymous user.  
  Workaround: Use reverse proxy to redirect the ‘Open hub’ link to a preferred landing site.
• Windows service Qlik Engine cannot be started on a node where the Qlik Engine service is disabled through the QMC. Every time Windows restarts for that node, the Qlik Engine service fails to start up and throws an error in Windows event logs. You can prevent this by temporarily disabling the Qlik Engine service in Windows Service Manager.
• Data connection passwords containing special characters (such as "=", "%", or ";") are not properly encoded when updated via the QMC. This causes authentication errors when trying to connect to specific data sources, which could cause reload tasks to fail.  
  Workaround: Use the data load editor to update the password. Note that once the password is updated, the name of the data connection is automatically appended by "(domain_userId)". You can adjust this later via the QMC.

 

Qlik Sense Desktop

• Qlik Sense Desktop can play WebM and Ogg but not MP4 files. This is due to limitations in Chromium.

 

Connectors

• REST connector: The ‘Next token’ pagination option does not work when the pagination token has the same value for each page.
• For connectors in the ODBC Connector Package only the data types listed as supported in the online help have been verified to work correctly in the Preview and Script editor. However, the ODBC Connector Package does not prevent you from loading other data types. In some cases, you can load unsupported data types with the load script.
• ODBC connector: Database connectors in the ODBC Connector Package do not work properly if the username on the Microsoft Windows system running Qlik Sense Desktop contains letters that are not English alphanumeric characters.
  Workaround: Change the Windows system locale to match the character set that contains the characters used in the username. For example, if the system locale on the system running Qlik Sense Desktop is set to English and a username contains Swedish characters, you must change the system locale to Swedish for the ODBC connector to work properly.
• The Qlik Salesforce connector does not support PK chunking on sharing objects. PK chunking is only supported on parent objects.
• The Apache Phoenix connector does not support non-Latin characters in metadata. The connector might return corrupted data or unpredictable query results if you run a query with non-Latin characters in metadata, such as table names, column names, and aliases.

 

Cloud deployments and Multi-Cloud

• When you download a pivot table in Qlik Sense Enterprise SaaS, expanded rows are not included but stay collapsed.

 

Upgrade notes

Important Notice for Android Mobile Users

Customers using Android mobile devices via the Qlik Sense mobile app need to update their app to version 1.30.1 which is now on play store.

 

For upgrade advisory regarding required add-on upgrades, see Community post.

 

System requirements notes

For information about the requirements for Qlik Sense, see System requirements for Qlik Sense in the online help.

 

Downloads

Download this release from the Product Downloads page on Qlik Community.

 

About Qlik

Qlik converts complex data landscapes into actionable insights, driving strategic business outcomes. Serving over 40,000 global customers, our portfolio provides advanced, enterprise-grade AI/ML, data integration, and analytics. Our AI/ML tools, both practical and scalable, lead to better decisions, faster. We excel in data integration and governance, offering comprehensive solutions that work with diverse data sources. Intuitive analytics from Qlik uncover hidden patterns, empowering teams to address complex challenges and seize new opportunities. As strategic partners, our platform-agnostic technology and expertise make our customers more competitive.

qlik.com

Show Less

Table of Contents

• What's new in Qlik Sense Technical Preview November 2024
• November 2024 – Technical Preview
• Resolved Defects
• Technical Preview November 2024
• Known issues and limitations
• Clients
• Dynamic views
• Managing a Qlik Sense site
• Qlik Sense Desktop
• Connectors
• Cloud deployments and Multi-Cloud
• Upgrade notes
• System requirements notes
• Downloads

 

This is Release notes for a Technical Review and are only available for a limit time. This release note will be archived when November 2024 is released.

What's new in Qlik Sense Technical Preview November 2024

November 2024 – Technical Preview

Please note: For the best experience, we recommend that you install this preview as a "fresh installation" only - not as an upgrade on your current setup. While upgrades are technically possible, they may impact performance. When the Initial Release (IR) version of the November 2024 release is live, upgrades will be fully supported.

 

Distribution to cloud tenants
We have removed the dependency on license type, allowing all client-managed subscription models to distribute Qlik Sense apps to a Qlik Cloud tenant.

 

Vizualization and client enhancements

• New asset panel with sheet grouping enabled.
• Improvements to pivot tables, straight tables, and combo charts.
• User-provided labels in the selection bar.

 

Postgres database support
Added support for Postgres versions 15 and 16.

 

Security enhancements
If you are using mashups or have cross-site domain setups, add the following response headers to enhance security and control access. These headers help protect against Cross-Site Forgery (CSRF) attacks:

• Access-Control-Allow-Origin: https://localhost:8080
• Access-Control- Allow-Credentials: true
• Access-Control-Expose-Headers: qlik-csrf-token

 

Resolved Defects

Technical Preview November 2024

Key	Title	Description
QB-29492	Qlik Sense Visualizations: Variance Waterfall fails to export as PDF or image	Fixed a problem introduced with the February 2024 release which prevented the exporting Variance waterfall to PDF or image.
QB-29401	Visualizations: Problem replacing invalid dimensions / measures master items	Fixed a problem where replacing dimensions or measures would sometimes fail if they were linked to a non-existing master dimension.
QB-29232	Qlik Sense Visualizations: The 'More' menu in the filter pane displayed incorrectly	The 'More' menu in filter panes displayed incorrectly under other objects or the assets panel.
QB-29043	Qlik Engine: Distinct count on key fields incorrectly handling key subsets in reports	In reporting mode, a set expression with a distinct count over a key field was not always calculated correctly. The calculation outcome depended on the table load order and the subset relation of the key in the tables. The reporting calculation now builds an invariant and well-determined field and table state.
QB-29033	Qlik Sense Platform: WebSocket connection lost	Fixed a problem that would, in some cases, throw an exception that caused the loop WebSocket listener to terminate.
QB-29018	Qlik Sense Engine: Incorrect library function used for deleting an element from object array	While updating the properties cache for DeleteChild operation, the library function used to remove an element from the childlist object array causes the last element to be moved to the deleted element index. This causes the original order of remaining elements to be changed. Fix is added to use the library function which preserves the order of remaining elements.
QB-29009	Visualizations: Problems with sheet navigation	Fixed a problem that intermittently prevented opening apps, adding new sheets, and navigating existing sheets. This was solved by optimizing the reranking of sheets whenever there are rank conflicts.
QB-28873	Qlik License: Captcha box not always visible on the the Signed License Definition	Fixed a problem where the Captcha box was not always visible on the Signed License Definition site.
QB-28865	Qlik Sense Visualizations: Cannot set or unset bookmark as default	Fixed a problem that prevented the setting or unsetting of the default bookmark within an app.
QB-28864	Qlik Engine: Window script function converts Nulls to text	Fixed a problem where the window function would incorrectly translate loaded null fields to '-' which could then be selected. With this fix, the handling of null values is corrected and null fields remain null.
QB-28741	Qlik Sense Visualizations: The listbox 'More' menu for tables and pivot tables closed without changes	When selecting one of the options in the listbox 'More' menu, it closed without applying the changes. The selections are now applied correctly instead of closing the menu.
QB-28727	Visualizations: Not possible to search for bookmark	Now validating bookmark creation date before the formatting date.
QB-28658	Visualizations: Sheet styles not working for newly created apps	Fixed a problem where sheet styles did not persist on new apps. Properties are now bound to the visual elements which show the changes.
QB-28630	Visualizations: Incorrect position of data points on a line chart	Fixed a problem that caused data points to be incorrectly positioned on small screens or when zooming to 125%.
QB-28611	Qlik Engine: Lineage data API is not working when using Preceding LOAD	Fixed a problem where the /v1/apps/{appId}/data/lineage API returned an empty discriminator for Load From statements with a preceding load.
QB-28589	Qlik Sense Visualizations: Field titles missing in Chart Exploration	Alternative columns were initially shown without proper titles in the new Qlik Sense straight table's chart exploration. This happened during sheet editing and when users worked with the exploration feature to add and remove columns.
QB-28453	Qlik Sense Engine: Dynamic scripts in charts did not add or replace values in the correct rows	When evaluated in a chart, the dynamic scripts did not have access to the context information used to access the source rows. Therefore, they only used one row for all additions and replacements.
QB-28451	Qlik Sense Engine: Dynamic scripts were not evaluated when expected	The engine only checked if a chart contained expressions when determining if it should be evaluated as a table or a hypercube. This meant that any hypercube modifiers such as dynamic scripts were ignored if the chart did not contain an expression.
QB-28426	Qlik Enterprise Connectors: Amazon Redshift populating duplicate columns	This enhancement addresses an issue where duplicate columns were being fetched when schemas with the same name existed in both the external schema and the Datashare schema. Now, columns are retrieved only from the selected database schema, ensuring accurate data retrieval and eliminating duplicate columns.
QB-28406	Qlik Sense: Axios security issue	Fixed a security issue caused by Qlik Sense using an old version of Axios. The was resolved by updating the version of Axios used by Qlik Sense.
QB-28392	Qlik Enterprise Connectors: Google Big Query Connector - Select dialog	Changing the catalog from dropdown did not refresh the list of databases.
QB-28299	Qlik Sense Engine: The Concat function resulted in a faulty lineage	In some cases, when the Concat function was used in combination with the FROM load statement, the Concat function did not add the correct sources for a field, resulting in an faulty lineage graph. The faulty graph assumed that the sources were present and therefore incremented an internal index, which resulted in incorrect relations between nodes. Support for the Concat function has been added for lineage and it will now properly add the sources.
QB-28201	Qlik Engine: Iterator is shown as a non-integer when using large values	Fixed a problem with the string conversion method used in a FOR loop, which caused formatting issues when handling large values.
QB-28142	Qlik Sense Engine: Missing privileges for connections	Fixed a problem where connections that were fetched using REST API were missing privileges. This would cause the Add data button to be missing from the connection Attached Files.
QB-27988	Qlik Engine: Syntax error on tab during script execution	Fixed a LOAD script parsing problem when the WHERE clause contains "(".
QB-27933	Qlik Sense: Date picker library is outdated	Updated momentJS to the latest version.
QB-27902	Qlik Sense Engine: Hypercube modifier REPLACE LOAD sourced data incorrectly and added rows to chart	When REPLACE LOAD was used in a dynamic chart script, it was using only one row for the source data regardless of the actual number of source rows. It also incorrectly added rows to the chart.
QB-27821	Resolved UI issue: Restored internal menu functionality in Dev Hub	In the Mashup editor in Dev Hub, the 'Menu' button in the toolbar was inadvertently replaced with a 'Help' button. The issue is resolved and access to the 'Menu' button has been restored.
QB-27754	Qlik Sense: CORS error blocks external API requests	Fixed an issue with CORS (Cross-Origin Resource Sharing) requests that were blocked when making external API requests. The issue was related to the handling of the "withCredentials" option in the requests.
QB-27751	Qlik Sense Visualizations: Overflow on button labels was not displaying correctly with ellipses	The button labels were missing settings for text overflow. CSS settings were added and now the labels work as expected.
QB-27657	Qlik Sense Engine: Parquet file not deleted	Parquet files were in some cases not deleted after being used. This has been fixed by not using the MemoryMap option when opening Parquet files for reading when the files have been downloaded using a web connector.
QB-27639	Schedule reload task using custom schedule	When adding a custom filter, some valid format options produced an error.
QB-27632	Qlik Sense Engine: Incorrect format when exporting a table containing dates	When exporting a table containing dates to Microsoft Excel, the date fields were exported in numeric format, instead of formatted date/time. This has been fixed by treating unformatted date/time values as formatted Excel date/time fields, using default formats that adjust to the viewer's locale.
QB-27623	"Show totals above" option is missing when converting native Pivot table to Pivot table (Visualization bundle)	An issue was identified in which the "Show totals above" option" is not shown when converting a native Pivot table to the Pivot table from the Visualization bundle. The issue has been resolved by adjusting a setting for indent mode.
QB-27565	Qlik Sense Visualizations: Added sanity check for invalid column width values, preventing view data crashing	Possibly due to converting a table to a pivot table, the, the values stored in the pivot table properties for column widths were incorrect. When the view data mode was selected, those incorrect values caused the chart to crash. A sanity check has been added to prevent the crash.
QB-27477	Qlik Engine: Tables with the same expression show different results	Fixed a problem when SET analysis constraints did not correctly limit the number of rows in the hypercube, leading to inconsistent results for the same expression.
QB-27393	Visualizations: Filter pane selection options are not displayed	Fixed a problem where expanding a filter pane caused the buttons for making different selection options (such as more, clear selection, cancel, and confirm)  were not displayed.
QB-27352	Qlik sense Visualizations: Selection popup and bar is blank when using getGlobal method in a mashup	Fixed a problem where listboxes within mashups could stop working. This problem occurred specifically for mashups created using the Capability API and calling the qlik.getGlobal function.
QB-27348	Qlik Enterprise Connectors: Invalid Session Token error for Amazon Athena connections	Resolved an issue with the Amazon Athena connector when using a proxy with user name and password to authenticate the connection. The resolution involved fixing the authentication process so that the Proxy Username value entered by the user is properly forwarded to the driver.
QB-27277	Qlik Sense Visualizations: Data Manager custom association field preview not working	Fixed a problem that caused the preview of the custom association fields to stop working when selecting which fields to associate the tables with.
QB-27237	Qlik Sense: Custom Trigger with double digits causes custom filter validation error	Custom filter now allows the use of double digits for the hourly position for Tasks in the Qlik Management Console.
QB-27227	Bar chart label incorrect when the result is 1.95	Fixed floating error on formatting.
QB-27147	Qlik Sense Visualizations: Qlik Sense icon not showing in apps on May 2024 IR	Fixed a problem that caused the favicon to disappear on some apps.
QB-27108	Visualizations: Exporting object with styling fails	Fixed a problem where exporting any object with shadow values as an image would fail. This was solved by disabling chart shadows on server printing.
QB-27008	Qlik Sense Visualizations: "Color by expression"  not working in a dimensionless barchart	Fixed an issue where you could not switch to "Color by expression" in a dimensionless barchart and instead it defaulted to single color.
QB-27006	Qlik Sense Visualizations: Incorrect CSS for overflowing content	When the content of a multi KPI could not fit in the height of the object, the data could end up inaccessible to users. By correcting the CSS, the data can always scrolled to the data.
QB-26965	Qlik Sense Visualizations: Incorrect rendering of heatmap	Fixed a floating error in calculating the number of rows and columns that caused heatmaps to render incorrectly.
QB-26946	Qlik Mobile zooming issue	Prevented users from interacting with a chart in a small device if the browser is zoomed in.
QB-26936	Qlik Sense Engine: Select and search methods fail to parse search strings starting with certain characters	Search strings starting with any of the following characters: <>\"~()='[] would not be parsed correctly when the user was expecting an exact search. A fix was added which will allow users to force an exact search by adding an extra backslash "\" before any of the special characters (for example, to search for "<x>" enter the search string "\<x>"). This fix is disabled by default. To enable it, update the Settings.ini file to include "EnableSpecialCharacterEscapingInSearch = 1".
QB-26902	Qlik Sense Visualizations: The button object was unclickable in a mashup if the label was too long	Buttons with long labels are now clickable within a mashup.
QB-26880	Qlik Web Connectors: Files stored in a team folder are inaccessible through the Dropbox connector	A new connection parameter was added to access Dropbox team folders and files. The root parameter allows the selection of team root if it's available for authenticated users.
QB-26872	Qlik Sense Engine: Resolving issues from open app performance enhancements	There were some issues with connection deletion behavior after implementing performance enhancements for opening apps. These have been resolved.
QB-26840	Qlik Sense Engine: The <CreatorDoc> tag is empty in QVDs created with Qlik Sense February 2024	Fixed a problem where the <CreatorDoc> tag in the metadata of QVD files created with Qlik Sense February 2024 was empty, instead of showing the app ID that generated the QVD. <CreatorDoc> tags are now written from the STORE statement, even if the format spec is omitted.
QB-26786	Qlik Sense Visualizations: Alternative measure & dimension dropdown was not updating correctly	The alternative measure & dimension dropdown did not update correctly when a user edited a chart. This issue has been fixed.
QB-26669	Qlik Sense Engine: Problem exporting straight table to Excel	Fixed a problem with handling the pre-generated format string for Euro during Excel export from the Qlik Engine.
QB-26657	Qlik Sense Visualizations: Qlik extensions lost custom properties after server restart	Three extensions did not have the version specified correctly: - sn-layout-container - sh-shape - sn-text The versions are now updated properly in all files for these extensions
QB-26613	Qlik Engine: Dimension created with Aggr function does not fully support selection	Fixed an issue that would cause some apps to have a limited ability to make selections in a dimension created using the Aggr function.
QB-26558	Qlik Engine: Connector performance reload issues in Qlik Sense February 2024	The Select Statement Lineage for Sense Server has been disabled as it served no purpose in Qlik Sense Enterprise on Windows. This was causing issues with some connectors by making irrelevant calls in Sense Server.
QB-26530	Qlik Sense: Custom Cache Control settings not maintained with server reboot	Enhanced the Hub service to use a retry mechanism, allowing it to wait for the QRS API's /ContentCacheControl endpoint to respond.
QB-26504	Qlik Cloud Engine: Line Chart not showing all values for X-axis	Fixed an issue that would, in some apps, exclude the highest magnitude dimension value from a chart using a continuous x-axis. This could happen when the data point's x-axis value was encoded using more than the 15-digit precision used in the QIX Engine
QB-26486	Qlik Sense on Windows: Straight table columns unusable with auto width	Fixed a problem where columns in straight tables using auto width became unusable. The minimum width has been increased to 120px.
QB-26447	Visualizations: Some table column headers do not wrap	Due to an indexing error in the table code, the showing/hiding header icons and wrapping header text, were based on the wrong column. These calculations now use the correct index and the text wrap and icons are shown correctly.
QB-26407	Qlik Sense: Node.js updated	Node.js has been updated to version 18.20.4.
QB-26392	Qlik Sense on Windows: Failing requests to fetch custom brand spam console	Fixed a problem where requests specific to the Qlik Cloud Services offering were made on Qlik Sense Enterprise for Windows deployment causing the failing requests to spam the console.
QB-26205	Visualizations: Cannot rearrange columns in the new Straight Table	Fixed a problem where columns could not be rearranged in the new straight table if the table had conditional columns.
QB-26199	Visualizations: Undo button not working	Fixed a problem where the undo button was unresponsive after unlinking a master dimension.
QB-26106	Qlik Engine: HypercubeEvaluator calculation error	Fixed a problem in a hypercube calculation that returned a row even when the selection result was empty. After the fix now rows should be returned.
QB-26098	Scatter plot labels	Fixed a problem with the rendering of the scatter plot during changes in viewing data.
QB-25981	Incorrect translation: Japanese	Corrected the Japanese translation for "Sorting in search" when working with pivot tables.
QB-25920	Qlik Engine: Unable to filter text values of QVD in Data Manager	Fixed a problem where the filtering of a text field for QVD files was not working. If the field type was a string but the filter value was a number (for example: 1), the filter would not work. This has been fixed by forcing the columns to be interpreted as text.
QB-25909	Qlik Sense on Windows: Unsupported trigger time zone reported as (GMT + 0000)	This adds a fix for setting Daylight Savings Time to Permanent Standard Time if the time zone is not supported by the Qlik Management Console (QMC).
QB-25871	Qlik Engine: Cannot reference iterator value using $() in chart script	In a chart script, the iterator in a "For… Next" loop could not be used in a dollar expansion expression. This has now been fixed.
QB-25773	Visualizations: Inconsistent behavior when pressing home/end keys	Fixed a problem that caused inconsistent behavior when pressing the home/end in the search listbox of a filter pane.
QB-25730	Qlik Sense Engine: Inner set expression issue when outer set expression is present	Fixed an issue that caused the miscalculation of inner set expressions when outer set expressions were present. The inner set expression {<Field1=StateA::Field1>} will now read Field1 correctly from StateA even when an outer set expression is present.
QB-25031	Qlik Web Connectors: Unable to load data from Odata database via Qlik Odata connector	Fixed a problem where a "System.OutOfMemoryException" would be thrown if the OData connector returned a large response. This was solved by accepting smaller values in the Max depth parameter. Additionally, new tables have been added to retrieve information (V4GetSchemas, V4GetEntities, and V4GetProperties).
QB-25016	Qlik Sense: Issue with display scaling on Qlik Sense on Windows February 2024	Fixed a problem with scaling present on high DPI monitors.
QB-24997	Qlik Sense on Windows: Exception importing sheets to NPrinting May 2023	Fixed a problem on the main-web-container component shipped with QSEoW that caused NPrinting exports of extended Sense sheets to fail when a Sense app carded theme was used.
QB-24968	Qlik Web Connectors: Error when importing a table using the Qlik ODATA connector	Fixed a problem that caused an error ("Sequence contains no elements") when retrieving data from the JsonV4GetData table. With this fix, paces in path parameter values are now processed correctly.
QB-24536	Data Prep & Insights: Import from SharePoint fails with error message	For some connectors, the same QVD ID (file name) was generated for two table sources, resulting in an error message ("Data could not be added to Data Manager"). We have changed how the QVD ID is generated by adding a load statement and including it in the text to generate the hash.
QB-23881	Qlik Sense: User details exposed in WebSockets (CWE-200	Fixed a vulnerability problem where user details were exposed in WebSockets (CWE-200 information exposure). This was solved by hiding the owner data for Anonymous User Context in AppPropList and the Owner data in the Hub App Card for Anonymous User Context.
QB-23565	Improved HTTP header validation	Improved HTTP communication by providing additional header validations.

 

Known issues and limitations

The following issues and limitations were identified at release time. The list is not comprehensive but lists all known major issues and limitations.

 

Clients

• Third-party extensions are currently not supported on mobile devices, and the Qlik Trusted Extension Developer program does not accredit extensions for use on mobile devices. Generated items might not be visualized properly on a mobile device, depending on individual device specifications, mobile OS, and the size of the Qlik Sense app.
• When you consume Qlik Sense apps using the Microsoft Edge browser on touch/hybrid devices, the long-press action does not work. This prevents you from accessing functions such as an object’s context menu, which requires a long press in touch mode. This is a Microsoft Edge issue.
  Workaround: If you use a hybrid device, turn off touch mode, and then turn it back on again.
• Export as Anonymous does not work for mashups deployed in a domain that is different from the domain where Qlik Sense is installed. Export only works for Anonymous if the mashup is deployed in the same domain as Qlik Sense.
• When using the new Load Extension syntax in the load script, the Data Load Editor syntax completion does not work well after the keyword “Extension” when trying to write the call to an SSE function (AAI function). The script still executes correctly.
• Legend does not show dimension values after row number 3000.
• Limitations when exporting a story to PowerPoint:   
  • Titles are not rescaled as HTML. Font settings are not exported.
  • Storytelling effects are not applied.
  • Exported charts might show fixed scroll bars, depending on the export resolution.
• It is not possible to open the context menu of an org chart on a touch device.
• When you choose to view data in the context menu in a dynamic chart and make a new selection in the app, you need to refresh the browser for the chart to be displayed again.

Dynamic views

• Dynamic views that you delete from one app are also deleted from every other app that was using the same view. There is no workaround for this issue. Avoid deleting views that might already be in use by other apps.
• When you create a new dynamic view in the assets pane, the dropdown menu item does not automatically change to show the charts of the newly created dynamic view if there are any existing dynamic views. You must click on the dropdown menu to choose the newly created view.
• The data for a dynamic view is automatically refreshed whenever you open a sheet that contains charts for the view. The same happens when you enter and then return from the global selections pane, and when you add a new chart for the view. Refrain from performing these actions on the base app to prevent triggering refreshes.
• The view of a dynamic chart is cleared and shows a message indicating a view constraint violation whenever you change the selection state of the base app in a way that violates the view's constraints. Refrain from changing the selection state of the base app until it has finished making use of the data in any of the dynamic view charts.
• The ‘Go to source’ option on a snapshot slide (available on right-click) for a dynamic chart does not select the actual dynamic chart when you change the view to the base app sheet.
• Changes to chart settings for dynamic view charts using the Exploration menu are lost after refreshing the view.
• Dynamic views do not support the Trellis extension.

 

Managing a Qlik Sense site

• The Edit pane under Custom properties in the Qlik Management Console (QMC) can currently handle a limited number of custom properties. If you want to edit custom property values in the QMC, we recommend keeping the number of custom property values to a maximum of 500. If you want to apply values without modifying them, the QMC can handle up to 10,000 custom property values.
• When you remove app objects from an application via the QMC interface, deleted objects are not removed from the application’s binary file stored on the file system.
• It is not possible to use a security rule on the HubSection_* resource to hide the ‘Open hub’ link from the navigation menu when accessing an app as an anonymous user.  
  Workaround: Use reverse proxy to redirect the ‘Open hub’ link to a preferred landing site.
• Windows service Qlik Engine cannot be started on a node where the Qlik Engine service is disabled through the QMC. Every time Windows restarts for that node, the Qlik Engine service fails to start up and throws an error in Windows event logs. You can prevent this by temporarily disabling the Qlik Engine service in Windows Service Manager.
• Data connection passwords containing special characters (such as "=", "%", or ";") are not properly encoded when updated via the QMC. This causes authentication errors when trying to connect to specific data sources, which could cause reload tasks to fail.  
  Workaround: Use the data load editor to update the password. Note that once the password is updated, the name of the data connection is automatically appended by "(domain_userId)". You can adjust this later via the QMC.

 

Qlik Sense Desktop

• Qlik Sense Desktop can play WebM and Ogg but not MP4 files. This is due to limitations in Chromium.

 

Connectors

• REST connector: The ‘Next token’ pagination option does not work when the pagination token has the same value for each page.
• For connectors in the ODBC Connector Package only the data types listed as supported in the online help have been verified to work correctly in the Preview and Script editor. However, the ODBC Connector Package does not prevent you from loading other data types. In some cases, you can load unsupported data types with the load script.
• ODBC connector: Database connectors in the ODBC Connector Package do not work properly if the username on the Microsoft Windows system running Qlik Sense Desktop contains letters that are not English alphanumeric characters.
  Workaround: Change the Windows system locale to match the character set that contains the characters used in the username. For example, if the system locale on the system running Qlik Sense Desktop is set to English and a username contains Swedish characters, you must change the system locale to Swedish for the ODBC connector to work properly.
• The Qlik Salesforce connector does not support PK chunking on sharing objects. PK chunking is only supported on parent objects.
• The Apache Phoenix connector does not support non-Latin characters in metadata. The connector might return corrupted data or unpredictable query results if you run a query with non-Latin characters in metadata, such as table names, column names, and aliases.

 

Cloud deployments and Multi-Cloud

• When you download a pivot table in Qlik Sense Enterprise SaaS, expanded rows are not included but stay collapsed.

 

Upgrade notes

For upgrade advisory regarding required add-on upgrades, see Community post.

 

System requirements notes

For information about the requirements for Qlik Sense, see System requirements for Qlik Sense in the online help.

 

Downloads

Download this release from the Product Downloads page on Qlik Community.

 

 

About Qlik

Qlik converts complex data landscapes into actionable insights, driving strategic business outcomes. Serving over 40,000 global customers, our portfolio provides advanced, enterprise-grade AI/ML, data integration, and analytics. Our AI/ML tools, both practical and scalable, lead to better decisions, faster. We excel in data integration and governance, offering comprehensive solutions that work with diverse data sources. Intuitive analytics from Qlik uncover hidden patterns, empowering teams to address complex challenges and seize new opportunities. As strategic partners, our platform-agnostic technology and expertise make our customers more competitive.

qlik.com

Show Less

Table of Contents

• What's New
• Migration and Upgrade
• Microsoft .NET Framework 4.8 Upgrade/Installation Prerequisite
• Upgrade paths
• Upgrading from Enterprise Manager April 2020 (6.6)
• Upgrading from unsupported versions
• Compatibility with related products
• Resolved issues
• Downloads

What's New

Learn about new features and improvements in Qlik Enterprise Manager.

Migration and Upgrade

Before upgrading, it's important to review the migration and upgrade considerations below.

Microsoft .NET Framework 4.8 Upgrade/Installation Prerequisite

• Using the Setup Wizard - It is preferable for .NET Framework 4.8 to be installed on the Enterprise Manager Server machine before running Setup. If .NET Framework 4.8 is not present on the machine, Setup will prompt you to install it. This November require the machine to be rebooted when the installation completes.
• Silent Installation – The ISS file required for silently installing Enterprise Manager must be created on a machine that already has .NET 4.8 installed on it.

Upgrade paths

Qlik supports four Enterprise Manager versions (including this one).

Direct upgrade is supported from the last two versions only (including any service releases for those versions). The last two versions are Enterprise Manager November 2023 and Enterprise May 2024.

Upgrading from Enterprise Manager April 2020 (6.6)

If you are upgrading from Enterprise Manager April 2020 (6.6), first upgrade to Enterprise Manager November 2020 (7.0), then upgrade to Enterprise Manager May 2021, then upgrade to Enterprise Manager May 2022, then upgrade to Enterprise Manager November 2022, then upgrade to Enterprise Manager November 2023, and finally upgrade to Enterprise Manager November 2024.

Upgrading from unsupported versions

If you are upgrading from Enterprise Manager 6.x (starting from 6.3), you first need to upgrade to Enterprise Manager 6.5, then to Enterprise Manager November 2020 (7.0), then to Enterprise Manager May 2021, then upgrade to Enterprise Manager May 2022, then upgrade to Enterprise Manager November 2022, then upgrade to Enterprise Manager November 2023, and finally upgrade to Enterprise Manager November 2024.

If you are upgrading from Enterprise Manager 3.3, please contact Qlik Support.

Compatibility with related products

This version of Enterprise Manager is compatible with the following related products only:

• Replicate November 2024, Replicate May 2024, Replicate November 2023 SR1, Replicate November 2023, Replicate May 2023, and Replicate November 2022.
• Qlik Compose November 2023 (and its Service Releases) only.
• Qlik Catalog May 2023 SR2 only.

Resolved issues

The following issues have been resolved since the Enterprise Manager May 2024 initial release.

Jira issue: RECOB-9044 

Salesforce case: 291419 

Type: Issue 

Component/Process: Security 

Description: Users with the Designer role would not be able to add or remove endpoints from a task. 

 

Jira issue: RECOB-8661 

Salesforce case: 157008 

Type: Issue 

Component/Process: Infrastructure 

Description: After losing the connection to Replicate Server, Enterprise Manager would sometimes fail to reconnect immediately. 

 

Jira issue: RECOB-8711 

Salesforce case: N/A 

Type: Issue 

Component/Process: Security 

Description: Enterprise Manager would ship with an outdated log4net version and a vulnerable Newtonsoft.Json file. 

 

Jira issue: RECOB- 8653 

Salesforce case: 146939 

Type: Issue 

Component/Process: Task Monitor 

Description: When switching from one task tab to another, the following error would sometimes occur: 

Could not convert string to boolean 

 

Jira issue: RECOB-8483 

Salesforce case: N/A 

Type: Issue 

Component/Process: Security - UI 

Description: Updated Angular to a version that resolves known vulnerabilities. 

 

Jira issue: RECOB-8392 

Salesforce case: 143505 

Type: Issue 

Component/Process: Notification 

Description: Email notifications would not be sent when using OpenID Connect login. 

Downloads

Download this release from the Product Downloads page on Qlik Community.

 

About Qlik

Qlik converts complex data landscapes into actionable insights, driving strategic business outcomes. Serving over 40,000 global customers, our portfolio provides advanced, enterprise-grade AI/ML, data integration, and analytics. Our AI/ML tools, both practical and scalable, lead to better decisions, faster. We excel in data integration and governance, offering comprehensive solutions that work with diverse data sources. Intuitive analytics from Qlik uncover hidden patterns, empowering teams to address complex challenges and seize new opportunities. As strategic partners, our platform-agnostic technology and expertise make our customers more competitive. 

qlik.com

Show Less

• What's new
• Migration and upgrade
• Upgrade paths
• Microsoft .NET Framework 4.8 upgrade/installation prerequisite
• Deleting the Replicate self-signed certificate after upgrade
• Upgrading an installation with multiple data folders
• Compatibility with related Qlik products
• Preventing log stream replication tasks from failing after upgrade
• End of life/support features
• End of support
• Resolved issues
• Known issues
• Downloads

What's new

Learn about new features and improvements in Qlik Replicate.

Migration and upgrade

This section describes the issues that you may encounter when upgrading/migrating to the new version.

Upgrade paths

Qlik supports four Replicate versions (including this one).

Direct upgrade is supported from the last two versions only (including any service releases for those versions). The last two versions are Replicate November 2023 and Replicate May 2024.

Upgrading from Replicate April 2020 (6.6)

If you are upgrading from Replicate April 2020 (6.6), you need to perform the following upgrades:

1. Upgrade to Replicate November 2020 (7.0).
2. Upgrade to Replicate November 2021.
3. Upgrade to Replicate November 2022.
4. Upgrade to Replicate May 2023 SR.
5. Upgrade to Replicate November 2023 SR
6. Upgrade to Replicate November 2024.

Upgrading from unsupported versions

If you are upgrading from Replicate 6.x (starting from 6.3), you need to perform the following upgrades:

1. Upgrade to Replicate 6.5.
2. Upgrade to Replicate November 2020 (7.0).
3. Upgrade to Replicate November 2021.
4. Upgrade to Replicate November 2022.
5. Upgrade to Replicate May 2023 SR.
6. Upgrade to Replicate November 2023 SR
7. Upgrade to Replicate November 2024.

Note: If you are upgrading from Replicate 5.5, please contact Qlik Support.

Microsoft .NET Framework 4.8 upgrade/installation prerequisite

• Using the Setup Wizard - It is preferable for .NET Framework 4.8 to be installed on the Replicate Server machine before running Setup. If .NET Framework 4.8 is not present on the machine, Setup will prompt you to install it. This may require the machine to be rebooted once the installation completes.
• Silent Installation – When recording an Install Shield Silent response file (ISS), the recording must be done on a machine with .NET 4.8 already installed on it as the silent installation process does not include a separate installation of .NET framework 4.8.

Deleting the Replicate self-signed certificate after upgrade

Note: This procedure does not need to be performed when upgrading from Replicate November 2022 or later.

After upgrading, customers that are using Replicate's self-signed certificate (i.e. instead of their own certificate) should perform the following procedure:

1. Delete all *.pem files from <replicate_data_folder>/ssl/data.
2. Restart the Qlik Replicate Server service.

This will cause Replicate to generate a new self-signed certificate, thereby ensuring that the certificate will be accepted by newer clients (browsers) that select the more secure TLS 1.3 protocol.

Note that if you do not perform the above procedure, the following error will be encountered when connecting to Replicate Console:

SYS,GENERAL_EXCEPTION,The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.

Upgrading an installation with multiple data folders

When upgrading a Replicate installation with multiple Data folders, only the default Data folder (<Product_Dir>\Data) will be automatically upgraded. The other Data folders need to be updated manually by running the following command:

repuictl.exe -d <data_folder_path> setup install

Compatibility with related Qlik products

This version of Replicate is compatible with the following related products only:

• Enterprise Manager November 2024 or later
• Compose November 2023 or later
• Compose for Data Lakes April 2020 (6.6)

Preventing log stream replication tasks from failing after upgrade

The introduction of the new Retrieve all source columns on UPDATE option option might impact your existing log stream replication tasks. If you are upgrading from a version earlier than Replicate May 2024, your replication tasks will fail if either of the following replication task setting are configured:

• Change Processing > Change Processing Tuning > DELETE and INSERT when updating a primary key column
• Error handling > Apply Conflicts > No record found for applying an UPDATE: Insert the missing target record

To prevent the task(s) from failing, you need to do one of the following for each log stream replication task (preferably the first):

• Enable the Retrieve all source columns on UPDATE option in Task Settings > Change Processing > Change Processing Tuning
  -OR-
• Add the disableLogstreamFullLoggingCheck flag to Task Settings > More Options and set it to On. This will preserve the previous behavior.

End of life/support features

This section provides information about End of Life versions, End of Support features, and deprecated features.

End of support

Endpoint versions

Support for the following endpoint versions has been discontinued:

• PostgreSQL 12.x
• IBM DB2 for z/OS: z/OS 2.4
• Databricks 9.1
• MongoDB 5.x

Resolved issues

The following issues have been resolved since Replicate May 2024 initial release.

Jira issue: RECOB-9039 

Salesforce case: 156279 

Type: Issue 

Component/Process: ARC Source 

Description: Using a network drive in AIS Router would sometimes result in missing data on the target. 

 

Jira issue: RECOB-9005 

Salesforce case: N/A 

Type: Issue 

Component/Process: Sorter 

Description: In rare scenarios, incorrect changes would be generated by Oracle Log Reader after Stop/Resume, resulting in unpredictable behavior. 

 

Jira issue: RECOB-8983 

Salesforce case: 311921 

Type: Issue 

Component/Process: Log Stream 

Description: Missing events would sometimes occur after Detach/Attach or Stop/Resume. 

 

Jira issue: RECOB-9094 

Salesforce case: 310873 

Type: Issue 

Component/Process: Oracle Source - Replicate Log Reader 

Description: When using redo event 11.22, missing INSERTs would occur when processing multiple INSERTs on a compressed page that was not compressed prior to the INSERTs. 

 

Jira issue: RECOB-9081 

Salesforce case: 320141 

Type: Issue 

Component/Process: Oracle Source - Replicate Log Reader 

Description: In rare scenarios, incorrect parsing of DELETE events in the redo log record would generate a "The Redo Log DELETE event contains an unknown structure" warning followed by various issues. 

 

Jira issue: RECOB-9053 

Salesforce case: 318417 

Type: Issue 

Component/Process: SAP Application (DB) 

Description: Transparent table LOB values would not be replicated when one of the key columns was DATE (DATS in SAP). 

 

Jira issue: RECOB-9034, RECOB-8963 

Salesforce case: 310873 

Type: Issue 

Component/Process: Oracle Source - Replicate Log Reader 

Description: When using redo event 11.22, missing INSERTs would occur when processing multiple INSERTs. 

 

Jira issue: RECOB-8856 

Salesforce case: N/A 

Type: Issue 

Component/Process: Snowflake Target 

Description: When the task settings were configured to create the control table schema, the task would fail with the following error: 

Failed to delete directory 

 

Jira issue: RECOB-8876 

Salesforce case: N/A 

Type: Issue 

Component/Process: SAP HANA Source (Trigger based) 

Description: The task would sometimes get stuck after a connection failure. 

 

Jira issue: RECOB-8963, , RECOB-9034

Salesforce case: 310873 

Type: Issue 

Component/Process: Oracle Source - Replicate Log Reader 

Description: Missing INSERT operations would sometimes occur in multi INSERT operations when using redo event 11.22. 

 

Jira issue: RECOB-8952 

Salesforce case: 310514 

Type: Issue 

Component/Process: Oracle Source - Replicate Log Reader 

Description: After upgrading Oracle 19g to the July 2024 patch, UPDATE operations would sometimes not be captured, and the following warning would be shown: 

 A compressed row cannot be parsed 

 

Jira issue: RECOB-8888 

Salesforce case: 308237 

Type: Enhancement 

Component/Process: DB2 iSeries Source 

Description: Support for the BOOLEAN data type as added (from iSeries 7.5). 

 

Jira issue: RECOB-8891 

Salesforce case: 173454 

Type: Issue 

Component/Process: Parallel load 

Description: Tasks configured to use parallel full load would sometimes crash after reloading more than one table. 

 

Jira issue: RECOB-8937 

Salesforce case: 308087 

Type: Issue 

Component/Process: Oracle Source - Replicate Log Reader 

Description: The bidirectional task would fail after the first change in the corresponding task. 

 

Jira issue: RECOB-8855 

Salesforce case: 301410 

Type: Issue 

Component/Process: Google Cloud BigQuery Target 

Description: The task would fail when connecting to Google BigQuery, due to a missing tmp folder. 

 

Jira issue: RECOB-8802 

Salesforce case: 302261 

Type: Issue 

Component/Process: Salesforce Source 

Description: An option to see the object PickListValueInfo was added using an internal parameter. 

 

Jira issue: RECOB-8799 

Salesforce case: 291593 

Type: Issue 

Component/Process: Teradata Target 

Description: Records missing due to a TPT error would result in the table being suspended, instead of continuing with a warning as in previous Replicate versions. This issue was resolved using an internal parameter. 

 

Jira issue: RECOB-8816 

Salesforce case: 170520 

Type: Issue 

Component/Process: SAP HANA Source 

Description: When replicating from SAP HANA Cloud, errors would occur as the task would try to create the attrep_cdc_changes table columns with CS_ column store types, which are no longer supported. 

 

Jira issue: RECOB-8842 

Salesforce case: 303478 

Type: Issue 

Component/Process: DB2 iSeries Source 

Description: During CDC, Replicate would set the value of numeric fields with scale definition to zero, resulting in the following error: 

Convert to numeric failed with error 1003 

 

Jira issue: RECOB-8490 

Salesforce case: 153406 

Type: Issue 

Component/Process: DB2 LUW Source 

Description: DB2LUW Data Loss Issues after using ADMIN_MOVE_TABLE command. 

 

Jira issue: RECOB-8747 

Salesforce case: 0168123 

Type: Issue 

Component/Process: Salesforce Source (Incremental Load) 

Description: Tables would be suspended after upgrading to Replicate 2024.5, due to the addition of the CreatedDate to the data retrieval query. 

 

Jira issue: RECOB-8841 

Salesforce case: 166673 

Type: Issue 

Component/Process: IBM DB2 for z/OS Source 

Description: Repeated "Instance recreated” errors would be handled as fatal errors instead of recoverable errors. 

 

Jira issue: RECOB-8755 

Salesforce case: 158476 

Type: Issue 

Component/Process: SAP HANA Source (Log based) 

Description: Changes that were part of the last log file block would sometimes not be captured. 

 

Jira issue: RECOB-8786 

Salesforce case: 00298081 

Type: Issue 

Component/Process: MongoDB Source 

Description: High memory and CPU consumption would sometimes occur when capturing many changes. The issue was resolved with an internal property that controls the maximum size of the reader queue. 

 

Jira issue: RECOB-8797 

Salesforce case: 298821 

Type: Issue 

Component/Process: Snowflake Azure Target 

Description: The Max file size setting was added to the General tab of the endpoint settings. 

 

Jira issue: RECOB-8733 

Salesforce case: 175070 

Type: Issue 

Component/Process: Snowflake Target 

Description: When the setIgnoreCaseFlag parameter was enabled, the task would sometimes fail to remove the old staging area or create a new one. 

 

Jira issue: RECOB-8761, RECOB-8805 

Salesforce case: 168796 

Type: Issue 

Component/Process: Oracle Source - Replicate Log Reader 

Description: After upgrading Oracle 19g to the July 2024 patch, data would not be replicated properly due to incorrect page decompression in DIRECT-INSERT or MULTI-INSERT operations. 

 

Jira issue: RECOB-8766 

Salesforce case: N/A 

Type: Enhancement 

Component/Process: SAP ODP Source 

Description: Support for D34R and RSTR data types was added. 

 

Jira issue: RECOB-8750 

Salesforce case: N/A 

Type: Issue 

Component/Process: SAP HANA Source - UI 

Description: Views were not shown in the UI Table Selection dialog. 

 

Jira issue: RECOB-8743 

Salesforce case: N/A 

Type: Issue 

Component/Process: Amazon Kinesis Target - UI 

Description: Fixed a UI typo in Message Properties. 

 

Jira issue: RECOB-8721 

Salesforce case: N/A 

Type: Issue 

Component/Process: Oracle Target 

Description: INSERT operations would sometimes fail with the following errors (excerpt). 

ORA-12838: cannot read/modify an object after modifying it in parallel  

The issue was resolved using an internal property to disable the ALTER SESSION PARALLEL DML operation. 

 

Jira issue: RECOB-8726 

Salesforce case: 163674 

Type: Issue 

Component/Process: SAP Extractor Source 

Description: The processed records counter in the SAP Extractor logs would sometimes show zero for full load and delta loads. 

 

Jira issue: RECOB-8694 

Salesforce case: 174180 

Type: Issue 

Component/Process: PostgreSQL Source - Logging 

Description: When setting the task not to replicate LOB columns, an incorrect failure message would be printed as INFO for every event. 

 

Jira issue: RECOB-8725 

Salesforce case: N/A 

Type: Issue 

Component/Process: Replicate Installation 

Description: The Replicate Linux installation file wrongly contained a public code-signing key. 

 

Jira issue: RECOB-8709 

Salesforce case: N/A 

Type: Issue 

Component/Process: Security 

Description: Replicate would ship with an outdated log4net version and a vulnerable Newtonsoft.Json file. 

 

Jira issue: RECOB-8611 

Salesforce case: 159309 

Type: Issue 

Component/Process: SAP HANA Source + Log Stream 

Description: In CTS mode, the following error would sometimes occur when replicating the /CHPDPE/CEITMPX table:  

SqlState: HY000 NativeError: 4 cannot allocate enough memory 

The issue was fixed with a feature flag. 

 

Jira issue: RECOB-8678 

Salesforce case: 160381 

Type: Issue 

Component/Process: SAP ODP 

Description: “Batch optimized apply” mode would ignore DELETE operation when a record was also updated in the same batch. 

 

Jira issue: RECOB-8680 

Salesforce case: 165375 

Type: Issue 

Component/Process: SAP ODP 

Description: When capturing changes from a BW table, an “Out of bounds” error would sometimes occur. 

 

Jira issue: RECOB-8679 

Salesforce case: 155357 

Type: Issue 

Component/Process: SAP ODP 

Description: Missing data would sometimes occur during Full Load, following SAP network errors. 

 

Jira issue: RECOB-8542 

Salesforce case: 165719 

Type: Issue 

Component/Process: Replicate Installation 

Description: The Replicate Linux installation would fail if there was no systemctl. 

 

Jira issue: RECOB-8576 

Salesforce case: 162044 

Type: Issue 

Component/Process: SAP HANA Source 

Description: The task would crash when source lookup was configured in the transformation. 

 

Jira issue: RECOB-8698 

Salesforce case: 295901 

Type: Issue 

Component/Process: Oracle Source - Replicate Log Reader 

Description: The task would crash after upgrading Oracle 19g to the July 2024 patch.  

 

Jira issue: RECOB-8598 

Salesforce case: 153905 

Type: Issue 

Component/Process: Kafka target 

Description: Stopping the task would cause a crash when the endpoint server license was missing or when the endpoint server was not running. This issue was resolved using an internal parameter. 

 

Jira issue: RECOB-8633 

Salesforce case: 128634 

Type: Issue 

Component/Process: Parallel apply in Batch optimized apply mode 

Description: When the Apply batched changes to multiple tables concurrently option was enabled, data would sometimes be missing after reattaching to the target (following a disconnect). The issue was resolved using a feature flag, which returns a recoverable error instead of attempting to reattach. 

 

Jira issue: RECOB-8691 

Salesforce case: N/A 

Type: Issue 

Component/Process: Snowflake targets 

Description: The task would sometimes fail when using Snowflake internal storage. 

 

Jira issue: RECOB-8651 

Salesforce case: 171424 

Type: Issue 

Component/Process: Oracle Source - Replicate Log Reader 

Description: When the last table column of a table with supplemental logging set on all columns was marked as unused, UPDATE operations would sometimes result in unexpected results on the target  

 

Jira issue: RECOB-8560 

Salesforce case: 153711 

Type: Issue 

Component/Process: Databricks (Cloud Storage) 

Description: When running multiple tasks against the same database, the CDC partition table files would be created with same name, thereby overriding each other. 
The issue was resolved with a Feature Flag at task level. 

 

Jira issue: RECOB-8614 

Salesforce case: 175635 

Type: Issue 

Component/Process: SAP Application (DB) 

Description: When a captured cluster document change deleted all rows of all its captured tables, missing DELETE operation and unnecessary assertion messages would be encountered. 

 

Jira issue: RECOB-8626 

Salesforce case: 171607 

Type: Issue 

Component/Process: Metadata Manager 

Description: Tasks would fail when using the use_manipulation_pk_for_apply feature parameter with Store Changes replication. 

 

Jira issue: RECOB-8627 

Salesforce case: 161454 

Type: Issue 

Component/Process: Amazon Kinesis 

Description: The connection would fail when using IAM Role for EC2 to connect to Amazon Kinesis, after using Key Pair authentication to connect to Amazon S3. 

 

Jira issue: RECOB-8582 

Salesforce case: 153169 

Type: Issue 

Component/Process: Microsoft SQL Server Target 

Description: When Use BCP for loading tables was enabled in the endpoint settings, the maximum LOB size would be limited to 63 KB. 

 

Jira issue: RECOB-8604 

Salesforce case: 166180 

Type: Issue 

Component/Process: Replicate Engine 

Description: After upgrading to Replicate 2024.5, it would not be possible to connect to Databricks (Delta) if FIPS was enabled on Windows. 

 

Jira issue: RECOB-8537 

Salesforce case: 154701 

Type: Enhancement 

Component/Process: Security 

Description: Added an option to install Replicate on Linux without using "RPM" or requiring "root" authority, and without allowing the creation of a new USER/GROUP. 

 

Jira issue: RECOB-8620 

Salesforce case: 162987 

Type: Issue 

Component/Process: Oracle Source - Replicate Log Reader 

Description: In rare scenarios, INSERT operations on wide tables would be replicated with partial column values. 

 

Jira issue: RECOB-8565 

Salesforce case: 170484 

Type: Issue 

Component/Process: Microsoft SQL Server Source 

Description: When moving data from SQL Server, a missing column name in the table definitions would cause an infinite notification loop in the repsrv.log file, with the following message: 

mssql_resolve_sqlserver_table_column_attributes(...) failed to find column 

 

Jira issue: RECOB-8592 

Salesforce case: 158504 

Type: Issue 

Component/Process: SAP Application (DB) 

Description: Added an internal property to prevent the addition of SAP Catalog tables to the list of SAP Application (DB) backend tables. 

 

Jira issue: RECOB-8550 

Salesforce case: 164667 

Type: Issue 

Component/Process: UI 

Description: The task settings’ Environmental errors tab would not show the proper settings. 

 

Jira issue: RECOB-8465 

Salesforce case: 165513 

Type: Issue 

Component/Process: UI 

Description: The total number of the selected tables would no longer be shown at the bottom of Designer view. 

 

Jira issue: RECOB-8538 

Salesforce case: 162298 

Type: Issue 

Component/Process: SAP HANA Source 

Description: Log-based CDC would fail or would keep reading from the same position when processing large multi-segment backup logs. 

 

Jira issue: RECOB-8518 

Salesforce case: N/A 

Type: Issue 

Component/Process: UI 

Description: The table keys would be incorrectly shown in the UI after defining key transformations. 

 

Jira issue: RECOB-8477 

Salesforce case: 154293 

Type: Issue 

Component/Process: Log Stream 

Description: Replication over log stream tasks would sometimes fail during task initialization. 

 

Jira issue: RECOB-8507 

Salesforce case: 150857 

Type: Issue 

Component/Process: SAP HANA Source 

Description: The task would sometimes start very slowly, impacting the creation of its captured tables list. 

 

Jira issue: RECOB-8405 

Salesforce case: 156279 

Type: Issue 

Component/Process: AIS Source 

Description: Added an internal parameter: printCSVFileNamesInInfo 

When the parameter is set to TRUE (and logging is set to INFO or higher), the Replicate IMS source endpoint will write CSV file names and their creation date to the Replicate log. 

As turning on the parameter will increase the log size, customers should monitor it to avoid storage issues. To reduce the logging impact, best practice is to maintain only a reasonable backlog of CSV files, and to delete CSV files that have already been applied to target. If the log size becomes excessive, set the parameter to FALSE to stop the additional logging. 

 

Jira issue: RECOB-8400 

Salesforce case: 152188 

Type: Issue 

Component/Process: Microsoft Azure Synapse Analytics Target 

Description: Older files would not be deleted from ADLS staging during reload. This would result in the task failing due to duplicate records or because of non-matching records.   

 

Jira issue: RECOB-8469 

Salesforce case: 158504 

Type: Issue 

Component/Process: SAP Application (DB) 

Description: Added an internal property to prevent the addition of SAP Catalog tables to the list of SAP Application backend tables. 

 

Jira issue: RECOB-8481 

Salesforce case: N/A 

Type: Issue 

Component/Process: Security - UI 

Description: Updated Angular to a version that resolves known vulnerabilities. 

 

Jira issue: RECOB-8475 

Salesforce case: 161767 

Type: Issue 

Component/Process: Log Stream 

Description: The "Retrieve all source columns on UPDATE" option would be turned off after upgrade, resulting in failure of tasks that needed this option to be turned on. The issue was resolved using a feature flag.  

 

Jira issue: RECOB-8451 

Salesforce case: 117989 

Type: Issue 

Component/Process: Infrastructure 

Description: Added logging for troubleshooting the following intermittent error:  

Message size <369295616> exceeds maximum of 16Mb 

 

Jira issue: RECOB-8433 

Salesforce case: N/A 

Type: Issue 

Component/Process: Microsoft Azure SQL Database Target 

Description: Creation of the Primary Key/Unique Index would fail when the constraint name exceeded 128 characters. 

 

Jira issue: RECOB-8338 

Salesforce case: 147998 

Type: Issue 

Component/Process: Hadoop 

Description: When using Hadoop without Hive access, the Full Load task would fail. 

 

Jira issue: RECOB-8402 

Salesforce case: 159978 

Type: Issue 

Component/Process: Databricks Delta 

Description: When a data value contained binary zeros, both the Full Load and the CDC task would fail. 

 

Jira issue: RECOB-8410 

Salesforce case: N/A 

Type: Issue 

Component/Process: Security 

Description: The java_file_factory component was updated to a version with non-vulnerable dependencies. 

Known issues

This release has the following known issues:

Jira issue: RECOB-9065 

Salesforce case: 316883 

Type: Issue 

Component/Process: SAP HANA Source (Log based) 

Description: When capturing changes from large SAP HANA backup log files in Application Connection mode, errors would sometimes occur during CDC. 

 

Jira issue: RECOB-8927 

Salesforce case: 303767 

Type: Issue 

Component/Process: PostgreSQL Source 

Description: When the year in the TIMESTAMP source column was later than 9999, a different value would be shown for Full Load and CDC on the target. This issue was resolved using an internal parameter.

Downloads

Download this release from the Product Downloads page on Qlik Community.

About Qlik

Qlik converts complex data landscapes into actionable insights, driving strategic business outcomes. Serving over 40,000 global customers, our portfolio provides advanced, enterprise-grade AI/ML, data integration, and analytics. Our AI/ML tools, both practical and scalable, lead to better decisions, faster. We excel in data integration and governance, offering comprehensive solutions that work with diverse data sources. Intuitive analytics from Qlik uncover hidden patterns, empowering teams to address complex challenges and seize new opportunities. As strategic partners, our platform-agnostic technology and expertise make our customers more competitive.

qlik.com

Show Less

The following release notes cover the versions of QlikView released in May 2024.

What’s new in QlikView May 2024

Data window functions in engine load script

Customers can now perform complex calculations on their data tables in the Qlik load script to perform aggregation on different partitions without losing the granularity of their data.

This functionality is commonly used in SQL and with many ML data preparation use cases.

Window functions

• Window - script function
• WRank - script function

Notice of removal – QlikView Mobile client

The support for the QlikView Mobile client has been removed as of this release of QlikView May 2024. You will still be able to use the Ajax client on both a phone and tablet, but the native application has been removed.

 

Resolved Defects

QlikView May 2024 Initial Release

 

Key	Title	Decription
QV-25218	QV 12.80 : Unclear behavior when saving temporary files on reload	Reload temp files now gets a unique name so that it does not cause a conflict when having several documents with the same name in different folders.
QV-25214	ErrorMode=0 does not work in QV 12.80	Macro expansions such like Must_Include can generate errors. These errors were not respecting the ErrorMode setting.
QV-25204	Issue when trying to select and filter charts by mouse in QlikView	Fixed a problem where mouse selections did not work as expected.
QV-25190	QVWS config.xml file is rewritten after Kerberos change	A fix so that the value negotiate is not overwritten for the http authentication in the settings file.
QV-25184	QlikView Desktop Open in server wrong pseudo url when tunneling required	This fix solves a problem for qvp-links using protocol and port.
QV-25175	QlikView Desktop 12.80 > Open in Server > .QVW extensions	Fixed a problem where the file extension comparison was case sensitive. A file extension with mixed case, lower case or upper case is now considered the same.
QV-25160	Disabling Home Button feature on AccessPoint	This fix introduces a setting in settings.ini for the web client and the QlikView plugin to disable the home button AllowGoBackToHub.
QV-25133	QlikView: Totals are shown as ##### when the table is exported as image seeOP-95953	Straight tables now show totals correctly when exported as images from QV Desktop.
QV-25106	Lost connection when opening local document in webview mode	Fixed a problem with lost connection when opening local documents in webview mode.
QV-25079	In Pivot table rows with the same dimension values are merged and displayed as a single row. But after 41st dimension values are not displayed at all in web, even though they exist in Excel export	All values are now displayed even for very wide pivot tables.
QV-25069	Thousand symbol not working as expected for values on data poins in charts	Fixes the pop up label for bar charts when using symbols on the number tab for object properties.
QV-25067	Underscores not displaying in Accesspoint	Fixed a problem whereUuderscore character was hidden by bottom border. Text is now displayed on top of the border instead of beneath it
QV-25057	QlikView 12.80: Displaying Wrong value in pop-up windows for Pie chart.	Fixes pop-up labels for the pie chart so that the correct value is displayed.
QV-25050	symbols not working in each field May 2023	Corrects the number presentation for numbers on data points on stacked bart charts when using a million symbol.
QV-25046	Issue with adding images in QlikView Report Header/Footer	Fixes so that it's possible to user images in a header of a report in QlikView.
QV-25030	some of values of not selected with IF fucntion	Fixed a problem where some values weren't selected when using the IF function.
QV-25021	Edit the report in the Report designer does not show the correct label and definition for the expressions	The edit object button has been removed from reports.
QV-25012	general exception occurs when session collab ended	Solved a problem when Session collaboration ended while the audit log was enabled, it resulted into below exception followed by crash dump. "Engine: Server aborted. Reason for restart: Internal inconsistency, general exception detected (Simple Request)."
QV-25010	Reload performance log cuts characters of qvw document name if there is underscore in the name	Fixed a problem where reload performance(ReloadMetadata ) log cut all characters before an underscore if such existed in document name.
QV-24977	Nprinting filters behaves differently with respect to connection Types with Qlik View	A previously delivered push to server fix (QV-19899) has been reverted. This may lead to some reports failing on servers with Push from Server enabled. If you encounter this problem, we recommend to disable Push from Server.
QV-24930	Format issue after upgrade to QV 12.70 sr2 behaves differently from QV 11.20	To fix a format issue that occured after upgrade, a new setting to keep real number format during export has been introduced. 'KeepRealNumberFormat' has default value 0. To enable it, add 'KeepRealNumberFormat=1' to Settings.ini.
QV-24924	After we Upgraded 12.8 Switch between IE Plugin and AJX is not seamless	The IE Plugin is only available from Microsoft Edge in IE mode, and the Ajax client does not open in Internet Explorer. This caused difficulties when if you used both the IE Plugin and the Ajax client. This has now been fixed so saving the plugin path to always use Internet Explorer mode does not affect other clients, like Ajax.
QV-24921	unable to lease license in DMS mode on May 2023	Fixed a problem with leasing a license in DMS mode. Follow the steps defined in the following support article:https://community.qlik.com/t5/Official-Support-Articles/How-to-lease-a-license-in-DMS-mode/ta-p/1714998 After successful license leased, you must restart QlikView Desktop.
QV-24919	QlikView Desktop WebView Cycling forever	Fixed a problem when opening apps in WebView mode without circling/cycling.
QV-24875	qvs has no ”Encrypt-Password.ps1” file	Encrypt-Password.ps1 and its dependent files have been added to QVS and are installed to the location %ProgramFiles%\QlikView\Licenses.
QV-24869	QlikView - May 2023 IR - NTFS Permissions removed after QMC Reload	NTFS file permissions are now passed to the user document after a reload when a publisher license is not being used.
QV-24847	QVW Data Reduction Process affected after upgrade to QlikView 12.70 SR1	Input field values were missing on refresh of server distributed QlikView app with Section Access. In case of Qlik Cloud, set ApplyInputFieldValues to false.
QV-24796	Unable to Edit qlikview when zoom less than 100% and unset flag Move/Size sheet objects	Fixed an issue of not being able to edit when zoom is less than 100% in QV Desktop.
QV-24706	Line Chart highlight feature has a limitation	The highlight effect can now be used for line charts with a high number of data points selected.
QV-24442	Task Status stuck in Waiting and Last Execution Never	Fixed a problem where task status was stuck in Waiting and Last Execution in Never
QV-24423	QlikView Key fields are marked incorrectly after saving QVW as QVF	Key Fields are now displayed correctly in the Document Properties window for both formats of QlikView apps: QVW and QVF.
QV-24379	Send to Excel doesn't work in webview	The Send to Excel option is now working as expected in WebView.
QV-24298	Sort by state not applied correctly in container	Sort by state is now working as expected for listboxes inside containers.
QV-24184	Date” list box that should be available are not visible.	Sort by state is now working as expected for listboxes inside containers.

 

Known issues and limitations

The following issues and limitations were identified at release time. The list is not comprehensive; it does however list all known major issues and limitations.

 

Limitations

If you are running Qlik NPrinting with QlikView, there is a Compatibility issue:

Installing On-Demand Add-on on a Microsoft IIS hosted QlikView AccessPoint will require the following minimum version for NPrinting on-demand installer

• May 2023 SR5
• February 2024 SR2

 

Upgrade notes

Upgrading when using certificates for authorization

 

If a standard Upgrade is done, new certificates will be created using the AES 256

GCM mode as part of the upgrade.

 

Instructions for upgrading QlikView with new certificates mode (GCM) – Before implementing this, TLS 1.2 has to be enabled for QVS to work normally.

Perform the upgrade on all machines in the cluster.

After completion, the installer will ask you to restart the machine/s.

After restart and services are running, stop all the services and open "C:\Program Files\QlikView\Management Service\QVManagementService.exe.config" and apply the following config:

 <add key="InstallingNewCertificatesAndCryptoKey" value="true"></add>

If Services are clustered, all the cluster nodes also need the new certificate.

Add into resp config files for each (one on each node):

<add key="InstallingNewCertificatesAndCryptoKey" value="true"></add>

or

InstallingNewCertificatesAndCryptoKey=1 if QVS.

Start the QMS first and then rest of all services

In the QMC, go to the service’s System/setup, for example if QDS select the node and distribute the new certificates to QDS machine with Apply in setup and follow the popup instructions. Do this for one service om each node to distribute new certs mode. Stop QMS again and all services. Make above configuration false in all config/settings files

"<add key="InstallingNewCertificatesAndCryptoKey" value="false"></add>".

Start all services. All machines in the cluster shall now have the new certs mode.

If you for some reason need to downgrade to the previous version again, follow this

Support Article to re-generate certificates using the old encryption algorithm.

https://community.qlik.com/t5/Official-Support-Articles/QlikView-Services-don-t-start-Shutting-down-service-since-there/ta-p/1716203

 

System requirements notes

The system requirements for this release can be found under “System requirements” on the Qlik help web site. https://help.qlik.com/en-US/qlikview/May2024/Content/QV_HelpSites/System-requirements.htm

 

QlikView May 2024 SR1 fixed defects

 

Downloads

https://community.qlik.com/t5/Product-Downloads/tkb-p/Downloads

 

What’s new in QlikView May 2024 SR1

Resolved Defects

QlikView May 2024 SR1

Key	Title	Description
QV-25388	QlikView: Signing of bundled files	Fixed the digital signing of the bundled files for qvconnect64.exe and qvconnect32.exe.
QV-25377	QlikView: Authentication redirect filtering not working	The QlikView Authentication redirect filtering has now been fixed and is working correctly.
QV-25376	QlikView: License tracking events not captured	QlikView report license tracking and CAL events are now captured in the Event log.
QV-25375	QlikView: Publisher function missing	Fixed a problem that caused the Publisher function to disappear in the QMC.
QV-25371	QlikView: Cannot open files on server from QlikView desktop	Fixed a problem where the files could not be opened on server from QlikView Desktop if the .qvw extension was in mixed casing or if it occurred more than once.
QV-25370	A fix for perpetual signed licenses	Fixes signed perpetual signed licenses that does not expire.
QV-25365	QlikView Server: New users in Section Access not granted access	Fixed a problem that caused a loaded QlikView document to fail to be refreshed to a reloaded version. This was caused by faulty conditions set for chart object validation. The fault only manifested under certain combinations of engine cache and document model changes.
QV-25348	QlikView: Desktop link in start menu not working	Fixed a problem that disabled the QlikView Desktop link in the Start menu for locked users.
QV-25339	QlikView: Wrong value displayed in popup label	Fixed a problem that caused the popup label to display the wrong value for bar charts with two expressions and no dimensions.
QV-25323	QlikView Publisher: Additional lines added to the log file	Fixed a problem that caused, for every task reload, an additional four lines to be added to the log file named with the current date.

 

Downloads

https://community.qlik.com/t5/Product-Downloads/tkb-p/Downloads

About Qlik

Qlik converts complex data landscapes into actionable insights, driving strategic business outcomes. Serving over 40,000 global customers, our portfolio provides advanced, enterprise-grade AI/ML, data integration, and analytics. Our AI/ML tools, both practical and scalable, lead to better decisions, faster. We excel in data integration and governance, offering comprehensive solutions that work with diverse data sources. Intuitive analytics from Qlik uncover hidden patterns, empowering teams to address complex challenges and seize new opportunities. As strategic partners, our platform-agnostic technology and expertise make our customers more competitive.

qlik.com

Show Less

Table of Contents

• What's New
• Migration and Upgrade
• Microsoft .NET Framework 4.8 Upgrade/Installation Prerequisite
• Upgrade paths
• Upgrading from Enterprise Manager April 2020 (6.6)
• Upgrading from unsupported versions
• Compatibility with related products
• Resolved issues
• Downloads

What's New

Learn about new features and improvements in Qlik Enterprise Manager.

Migration and Upgrade

Before upgrading, it's important to review the migration and upgrade considerations below.

Microsoft .NET Framework 4.8 Upgrade/Installation Prerequisite

• Using the Setup Wizard - It is preferable for .NET Framework 4.8 to be installed on the Enterprise Manager Server machine before running Setup. If .NET Framework 4.8 is not present on the machine, Setup will prompt you to install it. This November require the machine to be rebooted when the installation completes.
• Silent Installation – The ISS file required for silently installing Enterprise Manager must be created on a machine that already has .NET 4.8 installed on it.

Upgrade paths

Qlik supports four Enterprise Manager versions (including this one).

Direct upgrade is supported from the last two versions only (including any service releases for those versions). The last two versions are Enterprise Manager May 2023 and Enterprise Manager November 2023.

Upgrading from Enterprise Manager April 2020 (6.6)

If you are upgrading from Enterprise Manager April 2020 (6.6), first upgrade to Enterprise Manager November 2020 (7.0), then upgrade to Enterprise Manager May 2021, then upgrade to Enterprise Manager May 2022, then upgrade to Enterprise Manager November 2022, and finally upgrade to Enterprise Manager May 2024.

Upgrading from unsupported versions

If you are upgrading from Enterprise Manager 6.x (starting from 6.3), you first need to upgrade to Enterprise Manager 6.5, then to Enterprise Manager November 2020 (7.0), then to Enterprise Manager May 2021, then upgrade to Enterprise Manager May 2022, then upgrade to Enterprise Manager November 2022, and finally upgrade to Enterprise Manager May 2024.

If you are upgrading from Enterprise Manager 3.3, please contact Qlik Support.

Compatibility with related products

This version of Enterprise Manager is compatible with the following related products only:

• Replicate May 2024, Replicate November 2023 and its service releases, Replicate May 2023, Replicate November 2022, Replicate May 2022.
• Qlik Compose May 2022 (and its Service Releases) only.
• Qlik Catalog May 2023 SR2 only.

Resolved issues

The following issues have been resolved in Qlik Enterprise Manager May 2024 - Initial Release.

Jira issue: RECOB-7937 

Salesforce case: N/A 

Type: Issue 

Component/Process: Error Messages 

Description: Improved the error message to better determine the cause of null object exceptions. 

 

Jira issue: RECOB-8141 

Salesforce case: N/A 

Type: Issue 

Component/Process: Task log management 

Description: The session would disconnect after being idle for a long time. The issue was resolved by automatically reconnecting in such scenarios, and retrying the operation that was attempted before the session disconnected. In such a scenario, neither a warning nor an error will be shown in the log. 

 

Jira issue: RECOB-8482 

Salesforce case: N/A 

Type: Issue 

Component/Process: Security - UI 

Description: Updated Angular to a version that resolves known vulnerabilities. 

 

Jira issue: RECOB-8391 

Salesforce case: 143505 

Type: Issue 

Component/Process: Notifications 

Description: Email notifications would not work when using OpenID Connect as the login method. 

Downloads

Download this release from the Product Downloads page on Qlik Community.

 

About Qlik

Qlik converts complex data landscapes into actionable insights, driving strategic business outcomes. Serving over 40,000 global customers, our portfolio provides advanced, enterprise-grade AI/ML, data integration, and analytics. Our AI/ML tools, both practical and scalable, lead to better decisions, faster. We excel in data integration and governance, offering comprehensive solutions that work with diverse data sources. Intuitive analytics from Qlik uncover hidden patterns, empowering teams to address complex challenges and seize new opportunities. As strategic partners, our platform-agnostic technology and expertise make our customers more competitive. 

qlik.com

Show Less

• What's new
• Migration and upgrade
• Upgrade paths
• Microsoft .NET Framework 4.8 upgrade/installation prerequisite
• Deleting the Replicate self-signed certificate after upgrade
• Upgrading an installation with multiple data folders
• Compatibility with related products
• Preventing log stream replication tasks from failing after upgrade
• Required post-upgrade steps for tasks with a SAP ODP source endpoint
• End of life/support features
• Endpoint versions that are no longer supported
• Resolved issues
• Resolved issues and enhancements in Replicate May 2024 Service Release 1
• Resolved issues in Replicate May 2024 initial release
• Downloads

What's new

Learn about new features and improvements in Qlik Replicate.

Migration and upgrade

This section describes the issues that you may encounter when upgrading/migrating to the new version.

Upgrade paths

Qlik supports four Replicate versions (including this one).

Direct upgrade is supported from the last two versions only (including any service releases for those versions). The last two versions are Replicate May 2023 and Replicate November 2023.

Upgrading from Replicate April 2020 (6.6)

If you are upgrading from Replicate April 2020 (6.6), you need to perform the following upgrades:

1. Upgrade to Replicate November 2020 (7.0).
2. Upgrade to Replicate November 2021.
3. Upgrade to Replicate November 2022.
4. Upgrade to Replicate May 2023.
5. Upgrade to Replicate May 2024.

Upgrading from unsupported versions

If you are upgrading from Replicate 6.x (starting from 6.3), you need to perform the following upgrades:

1. Upgrade to Replicate 6.5.
2. Upgrade to Replicate November 2020 (7.0).
3. Upgrade to Replicate November 2021.
4. Upgrade to Replicate November 2022.
5. Upgrade to Replicate May 2023.
6. Upgrade to Replicate May 2024.

Note: If you are upgrading from Replicate 5.5, please contact Qlik Support.

Microsoft .NET Framework 4.8 upgrade/installation prerequisite

• Using the Setup Wizard - It is preferable for .NET Framework 4.8 to be installed on the Replicate Server machine before running Setup. If .NET Framework 4.8 is not present on the machine, Setup will prompt you to install it. This may require the machine to be rebooted once the installation completes.
• Silent Installation – When recording an Install Shield Silent response file (ISS), the recording must be done on a machine with .NET 4.8 already installed on it as the silent installation process does not include a separate installation of .NET framework 4.8.

Deleting the Replicate self-signed certificate after upgrade

Note: This procedure does not need to be performed when upgrading from Replicate November 2022 or later.

After upgrading, customers that are using Replicate's self-signed certificate (i.e. instead of their own certificate) should perform the following procedure:

1. Delete all *.pem files from <replicate_data_folder>/ssl/data.
2. Restart the Qlik Replicate Server service.

This will cause Replicate to generate a new self-signed certificate, thereby ensuring that the certificate will be accepted by newer clients (browsers) that select the more secure TLS 1.3 protocol.

Note that if you do not perform the above procedure, the following error will be encountered when connecting to Replicate Console:

SYS,GENERAL_EXCEPTION,The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.

Upgrading an installation with multiple data folders

When upgrading a Replicate installation with multiple Data folders, only the default Data folder (<Product_Dir>\Data) will be automatically upgraded. The other Data folders need to be updated manually by running the following command:

repuictl.exe -d <data_folder_path> setup install

Compatibility with related products

This version of Replicate is compatible with the following related products only:

• Enterprise Manager May 2024 or later
• Compose November 2023 or later
• Compose for Data Lakes April 2020 (6.6)

Preventing log stream replication tasks from failing after upgrade

The introduction of the new Retrieve all source columns on UPDATE option option might impact your existing log stream replication tasks. If you are upgrading from a version earlier than Replicate May 2024, your replication tasks will fail if either of the following replication task setting are configured:

• Change Processing > Change Processing Tuning > DELETE and INSERT when updating a primary key column
• Error handling > Apply Conflicts > No record found for applying an UPDATE: Insert the missing target record

To prevent the task(s) from failing, you need to do one of the following for each log stream replication task (preferably the first):

• Enable the Retrieve all source columns on UPDATE option in Task Settings > Change Processing > Change Processing Tuning
  -OR-
• Add the disableLogstreamFullLoggingCheck flag to Task Settings > More Options and set it to On. This will preserve the previous behavior.

Required post-upgrade steps for tasks with a SAP ODP source endpoint

When upgrading from Replicate versions earlier than Replicate May 2023 SP2, you must perform the following steps in the Replicate Console after the upgrade completes:

1. Select Advanced Run Options from the Run menu.
2. Choose Metadata Only  and then select Create missing tables and then stop. Click OK. 
3. The task will run, collect missing metadata, and then stop.
4. Resume the task after it stops.

End of life/support features

This section provides information about End of Life versions, End of Support features, and deprecated features.

Endpoint versions that are no longer supported

Support for the following endpoint versions has been discontinued:

• All Oracle versions and drivers earlier than Oracle 19.x
• SQL Server 2014
• MySQL 5.7
• PostgreSQL 11
• Kafka 2.x
• IBM DB2 for LUW 10.5
• IBM DB2 for z/OS: z/OS 2.3
• MongoDB 4.4

Resolved issues

Resolved issues and enhancements in Replicate May 2024 Service Release 1

The following section describes the issues resolved between Replicate May 2024 initial release and Replicate May 2024 Service Release 1.

Jira issue: RECOB-9039 

Salesforce case: 156279 

Type: Issue 

Component/Process: ARC Source 

Description: Using a network drive in AIS Router would sometimes result in missing data on the target. 

 

Jira issue: RECOB-9005 

Salesforce case: N/A 

Type: Issue 

Component/Process: Sorter 

Description: In rare scenarios, incorrect changes would be generated by Oracle Log Reader after Stop/Resume, resulting in unpredictable behavior. 

 

Jira issue: RECOB-8983 

Salesforce case: 311921 

Type: Issue 

Component/Process: Log Stream 

Description: Missing events would sometimes occur after Detach/Attach or Stop/Resume. 

 

Jira issue: RECOB-9094 

Salesforce case: 310873 

Type: Issue 

Component/Process: Oracle Source - Replicate Log Reader 

Description: When using redo event 11.22, missing INSERTs would occur when processing multiple INSERTs on a compressed page that was not compressed prior to the INSERTs. 

 

Jira issue: RECOB-9081 

Salesforce case: 320141 

Type: Issue 

Component/Process: Oracle Source - Replicate Log Reader 

Description: In rare scenarios, incorrect parsing of DELETE events in the redo log record would generate a "The Redo Log DELETE event contains an unknown structure" warning followed by various issues. 

 

Jira issue: RECOB-9053 

Salesforce case: 318417 

Type: Issue 

Component/Process: SAP Application (DB) 

Description: Transparent table LOB values would not be replicated when one of the key columns was DATE (DATS in SAP). 

 

Jira issue: RECOB-9065 

Salesforce case: 316883 

Type: Issue 

Component/Process: SAP HANA Source (Log based) 

Description: When capturing changes from large SAP HANA backup log files in Application Connection mode, errors would sometimes occur during CDC. 

 

Jira issue: RECOB-9034, RECOB-8963 

Salesforce case: 310873 

Type: Issue 

Component/Process: Oracle Source - Replicate Log Reader 

Description: When using redo event 11.22, missing INSERTs would occur when processing multiple INSERTs. 

 

Jira issue: RECOB-8927 

Salesforce case: 303767 

Type: Issue 

Component/Process: PostgreSQL Source 

Description: When the year in the TIMESTAMP source column was later than 9999, a different value would be shown for Full Load and CDC on the target. This issue was resolved using an internal parameter.

 

Jira issue: RECOB-8856 

Salesforce case: N/A 

Type: Issue 

Component/Process: Snowflake Target 

Description: When the task settings were configured to create the control table schema, the task would fail with the following error: 

Failed to delete directory 

 

Jira issue: RECOB-8876 

Salesforce case: N/A 

Type: Issue 

Component/Process: SAP HANA Source (Trigger based) 

Description: The task would sometimes get stuck after a connection failure. 

 

Jira issue: RECOB-8952 

Salesforce case: 310514 

Type: Issue 

Component/Process: Oracle Source - Replicate Log Reader 

Description: After upgrading Oracle 19g to the July 2024 patch, UPDATE operations would sometimes not be captured, and the following warning would be shown: 

A compressed row cannot be parsed 

 

Jira issue: RECOB-8888 

Salesforce case: 308237 

Type: Enhancement 

Component/Process: DB2 iSeries Source 

Description: Support for the BOOLEAN data type was added (from iSeries 7.5). 

 

Jira issue: RECOB-8891 

Salesforce case: 173454 

Type: Issue 

Component/Process: Parallel load 

Description: Tasks configured to use parallel full load would sometimes crash after reloading more than one table. 

 

Jira issue: RECOB-8937 

Salesforce case: 308087 

Type: Issue 

Component/Process: Oracle Source - Replicate Log Reader 

Description: The bidirectional task would fail after the first change in the corresponding task. 

 

Jira issue: RECOB-8855 

Salesforce case: 301410 

Type: Issue 

Component/Process: Google Cloud BigQuery Target 

Description: The task would fail when connecting to Google BigQuery, due to a missing tmp folder. 

 

Jira issue: RECOB-8802 

Salesforce case: 302261 

Type: Issue 

Component/Process: Salesforce Source IL 

Description: An option to see the object PickListValueInfo was added using an internal parameter. 

 

Jira issue: RECOB-8799 

Salesforce case: 291593 

Type: Issue 

Component/Process: Teradata Target 

Description: Records missing due to a TPT error would result in the table being suspended, instead of continuing with a warning as in previous Replicate versions. This issue was resolved using an internal parameter. 

 

Jira issue: RECOB-8816 

Salesforce case: 170520 

Type: Issue 

Component/Process: SAP HANA Source 

Description: When replicating from SAP HANA Cloud, errors would occur as the task would try to create the attrep_cdc_changes table columns with CS_ column store types, which are no longer supported. 

 

Jira issue: RECOB-8842 

Salesforce case: 303478 

Type: Issue 

Component/Process: DB2 iSeries Source 

Description: During CDC, Replicate would set the value of numeric fields with scale definition to zero, resulting in the following error: 

Convert to numeric failed with error 1003 

 

Jira issue: RECOB-8490 

Salesforce case: 153406 

Type: Issue 

Component/Process: IBM DB2 for LUW Source 

Description: Data loss would occur after using the ADMIN_MOVE_TABLE command. 

 

Jira issue: RECOB-8747 

Salesforce case: 0168123 

Type: Issue 

Component/Process: Salesforce Source (Incremental Load) 

Description: Due to the addition of the CreatedDate to the data retrieval query, tables would be suspended after upgrading to Replicate 2024.5. 

 

Jira issue: RECOB-8841 

Salesforce case: 166673  

Type: Issue 

Component/Process: IBM DB2 for z/OS Source 

Description: Repeated "Instance recreated” errors would be handled as fatal errors instead of recoverable errors. 

 

Jira issue: RECOB-8830, RECOB-8943 

Salesforce case: 302108 

Type: Issue 

Component/Process: SAP HANA Source (Log based) 

Description: Excessive memory consumption would sometimes occur when running Replicate on Linux. 

 

Jira issue: RECOB-8755 

Salesforce case: 158476 

Type: Issue 

Component/Process: SAP HANA Source (Log based) 

Description: Changes that were part of the last log file block would sometimes not be captured. 

 

Jira issue: RECOB-8786 

Salesforce case: 298081 

Type: Issue 

Component/Process: MongoDB Source 

Description: High memory and CPU consumption would sometimes occur when capturing many changes. The issue was resolved with an internal property that controls the maximum size of the reader queue. 

 

Jira issue: RECOB-8797 

Salesforce case: 298821 

Type: Issue 

Component/Process: Snowflake Azure Target 

Description: The Max file size setting was added to the General tab of the endpoint settings. 

 

Jira issue: RECOB-8733 

Salesforce case: 175070 

Type: Issue 

Component/Process: Snowflake Target 

Description: When the setIgnoreCaseFlag parameter was enabled, the task would sometimes fail to remove the old staging area or create a new one. 

 

Jira issue: RECOB-8761, RECOB-8805 

Salesforce case: 168796 

Type: Issue 

Component/Process: Oracle Source - Replicate Log Reader 

Description: After upgrading Oracle 19g to the July 2024 patch, data would not be replicated properly due to incorrect page decompression in DIRECT-INSERT or MULTI-INSERT operations. 

 

Jira issue: RECOB-8766 

Salesforce case: N/A 

Type: Enhancement 

Component/Process: SAP ODP Source 

Description: Support for D34R and RSTR data types was added. 

 

Jira issue: RECOB-8750 

Salesforce case: N/A 

Type: Issue 

Component/Process: SAP HANA Source - UI 

Description: Views were not shown in the UI Table Selection dialog. 

 

Jira issue: RECOB-8743 

Salesforce case: N/A 

Type: Issue 

Component/Process: Amazon Kinesis Target - UI 

Description: Fixed a UI typo in Message Properties. 

 

Jira issue: RECOB-8721 

Salesforce case: N/A 

Type: Issue 

Component/Process: Oracle Target 

Description: INSERT operations would sometimes fail with the following errors (excerpt). 

ORA-12838: cannot read/modify an object after modifying it in parallel  

The issue was resolved using an internal property to disable the ALTER SESSION PARALLEL DML operation. 

 

Jira issue: RECOB-8726 

Salesforce case: 163674 

Type: Issue 

Component/Process: SAP Extractor Source 

Description: The processed records counter in the SAP Extractor logs would sometimes show zero for full load and delta loads. 

 

Jira issue: RECOB-8694 

Salesforce case: 174180 

Type: Issue 

Component/Process: PostgreSQL Source - Logging 

Description: When setting the task not to replicate LOB columns, an incorrect failure message would be printed as INFO for every event. 

 

Jira issue: RECOB-8725 

Salesforce case: N/A 

Type: Issue 

Component/Process: Replicate Installation 

Description: The Replicate Linux installation file wrongly contained a public code-signing key. 

 

Jira issue: RECOB-8709 

Salesforce case: N/A 

Type: Issue 

Component/Process: Security 

Description: Replicate would ship with an outdated log4net version and a vulnerable Newtonsoft.Json file. 

 

Jira issue: RECOB-8611 

Salesforce case: 159309 

Type: Issue 

Component/Process: SAP HANA Source + Log Stream 

Description: In CTS mode, the following error would sometimes occur when replicating the /CHPDPE/CEITMPX table: 

SqlState: HY000 NativeError: 4 cannot allocate enough memory 

The issue was fixed with a feature flag. 

 

Jira issue: RECOB-8678 

Salesforce case: 160381 

Type: Issue 

Component/Process: SAP ODP 

Description: “Batch optimized apply” mode would ignore DELETE operation when a record was also updated in the same batch. 

 

Jira issue: RECOB-8680 

Salesforce case: 165375 

Type: Issue 

Component/Process: SAP ODP 

Description: When capturing changes from a BW table, an “Out of bounds” error would sometimes occur. 

 

Jira issue: RECOB-8679 

Salesforce case: 155357 

Type: Issue 

Component/Process: SAP ODP 

Description: Missing data would occur during Full Load, following SAP network errors. 

 

Jira issue: RECOB-8542 

Salesforce case: 165719 

Type: Issue 

Component/Process: Replicate Installation 

Description: The Replicate Linux installation would fail if there was no systemctl. 

 

Jira issue: RECOB-8576 

Salesforce case: 162044 

Type: Issue 

Component/Process: SAP HANA Source 

Description: The task would crash when source lookup was configured in the transformation. 

 

Jira issue: RECOB-8698 

Salesforce case: 295901 

Type: Issue 

Component/Process: Oracle Source - Replicate Log Reader 

Description: The task would crash after upgrading Oracle 19g to the July 2024 patch.  

 

Jira issue: RECOB-8598 

Salesforce case: 153905 

Type: Issue 

Component/Process: Kafka target 

Description: Stopping the task would cause a crash when the endpoint server license was missing or when the endpoint server was not running. This issue was resolved using an internal parameter. 

 

Jira issue: RECOB-8633 
Salesforce case: 128634 
Type: Issue 
Component/Process: Parallel apply in Batch optimized apply mode 
Description: When the Apply batched changes to multiple tables concurrently option was enabled, data would sometimes be missing after reattaching to the target (following a disconnect). The issue was resolved using a feature flag, which returns a recoverable error instead of attempting to reattach. 

 

Jira issue: RECOB-8691 

Salesforce case: N/A 

Type: Issue 

Component/Process: Snowflake targets 

Description: The task would sometimes fail when using Snowflake internal storage. 

 

Jira issue: RECOB-8651 

Salesforce case: 171424 

Type: Issue 

Component/Process: Oracle Source - Replicate Log Reader 

Description: When the last table column of a table with supplemental logging set on all columns was marked as unused, UPDATE operations would sometimes result in unexpected results on the target  

 

Jira issue: RECOB-8560 

Salesforce case: 153711 

Type: Issue 

Component/Process: Databricks (Cloud Storage) 

Description: When running multiple tasks against the same database, the CDC partition table files would be created with same name, thereby overriding each other. 
The issue was resolved with a Feature Flag at task level. 

 

Jira issue: RECOB-8614 

Salesforce case: 175635 

Type: Issue 

Component/Process: SAP Application (DB) 

Description: When a captured cluster document change deleted all rows of all its captured tables, missing DELETE operation and unnecessary assertion messages would be encountered. 

 

Jira issue: RECOB-8626 

Salesforce case: 171607 

Type: Issue 

Component/Process: Metadata Manager 

Description: Tasks would fail when using the use_manipulation_pk_for_apply feature flag with Store Changes replication. 

 

Jira issue: RECOB-8637 

Salesforce case: N/A 

Type: Enhancement 

Component/Process: Databricks Lakehouse (Delta) 

Description: Added support for Databricks Volumes. 

 

Jira issue: RECOB-8627 

Salesforce case: 161454 

Type: Issue 

Component/Process: Amazon Kinesis 

Description: The connection would fail when using IAM Role for EC2 to connect to Amazon Kinesis, after using Key Pair authentication to connect to Amazon S3. 

 

Jira issue: RECOB-8582 

Salesforce case: 153169 

Type: Issue 

Component/Process: Microsoft SQL Server Target 

Description: When Use BCP for loading tables was enabled in the endpoint settings, the maximum LOB size would be limited to 63 KB. 

 

Jira issue: RECOB-8604 

Salesforce case: 166180 

Type: Issue 

Component/Process: Replicate Engine 

Description: After upgrading to Replicate 2024.5, it would not be possible to connect to Databricks (Delta) if FIPS was enabled on Windows. 

 

Jira issue: RECOB-8537 

Salesforce case: 154701 

Type: Enhancement 

Component/Process: Security 

Description: Added an option to install Replicate on Linux without using "RPM", and without allowing the creation of a new USER/GROUP. 

 

Jira issue: RECOB-8620 

Salesforce case: 162987 

Type: Issue 

Component/Process: Oracle Source - Replicate Log Reader 

Description: In rare scenarios, INSERT operations on wide tables would be replicated with partial column values. 

 

 

Jira issue: RECOB-8565 

Salesforce case: 170484 

Type: Issue 

Component/Process: Microsoft SQL Server Source 

Description: When moving data from SQL Server, a missing column name in the table definitions would cause an infinite notification loop in the repsrv.log file, with the following message: 

mssql_resolve_sqlserver_table_column_attributes(...) failed to find column 

 

Jira issue: RECOB-8592 

Salesforce case: 158504 

Type: Issue 

Component/Process: SAP Application (DB) 

Description: Added an internal property to prevent the addition of SAP Catalog tables to the list of SAP Application (DB) backend tables. 

 

Jira issue: RECOB-8550 

Salesforce case: 164667 

Type: Issue 

Component/Process: UI 

Description: The task settings’ Environmental errors tab would not show the proper settings. 

 

Jira issue: RECOB-8465 

Salesforce case: 165513 

Type: Issue 

Component/Process: UI 

Description: The total number of the selected tables would no longer be shown at the bottom of Designer view. 

 

Jira issue: RECOB-8538 

Salesforce case: 162298 

Type: Issue 

Component/Process: SAP HANA Source 

Description: Log-based CDC would fail or would keep reading from the same position when processing large multi-segment backup logs. 

 

Jira issue: RECOB-8518 

Salesforce case: N/A 

Type: Issue 

Component/Process: UI 

Description: The table keys would be incorrectly shown in the UI after defining key transformations. 

 

Jira issue: RECOB-8477 

Salesforce case: 154293 

Type: Issue 

Component/Process: Log Stream 

Description: Replication over log stream tasks would sometimes fail during task initialization. 

 

Jira issue: RECOB-8507 

Salesforce case: 150857 

Type: Issue 

Component/Process: SAP HANA Source 

Description: The task would sometimes start very slowly, impacting the creation of its captured tables list. 

 

Jira issue: RECOB-8405 

Salesforce case: 156279 

Type: Issue 

Component/Process: AIS Source 

Description: Added an internal parameter: printCSVFileNamesInInfo 

When the parameter is set to TRUE (and logging is set to INFO or higher), the Replicate IMS source endpoint will write CSV file names and their creation date to the Replicate log. 

As turning on the parameter will increase the log size, customers should monitor it to avoid storage issues. To reduce the logging impact, best practice is to maintain only a reasonable backlog of CSV files, and to delete CSV files that have already been applied to target. If the log size becomes excessive, set the parameter to FALSE to stop the additional logging. 

 

Jira issue: RECOB-8400 

Salesforce case: 152188 

Type: Issue 

Component/Process: Microsoft Azure Synapse Analytics Target 

Description: Older files would not be deleted from ADLS staging during reload. This would result in the task failing due to duplicate records or because of non-matching records.  

 

Jira issue: RECOB-8469 

Salesforce case: 158504 

Type: Issue 

Component/Process: SAP Application (DB) 

Description: Added an internal property to prevent the addition of SAP Catalog tables to the list of SAP Application backend tables. 

 

Jira issue: RECOB-8481 

Salesforce case: N/A 

Type: Issue 

Component/Process: Security - UI 

Description: Updated Angular to a version that resolves known vulnerabilities. 

 

Jira issue: RECOB-8475 

Salesforce case: 161767 

Type: Issue 

Component/Process: Log Stream 

Description: The "Retrieve all source columns on UPDATE" option would be turned off after upgrade, resulting in failure of tasks that needed this option to be turned on. The issue was resolved using a feature flag.  

 

Jira issue: RECOB-8451 

Salesforce case: 117989 

Type: Issue 

Component/Process: Infrastructure 

Description: Added logging for troubleshooting the following intermittent error:  

Message size <369295616> exceeds maximum of 16Mb 

 

Jira issue: RECOB-8433 

Salesforce case: N/A 

Type: Issue 

Component/Process: Microsoft Azure SQL Database Target 

Description: Creation of the Primary Key/Unique Index would fail when the constraint name exceeded 128 characters. 

 

Jira issue: RECOB-8338 

Salesforce case: 147998 

Type: Issue 

Component/Process: Hadoop 

Description: When using Hadoop without Hive access, the Full Load task would fail. 

 

Jira issue: RECOB-8402 

Salesforce case: 159978 

Type: Issue 

Component/Process: Databricks Delta 

Description: When a data value contained binary zeros, both the Full Load and the CDC task would fail. 

 

Jira issue: RECOB-8410 

Salesforce case: N/A 

Type: Issue 

Component/Process: Security 

Description: The java_file_factory component was updated to a version with non-vulnerable dependencies. 

Resolved issues in Replicate May 2024 initial release

The following section describes the issues resolved in Replicate May 2024 initial release.

Jira issue: RECOB-8101

Salesforce case: 138462

Type: Issue

Component/Process: Amazon Redshift

Description: When the "Limit LOB size" option was enabled, and replicating data larger than limited lob size*2 on CLOB from IBM DB2 from z/OS, a data error would occur. This issue was resolved using an internal parameter.

 

Jira issue: RECOB-8192

Salesforce case: 150243

Type: Issue

Component/Process: Oracle Source - Replicate Log Reader

Description: Missing UPDATE operations would occur when replicating Advanced Compressed tables with long values.

 

Jira issue: RECOB-7965

Salesforce case: N/A

Type: Enhancement

Component/Process: IBM DB2 for z/OS Source

Description: The DB2 TRACE MONITOR will be auto-started when it is not active.

 

Jira issue: RECOB-8135

Salesforce case: N/A

Type: Enhancement

Component/Process: Oracle Source - Replicate Log Reader

Description: Improved Oracle Log Reader logging.

 

Jira issue: RECOB-8027

Salesforce case: 117549

Type: Issue

Component/Process: SAP ODP Source

Description: UPDATE operations would be captured as INSERT operations when using SLT.

 

Jira issue: RECOB-8090

Salesforce case: 135515

Type: Issue

Component/Process: MySQL Source

Description: Replication tasks from MySQL source would fail after upgrade to 2023.11.

 

Jira issue: RECOB-8064

Salesforce case: 144176

Type: Issue

Component/Process: Replicate Installation

Description: Added an option to force the installation to request a user and group.

 

Jira issue: RECOB-8021

Salesforce case: 108548

Type: Issue

Component/Process: Kafka

Description: Tasks using the Kafka target endpoint would consume excessive memory when capturing the REAL data type and using JSON message format.

 

Jira issue: RECOB-8066

Salesforce case: 132663

Type: Issue

Component/Process: SAP Application (DB)

Description: SAP transparent table LOB fields were not exposed in the Replicate UI.

 

Jira issue: RECOB-8059

Salesforce case: 132663

Type: Issue

Component/Process: SAP Application (DB)

Description: The "By partition" option of the Parallel Load feature could not be selected.

 

Jira issue: RECOB-8092

Salesforce case: 138709

Type: Issue

Component/Process: DB2 iSeries Source

Description: When using only RRN as a Primary Key on a table without a Primary key or Unique Index, the Primary Key position would be set to 0 instead of 1. This would result in an incorrect value being inserted in the 'primaryKeyPosition' metadata field.

 

Jira issue: RECOB-7760

Salesforce case: 108951

Type: Issue Component/Process: Kafka

Description: A memory leak (a new METADATA MANAGER TABLE pool would be created) would occur each time a data problem was detected.

 

Jira issue: RECOB-7949

Salesforce case: 106008

Type: Issue

Component/Process: Microsoft SQL Server Source

Description: The internal property logScanRowCount usage would sometimes cause missing operations or entire transactions. This would also result in the Sorter swap files not being deleted.

 

Jira issue: RECOB-7966

Salesforce case: 133745

Type: Enhancement

Component/Process: Kafka

Description: Added support for tombstone methodology for DELETE operations in Kafka. Supported using an internal parameter.

 

Jira issue: RECOB-7980, RECOB-8016

Salesforce case: 135999

Type: Issue

Component/Process: Oracle Source - Replicate Log Reader

Description: Missing and duplicate records would sometimes be encountered for multi Insert operations in Oracle instances with ENABLE_GOLDENGATE_REPLICATION=TRUE.

 

Jira issue: RECOB-7924

Salesforce case: 108202

Type: Issue

Component/Process: Microsoft SQL Server Source

Description: The compressed transaction log would be processed incorrectly in some specific SQL Server scenarios.

 

Jira issue: RECOB-7973

Salesforce case: 136823

Type: Issue

Component/Process: IBM DB2 for z/OS Source Source

Description: The IBM DB2 for z/OS source endpoint would not work with a German DB2 z/OS instance.

Downloads

Download this release from the Product Downloads page on Qlik Community.

About Qlik

Qlik converts complex data landscapes into actionable insights, driving strategic business outcomes. Serving over 40,000 global customers, our portfolio provides advanced, enterprise-grade AI/ML, data integration, and analytics. Our AI/ML tools, both practical and scalable, lead to better decisions, faster. We excel in data integration and governance, offering comprehensive solutions that work with diverse data sources. Intuitive analytics from Qlik uncover hidden patterns, empowering teams to address complex challenges and seize new opportunities. As strategic partners, our platform-agnostic technology and expertise make our customers more competitive. 

qlik.com

Show Less