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
• Known issues
• Downloads

What's new

Learn about new features and improvements in Qlik Compose.

Resolved issues

The following issues have been resolved since Compose November 2023 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
• Resolved Defects

What's New

Learn about new features and improvements in Qlik Cloud.

Resolved Defects

The following Release Notes cover resolved defects for Qlik Cloud. Solved issues and limitations for Qlik Cloud Services are also listed.

QB-27392	Visualizations: Reports are missing objects when custom theme is using custom font.	Resolved an issue where loading of the custom fonts in a theme was not properly awaited before reports were performed. After properly awaiting the font, loading reports are not missing objects anymore.
QB-27336	Qlik Cloud Administration: Navigation bar not clickable on Tenant encryption page	Resolved an issue where the navigation bar was not clickable on the Tenant encryption page.
QB-29673	Qlik Cloud Hub: Filtering in 'Favorites' does not work	Fixed an issue where filtering items under the 'Favorites' section of the Qlik Cloud hub did not work, resulting in all items being displayed.
QB-28915	Qlik Cloud: Objects missing when exporting a story as PDF	Resolved an issue where exporting stories and sheets would fail due to improper reuse of session objects.
QB-28939	Qlik Cloud: Japanese Kanji not rendered in exported PDF	Japanese Kanji were incorrectly rendered in exported PDFs, affecting titles and text content, despite the app being configured correctly with the "ja-JP" collation locale. This issue has been fixed.
QB-27327	Qlik Cloud: Inadequate contrast in DLE load Log	Updated the Data Load Editor (DLE) load log by changing the light grey color to a darker grey to enhance accessibility and meet contrast requirements for better readability.
QB-29359	Qlik Cloud Search: Unable to open apps and links from 'Search results'	Fixed an issue where clicking on a link to an app or a link from global 'Search results' would either fail to open the app or open an empty link.
QB-29065	Qlik Cloud: Race condition issue in reloads service	Resolved a rare race condition issue in the reloads service that caused reloads to exit abruptly at the start. The fix ensures that the service now waits for session requests to return before initiating the reloads.
QB-28513	AutoML: Incorrect routing key for OOM errors	Resolved an issue where the routing key for Out of Memory (OOM) errors was incorrectly set to "prediction.requested.error." This has been corrected to "prediction.error," allowing for accurate tracking of returnCode -9 and proper classification of OOM errors.
QB-27431	Qlik Cloud Hub: Combo chart appears blank when monitored from the hub	Fixed an issue where combo charts did not appear when monitored from the Qlik Cloud hub.
QB-27523	Qlik Cloud Administration: External consumption of analyzer capacity not shown	Analyzer capacity consumed by other deployments and regions has been added to the displayed measurement in the Administration activity center.
QB-27802	Qlik Cloud: Client crash when dragging fields in simplified authoring mode	Fixed a rare client crash that displayed the message "An error occurred" when dragging a field in simplified authoring mode, specifically when the sheet contained a master "Date picker" object.
QB-27298	Qlik Cloud: DLE and script editor failing when accessing script history for some users	Fixed an issue where the data load editor (DLE) and script editor would fail for some users when accessing script history. This occurred because the script history was using an incorrect locale for date/time formatting. If no default locale was set for the user, it was registered as null, causing the UI to fail.
QB-28408	Visualizations: Waterfall chart behaves differently when inside a layout container	Fixed a problem that caused the layout container to incorrectly handle ongoing selections when the show condition changed from true to false. This has been fixed and the behavior is now aligned with the tabbed container.
QB-29194	Qlik Cloud: Unable to edit subscriptions	Resolved an issue where the Edit subscription dialog did not appear when attempting to edit a sheet subscription.
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-27227	Bar chart label incorrect when the result is 1.95	Fixed floating error on formatting.
QB-29505	Qlik Cloud: User assigned Tenant Admin role does not see their user when assigning space roles	Resolved an issue where a user assigned Tenant Admin role via group membership would not find their specific user name (ID) when attempting to assign space roles.
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-28822	Qlik Engine: Selections discarded when distributing QlikView files to the Cloud	Fixed a problem that caused QlikView objects to be incorrectly distributed if the resource type was wrong. A new access rule solves this issue and includes the objects in the app.
QB-29763	Qlik Cloud Hub: 'Monitoring chart' removed from collections after app reload	Resolved an issue where the 'Monitoring chart' would lose its association with collections it was added to (including 'Favorites') when an app it originated from was reloaded.
QB-28372	Qlik Engine: Intermittent cancellation of store/upload	Fixed a degradation that caused intermittent cancellations of data file store/upload during reload.
QB-29761	Qlik Cloud: Inaccurate 'Time zone' displayed for new users	For new QCS users who don’t have the 'preferredZoneinfo' property defined, the 'Time zone' value displayed in the hub's 'Profile' settings would incorrectly show a preset value, which was actually inherited from the browser. This could create inconsistency between UI and other services which in the absence of 'preferredZoneinfo' default to UTC time zone. The fix was to display blank value when not set.
QB-29608	Qlik Cloud: Replacing dimensions or measures fails in charts with modifiers	Resolved an issue where replacing dimensions or measures would sometimes fail if they were linked to a non-existing master dimension in charts using modifiers. This fix complements the solution provided for QB-29401, which addressed the issue for charts not using modifiers.
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-28340	Qlik Cloud: Migration failure due to decryption issues with bookmarks	Fixed an issue where the key migration process failed when encountering corrupted bookmarks or other decryption errors. The engine has been updated to ensure that keys are migrated even when bookmarks cannot be read.
QB-29791	Qlik Data Prep: Error when updating data files in Data Load Editor	Fixed an encoding problem that caused the confirmation dialog to not appear when replacing files in Data manager. This happened when file names included special characters. In the Data load editor and Script editor, an error was displayed when attempting to replace files, sometimes without special characters in file names. These issues were resolved by ensuring file names are encoded only once.
QB-27983	Restrict send to excel option in contextual menu for "Has restricted View"	Users or groups with "Has restricted View" permission now have Send to excel option in contextual menu.
QB-27718	Qlik Cloud: Ascending and descending sorting not working in straight tables	Resolved an issue where the ascending and descending sort options for straight tables were not functioning correctly. Sorting has now been fixed to work as intended.
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.

 

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 Sense November 2024
• Visualizations & Dashboard
• Data & Platform
• Resolved Defects
• 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 and Notes.
• 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 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 DataTransfer November 2024
• Resolved Defects
• Known issues and limitations
• Upgrade notes
• Backup recommendations:
• System requirements notes
• Downloads
• Consider migrating to Qlik Data Gateway - Direct Access

 

The following release notes cover the version of Qlik DataTransfer released in November 2024. For questions or comments, post in the Product Forums or contact Qlik Support.

What's new in Qlik DataTransfer November 2024

The Qlik DataTransfer November 2024 release does not have any new features, but only provides an update of the embedded Qlik Engine and the fixes for the issues described below.

Resolved Defects

• Unhandled exceptions in the "Data folders" file watching mechanism have been fixed, and the underlying cause for the exception is now logged. Previously the DataUploadService component of Qlik DataTransfer crashed and lost track of any pending uploads.
  
  
• Temporary files are now ignored. Editing of XLSX-files residing in a folder being watched by Qlik DataTransfer could occasionally cause the DataUploadService to crash when it attempted to upload the temporary files (~$*.xlsx) created during the 3rd-party software's "Save" process.
  
  
• Any invalid configuration settings in the services.conf file are now logged as warnings with fallback to defaults. This will help users self-service while attempting to make advanced configuration changes. Invalid settings could previously cause the Service Dispatcher to continually restart the DataUploadService, making the application unresponsive.

Known issues and limitations

This release has the same known issues and limitations as noted in the release notes for Qlik DataTransfer November 2022.

Upgrade notes

Please refer to the online help for information about Upgrading Qlik DataTransfer.

Backup recommendations:

• It is important that you make a backup of the folder C:\ProgramData\Qlik\Sense\DataTransfer and C:\Program Files\Qlik\DataTransfer\services.conf before upgrading. This will make it possible to recover the installation if the upgrade fails.
• If you have installed Qlik DataTransfer to a folder other than C:\Program Files\Qlik\DataTransfer, then please make a copy of the services.conf file from that folder.
• If you have changed the default StoragePath in the services.conf file, then make a backup of that folder instead.
• The services.conf file is reset to the latest release’s defaults during upgrades so the backup is helpful for reapplying any custom user settings.
• If you are installing or upgrading on machine where Qlik Sense Enterprise for Windows is already installed, please make sure you install/upgrade Qlik DataTransfer using Qlik Sense service(s) user account.

System requirements notes

Please refer to the online help for information about Qlik DataTransfer system requirements.

Downloads

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

Consider migrating to Qlik Data Gateway - Direct Access

Whenever possible, Qlik recommends using the Qlik Data Gateway - Direct Access to load data from on premises into a Qlik Cloud tenant. The supported databases and the Generic ODBC Connector Package, together with the upcoming support for loading on premises files, can allow you to decommission Qlik DataTransfer servers (and potentially repurpose them for gateways). For more information, see Qlik Data Gateway - Direct Access.

 

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
• Resolved Defects

 

What's New

Learn about new features and improvements in Qlik Cloud.

 

Resolved Defects

The following Release Notes cover resolved defects for Qlik Cloud. Solved issues and limitations for Qlik Cloud Services are also listed.

QB-26556	Qlik Cloud Alerting: Report tasks not sent for certain users	Fixed a problem where a report task would not be sent for users with view and section access. This was solved by making the access rule more lenient to allow notification creation under certain circumstances.
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-17413	Qlik Engine: Select statement with preceding load results in faulty lineage	Field-level lineage for SQL/select statements have been refactored to resolve incorrect lineage for complex preceding load statements for SQL queries.
QB-25981	Incorrect translation: Japanese	Corrected the Japanese translation for "Sorting in search" when working with pivot tables.
QB-26400	Qlik AutoML: Realtime Predictions returning improper JSON response	Fixed a problem where a 200 response code was sent incorrectly because the correct 4xx code was nested in an array. A fix was implemented to check whether the response is in an array. If it is, it will grab the proper JSON response and send it to the user.
QB-26187	Qlik Application Automation: Error when using Open File block with FTP connector	Fixed a problem where the Open File block would throw an error when the file was in FTP.
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-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-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-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-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-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-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-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-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-27988	Qlik Engine: Syntax error on tab during script execution	Fixed a LOAD script parsing problem when the WHERE clause contains "(".
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-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-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-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-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-28727	Visualizations: Not possible to search for bookmark	Now validating bookmark creation date before the formatting date.
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-26792	Qlik Cloud Alerting Services: No option to remove email provider	We have added a new email provider option: "None"  Selecting "None" when another provider is configured, will delete the saved configuration.
QB-26995	Qlik Cloud Alerting Services: Tabular Reporting task scheduled showing incorrect scheduled dateFixed incorrect time displayed for Report task scheduled date	Fixed a problem where the scheduled column for a Report task would display "tomorrow" when it should have displayed "in 2 days". Reports with this issue would still run at their scheduled time.
QB-27207	Qlik Cloud Visualizations: Problems when exporting objects from different apps using the capability API	Fixed a problem where the capability API created bookmarks in the wrong app. This caused exporting objects from a mashup to work only for the first app.
QB-27200	Qlik Engine: Error when setting space of a staged QlikView app in Qlik Cloud	Fixed a problem were setting the space for a staged QlikView app in Qlik Cloud was denied. This was due to an admin access rule which prevented the operation.
QB-27253	Visualizations: Extra object shown in sheet when redirected from Multi KPI in storytelling	Resolved an issue where an additional object was displayed in the sheet upon redirecting from a Multi KPI in storytelling. The problem was fixed by ensuring the correct state is set when navigating from storytelling to the sheet using Multi KPI.
QB-27315	Qlik Cloud Hub: Duplicate of a modified app/script retains old name/description	Fixed an issue where upon duplicating an app or a script, which had been renamed or had its description modified, the newly created item would still show the old name and/or description.
QB-27271	Qlik Cloud: Dialog box not auto-scrolling to bottom when loading data via DLE	Resolved an issue where the dialog box did not automatically scroll to the bottom during data loading via the data load editor (DLE).

 

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
• 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)

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
• 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
• 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)

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

The following section describes the issues resolved in the 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