Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Release notes explain new features added, issues resolved, and improvements in Qlik Solutions.
Table of Contents
Learn about new features and improvements in Qlik Cloud.
The following Release Notes cover resolved defects for Qlik Cloud. Solved issues and limitations for Qlik Cloud Services are also listed.
QB-25098
|
Qlik Cloud Hub: App's description is cleared when the app's name is updated |
Fixed a problem that would clear an app's description when the app's name was changed. |
QB-24943
|
Visualizations: Map chart label coloring not functional through exploration menu |
Fixed a problem that caused changes to the base map and language setting when changing the label coloring for map charts in the exploration menu. |
QB-24356
|
Qlik Cloud Engine: Large app usage is double-counted |
When a second user tried to open an app that was already open, the request was denied and the app usage was counted twice. This has been fixed and large apps are not double-counted towards the large app quota. |
QB-25050
|
Qlik Cloud Engine: Reload error message not saved to reload summary |
When a reload crashed on a max-size engine, the error message was not saved in the reload summary. This has been fixed and reload error messages are now saved to the summary. |
QB-25219
|
Qlik Content Security Policy: "blob:"-type URIs are not allowed |
It is now possible to use "blob:"-type URIs as an origin for media-src. |
QB-24911
|
Visualizations: Some lines disappear when scrolling line charts |
Fixed a problem where, for certain datasets, two-dimensional line charts sometimes failed to show all lines when scrolling. |
QB-25189
|
Visualizations: Turning off "Toggling selection toolbar" does not work in filter panes |
Fixed a problem where the show selections toolbar was not working because the property was not propagated to the component. A rendering test has also been added to capture similar problems in the future. |
QB-24752
|
Visualizations: New slides in storytelling are not placed at the end of exported PDF |
New storytelling slides will always be placed at the end of the story.
|
QB-25055
|
Visualizations: Calculation condition does not work correctly |
The name of the calculated item was not displayed when the condition was not met. This has been fixed and the labels for dimension expressions are shown instead of showing an error text. |
QB-24411
|
Visualizations: Expression for legend label in distribution plot not evaluated |
Using an expression for a legend label wasn't evaluated in a distribution plot. For this fix to take effect, the user will need to reapply the properties for the visualization to pick up the change. |
QB-23975
|
Qlik NL Insights: Incorrect Dutch translation |
NL Insights for "top dimensions" have been updated to the correct translation in Dutch. |
QB-25340
|
Qlik Cloud Data Integration: Manual database input load fails |
When using database manual input, users with low privileges could not get a list of databases and instead would get an error message ("Failed to prepare data app"). With this fix, users with low privileges will instead get the database that was manually input during the connection's creation. |
QB-25340
|
Qlik Cloud Data Integration: Manual database input load fails |
When using database manual input, users with low privileges could not get a list of databases and instead would get an error message ("Failed to prepare data app"). With this fix, users with low privileges will instead get the database that was manually input during the connection's creation. |
QB-25217
|
Qlik Data Prep: Limited field of view in the Add Data dialog in Data Manager on Chrome and Edge |
When selecting a source data file, the preview window was limited to only showing one row. This has been solved by fixing a rendering problem in the Add Data Dialog on the latest Google Chrome and Microsoft Edge versions. |
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 Alerting Release Notes – July 2023 Service Release 2
Qlik Alerting is an intelligent alerting platform for Qlik Sense, providing sophisticated, data-driven alerts that help you more proactively monitor your business and take timely action. The mobile app allows existing Qlik Alerting customers to deliver data alerts to users in a secure manner on mobile devices. For more information on Qlik Sense and Qlik Alerting, please visit Qlik.com.
What's new in Qlik Alerting July 2023 Service Release 2
We are providing security fix on July 2023 release and rebranding alerting in Windows, Android and iOS to reflect new Qlik logo.
Download Qlik Alerting on Windows release from the Product Downloads page on Qlik Community. The Android and iPhone apps are available in their respective stores.
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.
Table of Contents
The following release notes cover the versions of Qlik GeoAnalytics Plus released in February 2024. For questions or comments, post in the Product Forums or contact Qlik Support.
GeoAnalytics Server now requires Java 17 or newer.
Performance optimizations (speed, and total memory allocations) in loading data from external files, for all supported file formats.
The connector will now retry a few times if Plus fails to start. Improved logging during startup. Improved error handling during startup.
QB-19383 | Character encoding does not apply to Shapefile field names | This is now fixed, and the auto-detection of Shapefile character encodings has been improved. |
GEO-1940 | Can't use numeric field for route operation costs | Previously the operation would fail with an error message about the column being the wrong type. |
GEO-1942 | Previewing a CSV with WKT geometries would not pick up the geometry type | It would only load the CSV header and not pick up the geometry type from the first row. |
None.
Requires Java 17 or newer.
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.
Table of Contents
The following release notes cover the versions of Qlik GeoAnalytics Extensions for QlikView released in February 2024. For questions or comments, post in the Product Forums or contact Qlik Support.
Upgraded dependencies for the license update tool.
No changes.
Storytelling - a map or layer snapshot should only be added once per story, and combining an embedded sheet with snapshots from the same sheet is not supported.
Printing is not supported.
The license tool now requires .NET 4.8 or newer.
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.
Table of Contents
The following release notes cover the versions of Qlik GeoAnalytics Extensions for Qlik Sense released in February 2024. For questions or comments, post in the Product Forums or contact Qlik Support.
Upgraded dependencies for the license update tool.
No changes.
Storytelling - a map or layer snapshot should only be added once per story, and combining an embedded sheet with snapshots from the same sheet is not supported.
Printing is not supported.
The license tool now requires .NET 4.8 or newer.
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.
Table of Contents
The following release notes cover the versions of GeoAnalytics Server released in February 2024. For questions or comments, post in the Product Forums or contact Qlik Support.
GeoAnalytics Server now requires Java 17 or newer.
Performance optimizations (speed, and total memory allocations) in loading data from external files, for all supported file formats.
QB-17223 | Improved placement of city labels in webmap | An issue in the label priority comparison was fixed, which should lead to better prioritization of city labels. |
QB-19383 | Character encoding does not apply to Shapefile field names | This is now fixed, and the auto-detection of Shapefile character encodings has been improved. |
GEO-1940 | Can't use numeric field for route operation costs | Previously the operation would fail with an error message about the column being the wrong type. |
GEO-1942 | Previewing a CSV with WKT geometries would not pick up the geometry type | It would only load the CSV header and not pick up the geometry type from the first row. |
GEO-1944 | GeoAnalytics logs not showing up in the main log | Fixed an issue that caused GeoAnalytics log messages to be silently discarded. |
None.
GeoAnalytics Server now requires Java 17 or newer.
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.
Table of Contents
The following release notes cover the versions of Qlik Sense Enterprise on Windows released in February 2024. For questions or comments, post in the Product Forums or contact Qlik Support.
Please refer to the What’s new sections of the online help for information about the new and updated features of the Qlik Sense Enterprise on Windows February 2024 release:
What's new in Qlik Sense February 2024 (Users)
What's new in Qlik Sense February 2024 (Developers)
What's new in Qlik Sense February 2024 (Administrators)
New load balancing algorithm
The load balancing algorithm has been improved by using Engine health check data. As part of the Engine health check data we now store the CPU usage and free memory information per Engine node. Now, apps can be routed to nodes based on this data to make sure nodes are receiving new apps or new sessions based on their current usage.
Added support for SHA-384
Support for SHA-384 has been added for a higher encryption within a Qlik Sense deployment. After a new installation or upgrade, SHA-256 will still be selected but the configuration can be changed into SHA-384 certificates.
Export functionality added for audits in the QMC
With the February 2024 release, you can now export your audit results out of your QMC into CSV files and use those values outside of your Qlik Sense Enterprise deployment.
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.
New pivot table
The new Pivot table is here with a set of new features:
All of the above are designed and added based on feedback from our users. The new Pivot table is launched in the Visualization bundle and will replace native pivot next year when additional features are added.
Layout container
The Layout container is a new component in the Dashboard bundle. In the Layout container, charts can be placed in a freeform manner with or without a snapping grid. Charts can overlap, be stacked, and controlled with show conditions. The Layout container is highly versatile but especially useful for:
To get the most out the layout container, follow best practices, check out Bruno Calver's talk at Techspert Visualization Day on Qlik Community.
Styling Grid, Funnel & Sankey charts
The Grid chart, Funnel chart, and the Sankey chart have been upgraded with the new property panel for styling. The styling includes general settings for title, subtitle, footnote, background, border and shadow and chart specific settings for axis and value labels.
Filter pane styling
The Filter pane now gets more properties for styling: General settings for title font styling, background, border and shadow. Chart specific styling for header and content font styling, color settings for selection state, background color and image.
Borders and shadows
As of today, most charts receive settings for borders and shadows. Charts inherit the border setting from the theme but the border width and color setting can now be overridden and customized per chart. The border can play a big role in how your dashboard is perceived, use it wisely to achieve your goals.
Chart shadow is a new property on charts, providing a shadow contour around the chart, with options for size and color. Shadows create a depth effect and can be used to highlight and make certain elements stand out.
Borders and shadows works very well in the Layout container where charts can overlap and be stacked.
Copy and paste style
You now have a new menu choice for copying style settings from one chart to another. This quality of life improvement makes it easier to style and work with charts. Especially now when all charts has many more styling settings.
Offline license issue in Qlik Sense Enterprise on Windows February 2024.
The following support article details a workaround: https://community.qlik.com/t5/Official-Support-Articles/Cannot-set-offline-license-in-Qlik-Sense-Enterprise-on-Windows/ta-p/2425091.
This issue will be fixed with the release of Qlik Sense Enterprise on Windows February 2024 Patch 2 on March 20, 2024.
Key | Title | Description |
QB-24440 | Qlik Sense: EngineHealth function in QMC stops working when TimeZone is UTC | Fixed a problem where the engine timestamp did not include a timezone offset, presenting only a "Z" instead of the expected "+0000", leading to a failure in converting the timestamp into a readable format. This update addresses a critical issue where the EngineHealth function would cease to operate correctly when the system TimeZone was set to UTC. We have enhanced the functionality within the QMC to ensure robust and accurate parsing of date-time strings across various time zone formats. |
QB-24625 | Qlik Sense Engine: Access to hidden values possible through Set Analysis on dimension | Fixed a problem where the Section Access value subset was not correctly applied to fields-on-the-fly based on a single key field. This resulted in all key values being visible on the field on the fly, even if Section Access restricted the source key field. |
QB-24368 | Qlik Sense: Content libraries do not recognize virtual proxy prefix | Fixed a problem where it was not possible to load content library items if a virtual proxy was used. |
QB-22171 | REST Connector: Slow when importing large files | We have made performance improvements of file import with the REST connector for cases where a table contains a large number of columns. |
QB-24441 | Qlik NL Insights: NL Insights not working on mashups on Qlik Sense Enterprise on Windows | Fixed a problem where NL Insights considered extensions as virtual proxy prefixes, causing the request to use the wrong URL. |
QB-24350 | Qlik Sense Visualizations: No longer possible to select several areas of the map at the same time | Clicking on one element of a slightly off-screen map would focus on the selection and confirmed it directly. This has been fixed and the map allows multiple selections. |
QB-24944 | Visualizations: Qlik.Resize() not working in mashups | Fixed a problem where Qlik.Resize() was not working in mashups. Chart rendering on resize is now triggered when the chart starts with zero size. |
QB-24577 | Qlik Sense Visualizations: Treemap chart color doesn't apply defined custom theme after upgrade | After upgrading to QS May 2023 patch 9, the custom theme was not applied to the treemap. This has been solved, and in cases where the color scheme does not exist, it will fall back to default. |
Key |
Title |
Description |
QB-19742 | Connectors: SAP BW/Infoprovider data type "INT8" limitation | The use of CL_ALV_TABLE_CREATE=>CREATE_DYNAMIC_TABLE was created in SAP_BASIS 46B, so new data types were not supported. This is now resolved by this ticket which was identified by SAP note 551605. |
QB-20411 | Qlik Engine: Outer set analysis could give different results with a master measure | If a master measure had an inner set using a $-sign expression, then the outer set could be applied erroneously. This meant that the result of an outer set with an expression could give different results than that outer set with an expression in a master measure. This has been fixed and set analysis results are now the same independent of whether the expression is in a master measure or not. |
QB-20509 | Qlik Engine: Embedded field names are sometimes not detected | Qlik Engine on Linux now correctly detects embedded labels in text files with Japanese and other non-western European languages. |
QB-21103 | Qlik Engine: Variable definitions are unexpectedly changing during an interactive reload | If a variable was created as an app object (not in script) and a user changed the value of the variable within their session, for example by using the variable input control in the Qlik Sense user interface, and the user then reloaded the app in the same session, the definition of the variable would change to the value in the user's session. This scenario would typically occur during app development, since it requires user-triggered interactive reload, with the same user working in the app, in the same session. This fix ensures that the definition of a variable is always maintained unless it is explicitly changed by an app designer or in a load script. The in-session value of the variable is independently controlled. |
QB-21227 | Visualizations: When bar chart is selected NVDA screen reader reads incorrect information | Fixed a problem that caused NVDA screen reader to read incorrect information when a bar chart was selected. |
QB-21289 | Visualizations: Variance waterfall data shows incorrect number abbreviation in Auto mode | This fix formats both the labels and the tips of the variance-waterfall chart based on the first measure format, in both Auto and Number mode. |
QB-22155 | Qlik Sense: Fail to open Data Load Editor in new tab | The routing was redirecting to a non-existent HMTL file, causing the failure to open the Data Load Editor in a new tab. This fix corrects the routing. |
QB-22161 | Qlik Sense Hub: Blank space appears in the Hub when app menu is opened | Fixed an issue where a blank space was displayed at the bottom of the screen in the Hub when the app menu was opened using right-click. |
QB-22217 | Qlik Sense on Windows: Bad request error when connecting to websocket for some formats of headers | This issue affected Qlik Sense on Windows August 2023 Patch 2. A "400 Bad request" error was thrown when connecting to websocket if multiple comma-separated valid headers were entered without entering a whitespace after the comma. This has been fixed and header values are now allowed without whitespaces. |
QB-22272 | Qlik Sense: Error when reloading Excel data after upgrading to Qlik Sense May2023 patch 6 | After upgrading to Qlik Sense May 2023 patch 6, some users saw "Error: Too many columns in data sources (16326) but the limit is 10000)" when reloading Excel data. This has been fixed by updating the default value of MaxColumsInDataSource to 0 for Qlik Sense Enterprise environments. The limit is set to 10,000 in Cloud environments by the cloud management rules in args.yml template. |
QB-22497 | Qlik Sense Visualizations: Hyperlink in table not working on Qlik Sense August 2022 IR | Fixed a problem where opening a URL from a table would cause the link to have a port attached to the URL. This went against the browser's origin restriction, meaning the iframe didn't show. This was solved by adding a "noopener" to the opening of the link. |
QB-22664 | Connectors: SAP BW reload fails when processing a variable value with "+" filter | Added support for "+" character in BEx variable values. |
QB-22724 | Tab Nabbing vulnerability in openNewTab() | Noopener has now been included when opening URLs from button objects. |
QB-22750 | Visualizations: Copy and paste of cell value fails in iFrame | Copying to clipboard is blocked within iFrames and needs to be specifically allowed on the iFrame properties. Due to the deprecation of execCommand in the browser API, Qlik now uses the never clipboard API. This is however blocked by default in iframes, unless you explicitly allow it. To allow, add: <iframe src="index.html" allow="clipboard-read; clipboard-write"></iframe> execCommand can still be utilized until it is removed. Until then, Qlik supports it as a fallback if the preferred copy solution is blocked. |
QB-22795 | 'Last modified by' is set to INTERNAL\bootstrap at app reload | The 'Modified by' column in QMC apps table is now set to INTERNAL\sa_repository after each app reload, reflecting the repository service updates to the app static byte size. This feature can be toggled on/off in the repository and QMC. |
QB-22817 | Visualizations: Color by expression not working in bar/line charts | Fixed a problem where color by expression was not applied correctly in some bar and line charts if it was combined with conditionally hidden measures. |
QB-22849 | Qlik Sense: Dashboard variable input has inconsistent behavior | Fixed a problem where the variable input from the dashboard bundle added an extra option to the dropdown. This extra option was confusing and has now been removed from the dropdown options. A new hidden option has been added that will allow selection of any option in the dropdown when these do not match the current value of the variable. |
QB-22966 | Qlik Connectors: Drill connector ODBC driver update | The ODBC driver for the Drill connector has been updated to a newer version that includes updates to third-party components. |
QB-22968 | Qlik Sense: External call to fonts.googleapis.com | The font Qlik Sense loads when the application starts is now loaded from Qlik Sense's own web resources. This means that external calls are no longer made. |
QB-23049 | Qlik Sense Visualizations: Unable to export to image or PDF when using URL rewrite in Reverse Proxy | Exporting Image/PDF didn't work using a Reverse Proxy prefix if a Virtual Proxy was not provided in the QMC. This fix removes the need to set up a Virtual Proxy in the QMC and instead uses the configurations of the Reverse Proxy to call the correct path to the printing service |
QB-23162 | Reading Parquet from S3 | Added a fix to read parquet files from S3 |
QB-23280 | Qlik Engine: Attribute flag does not affect cardinality of a Pivot table | Fixed a problem where an attribute with a SET statement with the attribute flag set to "false", was not expanding the whole cube to include the SET. |
QB-23298 | Qlik Sense Visualizations: Abbreviation of dimension labels are too short | Fixed a problem where GetObjectMeasures() did not work when used in a calculated dimension with aggr() method. |
QB-23329 | Visualizations: Scroll option missing in Link to Sheet selection. | Fixed an error that caused some CSS to not load properly, resulting in the missing scrolling function |
QB-23393 | Qlik Engine: Parquet file not read correctly | Parquet files were incorrectly ready, producing incorrect data output. This was fixed by supporting decimal types stored as fixed-length byte arrays. |
QB-23492 | Qlik Sense Visualizations: Total cell is not bold in Pivot table | In Pivot tables with a measure and a dimension in column, the Total value cell was not bold. This has been fixed and the Total value cells are correctly set as bold when there are only column dimensions and indent mode is turned off. |
QB-23497 | Master measure formatting was not applied in Insight Advisor charts | Resolved an issue where changes were not applied in Insight Advisor charts when master item settings were changed. |
QB-23501 | Windows authentication pop-up appears when loading background images in charts | The issue has been resolved. The media library button in the property panel was not using the virtual proxy prefix when loading the images. |
QB-23548 | Qlik Sense Hub: Long app names get truncated | In the Hub, apps with long names were truncated and not shown in the UI. This has been fixed with styling changes to show the app name on the next line if it exceeds a certain length. |
QB-23564 | Visualizations: Sheet background cannot be inserted via virtual proxy prefix | Resolved an issue where sheet background insertion was not possible via virtual proxy prefix. |
QB-23580 | Visualizations: Grid chart not allowing filtering on Y-axis dimension | Fixed a problem where gird charts did not render correctly if the current selection did not generate any data. |
QB-23712 | Visualizations: Selection icon hidden when zoom is used on Qlik Sense Mobile | Fixed a problem where the icon to confirm selections on the filter pane disappeared from the screen when zoom was active. Zooming is now prevented on the search field on small devices. |
QB-23717 | Visualizations: Clipboard API does not exist in non-secure context (HTTP) | Resolved and issue where write text to clipboard did not exist in nonsecure context (HTTP allowed). Now, a check ensures that the string is copied through a callback function whenever the clipboard API is unavailable. |
QB-23790 | Qlik Sense Engine: Windows script functionality | Window and WRank script functionality was originally available only on Qlik Cloud. With this fix, the script function is now available for Qlik Sense Enterprise on Windows. |
QB-23934 | Updated filter pane responsiveness | Resolved an issue where the filter pane would appear cropped when made very narrow in some cases. |
QB-23976 | Fix default context menu in mashups with containers | Resolved an issue where the default context menu of the browser failed to appear in mashups containing containers. |
QB-24345 | Qlik Sense: Mashups not loading after Qlik Sense upgrade | A comparison for cross-site mashups was not considering a mashup on the same host with a different port to be a cross-site mashup. |
QB-24377 | Visualizations: Wrong color by dimension | Fixed an issue where changing the first dimension of a two-dimensional chart via the exploration menu could update the "Color by dimension" incorrectly. |
SHEND-1522 | Qlik Sense: Updated Node.js | Qlik Sense February 2024 updates the version of NodeJS to pick up recent patches |
The following issues and limitations were identified at release time. The list is not comprehensive but lists all known major issues and limitations.
3rd party library QT has been updated to version 6.5.4.
SHA-384: Upgrading the certificate signing algorithm requires the restart of Qlik Sense services. For a step-by-step instruction, see Upgrading the certificate signing algorithm. If Qlik NPrinting is connected to the Qlik Sense server, certificates must also be exported to the NPrinting deployment and NPrinting services need to be restarted.
For information about the requirements for Qlik Sense, see System requirements for Qlik Sense in the online help.
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.
Table of Contents
The following release notes cover the versions of Qlik NPrinting released in February 2024 Initial Release.
Excel templates can be exported using the Qlik NPrinting web console or APIs. Templates can then be imported into Qlik Cloud.
Qlik Sense February 2024 is supported.
Jira issue ID: OP-95934
Qlik Sense November 2023 is supported.
Jira issue ID: OP-95900
Qlik NPrinting Messaging service (RabbitMQ) is upgraded to the 3.12 track.
Jira issue ID: QB-24179
The Qlik NPrinting Repository service version of PostgreSQL is upgraded to 13.13. This addresses PostgreSQL CVE-2023-5869.
Jira issue ID: OP-95960
The list of time zones is updated to IANA 2023d.
Jira issue ID: QB-21902
Rendering reports with sheets from huge Qlik Sense apps failed intermittently when a customizable timeout setting was not correctly applied.
Jira issue ID: OP-95938
Producing PowerPoint reports sometimes raised the error: “The value cannot be null. Parameter name: key”.
Jira issue ID: OP-95964
Improved handling of cross-origin resource by enhancing URL validation.
The following issues and limitations were identified at release time. The list is not comprehensive; it lists all known major issues and limitations. We expect to have these issues fixed in future versions.
The following languages are supported:
Other languages are not officially supported. There may be issues with other languages, particularly those with right-to-left script and non-Roman alphabets.
Qlik Sense custom size sheets are not supported. Custom size will not be maintained on export.
Alternate states
QlikView and Qlik Sense alternate states are not supported.
QlikView and Qlik Sense alternate states are not supported.
Jira issue ID: OP-6196
Qlik NPrinting Server, Engine, and Designer can only be installed on C: drives. Any attempt to install them on a different drive will result in task failures.
Jira issue ID: OP-5831
When you add the same object twice, using the Images node in Qlik NPrinting Designer, only the image size property of the first image is respected.
It is possible to select the “Enable” check box in On-Demand for reports using Qlik Sense app data. These reports are visible in the QlikView On-Demand menu of the QlikView On-Demand add-on. But if selected, they will not generate reports, and you will see an error message.
If you experience random crashes when using Qlik NPrinting Designer, open your Windows Display Settings in the Control Panel and verify that Smaller – 100% (default) is selected. When settings of 125% or 150% are selected, Qlik NPrinting Designer may crash.
Jira issue ID: OP-5908
In some cases, when you use Qlik NPrinting On-Demand in Internet Explorer 11 or Edge, the “origin” HTTP header is not generated. This results in the error message “REVEL_CSRF: tokens mismatch”.
The workaround is to install Qlik NPrinting On-Demand on a Microsoft IIS server hosting QlikView Access point or use a different web browser.
Jira issue ID: OP-4940
Qlik NPrinting Designer may be unable to open a report template if there are too many filters associated with a connection in the report's app. The following error message displays: “A task was canceled”.
This typically happens when more than 4000 filters are using fields from a connection. Sometimes, higher numbers can work. For example, 7000 filters have worked in some situations.
The workaround is:
1. Split the Qlik NPrinting app into separate apps.
2. Split the connections (possibly by using multiple connections to the same documents in different apps).
3. Split the filters across apps (so that the filter count per app is lower).
Jira issue ID: OP-4839
Some Qlik NPrinting tasks fail with the error message: “Exceeded maximum number of retries”. This is due to a performance issue in QlikView that appears when it exports large unfiltered files to Excel.
Jira issue ID: OP-5278
In some rare circumstances, pressing the Verify connection button will cause the screen to freeze on the “Initializing…” status and the spinning wheel cursor. This happens when a Qlik NPrinting Engine goes offline and Verify connection is pressed before the Qlik NPrinting Scheduler is aware that it is offline. It can take up to 20 seconds before the Qlik NPrinting Scheduler determines the offline status of a Qlik NPrinting Engine.
Jira issue ID: OP-5914
When you:
The filters associated with each user are not uploaded, or displayed, for performance reasons. Waiting for all filters for thousands of users to import would take a long time. In most cases, importing this information is unnecessary, because filters created for users often contain something like the user IDs. You can change this behavior and make all filters visible by uncommenting the line <!--<add key="include-user-filters" />--> in the webengine.config file.
To make a specific filter visible in the lists, remove its association to all users, or create a new filter with the same fields and values not linked to any user.
Jira issue ID: OP-3986
The rollback that follows a Qlik NPrinting Server or Engine upgrade cancellation may corrupt the related Qlik NPrinting installation. A rollback is triggered by errors or by clicking the cancel button during the upgrade execution. After a corruption caused by a rollback, services may be uninstalled or cannot be started.
To restore a Qlik NPrinting Server to its original status:
You should always create a backup before starting an update. In any case, a backup is automatically created in the folder "%ProgramData%\NPrinting" at the beginning of the upgrade process. To restore a Qlik NPrinting Engine to original status:
Jira issue ID: OP-7560
Add title functionality is not supported on Qlik Sense objects with Assistance mode enabled. The workaround to restore the Add title functionality is to disable Assistance mode for the chart in Qlik Sense. Then reload the metadata of the connection.
Jira issue ID: OP-7568
Qlik Sense objects made in Assistance mode cannot be used as tables, columns, or cells in Qlik NPrinting. To restore them, disable Assistance mode on the chart in Qlik Sense; then reload the metadata of the connection. Furthermore, if a Qlik Sense object made with Assistance mode is exported as a table, column, or cell using Qlik NPrinting APIs, the request will fail.
Jira issue ID: OP-7165
Open Type Fonts (*.otf) are not supported in PixelPerfect templates. Generated reports will use a different font, and not look as expected.
Jira issue ID: OP-7747
The following functionalities are not supported for Qlik Sense tables that have a "Show column if" condition set on one or more of their columns: levels, single column export, and keep source formats.
Jira issue ID: OP-8382
Qlik Sense On-Demand reports with selections applied on calculated dimensions will fail. However, you can apply selections on dimensions based on Qlik Sense fields. The workaround is to move the formula to the load script and use the calculated fields to apply selections to your On-Demand reports.
Jira issue ID: OP-8985
Due to the internal way of exporting Qlik Sense histograms, you cannot add them to the Qlik NPrinting Designer Tables node. If you add a Qlik Sense histogram to the Tables node, you will not receive any errors or warning messages, but the exported data will be wrong.
Jira issue ID: OP-8921
QlikEntity reports support Qlik Sense objects with the following limitations:
Jira issue ID: OP-9087
You cannot embed an Excel worksheet in a PowerPoint report template. This will cause a Qlik NPrinting Designer crash. The workarounds are to insert the Excel worksheet without using the Qlik NPrinting Designer:
Jira issue ID: OP-9067
Dynamic views is a new Qlik Sense feature starting from June 2020.
If you connect Qlik NPrinting to a Qlik Sense app that contains a chart used to generate dynamic views, the chart and the containing sheet are excluded from the Qlik NPrinting connection cache and cannot be used in reports.
You can connect Qlik NPrinting to a Qlik Sense app containing dynamic views. However, after a dynamic view refresh, the connection will stop working.
Jira issue ID: OP-9628
Starting from November 2020, RabbitMQ Server (deployed as Qlik NPrinting Messaging Service) has been updated to version 3.8.3. It has an internal limit, not configurable, about messages size of 512MB. Previous limit was 2GB. As consequence, is not possible to generate Qlik NPrinting reports bigger than 512MB.
Jira issue ID: OP-9766
Excel worksheet print areas can contain more than one range if the generation of the report does not expand the print area. If it expands, you will see an error: “Invalid Cell Name”. For example, the default setting of the Expand Range option in a Qlik NPrinting table causes the print area to change during report production, and an error is received.
Jira issue ID: OP-9518
Using Cyrillic characters in the Search form of the Qlik NPrinting user interface is case sensitive.
Jira issue ID: OP-9995
The percentage “%” format is not kept in Excel reports when using QlikView 12.50 (12.50.20000) or newer due to a QlikView issue. You can solve this by upgrading to QlikView May 2021 SR2 (12.60.20200) or newer.
Jira issue ID: OP-95599
If you start a Run Verification on a connection to a QlikView document in QVF format, Qlik NPrinting cannot confirm whether the QlikView Desktop version installed locally on each Qlik NPrinting Engine is compatible with QVF file format. The check mark next to "QlikView can open the document" may be green, even if a version of QlikView that does not support QVF is installed. This is because verification only checks file permissions. If the installed QlikView Desktop does not support QVF format, metadata generation will fail.
Jira issue ID: OP-95682
QlikView objects with many different fields with exactly the same label are not supported. Duplicated labels cause an exception during the connection cache generation. To solve this issue, ensure that each field has a unique label.
Jira issue ID: OP-95797
Images linked by using URLs in Qlik Sense tables are exported as text. This affects only Qlik Sense connections. A workaround exists for PixelPerfect templates.
To upgrade to Qlik NPrinting February 2024 IR, you must start from one of the following versions:
If you have a version of Qlik NPrinting older than April 2018, you must upgrade to Qlik NPrinting April 2018 before you can upgrade to Qlik NPrinting February 2024 IR.
If you have a version of Qlik NPrinting older than 17.3, you must first upgrade to Qlik NPrinting 17.3. Then you
must upgrade to a version from April 2018 to May 2021 SR4 before you can upgrade to Qlik NPrinting May
2023 SR3.
If you are upgrading from a version older than February 2018, all metadata caches (QlikView and Qlik Sense) will be marked as "not generated". This is due to a breaking change in the format of the metadata cache. All connection caches must be regenerated before you can edit a template or create a new connection.
You must back up your data before you proceed. Data can become damaged if a problem occurs during the
upgrade. If data is damaged, a backup is required to restore the repository. See: Backup and restore of a repository.
After backup, you must follow the instructions for upgrading on the help site page Qlik NPrinting upgrade.
If you are upgrading to February 2024 IR from September 2018 SR2 or older you must:
• Open port 4997 outbound on Qlik NPrinting Server and inbound on all Qlik NPrinting Engines.
• Reinstall all your Qlik NPrinting Engines and provide a password for certificate exchange.
• Open the Engine manager in the Web Console.
• Open the detail page for each Engine and send the certificate after inserting the same password you used during the engine’s reinstallation.
Qlik NPrinting Engines stay offline until the certificate exchange is performed. Older Engine versions cannot connect to a Qlik NPrinting February 2024 IR Server.
Setups are available at https://community.qlik.com/t5/Downloads/tkb-p/Downloads
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.
Table of Contents
Learn about new features and improvements in Qlik Cloud.
The following Release Notes cover resolved defects for Qlik Cloud. Solved issues and limitations for Qlik Cloud Services are also listed.
QB-24576
|
Visualizations: Brand logo is not adjusted to size in apps |
Fixed a problem causing wide logos to overflow on the top bar in apps. The lack of constraint has been fixed and logos will not block other UI elements. |
QB-22767
|
Qlik Cloud Alerting Services: Updated wording for snooze notification options |
We have updated the wording of the snooze notification options for data alerts. |
QB-24567
|
Qlik Application Automation: Input block not working |
The checkboxes shown in the Automation History during the automation's run were unresponsive if an input block was included in an automation with input type "Multi Select". This has now been fixed. |
QB-24662 |
Qlik Cloud: QlikView apps not opening via new search input field |
Fixed a problem that prevented QlikView apps from opening when searched for via the new search input field. |
QB-22814
|
Qlik Cloud: Content Security Policy (CSP) hostnames containing a digit on 3rd level domain throw an error |
The CSP component did not allow for the 3rd level of a domain name to be a number. Entering a domain name with a number would result in an error. This has been fixed and the 3rd level domain name in CSP can be a number. |
QB-24370
|
Checkbox not disabled after removing role in Edit roles table |
The checkboxes for assigning roles in the Edit Roles table in the Management Console now accurately reflect role assignments. |
QB-24019
|
Restored toggles for assigning roles to Full Users |
For Qlik Cloud capacity-based licenses, the Settings pane in the Management Console now includes toggles for assigning Shared Space Creator, Private Analytics Content Creator, and Data Services Contributor roles to Full Users. |
QB-23298
|
Qlik Sense Visualizations: Abbreviation of dimension labels are too short |
Fixed a problem where GetObjectMeasures() did not work when used in a calculated dimension with aggr() method. |
QB-24225
|
Qlik Cloud Alerting: Ambiguous error message when upload of recipients fails |
Added more descriptive error messages when recipients and group adding operations fail for reasons such as commas included in recipient name or email addresses; no recipients in source data; missing tags in source data; or too many rows in source data. |
QB-24559
|
Qlik Cloud Alerting: Changing alert ownership throws error |
When trying to change an alert that belonged to a deleted user, the ownership change would fail with a "Failed to change alert ownership" error message. This has been fixed and the new owner can access the alert in the Hub. |
QB-24825
|
Qlik Cloud Reporting: Reload error when uploading distribution list |
Fixed a problem where uploading new recipients and groups for reporting would fail. |
QB-24430
|
Qlik Data Prep: Uploaded data not converted to date format automatically |
Fixed a problem where the Data manager did not provide the correct date format in the script for auto concat scenario. |
QB-24624
|
Qlik Sense Visualizations: Wrong scroll position |
Fixes an issue in the combo chart where the initial scroll position could be incorrect when combined with selection sheet actions. |
QB-24944
|
Visualizations: Qlik.Resize() not working in mashups |
Fixed a problem where Qlik.Resize() was not working in mashups. Chart rendering on resize is now triggered when the chart starts with zero size. |
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.
Table of Contents
The following release notes cover the version of Qlik Web Connectors released in January 2024. For questions or comments, post in the Product Forums or contact Qlik Support.
The following updates have been made to the Qlik Web Connectors Core and Web UI as well as the connectors listed.
Core Engine
Qlik Azure Storage Connector
Qlik Facebook Insights Connector
Qlik FTP/SFTP Connector
Qlik Google Ad Manager Connector
Qlik Google Ads Connector
Qlik MailChimp Connector V2
Qlik Mailbox IMAP Connector
Qlik SMTP Connector
Qlik SugarCRM Connector
When upgrading connectors to the latest APIs, unfortunately the changes can be so extensive that we are unable to modify the existing connector. When this happens we will create a new version of the connector and put the existing one into a ‘Deprecated’ state. This means that at some point in the future it will no longer be available and after entering the deprecated status, it will no longer be updated. The date is normally determined by the underlying API which will often have its own expiry date, after which the connector using it will no longer work.
You can see connectors affected under the Deprecated tab in Qlik Web Connectors. One connector is noted as deprecated in this release:
One connector is removed in this release, after being noted as deprecated since previous release:
IP v6 addresses are not supported when you enter an IP v6 address for the purpose of white listing.
Load Balancing is not supported.
Qlik Web Connectors requires .NET Framework 4.8.
Download this release from the Product Downloads page on Qlik Community. The new Qlik Web Connectors release package is available under the Value Added tab.
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.
Table of Contents
Learn about new features and improvements in Qlik Cloud.
The following Release Notes cover resolved defects for Qlik Cloud. Solved issues and limitations for Qlik Cloud Services are also listed.
QB-24223 |
GeoAnalytics: Heatmap is not displaying all values |
For some values, the default label font size of 13px would cause the value to be too large to fit in the chart. The value has now been set at 12px. |
QB-23908
|
Qlik Engine: Apps reconnecting with error message |
In rare cases, upgrading a build tool could cause the response to the client to be malformed and the connection would be closed. The app would then reconnect the error message "Could not decode a text frame as UTF-8" would be shown. This has now been fixed. |
QB-23840
|
Qlik Cloud Visualizations: Source Table view shows data from different column |
Fixed a problem where Source Table viewer was showing data from different columns in large tables with one or more hidden fields. |
QB-23121
|
Qlik Application Automation: Unable to create a file on Amazon S3 |
A bug in the "Write Line to File" block caused the standard encoding to be UTF-8, even when otherwise specified. This has now been resolved, and other encoding options such as Shift JIS can now be specified as a block input. |
QB-23254
|
Qlik Cloud: Export to Excel does not keep number format
|
Fixed a problem where the cell format was changed from general/number to custom format when exporting to Excel. |
QB-22903
|
Visualizations: Master items are editable in containers |
Fixed authorization for Master Items in Containers. Adding master items to a container no longer allows users without the correct permissions to edit them. |
QB-23851
|
Visualizations: Straight Table percentage option for width cannot be selected |
Fixed a problem where the percentage width setting was unavailable. |
QB-20929
|
Direct Access gateway: Failure of reload script queries over 500,000 characters |
When connecting to data sources via Direct Access gateway, reload scripts with queries exceeding 500,000 characters would fail. A limitation that reload scripts queries cannot exceed 500,000 characters was added to the help. |
QB-23497
|
Master measure formatting was not applied in Insight Advisor charts |
Resolved an issue where changes were not applied in Insight Advisor charts when master item settings were changed. |
QB-24219
|
Visualizations: Added show condition for measures to new pivot table |
Fixed an issue where the show condition for measures was missing in certain cases. All measures now have an input field in the property panel for the "Show column if" option. |
QB-23576
|
Vizualisations: Enhanced tooltip positioning |
Resolved an issue where tooltips extended beyond the frame when the chart size was set to "small." |
QB-22648
|
Alerting: Analyzer users could not evaluate history-condition based data alerts |
Resolved an issue that prevented users with analyzer entitlement from evaluating data alerts based on history conditions. Before this fix, data alerts with history conditions would fail to evaluate if owned by a user with analyzer entitlement. |
QB-24209
|
Qlik Engine: Fixed Out of Memory problem in Lineage when saving apps |
Engine will no longer face out-of-memory termination issues during saving. |
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.
Table of Contents
The following release notes cover the versions of Qlik NPrinting released in May 2023 Service Release 3.
Jira issue ID: OP-95900
Qlik NPrinting Messaging service (RabbitMQ) is upgraded to the 3.12 tack.
Jira issue ID: OP-95937
Using a section break within a level raised the exception: “System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values” when producing the reports in both case preview in Designer and in a publish task. Note that section break is different than page break.
Jira issue ID: OP-95932
The select multiple items flag in Excel pivot table filters checked in templates was not kept in generated reports. Generated reports had only one item filtered and displayed instead of all.
Jira issue ID: QB-21902
Rendering reports with sheets from huge Qlik Sense apps could fail intermittently because a customizable timeout setting was not correctly applied.
Jira issue ID: OP-95820
If all columns of a level in an Excel template were hidden and there were no other objects outside the report generation failed.
Jira issue ID: QB-22744
Third party extensions tables added as column tags in an order different than the original had wrong data in the generated reports. Keeps Source Format setting was also not respected.
Note: some third-party extension return incorrect background color information when keep source format is applied, resulting in a unintended black background. Removing keep source format restores the previous appearance. We recommend that keep source format is removed from third party extensions before upgrading.
Jira issue ID: OP-95943
Drag and drop of entity tags that begins with some HTML words like "Html", "Body", "Table", "Head", "Script" or "Frameset", in there original or customized name, did not work in Excel templates. Starting from this version an underscore “_” will be automatically added at the beginning of those tags to solve.
Jira issue ID: OP-95942
Excel worksheet names with Pages tags and fixed text were incorrect in the generated reports. The issue affected only May 2023 SR2.
The following issues and limitations were identified at release time. The list is not comprehensive; it lists all known major issues and limitations. We expect to have these issues fixed in future versions.
The following languages are supported:
Other languages are not officially supported. There may be issues with other languages, particularly those with right-to-left script and non-Roman alphabets.
Qlik Sense custom size sheets are not supported. Custom size will not be maintained on export.
Alternate states
QlikView and Qlik Sense alternate states are not supported.
QlikView and Qlik Sense alternate states are not supported.
Jira issue ID: OP-6196
Qlik NPrinting Server, Engine, and Designer can only be installed on C: drives. Any attempt to install them on a different drive will result in task failures.
Jira issue ID: OP-5831
When you add the same object twice, using the Images node in Qlik NPrinting Designer, only the image size property of the first image is respected.
It is possible to select the “Enable” check box in On-Demand for reports using Qlik Sense app data. These reports are visible in the QlikView On-Demand menu of the QlikView On-Demand add-on. But if selected, they will not generate reports, and you will see an error message.
If you experience random crashes when using Qlik NPrinting Designer, open your Windows Display Settings in the Control Panel and verify that Smaller – 100% (default) is selected. When settings of 125% or 150% are selected, Qlik NPrinting Designer may crash.
Jira issue ID: OP-5908
In some cases, when you use Qlik NPrinting On-Demand in Internet Explorer 11 or Edge, the “origin” HTTP header is not generated. This results in the error message “REVEL_CSRF: tokens mismatch”.
The workaround is to install Qlik NPrinting On-Demand on a Microsoft IIS server hosting QlikView Access point or use a different web browser.
Jira issue ID: OP-4940
Qlik NPrinting Designer may be unable to open a report template if there are too many filters associated with a connection in the report's app. The following error message displays: “A task was canceled”.
This typically happens when more than 4000 filters are using fields from a connection. Sometimes, higher numbers can work. For example, 7000 filters have worked in some situations.
The workaround is:
1. Split the Qlik NPrinting app into separate apps.
2. Split the connections (possibly by using multiple connections to the same documents in different apps).
3. Split the filters across apps (so that the filter count per app is lower).
Jira issue ID: OP-4839
Some Qlik NPrinting tasks fail with the error message: “Exceeded maximum number of retries”. This is due to a performance issue in QlikView that appears when it exports large unfiltered files to Excel.
Jira issue ID: OP-5278
In some rare circumstances, pressing the Verify connection button will cause the screen to freeze on the “Initializing…” status and the spinning wheel cursor. This happens when a Qlik NPrinting Engine goes offline and Verify connection is pressed before the Qlik NPrinting Scheduler is aware that it is offline. It can take up to 20 seconds before the Qlik NPrinting Scheduler determines the offline status of a Qlik NPrinting Engine.
Jira issue ID: OP-5914
When you:
The filters associated with each user are not uploaded, or displayed, for performance reasons. Waiting for all filters for thousands of users to import would take a long time. In most cases, importing this information is unnecessary, because filters created for users often contain something like the user IDs. You can change this behavior and make all filters visible by uncommenting the line <!--<add key="include-user-filters" />--> in the webengine.config file.
To make a specific filter visible in the lists, remove its association to all users, or create a new filter with the same fields and values not linked to any user.
Jira issue ID: OP-3986
The rollback that follows a Qlik NPrinting Server or Engine upgrade cancellation may corrupt the related Qlik NPrinting installation. A rollback is triggered by errors or by clicking the cancel button during the upgrade execution. After a corruption caused by a rollback, services may be uninstalled or cannot be started.
To restore a Qlik NPrinting Server to its original status:
You should always create a backup before starting an update. In any case, a backup is automatically created in the folder "%ProgramData%\NPrinting" at the beginning of the upgrade process. To restore a Qlik NPrinting Engine to original status:
Jira issue ID: OP-7560
Add title functionality is not supported on Qlik Sense objects with Assistance mode enabled. The workaround to restore the Add title functionality is to disable Assistance mode for the chart in Qlik Sense. Then reload the metadata of the connection.
Jira issue ID: OP-7568
Qlik Sense objects made in Assistance mode cannot be used as tables, columns, or cells in Qlik NPrinting. To restore them, disable Assistance mode on the chart in Qlik Sense; then reload the metadata of the connection. Furthermore, if a Qlik Sense object made with Assistance mode is exported as a table, column, or cell using Qlik NPrinting APIs, the request will fail.
Jira issue ID: OP-7165
Open Type Fonts (*.otf) are not supported in PixelPerfect templates. Generated reports will use a different font, and not look as expected.
Jira issue ID: OP-7747
The following functionalities are not supported for Qlik Sense tables that have a "Show column if" condition set on one or more of their columns: levels, single column export, and keep source formats.
Jira issue ID: OP-8382
Qlik Sense On-Demand reports with selections applied on calculated dimensions will fail. However, you can apply selections on dimensions based on Qlik Sense fields. The workaround is to move the formula to the load script and use the calculated fields to apply selections to your On-Demand reports.
Jira issue ID: OP-8985
Due to the internal way of exporting Qlik Sense histograms, you cannot add them to the Qlik NPrinting Designer Tables node. If you add a Qlik Sense histogram to the Tables node, you will not receive any errors or warning messages, but the exported data will be wrong.
Jira issue ID: OP-8921
QlikEntity reports support Qlik Sense objects with the following limitations:
Jira issue ID: OP-9087
You cannot embed an Excel worksheet in a PowerPoint report template. This will cause a Qlik NPrinting Designer crash. The workarounds are to insert the Excel worksheet without using the Qlik NPrinting Designer:
Jira issue ID: OP-9067
Dynamic views is a new Qlik Sense feature starting from June 2020.
If you connect Qlik NPrinting to a Qlik Sense app that contains a chart used to generate dynamic views, the chart and the containing sheet are excluded from the Qlik NPrinting connection cache and cannot be used in reports.
You can connect Qlik NPrinting to a Qlik Sense app containing dynamic views. However, after a dynamic view refresh, the connection will stop working.
Jira issue ID: OP-9628
Starting from November 2020, RabbitMQ Server (deployed as Qlik NPrinting Messaging Service) has been updated to version 3.8.3. It has an internal limit, not configurable, about messages size of 512MB. Previous limit was 2GB. As consequence, is not possible to generate Qlik NPrinting reports bigger than 512MB.
Jira issue ID: OP-9766
Excel worksheet print areas can contain more than one range if the generation of the report does not expand the print area. If it expands, you will see an error: “Invalid Cell Name”. For example, the default setting of the Expand Range option in a Qlik NPrinting table causes the print area to change during report production, and an error is received.
Jira issue ID: OP-9518
Using Cyrillic characters in the Search form of the Qlik NPrinting user interface is case sensitive.
Jira issue ID: OP-9995
The percentage “%” format is not kept in Excel reports when using QlikView 12.50 (12.50.20000) or newer due to a QlikView issue. You can solve this by upgrading to QlikView May 2021 SR2 (12.60.20200) or newer.
Jira issue ID: OP-95599
If you start a Run Verification on a connection to a QlikView document in QVF format, Qlik NPrinting cannot confirm whether the QlikView Desktop version installed locally on each Qlik NPrinting Engine is compatible with QVF file format. The check mark next to "QlikView can open the document" may be green, even if a version of QlikView that does not support QVF is installed. This is because verification only checks file permissions. If the installed QlikView Desktop does not support QVF format, metadata generation will fail.
Jira issue ID: OP-95682
QlikView objects with many different fields with exactly the same label are not supported. Duplicated labels cause an exception during the connection cache generation. To solve this issue, ensure that each field has a unique label.
Jira issue ID: OP-95797
Images linked by using URLs in Qlik Sense tables are exported as text. This affects only Qlik Sense connections. A workaround exists for PixelPerfect templates.
To upgrade to Qlik NPrinting May 2023 SR3, you must start from one of the following versions:
If you have a version of Qlik NPrinting older than April 2018, you must upgrade to Qlik NPrinting April 2018 before you can upgrade to Qlik NPrinting May 2023 SR3.
If you have a version of Qlik NPrinting older than 17.3, you must first upgrade to Qlik NPrinting 17.3. Then you
must upgrade to a version from April 2018 to May 2021 SR4 before you can upgrade to Qlik NPrinting May
2023 SR3.
If you are upgrading from a version older than February 2018, all metadata caches (QlikView and Qlik Sense) will be marked as "not generated". This is due to a breaking change in the format of the metadata cache. All connection caches must be regenerated before you can edit a template or create a new connection.
You must back up your data before you proceed. Data can become damaged if a problem occurs during the
upgrade. If data is damaged, a backup is required to restore the repository. See: Backup and restore of a
repository.
After backup, you must follow the instructions for upgrading on the help site page Qlik NPrinting upgrade.
If you are upgrading to May 2023 SR3 from September 2018 SR2 or older you must:
• Open port 4997 outbound on Qlik NPrinting Server and inbound on all Qlik NPrinting Engines.
• Reinstall all your Qlik NPrinting Engines and provide a password for certificate exchange.
• Open the Engine manager in the Web Console.
• Open the detail page for each Engine and send the certificate after inserting the same password you used during the engine’s reinstallation.
Qlik NPrinting Engines stay offline until the certificate exchange is performed. Older Engine versions cannot connect to a Qlik NPrinting May 2023 SR3 Server.
Setups are available at https://community.qlik.com/t5/Downloads/tkb-p/Downloads
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.
Table of Contents
Learn about new features and improvements in Qlik Cloud.
The following Release Notes cover resolved defects for Qlik Cloud. Solved issues and limitations for Qlik Cloud Services are also listed.
QB-23189 |
QQlik AutoML: Empty cells displayed as NaN when viewing distinct field values
|
Empty cells from uploaded data files (such as CSV or XLS) will now be interpreted as “null” instead of being displayed as NaN (not a number). This change makes profiling data files more consistent with profiling relational database tables and eases the detection of sparsely populated columns in files.
|
QB-23078
|
Qlik Cloud: Amharic language symbols shown as boxes on PDF export |
Amharic language symbols were not rendered on export to PDF report and boxes were visible instead. This has been fixed and the language symbols are correctly rendered when exporting to PDF reports. |
QB-22524
|
Occasional failure of application reloads performed via Direct Access gateway |
Qlik Cloud resource scaling would sometimes result in a DirectAccess-1006 error. An enhancement was made to improve handling of certain Qlik Cloud resource scaling scenarios that occur during application reloads performed via Direct Access gateway. |
QB-22817
|
Visualizations: Color by expression not working in bar/line charts |
Fixed a problem where color by expression was not applied correctly in some bar and line charts if it was combined with conditionally hidden measures. |
QB-23329
|
Visualizations: Scroll option missing in Link to Sheet selection. |
Fixed an error that caused some CSS to not load properly, resulting in the missing scrolling function |
QB-23393
|
Qlik Engine: Parquet file not read correctly |
Parquet files were incorrectly ready, producing incorrect data output. This was fixed by supporting decimal types stored as fixed-length byte arrays. |
QB-22663
|
Reporting: Short and long weekday names are not correctly exported to Excel |
Fixed by extending reporting-service to handle day names on Excel export. |
QB-22750
|
Visualizations: Copy and paste of cell value fails in iFrame |
Copying to clipboard is blocked within iFrames and needs to be specifically allowed on the iFrame properties. Due to the deprecation of execCommand in the browser API, Qlik now uses the never clipboard API. This is however blocked by default in iframes, unless you explicitly allow it. To allow, add: |
QB-23280
|
Qlik Engine: Attribute flag does not affect cardinality of a Pivot table |
Fixed a problem where an attribute with a SET statement with the attribute flag set to "false", was not expanding the whole cube to include the SET. |
QB-21531
|
Qlik Cloud Identity Management: Unable to log in when using Bring your own IDP
|
When moving from Qlik IDP to your identity provider, any users with expired invites would be denied access to Qlik Cloud, despite being members in your IDP. Qlik Cloud now ignores expired invites when using your IDP (invited users are only applicable when using Qlik's built-in IDP). |
QB-21508
|
Qlik Cloud Identity Management: SalesForce IDP when Enhanced Domains does not work |
Fixed a problem where Qlik Cloud would incorrectly use the old identity provider discovery address when attempting to change the address and validate the changes. It is now possible to enable Enhanced Domains with SalesForce. |
QB-23577
|
Qlik Engine: AlwaysOneSelected property lost during reload
|
Fixed a problem where the "AlwaysOneSelected" property was lost during reload if the app was opened without data and the field content had changed. |
QB-23580
|
Visualizations: Grid chart not allowing filtering on Y-axis dimension |
Fixed a problem where gird charts did not render correctly if the current selection did not generate any data. |
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 Alerting – July 2023 Service Release 1
Table of Contents
This release includes mainly library upgrades, addressing security vulnerabilities and a fix in reporting.
Compatibility with related products
As in Qlik Alerting July 2023 IR, for SR1 too, recommended version of Qlik Sense Enterprise on Windows is May 2023 or later.
For a detailed and updated list of supported mobile operating systems, devices, and compatibility with Qlik Sense Enterprise, please refer to Qlik Sense system requirements and supported browsers on help.qlik.com.
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.
Table of Contents
The following release notes cover the versions of Qlik Sense Enterprise on Windows released in November 2023.
For questions or comments, post in the Product Forums or contact Qlik Support.
Please refer to the What’s new sections of the online help for information about the new and updated features of the Qlik Sense Enterprise on Windows November 2023 release:
What's new in Qlik Sense November 2023 (Users)
What's new in Qlik Sense November 2023 (Developers)
What's new in Qlik Sense November 2023 (Administrators)
Key | Title | Description |
QB-24350 | Qlik Sense Visualizations: No longer possible to select several areas of the map at the same time | Clicking on one element of a slightly off-screen map would focus on the selection and confirmed it directly. This has been fixed and the map allows multiple selections. |
QB-24577 | Qlik Sense Visualizations: Treemap chart color doesn't apply defined custom theme after upgrade | After upgrading to QS May 2023 patch 9, the custom theme was not applied to the treemap. This has been solved, and in cases where the color scheme does not exist, it will fall back to default. |
QB-24944 | Visualizations: Qlik.Resize() not working in mashups | Fixed a problem where Qlik.Resize() was not working in mashups. Chart rendering on resize is now triggered when the chart starts with zero size. |
QB-24625 | Qlik Sense Engine: Access to hidden values possible through Set Analysis on dimension | Fixed a problem where the Section Access value subset was not correctly applied to fields-on-the-fly based on a single key field. This resulted in all key values being visible on the field on the fly, even if Section Access restricted the source key field. |
Key | Title | Description |
QB-24368 | Qlik Sense: Content libraries do not recognize virtual proxy prefix | Fixed a problem where it was not possible to load content library items if a virtual proxy was used. |
QB-24440 | Qlik Sense: EngineHealth function in QMC stops working when TimeZone is UTC | Fixed a problem where the engine timestamp did not include a timezone offset, presenting only a "Z" instead of the expected "+0000", leading to a failure in converting the timestamp into a readable format. This update addresses a critical issue where the EngineHealth function would cease to operate correctly when the system TimeZone was set to UTC. We have enhanced the functionality within the QMC to ensure robust and accurate parsing of date-time strings across various time zone formats. |
QB-22171 | REST Connector: Slow when importing large files | We have made performance improvements of file import with the REST connector for cases where a table contains a large number of columns. |
Key | Title | Description |
QB-23501 | Windows authentication pop-up appears when loading background images in charts | The issue has been resolved. The media library button in the property panel was not using the virtual proxy prefix when loading the images. |
QB-23717 | Visualizations: Clipboard API does not exist in non-secure context (HTTP) | Resolved and issue where write text to clipboard did not exist in nonsecure context (HTTP allowed). Now, a check ensures that the string is copied through a callback function whenever the clipboard API is unavailable. |
QB-22795 | 'Last modified by' is set to INTERNAL\bootstrap at app reload | The 'Modified by' column in QMC apps table is now set to INTERNAL\sa_repository after each app reload, reflecting the repository service updates to the app static byte size. This feature can be toggled on/off in the repository and QMC. |
QB-22966 | Qlik Connectors: Drill connector ODBC driver update | The ODBC driver for the Drill connector has been updated to a newer version that includes updates to third-party components. |
Key | Title | Description |
QB-22795 | Reading Parquet from S3 | Added a fix to read parquet files from S3 |
QB-23790 | Qlik Sense Engine: Windows script functionality | Window and WRank script functionality was originally available only on Qlik Cloud. With this fix, the script function is now available for Qlik Sense Enterprise on Windows. |
Key | Title | Description |
QB-23280 | Qlik Engine: Attribute flag does not affect cardinality of a Pivot table | Fixed a problem where an attribute with a SET statement with the attribute flag set to "false", was not expanding the whole cube to include the SET. |
QB-23049 | Qlik Sense Visualizations: Unable to export to image or PDF when using URL rewrite in Reverse Proxy | Exporting Image/PDF didn't work using a Reverse Proxy prefix if a Virtual Proxy Prefix was not provided in the QMC. This fix removes the need to set up a Virtual Proxy in the QMC and instead uses the configurations of the Reverse Proxy to call the correct path to the printing service. |
Key | Title | Description |
QB-21103 | Qlik Engine: Variable definitions are unexpectedly changing during an interactive reload | If a variable was created as an app object (not in script) and a user changed the value of the variable within their session, for example by using the variable input control in the Qlik Sense user interface, and the user then reloaded the app in the same session, the definition of the variable would change to the value in the user's session. This scenario would typically occur during app development, since it requires user-triggered interactive reload, with the same user working in the app, in the same session. This fix ensures that the definition of a variable is always maintained unless it is explicitly changed by an app designer or in a load script. The in-session value of the variable is independently controlled. |
QB-22968 | Qlik Sense: External call to fonts.googleapis.com | The font Qlik Sense loads when the application starts is now loaded from Qlik Sense's own web resources. This means that external calls are no longer made. |
QB-22161 | Qlik Sense Hub: Blank space appears in the Hub when app menu is opened | Fixed an issue where a blank space was displayed at the bottom of the screen in the Hub when the app menu was opened using right-click. |
QB-22497 | Qlik Sense Visualizations: Hyperlink in table not working on Qlik Sense August 2022 IR | Fixed a problem where opening a URL from a table would cause the link to have a port attached to the URL. This went against the browser's origin restriction, meaning the iframe didn't show. This was solved by adding a "noopener" to the opening of the link. |
QB-22217 | Qlik Sense on Windows: Bad request error when connecting to websocket for some formats of headers | This issue affected Qlik Sense on Windows August 2023 Patch 2. A "400 Bad request" error was thrown when connecting to websocket if multiple comma-separated valid headers were entered without entering a whitespace after the comma. This has been fixed and header values are now allowed without whitespaces. |
QB-22155 | Qlik Sense: Fail to open Data Load Editor in new tab | The routing was redirecting to a non-existent HMTL file, causing the failure to open the Data Load Editor in a new tab. This fix corrects the routing. |
QB-22849 | Qlik Sense: Dashboard variable input has inconsistent behavior | Fixed a problem where the variable input from the dashboard bundle added an extra option to the dropdown. This extra option was confusing and has now been removed from the dropdown options. A new hidden option has been added that will allow selection of any option in the dropdown when these do not match the current value of the variable. |
Key |
Title |
Description |
QB-17864 |
Visualizations: NPrinting reports do not keep original theme background |
NPrinting theme with cards was showing a white background. This has been solved and the background is grey with a border visible around the cards. |
QB-19282 |
Front-end validation and Regular Expression enhancement for 'Custom filter' in 'Custom' schedule of a trigger |
Implemented front-end validation for 'Custom filter' in 'Custom' schedule of a trigger to avoid invalid data submission. Also added regular expression checks to ensure the correct format of the custom filter input, including minute, hour, weekdayPrefix, weekday, weeklyInterval, day of month, month, and monthly interval. Users can see real-time feedback on the validity of their input in custom filters, reducing the occurrence of scheduling errors. |
QB-19290 |
Fixed err,or related to "Multiple files not allowed" |
User can now upload new file with same name or different name and connection will be updated based on content on new file. |
QB-19335 |
Visualizations: Accessible headings |
Sheet title is now marked as Header <h1>, and the title and subtitles of the objects on the sheet are marked as <h2> and <h3>, respectively. |
QB-19432 |
Qlik Sense Visualizations: Sheet image and sheet title are not accessibility compliant |
Sheet image and sheet title were not accessible by tab and the image did not have any descriptive text. This has been fixed and both the sheet title and sheet image can be accessed by tabbing and the logo has descriptive text. |
QB-19433 |
Hide button label to allow for accessibility |
It is now possible to hide a Button object label while keeping a label text, which leaves the label text as a screen reader-only label for the button. |
QB-19571 |
Enterprise Connectors: Unexpected behavior in the data preview for the Oracle connector (ODBC connector package) |
Fixed a problem where the data preview did not show all the available tables in the select dialog for the Oracle connector. |
QB-19712 |
Visualizations: "Indent rows" not working on pivot table when Hebrew is added |
When the app was in RTL mode, the text in the pivot table would not properly align with the "indent row" options enabled. This has been fixed and text alignment is now correctly handled. |
QB-19860 |
Visualizations: Issue with label contrast |
Introduced a new setting for automatically adjusting labels inside bars to get a better contrast. |
QB-19896 |
Qlik Sense Hub: Visible blank space in the Hub when app menu is opened |
Fixed an issue that displayed a blank space at the bottom of the screen in the Hub when the app menu was opened using right-click. |
QB-19914 (linked to QB-22702) |
Qlik Sense Visualizations: Keyboard navigation to selections menu does not work |
It is now possible to use the keyboard navigation to access the selections menu when activating selections in the straight table. |
QB-19943 |
Visualizations: Background images not always showing in exports |
There has been a delay when loading a button's background image when preparing to be reported via reporting causing the image to not be exported in some cases. The time gap is now adjusted so the button's background image is loaded before being downloaded as an image or PDF. |
QB-19992 |
Visualizations: Difficult to see navigation arrows |
It was difficult to see the quick navigation arrows on an app sheet if the background was dark. The arrows now have a light color on dark backgrounds. |
QB-20005 |
Visualizations: Value labels not visible in Waterfall charts with dark colors |
Value labels are now visible if a dark color is used in Waterfall charts. When you use a dark color, the value label color will change to make them visible. |
QB-20064 |
Visualizations: Scroll hint indicator incorrectly displayed |
Fixed an issue where scrollable charts showed the scroll hint indicator even when further scrolling was not possible. |
QB-20138 |
Confirm selection |
Confirm ongoing selection in a chart by clicking outside of the chart would freeze the chart. |
QB-20282 |
Visualizations: Straight table search option not showing listbox |
Fixed a problem where the listbox for searching and selecting was not opening when clicking on the search option in the header menu. |
QB-20292 |
Generating ODAG app and publish to stream |
Generating ODAG apps and publishing them to a stream didn't work for any user IDs with spaces in them. This is now resolved. |
QB-20321 |
Alternative dimensions and measures |
Improved accessibility of alternative dimensions and measures. |
QB-20326 |
Use connection name for "Select data from source" in Data Manager |
For "Select data from source" we need to look up by connection name to be more consistent with Data Load Editor. After an upgrade, the connection ID no longer matched which caused issues trying to add the data from source in Data Manager. |
QB-20478 |
Prevent flickering scrollbar and item displacement when dragging sheet or story items |
When the container with sheets or stories was close to overflowing, the scrollbar was flickering. On browsers rendering a thick scrollbar, this sometimes lead to a displacement of subsequent items. This has been fixed through a CSS style change of the containers and should now work as expected. |
QB-20521 |
Qlik Sense Operations Monitor: Incorrect master dimensions |
The Operations Monitor app was displaying the "Incomplete visualization" error due to inexistent dimensions. Three master dimensions have now been removed as these did not exist in the data model. |
QB-20549 |
Qlik Enterprise Connectors: Amazon Athena returns incorrect value when using useBulkReader |
When using useBulkReader an incorrect value for $file_modified_time was returned. This has been fixed and now the correct value is shown. |
QB-20586 |
Border option in Container |
The Border option for Container objects did not work after the February 2023 release. This is now fixed. |
QB-20587 |
Qlik Sense Engine: The engine crashes when merging tables in the load script |
Fixed a problem where the engine would crash when merging tables in the load script by resizing the ColGenerationCounters array to avoid access violation exceptions. |
QB-20591 |
Prevent duplicate expression in master dimension |
It used to be possible to add duplicate expressions in a master dimension. |
QB-20614 |
Storing data containing null values into parquet file created a faulty file |
Storing data that contained null values into a parquet file created a file that when loaded would throw an error: "Cannot open file: 'Failed to read column' (: Malformed levels. min: 0 max: 254 out of range)". Null values will now be handled correctly when storing data into parquet files. |
QB-20783 |
Buttons with fixed layout |
It is now possible to place a space between icon and text in buttons with fixed layout. |
QB-20802 |
Qlik Engine: Telemetry logging does not work with 2 GB ErrorPeakMemory or more |
Engine setting size for ErrorPeakMemory and WarningPeakMemory were upgraded from Int32 to Int64. |
QB-20824 |
Straight table Select All function issue |
The inline listbox in table header cells would not work for master dimensions. |
QB-20860 |
Qlik Sense: Analyzer capacity minutes not consumed as expected |
Fixed the way Analyzer capacity minutes are consumed. The minutes are consumed per user session. |
QB-20866 |
Bookmark set expressions are not working as expected |
Fixed issues with bookmark set expression: |
QB-20885 |
Scheduler failure with a trigger with incorrect filter in one of the scheduled tasks |
Scheduler failed to execute all scheduled tasks due to the presence of a trigger with an incorrect filter in one of the scheduled tasks. This issue is fixed by identifying the trigger with an incorrect filter, disabling it, and removing it from the scheduler's memory to avoid future executions of the task. With this fix, other tasks will continue running as per their schedule. |
QB-20910 |
Visualizations: Changed position of selection toolbar in table |
We moved the selection toolbar from the top-right corner of the table to the column where the user makes the selections. |
QB-21015 |
Variable input extension |
Variable input extension was reverted to the previous version to fix unintended changed behavior. |
QB-21045 |
Geoanalytics: Tooltip is stuck to a fixed position when scrolling the page |
The tooltip in a geo-mapchart would get stuck when hovering over a data point and then quickly moving the cursor outside the geo-mapchart. This has now been fixed. |
QB-21051 |
Straight table in alternate state |
Straight table, available in the Visualization bundle, is now respecting alternate states when making selections through the listbox in the header. |
QB-21095 |
Visualizations: Tooltip information not visible when the cell is extended in size |
When the screen area is fully covered, the tooltip information will not default to the top and instead will be shown in the center of the object. |
QB-21109 |
Visualizations: Thumbnail of sheet was cut off on Sheets menu |
Fixed an issue where sheets and bookmarks were not completely visible in the navigation popover viewed from a sheet. |
QB-21110 |
Visualizations: Title and image not properly aligned on sheet |
Fixed an issue where the sheet title was styled as header h1 wich changed the the CSS styling. Correct CSS classes have been implemented and the title and image are now aligned as expected. |
QB-21153 |
Qlik Engine: Issues with pivot table introduced in early 2022 |
When a pivot table has both Left and Top dimensions, rows would disappear (wrongly suppressed) when group sums were 0 or null. A fix was applied to not suppress group sums that resulted in 0 or null when dimensions in a pivot table are placed on top. |
QB-21206 |
Combo chart issue |
Fixed an issue where combo chart did not show bar value labels for null values. |
QB-21242 |
ODAG crashing or getting stuck when canceling an app reload |
When canceling an ongoing ODAG link reload, the ODAG service would crash or in some cases the reload would get stuck in canceling state for a long time. |
QB-21263 |
Qlik Sense: Updated Node.js |
Updated Node.js. For more information, see https://nodejs.org/en/blog/vulnerability/august-2023-security-releases |
QB-21270 |
Qlik Sense Insight Advisor: Not working on externally hosted mashup |
|
QB-21358 |
Visualizations: Date column is exported as numbers in Excel |
When downloading the data by selecting "table formatting", the date column is exported as numbers in Excel. This has been fixed so Excel exports now support formatting for timestamp fields. |
QB-21429 |
Qlik Sense Engine: Data load from CSV picks up extra values |
Fixed a problem that caused a whitespace (space or tab) after a delimiter to disable MSQ interpretation on Qlik Sense Enterprise on Windows. |
QB-21437 |
Qlik Sense: Improved HTTP Request validation |
Implemented additional validation logic when processing HTTP Request body. |
QB-21469 |
Qlik Sense: NL Insights not honoring virtual prefix |
When logging in using a virtual proxy with a prefix, NL Insights was not working. This has been fixed and it is now possible to use the NL Insights extension while using a virtual proxy with a prefix. |
QB-21497 |
Qlik Sense Enterprise Connectors: PosgreSQL connector cuts off strings |
The Qlik Sense PosgreSQL connector now supports loading strings containing more than 255 characters. |
QB-21539 |
Insight Advisor: Issue when using Custom analysis with 2 dimensions and 2-3 measures |
Resolved an issue where charts were not displayed as expected when using Custom analysis on a pivot table with two dimensions and two to three measures. |
QB-21549 |
Qlik Sense: The Hub does not redirect if a stream with no access is directly accessed |
Fixed a problem that caused endless loading of streams of links with no access instead of redirecting to the first visible stream or My work area. |
QB-21561 |
Qlik Sense: Proxy web cache poisoning |
Implemented additional validation to prevent poisoning of the Proxy web cache in Qlik Sense Enterprise for Windows. |
QB-21642 |
Qlik Sense: Hub stuck in loading state when F5 key is used while in "Search" mode |
When using "Search" mode in the Hub, if a user pressed the F5 key to refresh the page, the Hub would not properly reload and would get stuck in a loading state. This has now been fixed. |
QB-21662 |
Visualizations: Data point errors when converting from line chart to combo chart |
After converting a line chart to a combo chart, the chart applied line chart-specific measure styling which caused some of the data points to become enlarged and unable to be adjusted. This issue has been fixed. |
QB-21676 |
QlikView: Access-Control header contains a wildcard |
The Access-Control-Allow-Origin header for QlikView Converter contained a wildcard. This has now been fixed. |
QB-21683 |
Qlik Sense: Improved validation of Transfer-Encoding Headers |
Added additional validation to the Qlik Proxy to ensure only valid Transfer-Encoding headers are passed on. |
QB-21730 |
Qlik Cloud Engine: Degradation in the DefaultMissingAggr wrapping |
Fixed an issue in the DefaultMissingAggr wrapping and IsConstant has been changed to apply only in the InPeriod implementation. |
QB-21731 |
Qlik Sense: Added validation to X-Qlik-* HTTP headers |
Additional validation performed by the Qlik Proxy to ensure only valid X-Qlik-* HTTP headers are passed through. |
QB-21792 |
Qlik Sense Visualizations: Unusable search functionality on mobile devices |
Fixed a problem that caused users to be trapped inside an expanded list box on iOS. This was solved by adjusting the positioning of the pop-over on the list box on mobile devices, and resetting the browser zoom after the pop-over opens. |
QB-21812 |
Qlik Sense Visualizations: Cross-site mashups not fetching JavaScript resources |
Fixed a problem that prevented mashups hosted on a different domain than the Qlik Sense Enterprise installation from fetching JavaScript resources from the servers, even though users were logged in and cookies had been set. Resource requests now add credentials when it is required. |
QB-21839 |
Qlik Sense Visualizations: Dragging dimension to pivot table fails when disabled dimensions exist |
Fixed a problem that prevented moving pivot table dimensions past hidden dimensions. Previously, moving past a hidden dimension from left tree to top tree would not move the dimension and instead, it would move one of the hidden dimensions. |
QB-21856 |
Qlik Sense: Straight chart exploration feature is missing |
Fixed an issue where the straight table had no chart exploration feature. |
QB-21908 |
Duplicated tick labels on scatterplot charts |
Fixed duplicated tick labels on a scatterplot chart axis due to formatting. |
QB-21918 |
Qlik Sense Visualizations: Scale of line and combo chart is sometimes incorrect |
Fixed an issue that caused the scale of the line and combo chart to sometimes be incorrect when the minimum and maximum values were close to each other. |
QB-22000 |
Data load editor: Data model viewer preview not showing table comments |
Fixed an issue where table comments added via the "comment table" statement in the data load editor were not visible in the Data model viewer. |
QB-22050 |
Insight Advisor: Data value lookup does not work with master dimension |
This fix includes master items in the data value search. |
QB-22125 |
Qlik Sense Visualizations: Selection bar not shown in Container when "Position: fixed" |
Fixed an error that prevented the selection bar from showing when "Position: Fixed" was set for a container in a Mashup. This affected Sense May 2023. |
QB-22238 |
Qlik Sense Engine: Quoting style not used in header calculations |
Fixed a problem where MSQ Quoting Style was not correctly working with CSV delimited files. |
QB-22334 |
Qlik Sense Enterprise on Windows: Import of apps larger than 2 GB fails |
Due to recent security fixes, the upload functionality stopped working for files larger than 2 GB. This has now been corrected without compromising on security. |
QB-22346 |
Visualizations: Filter pane disables view of dimension item on far right of the filter pane object |
Fixed an issue that would hide a column item when rendering multiple columns and the Filter pane height was small. |
QB-22702 (linked to QB-19914) |
Qlik Sense Visualizations: Cannot search in listbox |
Fixed a problem where searching in listbox was not possible. The new release has the correct behavior. |
QB-22833 |
Mashups: Mashups cannot load correctly if require.js is loaded with jquery |
Loading require.js using a method other than a script tag, would cause the mashup to not load correctly. This has been fixed so the "isMashup" check works properly in all situations. |
SHEND-1154 |
Qlik Sense: Installed components on the server are displayed |
The lists of Qlik Sense components (with versions) and third-party software components (without version) have been moved from the About dialog in the Hub to the Qlik Management Console (QMC). Versions of Qlik Sense components have also been removed from the product-info.json file. |
SHEND-1293 |
Qlik Sense: .NET core update |
Updated .NET core 3.1 to .NET 6 LTS for app-distribution-service, hybrid-deployment-service, dotnet-core-service-utils, and qdc-catalog-service. |
SHEND-1368 |
Qlik Sense: Generic error message for invalid licenses |
Licenses can be invalid for a number of reasons. We have improved the description in the error message for invalid licenses so users can take appropriate action where necessary. |
SHEND-1390 |
Qlik Sense: Update to custom banners |
Updated custom banner messages to support hyperlinks. |
ODCB-1237 |
Qlik Sense: Unauthorized Access to "QDC Catalog Service Configuration" API |
A non-admin, unauthorized user (such as an analyst) could directly access the API used to populate the "QDC Catalog Service Configuration" management console user interface after login to the Qlik Sense Hub. This is the user interface used to configure the Qlik Sense to Qlik Catalog integration. If the integration had been configured, the saved information, including credentials, was returned to the unauthorized user. |
The following issues and limitations were identified at release time. The list is not comprehensive but lists all known major issues and limitations.
For information about the requirements for Qlik Sense, see System requirements for Qlik Sense in the online help.
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.
Table of Contents
Learn about new features and improvements in Qlik Cloud.
The following Release Notes cover resolved defects for Qlik Cloud. Solved issues and limitations for Qlik Cloud Services are also listed.
QB-18819
|
Using the qualify and unqualify statement when having a "*" in combination with letters creates irregular behavior in the qualification of fields in the lineage graph generation. |
Using the qualify and unqualify statement when having a "*" in combination with letters creates irregular behavior in the qualification of fields in the lineage graph generation. This appeared through the source of the edge linking to the default node 0. This is now fixed. |
QB-19665 |
Qlik Engine: Impact analysis fails with "Internal Error" |
Fixed a problem where lineage was not rendered due to a mismatch between the table and the field level in the lineage graph out from the Qlik Engine. This occurred when multiple stores to the same file are done with different sources. The issue was solved by using the last iteration of the stored nodes. With this, lineage graph generation confusion is reduced and there is no mismatch between levels. |
QB-22841 |
Reporting: Sheet title font setting ignored |
When exporting a sheet as a PDF, the title was not rendered correctly. This issue has now been solved and sheet title settings are observed. |
QB-22062 |
Qlik Cloud: Wrong script version is used during data loading |
The wrong version of the script was sometimes used If an app is reloaded shortly after the script is updated via API. This has been fixed by checking the server script version before loading the data in the Data Load Editor. If the script on the server is newer, the user will be notified and asked if they want to refresh and use the newest script. |
QB-22658
|
Qlik Sense Reporting: Cannot display Chinese characters in sheet title of subscribed report |
Chinese characters were not rendered properly in the sheet title of PDF report subscriptions. This fix adds the correct font in the title HTML fragment. |
QB-22781 |
Qlik Engine: DROP TABLE not freeing memory |
Fixed a problem where the DROP TABLE command was not freeing memory by updating the request's memory usage information when the command is executed. |
QB-21217 |
Direct Access gateway: Resolved debug failure in Data Load Editor (DLE) |
When debugging the code in the Data Load Editor (DLE) with the Limit Results option enabled, the debug would fail with the following error: Connector error: Invalid load request (DirectAccess-1006) |
QB-21238
|
Qlik Data Gateway - Direct Access: Vague error message when naming a Gateway |
The Gateway name validation error message has been updated to be more accurate. It now states the specific characters that cannot be used in a name. |
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.
Table of Contents
Learn about new features and improvements in Qlik Compose.
This section describes the issues that you may encounter when upgrading/migrating to the new version.
Direct upgrade is supported from Compose May 2022 only. Customers upgrading from earlier Compose versions need to first upgrade to Compose May 2022 and then to Compose November 2023.
Compose for Data Warehouses has been superseded by Qlik Compose. Existing Compose for Data Warehouses customers can upgrade to Qlik Compose as described below.
Note: For information on the procedure for upgrading from Compose for Data Warehouses to Compose February 2021, see the Qlik Compose February 2021 release notes
Customers upgrading from Compose for Data Warehouses 6.5 or 6.6:
Customers upgrading from Compose for Data Warehouses 6.3 or 6.4:
Customers upgrading from Compose for Data Warehouses 3.1 should contact Qlik Support.
For information on upgrading from Compose for Data Lakes, see Migrating from Compose for Data Lakes below.
Existing Compose for Data Warehouses customers who want to create and manage Data Warehouse projects only in Qlik Compose can use their existing license. Similarly, existing Compose for Data Lakes customers who want to create and manage Data Lake projects only in Qlik Compose can use their existing license.
Customers migrating from Qlik Compose for Data Warehouses or Qlik Compose for Data Lakes, and who want to create and manage both Data Warehouse projects and Data Lakes projects in Qlik Compose, will need to obtain a new license. Customers upgrading from Compose February 2021 can continue using their existing license.
It should be noted that the license is enforced only when trying to generate, run, or schedule a task (via the UI or API ). Other operations such as Test Connection may also fail if you do not have an appropriate license.
Compose for Data Lakes has been superseded by Qlik Compose. Existing Compose for Data Lakes customers can migrate their projects from Qlik Compose for Data Lakes to Qlik Compose. You can migrate both your project definitions and your data although the latter is only required if you need to migrate production data.
For migration instructions, see the Qlik Compose August 2021 Release notes.
Note: Migration can be performed from Compose for Data Lakes 6.6 only.
Qlik Replicate is required for landing data into the data warehouse or storage while Qlik Enterprise Manager allows you to monitor and control Compose tasks running on different servers. This section lists the supported versions for each of these products.
Compose November 2023 Initial Release is compatible with the following Replicate and Enterprise Manager versions:
The following versions are now supported:
The following versions are no longer supported:
Jira issue: RECOB-7474
Salesforce case: 103547
Type: Issue
Component/Process: Data Marts, ETL Statements
Description: Under very special conditions (a child table having multiple relationships to parent table P1 and having multiple relationships to parent table P2), the generated ETL for handling dimensions would be incorrect.
Jira issue: RECOB-7777
Salesforce case: 118205
Type: Issue
Component/Process: CDC, Azure Synapse Analytics and SQL Server
Description: When capturing changes from NVARCHAR columns, the CDC task would fail when the Windows environment variable "qlk__UseSatelliteRIS" was set to "1".
Jira issue: RECOB-7766
Salesforce case: 115292
Type: Issue
Component/Process: UI Monitor - Performance
Description: The monitor window would sometimes take a long time to load because old tasks entries were not purged from the repository.
Jira issue: RECOB-7692
Salesforce case: 119959
Type: Issue
Component/Process: Data Marts
Description: When a column was accessible by different join paths involving self-joins, ETL generation would fail with a "Duplicate columns detected" error.
Jira issue: RECOB-7707
Salesforce case: 118694
Type: Issue
Component/Process: Data Marts, Amazon Redshift
Description: Data mart validation would sometimes fail with the following error: "Attribute used in expression for fact_shipment does not exist in the model".
Jira issue: RECOB-7705
Salesforce case: 120120
Type: Issue
Component/Process: Data Marts, Amazon Redshift
Description: Linked dimensions to the fact table would not be displayed in the UI.
Jira issue: RECOB-7672
Salesforce case: 114913
Type: Issue
Component/Process: BigQuery Target
Description: In certain scenarios, the list of data warehouse tables would not be not shown when clicking Display.
Jira issue: RECOB-7728
Salesforce case: 118138
Type: Issue
Component/Process: ETL Statements
Description: When the the Consolidate uniform sources option was enabled, records would sometimes be missing from incremental loads.
To apply the fix, you must regenerate the data warehouse tasks.
Jira issue: RECOB-7727
Salesforce case: 121509
Type: Issue
Component/Process: ETL Statements
Description: ETL generation would fail when the the Consolidate uniform sources option was enabled and the entity name was different from the table name in the landing.
Jira issue: RECOB-7674
Salesforce case: 118869
Type: Issue
Component/Process: Data Marts, ETL Statements
Description: Data would sometimes be missing from the data mart when dimensions were not linked to the fact table.
Jira issue: RECOB-7621
Salesforce case: 113192
Type: Issue
Component/Process: Cloudera Data Platform (CDP)
Description: A hive subquery syntax error would sometimes be encountered when generating views in GEN2.
Jira issue: RECOB-7536
Salesforce case: 108912
Type: Issue
Component/Process: ETL Statements
Description: The RUNNO_UPDATE column would sometimes not be updated, which would lead to missing information in the data marts.
Jira issue: RECOB-7540
Salesforce case: 108352
Type: Issue
Component/Process: Data Marts, ETL Statements
Description: After a data warehouse update, records would be deleted in the data mart dimension table instead of being marked as obsolete.
Jira issue: RECOB-7567
Salesforce case: 107411
Type: Issue
Component/Process: Data Marts
Description: The data mart fact table would sometimes not be updated after a data warehouse update.
Jira issue: RECOB-7587
Salesforce case: 111691
Type: Issue
Component/Process: ETL Statements
Description: Compose would mistakenly insert a RUNNO_UPDATE = 0 row when encountering an early-arriving fact.
Jira issue: RECOB-7601
Salesforce case: 111708
Type: Issue
Component/Process: ETL Statements
Description: Latest data from the change tracking landing table would not be reflected in a data warehouse with a partially mapped Type1 table.
Jira issue: RECOB-7511
Salesforce case: 105946
Type: Issue
Component/Process: Data Marts, ETL Statements
Description: Re-running a failed data mart task would insert duplicate rows into the dimension tables.
Jira issue: RECOB-7570
Salesforce case: 109123
Type: Issue
Component/Process: Oracle Target
Description: Data Quality rules would sometimes generate a statement with the wrong database name.
Jira issue: RECOB-7450
Salesforce case: 101661
Type: Issue
Component/Process: Data Marts, ETL Statements, Azure Synapse Analytics
Description: Using very complex Transactional Fact definitions in a Synapse environment would sometimes cause the following error:
SQL Statement Nested to deeply
Jira issue: RECOB-7612
Salesforce case: 114071
Type: Issue
Component/Process: ETL Statements, Oracle
Description: When the alias name "S" was defined in parentheses and then then used outside the parentheses, the following error would occur:
'ORA-00904: "S"."PROVENIENZA": invalid identifier.
Jira issue: RECOB-7527
Salesforce case: 107814
Type: Issue
Component/Process: Data Marts
Description: Data mart tasks would use the data mart schema defined in the default connection settings, even when a different schema was defined in the data mart settings.
Jira issue: RECOB-7229
Salesforce case: 79491
Type: Issue
Component/Process: UI Designer
Description: The following error would sometimes occur when editing a task's ETL SQL:
REPO-I0ITOLVER, Current item (PL_Party_assigned_....) is an older version of stored item in this repository.
Jira issue: RECOB-7401
Salesforce case: 99326
Type: Issue
Component/Process: Data Marts
Description: In rare cases, dropping a dimension would result in repository corruption.
Jira issue: RECOB-6622
Salesforce case: 55889
Type: Issue
Component/Process: Adjust (CMPS) - Data Lakes Projects
Description: Enabling the "Save History" option for a table in the model would sometimes generate an incorrect Adjust script.
Jira issue: RECOB-7223
Salesforce case: 81724
Type: Issue
Component/Process: Error Handling - Data Lake Projects
Description: In rare scenarios, the server log would report a "WaitForActiveTasksToFinish" error while the agent log would state "reported state done, exit value 23". The actual task log would be created empty.
Jira issue: RECOB-7485
Salesforce case: 82981
Type: Issue
Component/Process: Task Commands
Description: Backdating CDC tasks would not update the RUNNO_UPDATE value properly.
Jira issue: RECOB-7493
Salesforce case: 105049
Type: Issue
Component/Process: Data Marts, UI Monitor
Description: Inserted rows for data marts tasks would not be visible in the monitor.
Jira issue: RECOB-7518
Salesforce case: 107411
Type: Issue
Component/Process: Data Marts
Description: In rare scenarios, changes to data warehouse satellite tables would not be propagated to the data mart.
Jira issue: RECOB-7402
Salesforce case: 99326
Type: Issue
Component/Process: Data Marts
Description: A "Could not drop constraint" error would sometimes occur when deleting a dimension.
Jira issue: RECOB-7363
Salesforce case: 92519
Type: Issue
Component/Process: Data Marts
Description: The ETL generated for state-oriented fact tables when the environment setting 'qlk__UseClassicETLForStOrFact' was set to TRUE did not handle the OIDs for DATE and TIME dimensions.
Jira issue: RECOB-7258
Salesforce case: 89872
Type: Issue
Component/Process: UI
Description: Searching the mappings would not work as expected.
Jira issue: RECOB-7312, RECOB-7341
Salesforce case: 92519
Type: Issue
Component/Process: ETL Statements, Data Marts
Description: After upgrade, state oriented fact tables date/time OIDs would not show -1 when the date/time was not available in the date dimension.
Jira issue: RECOB-7301, RECOB-7341
Salesforce case: 90926
Type: Issue
Component/Process: Data Marts
Description: Incremental loading of dimensions would not complete as expected as the ETL query ignored changes to root level HUB and SAT tables and sometimes ignored SAT tables entirely.
Jira issue: RECOB-7026
Salesforce case: 80978
Type: Issue
Component/Process: Data Marts
Description: Data mart tasks where referencing dimensions are referring to parent dimensions that were populated with the 'Full Rebuild' option would fail with the following error:
The task was aborted as the referenced dimension 'Employees_change_Parent_DataMart' is not up-to-date. Run 'Parent_DataMart' first, and when it completes, run this task again.
Jira issue: RECOB-7264
Salesforce case: 89745
Type: Issue
Component/Process: Cloudera Data Platform (CDP)
Description: An incompatibility with Impala was discovered when using the INT function.
Jira issue: RECOB-6597
Salesforce case: 67977
Type: Issue
Component/Process: Microsoft Azure Synapse Analytics Data Warehouse
Description: Full Load of billions of records into the data warehouse would fail with the following error: "Could not allocate tempdb space while transferring data from one distribution to another"
Loading of satellite tables has been optimized so the error no longer occurs.
Jira issue: RECOB-6643
Salesforce case: 69594
Type: Issue
Component/Process: ETL Statements
Description: When using the Data Quality rule and adding a column to the source, the data warehouse would be adjusted accordingly and the new column would be added to the data warehouse table, but Compose would not generate the new column in "Compose Error Mart" in the Task Statement.
Other enhancements:
Jira issue: RECOB-7217
Salesforce case: 87288
Type: Issue
Component/Process: Import from ERWin
Description: The following error would sometimes occur when importing an ERwin model: "Object reference not set to an instance of an object".
Jira issue: RECOB-7195
Salesforce case: 85992
Type: Issue
Component/Process: CLI Import - Data Marts
Description: The Compose CLI import_csv command would fail when importing Custom ETLs.
Jira issue: RECOB-7200
Salesforce case: 86479
Type: Issue
Component/Process: Task Settings
Description: Changing the task recovery settings had no effect.
Jira issue: RECOB-7105
Salesforce case: N/A
Type: Issue
Component/Process: Security - RBAC
Description: A user with Viewer role was able to perform the CloseProjectParams operation, which should require Designer role.
Jira issue: RECOB-7292
Salesforce case: 85074
Type: Issue
Component/Process: Security
Description: Due to known security vulnerability, C:\Program Files\Qlik\Compose\java\snowflake-jdbc-3.13.14 was replaced with snowflake-jdbc-3.13.33.
See https://nvd.nist.gov/vuln/detail/CVE-2023-30535 for more details.
Jira issue: RECOB-5286
Salesforce case: 69716
Type: Issue
Component/Process: Security
Description: Due to known security vulnerability, C:\Program Files\Qlik\Compose\java\external\gson-2.8.5.jar was replaced with gson-2.8.9.jar.
See https://www.whitesourcesoftware.com/vulnerability-database/WS-2021-0419 for more details.
Jira issue: RECOB-5289
Salesforce case: 69716
Type: Issue
Component/Process: Security
Description: Due to known security vulnerability, C:\Program Files\Qlik\Compose\java\external\jackson-databind-2.12.3.jar was replaced with jackson-databind-2.15.0.jar.
See https://security.snyk.io/vuln/SNYK-JAVA-COMFASTERXMLJACKSONCORE-2421244 for more details.
Jira issue: RECOB-7193
Salesforce case: 85074
Type: Issue
Component/Process: Security
Description: JQuery JS versions with vulnerabilities remained in the Compose installation folder instead of only the latest version.
Jira issue: RECOB-6985
Salesforce case: 76987
Type: Issue
Component/Process: CLI
Description: The command to reset the watermarks table would not work.
Jira issue: RECOB-7124
Salesforce case: N/A
Type: Issue
Component/Process: Data marts
Description: For dimensions with satellites containing only foreign keys, changes to the foreign keys would not be captured.
Jira issue: RECOB-7123
Salesforce case: 83371
Type: Issue
Component/Process: Databricks on Azure
Description: It would not be possible to create column names with special characters and spaces.
Jira issue: RECOB-7072
Salesforce case: 82981
Type: Issue
Component/Process: Data Marts, ETL Statements, Performance
Description: Data Mart queries for building Type 2 dimensions would take a long time to complete in Snowflake. After installing this patch, you need to re-generate the task ETLs.
To revert to the previous behavior, set the environmental variable "qlk__PreselectT2DimIDs" to 'false' or '0'.
Jira issue: RECOB-6774
Salesforce case: 73478
Type: Issue
Component/Process: Data Marts, ETL Statements, Performance
Description: During incremental loading, the ETL for loading Type 2 dimensions would fetch all rows from the hub and satellite tables instead of only the updated rows. After installing this patch, you need to re-generate the task ETLs.
To revert to the previous behavior, set the environmental variable "qlk__PreselectT2DimIDs" to 'false' or '0'.
Jira issue: RECOB-6994
Salesforce case: 80785
Type: Issue
Component/Process: Data Marts - Snowflake
Description: When different databases were defined for the landing and the data warehouse, the 'Evaluate Expression' would be performed on the wrong database.
Jira issue: RECOB-7025
Salesforce case: 81154
Type: Issue
Component/Process: ETL Statements
Description: Evaluated values would be truncated to type of UNSIGNED INTEGER, resulting in negative results in the event of an overflow. This has been fixed to use type LONG instead.
Jira issue: RECOB-7103
Salesforce case: 84139
Type: Issue
Component/Process: Data mart adjust
Description: Adding a referenced Type 2 dimension to a star schema would result in incorrect adjustment. The fix drops and recreates the data mart instead of adjusting it.
Jira issue: RECOB-7108
Salesforce case: 84140
Type: Issue
Component/Process: CLI
Description: The "ComposeCli.exe generate_tasks" command would not generate a specific data mart task.
Jira issue: RECOB-7086
Salesforce case: 83519
Type: Issue
Component/Process: Data Marts
Description: The following error would occur during ETL generation of data marts with reference-dimensions:
Object reference not set
Jira issue: RECOB-6845
Salesforce case: 76209
Type: Issue
Component/Process: Data Marts
Description: Generating the data mart task would sometimes fail with the following error:
SYS,GENERAL_EXCEPTION,Sequence contains no elements
When validating a data mart, the following error would sometimes occur:
Failed to Find dimension. Fact/dimension <fact name> object include wrong Path property
This error occured when the fact definition contained an OID-column pointing to non-existing dimensions. The issue was resolved by automatically dropping the OID-columns from the fact table in such situations. However, users need to review the "non-existing" dimensions and remove if necessary.
Jira issue: RECOB-7024
Salesforce case: 81584
Type: Issue
Component/Process: Data Marts
Description: An error sometimes occurred when generating the data mart task.
Jira issue: RECOB-6755
Salesforce case: 73291
Type: Issue
Component/Process: Data Marts
Description: Deleting a referenced dimension would sometimes result in an error.
Jira issue: RECOB-7016
Salesforce case: 80287
Type: Issue
Component/Process: Data warehouse ask generation
Description: Generating the data warehouse CDC task would sometimes fail with the following error:
SYS,GENERAL_EXCEPTION,Sequence contains no elements
Jira issue: RECOB-7048
Salesforce case: N/A
Type: Enhancement
Component/Process: Performance
Description: Added an option to improve performance of History and Live History views, but without filtering out potential duplicates. This improvement is controlled using an environment variable.
Jira issue: RECOB-7002
Salesforce case: 80613
Type: issue
Component/Process: Permissions
Description: Compose would not allow users with the Designer role to associate a Replicate task or choose a task from a Replicate server.
Jira issue: RECOB-7021
Salesforce case: 81149
Type: Issue
Component/Process: ETL statements, Data marts
Description: The generated data mart task statements would sometimes contain runtime clauses with unbalanced brackets.
Jira issue: RECOB-6962
Salesforce case: 76585
Type: Issue
Component/Process: Update Statistics on Microsoft Azure Synapse Analytics
Description: The following 'Update Statistics' issues have been resolved:
1) When the system variable 'qlk__UpdateStatisticsPercentageDma' was set to 0, a runtime error would occur.
2) For Hub and Transactional fact tables, statistics were not updated.
Jira issue: RECOB-6973
Salesforce case: 80395
Type: Issue
Component/Process: Data mart ETL statements on Microsoft Azure Synapse Analytics and Microsoft SQL Server
Description: Loading State-Oriented fact tables would take an excessively long time when numerous dimensions were involved. The issue was resolved by using an temporary table that stores intermediate results. In certain environments the fix might not have the desired effect. In this case, you can revert to the previous method of loading State-Oriented fact tables by setting the environmental variable 'qlk__UseClassicETLForStOrFact' to '1' or 'true'. After setting the environment variable, you need to restart the Qlik Compose service.
Jira issue: RECOB-6968
Salesforce case: 80259
Type: Issue
Component/Process: Cli
Description: When long CLI commands were run by non-admin users, the following error would sometimes occur:
Failed to send a ping message, SYS-E-HTTPFAIL, SYS-E-AUTHERR, Unauthorized Request. request: Ping.
Jira issue: RECOB-6876
Salesforce case: 70246
Type: Issue
Component/Process: Security
Description: Parsing of expressions and input attribute references would not work for non-admin users that had admin permissions on a specific project.
Jira issue: RECOB-6903
Salesforce case: N/A
Type: Issue
Component/Process: Model validations
Description: It would not be possible to use Change Table views in a mapping when Keep changes was turned on in the landing task settings.
Jira issue: RECOB-6916
Salesforce case: N/A
Type: issue
Component/Process: Project deployment
Description: When deploying a project for the first time (which means the data warehouse connection was configured without password), and the Create DDL scripts only option was enabled in the project settings, an "object reference not set" error would occur when creating tables.
Jira issue: RECOB-6917
Salesforce case: N/A
Type: issue
Component/Process: Discovery and mapping
Description: Discovering from a source would create two duplicate mappings per entity, instead of only one mapping as it should have.
Jira issue: RECOB-6858
Salesforce case: 76867
Type: Issue
Component/Process: Data mart validation
Description: Resolves the following issues:
Jira issue: RECOB-6828
Salesforce case: 76586
Type: Issue
Component/Process: Compose CLI
Description: The CLI would generate an incorrect statement for adding statistics to aggregated fact tables.
Jira issue: RECOB-6734
Salesforce case: 72085
Type: Issue
Component/Process: Data Mart Validation
Description: In rare scenarios, validating a data mart would mistakenly cause columns with names ending in 'OID' to be dropped.
Jira issue: RECOB-6746
Salesforce case: N/A
Type: Issue
Component/Process: Azure Synapse Analytics - Project Deployment
Description: Deploying an Azure Synapse Analytics project would take an excessive amount of time.
Jira issue: RECOB-6570
Salesforce case: 66314
Type: Issue
Component/Process: Consolidation
Description: When using the Consolidate uniform sources option with archiving enabled, Compose would generate an invalid SQL statement during the CDC ETL process.
Jira issue: RECOB-6687
Salesforce case: 67429
Type: Issue
Component/Process: Schema Evolution - Databricks
Description: Schema Evolution would adds a STRING column as a VARCHAR.
Jira issue: RECOB-6570
Salesforce case: 66314
Type: Issue
Component/Process: ETL Generation with Consolidation
Description: When the Consolidation uniform sources option is enabled, a check will now be done that prevents generating faulty ETL code when source tables/queries are missing. The check provides information so that users can resolve the issue on their own.
Jira issue: RECOB-6776
Salesforce case: 74070
Type: Issue
Component/Process: Upgrade - Snowflake
Description: After upgrading to Compose 2022.5, an error would occur on Snowflake when the connection string contained additional parameters.
Jira issue: RECOB-7071
Salesforce case: N/A
Type: Issue
Component/Process: Incremental load
Description: When performing incremental load of Type 2 data, records would sometimes be deleted on Microsoft Azure Synapse Analytics and Snowflake platforms.
Jira issue: RECOB-6639
Salesforce case: 69870
Type: Issue
Component/Process: Data Mart Generation
Description: The following error would sometimes be encountered when trying to generate a data mart:
GENERAL_EXCEPTION,Object reference not set to an instance of an object
Jira issue: RECOB-6630
Salesforce case: 69276
Type: Issue
Component/Process: Data Mart Tasks
Description: An "invalid column name" error would sometimes be encountered when running data mart tasks.
Jira issue: RECOB-6619
Salesforce case: 67621
Type: Issue
Component/Process: Data Mart Tasks
Description: When regenerating tasks, Compose would automatically adjust all facts tables by removing the Date dimension OID.
Jira issue: RECOB-6514
Salesforce case: 69682
Type: Issue
Component/Process: Data Marts
Description: The following error would sometimes occur in an Aggregated Star Schema with Date Dimension:
Column is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause
Jira issue: RECOB-6537
Salesforce case: 66261
Type: Issue
Component/Process: Data Marts Tasks
Description: The following error would sometimes occur when generating data mart tasks.
Sequence contains no elements
Jira issue: RECOB-6453 + RECOB-6481
Salesforce case: 63783 + 63736
Type: Issue
Component/Process: Data Marts Tasks
Description: The following error would sometimes occur when generating data mart tasks:
Value Cannot be Null
Jira issue: RECOB-6635
Salesforce case: 69134
Type: Issue
Component/Process: Data Marts Tasks
Description: An "Invalid identifier" error would sometimes occur when running data mart tasks:
Jira issue: RECOB-5606
Salesforce case: 42279
Type: Issue
Component/Process: Custom ETL
Description: When opening a Custom ETL, code with more than 11 lines would not load completely.
Jira issue: RECOB-6511
Salesforce case: 36345
Type: Issue
Component/Process: Compose Import Project Repository CLI
Description: When running the import_project_repository command, the following error would sometimes be encountered:
Data mart is not valid
Jira issue: RECOB-6527
Salesforce case: 65766
Type: Issue
Component/Process: Logging
Description: When a data mart task instance failed, the data mart log information would sometimes be inaccurate.
Jira issue: RECOB-6611
Salesforce case: 67579
Type: Issue
Component/Process: Compose Export Project CLI
Description: The --exclude_envar_values parameter would not work as expected.
Jira issue: RECOB-6674
Salesforce case: 70086
Type: Issue
Component/Process: Data Warehouse Generation
Description: Data warehouse ETL generation would fail when query-based mapping included custom environment variables.
Jira issue: RECOB-6691
Salesforce case: 71770
Type: Issue
Component/Process: Data Mart
Description: Expressions would be ignored when defined on existing fact table attributes.
Jira issue: RECOB-6433
Salesforce case: N/A
Type: Enhancement
Component/Process: Apache Impala views in Data Lakes projects
Description: The header__batch_modified column will now be cast as varchar(32) for the outbound Apache Impala views. To leverage this enhancement, you need to set an environment variable.
Jira issue: RECOB-6508
Salesforce case: 63304
Type: Issue
Component/Process: AWS glue in Data Lakes projects
Description: CDC tasks using AWS glue would sometimes fail with the following error:
expects to have a column name on a left side, but got 'substr"
Jira issue: RECOB-6568
Salesforce case: 54618
Type: Issue
Component/Process: Hive 3.1.3 in Data Lakes projects
Description: When using Hive 3.1.3, the following error would sometimes be encountered:
SemanticException Line 0:-1 Wrong arguments 'hdr__ts': Casting DATE/TIMESTAMP types to NUMERIC is prohibited
Jira issue: RECOB-6566
Salesforce case: N/A
Type: Issue
Component/Process: Upgrade from Compose for Data Lakes 6.6
Description: Upgrading from Compose for Data Lakes 6.6 would cause the column prefix to change from header to hdr. To leverage this fix, you need to set an environment variable.
Jira issue: RECOB-5343
Salesforce case: 35725
Type: Issue
Component/Process: Discovery
Description: It would not be possible to discover landing views.
Jira issue: RECOB-6072
Salesforce case: 54081
Type: Issue
Component/Process: Compose CLI
Description: The compare_csv CLI option would not work properly when project items contained line breaks.
Jira issue: RECOB-6268
Salesforce case: 59331
Type: Issue
Component/Process: Data Mart Generation
Description: The following error would sometimes occur when generating a data mart:
Multiple attributes (n = 2) use the same internal ID: 'DESCRIPTION', 'TEST_NAME'
Jira issue: RECOB-6282
Salesforce case: 58371
Type: Issue
Component/Process: Tasks
Description: When a project had two full load tasks reading from the same landing zone database, the CDC task would start from the default partition.
Jira issue: RECOB-5808
Salesforce case: 48291
Type: Issue
Component/Process: Data Mart (Fact) Performance
Description: Performance issues would be encountered when updating the fact table.
Jira issue: RECOB-6356
Salesforce case: 60650
Type: Issue
Component/Process: Data Mart Tasks
Description: Data mart loading would sometimes fail at the "Merging changes into dimension" stage.
Jira issue: RECOB-6410
Salesforce case: 62525
Type: Issue
Component/Process: Environment Variables - Data Warehouse Projects
Description: Applying a predefined variable using the CLI would result in an "Object reference not set to an instance of an object" error.
Jira issue: RECOB-6435
Salesforce case: N/A
Type: Issue
Component/Process: Data Mart Tasks
Description: When working with Microsoft Azure Synapse, it would not be possible to create a data mart in a non-default schema.
Jira issue: RECOB-5290
Salesforce case: N/A
Type: Issue
Component/Process: Security
Description: Updated the ojdbc component (ojdbc7-12.1.0.2) to the newest version, which fixes security vulnerability CVE-2016-3506.
Jira issue: RECOB-5285
Salesforce case: N/A
Type: Issue
Component/Process: Security
Description: Updated the PostgreSQL component (postgresql-42.2.25) to the newest version, which fixes security vulnerability CVE-2022-21724.
Jira issue: RECOB-6409
Salesforce case: N/A
Type: Issue
Component/Process: Microsoft Azure Synapse Analytics
Description: If the connection to the database was aborted, the task would not recover.
Jira issue: RECOB-6067
Salesforce case: N/A
Type: Issue
Component/Process: Microsoft Azure Synapse Analytics
Description: Changing dimensions from Type 2 to Type 1 would sometimes result in the following errors when recreating the associated tables:
SYS,GENERAL_EXCEPTION,Column name '<column-name>' does not exist in the target table or view
Jira issue: RECOB-6267
Salesforce case: N/A
Type: Issue
Component/Process: Data Mart Validation
Description: When validating a data mart with Date and Time columns, the validation would incorrectly report the following message:
The data mart tables in the database are different from the data mart definition
Jira issue: RECOB-6439
Salesforce case: N/A
Type: Issue
Component/Process: Project Import
Description: After importing a project from a diagnostic package, editing the connection settings would result in a 'SYS,DESERIALIZE_TO_TYPE' incompatibility error.
Jira issue: RECOB-6307
Salesforce case: 59873
Type: Issue
Component/Process: Data Mart Task
Description: Due to an issue with handling relationships, the data mart task would sometimes fail with the following error:
Invalid column name <name>
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.
Learn about new features and improvements in Qlik Replicate.
This section describes the issues that you may encounter when upgrading/migrating to the new version.
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 are Replicate November 2022 and Replicate May 2023 SR.
If you are upgrading from Replicate April 2020 (6.6), you need to perform the following upgrades:
If you are upgrading from Replicate 6.x (starting from 6.3), you need to perform the following upgrades:
Note: If you are upgrading from Replicate 5.5, please contact Qlik Support.
Note: This procedure does not need to be performed when upgrading from Replicate November 2022.
After upgrading, customers that are using Replicate's self-signed certificate (i.e. instead of their own certificate) should perform the following procedure:
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.
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
This version of Replicate is compatible with the following related products only:
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:
This section provides information about End of Life versions, End of Support features, and deprecated features.
Support for the following source endpoint types has been discontinued:
Support for the following target endpoint types has been discontinued:
Support for the following source endpoint versions has been discontinued:
Support for the following target endpoint versions has been discontinued:
Windows Server 2012: Support for installing Replicate on Windows Server 2012 (64-bit) and Windows Server 2012 R2 (64-bit) has been discontinued.
This section lists the newly supported platforms, database versions and third-party software versions.
This version introduces support for installing Replicate on Red Hat Enterprise Linux 9.x (64-bit).
Note: Requires Replicate November 2023 SR1 or later
The following source endpoint versions/editions are now supported:
The following target endpoint versions/editions are now supported:
This section lists the issues resolved since Replicate November 2023 initial release.
Jira issue: RECOB-7936
Salesforce case: 124583
Type: Issue
Component/Process: Oracle Source - Replicate Log Reader
Description: When a raw contained more than 1 trailing null and supplemental logging was defined for all the table columns, the After-Image would not contain all the columns.
Jira issue: RECOB-7839
Salesforce case: 121852
Type: Enhancement
Component/Process: IBM Informix Source
Description: Added support for the DECIMAL FLOAT data type using an internal parameter.
Jira issue: RECOB-7954
Salesforce case: N/A
Type: Enhancement
Component/Process: SAP HANA Source (Trigger mode)
Description: Added support for a configurable wait interval in Capture Trigger Mode v2, via two internal parameters.
Jira issue: RECOB-7934
Salesforce case: 122783
Type: Issue
Component/Process: Microsoft SQL Server (MS-CDC)
Description: Starting from timestamp would start from the Replicate server time instead of the database server time.
Jira issue: RECOB-9755
Salesforce case: N/A
Type: Issue
Component/Process: SAP HANA Target
Description: Removed redundant items options from the endpoint's Advanced tab.
Jira issue: RECOB-7907
Salesforce case: 131380
Type: Issue
Component/Process: Oracle Source - Replicate Log Reader
Description: Oracle Object ID values greater than 2^31 would be processed incorrectly.
Jira issue: RECOB-7916
Salesforce case: 109512
Type: Issue
Component/Process: IBM DB2 for z/OS Source
Description: The DB2Z_RECORD pool size would constantly increase and consume excessive memory when detected events did not belong to captured tables.
Jira issue: RECOB-7887
Salesforce case: 129439
Type: Issue
Component/Process: IBM DB2 for z/OS Source
Description: When a load balancing DB2 URL was configured in the endpoint, Replicate would fail to reconnect to the source database after a timeout.
Jira issue: RECOB-7889
Salesforce case: 129439
Type: Enhancement
Component/Process: IBM DB2 for z/OS Source
Description: An internal parameter was added that prevents capture of tables created by third-party applications during CDC.
Jira issue: RECOB-7881
Salesforce case: 127549
Type: Issue
Component/Process: IBM DB2 for z/OS Source
Description: When parsing DB2 variation 3 log records, the change capture process would stop unexpectedly or UPDATEs would not be captured.
Jira issue: RECOB-7930
Salesforce case: N/A
Type: Enhancement
Component/Process: Google Cloud BigQuery Target
Description: The Google Cloud BigQuery target endpoint build was updated to use .NET 8 for compatibility with OpenSSL 3.x.
Jira issue: RECOB-7874
Salesforce case: N/A
Type: Issue
Component/Process: Microsoft Fabric Data Warehouse Target
Description: The task would sometimes fail when the Limit LOB size to (KB) option was enabled and a LOB column was truncated.
Jira issue: RECOB-7749
Salesforce case: 118870
Type: Issue
Component/Process: Teradata Target
Description: When the data row buffer size exceeded 64k, the task would fail. This issue was resolved using an internal parameter.
Jira issue: RECOB-7770
Salesforce case: 84061
Type: Enhancement
Component/Process: PostgreSQL Source
Description: "Unsupported operation encountered: 'TRUNCATE' ignored" warnings would wrongly be shown for tables not included in the task. The issue was resolved using a feature flag.
Jira issue: RECOB-7850
Salesforce case: N/A
Type: Issue
Component/Process: Microsoft Fabric Data Warehouse Target
Description: The number of files applied in a batch would exceed the number specified in the Number of files to apply in a batch field.
Jira issue: RECOB-7854
Salesforce case: 120894
Type: Issue
Component/Process: Targets: Amazon Redshift, Databricks Lakehouse (Delta), Snowflake
Description: Temporary files would accumulate on disk during Full Load instead of being deleted. This would sometimes result in crashes due to insufficient disk space.
Jira issue: RECOB-7734
Salesforce case: 120019
Type: Issue
Component/Process: Databricks Lakehouse (Delta)
Description: When working with the Unmanaged tables option and resuming a task from timestamp, zero records would be replicated.
Jira issue: RECOB-7814
Salesforce case: 117552
Type: Issue
Component/Process: Notifications
Description: It would not be possible to specify different Notification on message and Notification off message texts.
Jira issue: RECOB-7833
Salesforce case: 121945
Type: Issue
Component/Process: AIS Source
Description: Timestamp header columns such as $AR_H_COMMIT_TIMESTAMP and $AR_H_TIMESTAMP would not include milliseconds.
Jira issue: RECOB-7810
Salesforce case: N/A
Type: Issue
Component/Process: Microsoft Fabric Data Warehouse Target
Description: Replication of tables with a BLOB data type would fail.
Jira issue: RECOB-7771
Salesforce case: 80371
Type: Issue
Component/Process: SAP ODP Source
Description: The task would always show constant CDC latency (regardless of the configured delta interval) when Replicate Server was installed in a timezone with a negative offset from UTC time.
Jira issue: RECOB-7809
Salesforce case: N/A
Type: Enhancement
Component/Process: Change Tables
Description: Added a verbose message to improve supportability.
Jira issue: RECOB-7744
Salesforce case: 93527
Type: Issue
Component/Process: SAP HANA Source (Trigger mode)
Description: During CDC, some records would not be replicated to the target. The issue was resolved by disabling the maxRowIdFromView internal parameter.
Jira issue: RECOB-7699
Salesforce case: NA
Type: Enhancement
Component/Process: Replicate Installation
Description: The Replicate RPM now uses systemd for Replicate service instances instead of init.d.
Jira issue: RECOB-7796
Salesforce case: 123341
Type: Issue
Component/Process: Oracle Source - Replicate Log Reader
Description: Following the installation of the Oracle 19c Oct 2023 patch, an UPDATE for a table with supplemental logging on all columns would suspend the table with the following error:
00002224: 2023-11-07T21:12:42:15551 [TARGET_APPLY ]T: Failed to get source column def for ids[3]=32714. [1021803] (endpointshell.c:4499)
00002221: 2023-11-07T21:12:42:21648 [TASK_MANAGER ]W: Table '<name>' (subtask 0 thread 1) is suspended. Failed to get source column def for ids[3]=32714. (replicationtask.c:3150)
Jira issue: RECOB-7703
Salesforce case: 114443
Type: Issue
Component/Process: Oracle Source - Replicate Log Reader
Description: Attempting to capture a DELETE operation on a migrated row in a SYS.OBJ$ table would cause the task to fail.
Jira issue: RECOB-7697
Salesforce case: 85369
Type: Issue
Component/Process: Oracle Source - Replicate Log Reader
Description: Following the installation of the Oracle 19c July CPU Patch (19.20.0.0.0), capturing Direct Inserts to wide tables (exceeding 255 columns) or compressed tables (basic and advanced) would sometimes not work as expected.
This section lists the issues resolved since Replicate May 2023 SR1.
Jira issue: RECOB-7506
Salesforce case: 73909
Type: Issue
Component/Process: SAP Application (DB)
Description: When the last batch contained operations on clustered tables, some changes would sometimes not be captured after detach/attach or stop/resume.
Jira issue: RECOB-7509
Salesforce case: 105266
Type: Enhancement
Component/Process: Oracle Source - Replicate Log Reader
Description: Added support for Archived redo logs destination ID 32, which is sometimes used in a Physical Standby environment.
Jira issue: RECOB-7457
Salesforce case: 94798
Type: Issue
Component/Process: Replicate Installation
Description: The docker sample used CentOS 7 while Replicate requires CentOS 8.
Jira issue: RECOB-7408
Salesforce case: 83880
Type: Issue
Component/Process: IBM DB2 for z/OS Source
Description: The capture process would not recover from a communication error in the metadata connection.
Jira issue: RECOB-7349
Salesforce case: 94030
Type: Issue
Component/Process: Salesforce Incremental Load
Description: When capturing transactions longer than the transaction consistency parameter, changes would be captured in the incorrect order. Added a warning to inform customers when this occurs.
Jira issue: RECOB-7464
Salesforce case: 85369
Type: Issue
Component/Process: Oracle Source - Replicate Log Reader
Description: Direct Insert on a wide (exceeding 255 columns) Advanced or Basic compressed table would sometimes cause the replication task to fail.
Jira issue: RECOB-7449
Salesforce case: 75277
Type: Issue
Component/Process: Linux Server
Description: Replicate Server would sometimes crash when the browser closed the connection unexpectedly.
Jira issue: RECOB-7477
Salesforce case: 102135
Type: Issue
Component/Process: SAP Extractor Source
Description: An ABORT of a delta extractor job during change capture would result in a table being suspended, instead of a recoverable error.
Jira issue: RECOB-7365
Salesforce case: N/A
Type: Issue
Component/Process: MongoDB Source
Description: Selecting multiple individual tables (i.e. not using a pattern) would result in no changes being captured.
Jira issue: RECOB-7456
Salesforce case: 96660
Type: Issue
Component/Process: SAP ODP
Description: When unloading failed, it would be reported as completed instead of failed.
Jira issue: RECOB-7458
Salesforce case: 84117
Type: Issue
Component/Process: Databricks (Cloud Storage)
Description: When reconnecting after a recoverable error while uploading a file, the last file would not be uploaded, resulting in missing data.
Jira issue: RECOB-7461
Salesforce case: 97216
Type: Issue
Component/Process: Cloudera Data Platform Target
Description: Kerberos authentication would not work properly.
Jira issue: RECOB-7279
Salesforce case: N/A
Type: Issue
Component/Process: SDK
Description: QCS Repagent Endpoint Server logs would be duplicated when scrolling up.
Jira issue: RECOB-7440
Salesforce case: 92546
Type: Enhancement
Component/Process: SAP ODP
Description: Added support for CDS views that have mandatory parameters.
Jira issue: RECOB-7288
Salesforce case: 87621
Type: Issue
Component/Process: Databricks Lakehouse (Delta)
Description: When using merge, if one of the columns in a Unique Index was NULL the changes would not be applied correctly. The issue was resolved using a Feature Flag at task and server level.
Jira issue: RECOB-7385
Salesforce case: 73152
Type: Issue
Component/Process: IBM DB2 for z/OS Source
Description: The following ambiguous warning message would sometimes be issued when resuming a task:
Transaction <> was committed after the Full Load started and the BEGIN TRANSACTION statement was not captured
Jira issue: RECOB-7425
Salesforce case: N/A
Type: Issue
Component/Process: Snowflake Target
Description: When a Snowflake stage already existed in the target, Full Load would sometimes fail.
Jira issue: RECOB-7423
Salesforce case: 87699
Type: Issue
Component/Process: Oracle Source - Replicate Log Reader
Description: When replicating a non-compressed table, the following warning would sometimes occur, after which there would be missing DELETE operations:
MULTI DELETE compressed event cannot be parsed
Jira issue: RECOB-7414
Salesforce case: 79317
Type: Issue
Component/Process: SAP Extractor Source
Description: Import of the Transport to a SAP Application Server would fail due to vulnerability issues.
Jira issue: RECOB-7220
Salesforce case: 52384
Type: Issue
Component/Process: DB2 z/OS Source
Description: DB2 would sometimes abend in a data sharing environment when tasks moved back and forth between LPARs.
Jira issue: RECOB-7328
Salesforce case: 86717
Type: Issue
Component/Process: Microsoft Azure ADLS Target
Description: When using numerous segments for Parallel Load to any File-based target, errors would sometimes occur during Full Load.
Jira issue: RECOB-7405
Salesforce case: 94821
Type: Issue
Component/Process: Microsoft Event Hubs Target
Description: When one or more error occured, and one of them was a connection error, Replicate would suspend the table being replicated instead of trying to reconnect.
Jira issue: RECOB-7415
Salesforce case: 85636
Type: Issue
Component/Process: SAP ODP
Description: When Current Data mode was enabled, Full Load would not replicate any records and the following error would occur during CDC:
java.lang.String incompatible with java.math.BigDecimal
Jira issue: RECOB-7622
Salesforce case: 111550
Type: Issue
Component/Process: Microsoft SQL Server Source
Description: The task would sometimes stop unexpectedly when reading an SQL Server backup transaction log.
Jira issue: RECOB-7603
Salesforce case: 108309
Type: Issue
Component/Process: IBM DB2 for iSeries Source
Description: Attempting a Full Load of a table with over 1000 columns using the "loadCSV" internal parameter would sometimes fail with the following error (excerpt):
Command failed to load data with exit error code 3
Jira issue: RECOB-7558
Salesforce case: 105303
Type: Issue
Component/Process: Amazon RDS for PostgreSQL Source
Description: The following issue would sometimes occur during CDC:
Jira issue: RECOB-7770
Salesforce case: 84061
Type: Issue
Component/Process: PostgreSQL Source
Description: Whenever source database table that are not part of the replicate task are truncated, the following warning is logged:
[SOURCE_CAPTURE ]W: Unsupported operation encountered: 'TRUNCATE' ignored. (postgres_endpoint_wal_utils.c:1919)
This increases the log size, thereby impacting the amount of resources.
Jira issue: RECOB-7749
Salesforce case: 118870
Type: Issue
Component/Process: Teradata Target
Description: The following error occurs when replicating rows larger than 64k:
Data row buffer size exceeds maximal supported size
Jira issue: RECOB-7734
Salesforce case: 120019
Type: Issue
Component/Process: Databricks Lakehouse (Delta) Target
Description: When the Create table as option is set to Unmanaged tables, no records are loaded when starting a task from timestamp.
Jira issue: RECOB-7703
Salesforce case: 114443
Type: Issue
Component/Process: Oracle Source - Replicate Log Reader
Description: Attempting to capture a DELETE operation on a migrated row in a SYS.OBJ$ table would cause the task to fail.
Jira issue: RECOB-7697
Salesforce case: 85369
Type: Issue
Component/Process: Oracle Source - Replicate Log Reader
Description: Following the installation of the Oracle 19c July CPU Patch (19.20.0.0.0), capturing direct Inserts to wide (more than 255 columns) or compressed tables (basic and advanced) does not work as expected.
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.
Table of Contents
Learn about new features and improvements in Qlik Enterprise Manager.
Before upgrading, it's important to review the migration and upgrade considerations below.
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 2022 and Enterprise Manager May 2023.
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 November 2023.
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 November 2023.
If you are upgrading from Enterprise Manager 3.3, please contact Qlik Support.
This version of Enterprise Manager is compatible with the following related products only:
Windows Server 2012: Support for installing Enterprise Manager on Windows Server 2012 (64-bit) and Windows Server 2012 R2 (64-bit) has been discontinued.
This section lists the issues resolved since Enterprise Manager May 2023 initial release.
Jira issue: RECOB-7694
Salesforce case: 107620
Type: Issue
Component/Process: Parallel Load, UI
Description: When using Enterprise Manager May 2023 to configure old Replicate versions, parallel load with partitions would be disabled in the UI.
Jira issue: RECOB-7628
Salesforce case: 67578
Type: Enhancement
Component/Process: Performance
Description: Improved performance when retrieving the status of the Replicate server.
Jira issue: RECOB-7173
Salesforce case: N/A
Type: Issue
Component/Process: General
Description: Added support for web_log in Verbose mode. Web log lists all REST requests accepted by Enterprise Manager.
Jira issue: RECOB-7092, RECOB-7093
Salesforce case:
Type: Issue
Component/Process: Security
Description: Resolved a security vulnerability related to Personal Access Tokens (CWE-352: Cross-Site Request Forgery (CSRF)).
Jira issue: RECOB-7013
Salesforce case: 67578
Type: Enhancement
Component/Process: Performance
Description: Improved performance when loading the list of tasks.
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.
Table of Contents
The following release notes cover the versions of Qlik NPrinting released in May 2023 Service Release 2.
Jira issue ID: OP-95917
Due to new internal code optimizations, the generation of Word reports with levels is now faster.
Jira issue ID: OP-95892
When saving or previewing a report in the Qlik NPrinting Designer, sometimes the error: “TemplateEntities list does not contain this column” occurred.
Jira issue ID: OP-95905
When using single table tags, the borders of blank cells were sometimes not displayed in the Excel report. A workaround was to insert all the column tags instead of using the single table tag.
Jira issue ID: OP-95915
The "audience" attribute was not checked while validating a SAML response by an Identity Service Provider. A SAML response that was addressed by the same Identity Service Provider for another application could be used to access Qlik NPrinting if it was signed by the same certificate configured in Qlik NPrinting and find the attributes used to authenticate the user (email address or domain username) among Qlik NPrinting users.
Jira issue ID: OP-95904
Qlik NPrinting Server installation or upgrade failed if the LOGS or LOG_BASE environment variable was set in the machine.
Jira issue ID: OP-95786
Text alignment set in in email bodies publish tasks was not saved when the text editor was used.
The following issues and limitations were identified at release time. The list is not comprehensive; it lists all known major issues and limitations. We expect to have these issues fixed in future versions.
The following languages are supported:
Other languages are not officially supported. There may be issues with other languages, particularly those with right-to-left script and non-Roman alphabets.
Qlik Sense custom size sheets are not supported. Custom size will not be maintained on export.
Alternate states
QlikView and Qlik Sense alternate states are not supported.
QlikView and Qlik Sense alternate states are not supported.
Jira issue ID: OP-6196
Qlik NPrinting Server, Engine, and Designer can only be installed on C: drives. Any attempt to install them on a different drive will result in task failures.
Jira issue ID: OP-5831
When you add the same object twice, using the Images node in Qlik NPrinting Designer, only the image size property of the first image is respected.
It is possible to select the “Enable” check box in On-Demand for reports using Qlik Sense app data. These reports are visible in the QlikView On-Demand menu of the QlikView On-Demand add-on. But if selected, they will not generate reports, and you will see an error message.
If you experience random crashes when using Qlik NPrinting Designer, open your Windows Display Settings in the Control Panel and verify that Smaller – 100% (default) is selected. When settings of 125% or 150% are selected, Qlik NPrinting Designer may crash.
Jira issue ID: OP-5908
In some cases, when you use Qlik NPrinting On-Demand in Internet Explorer 11 or Edge, the “origin” HTTP header is not generated. This results in the error message “REVEL_CSRF: tokens mismatch”.
The workaround is to install Qlik NPrinting On-Demand on a Microsoft IIS server hosting QlikView Access point or use a different web browser.
Jira issue ID: OP-4940
Qlik NPrinting Designer may be unable to open a report template if there are too many filters associated with a connection in the report's app. The following error message displays: “A task was canceled”.
This typically happens when more than 4000 filters are using fields from a connection. Sometimes, higher numbers can work. For example, 7000 filters have worked in some situations.
The workaround is:
1. Split the Qlik NPrinting app into separate apps.
2. Split the connections (possibly by using multiple connections to the same documents in different apps).
3. Split the filters across apps (so that the filter count per app is lower).
Jira issue ID: OP-4839
Some Qlik NPrinting tasks fail with the error message: “Exceeded maximum number of retries”. This is due to a performance issue in QlikView that appears when it exports large unfiltered files to Excel.
Jira issue ID: OP-5278
In some rare circumstances, pressing the Verify connection button will cause the screen to freeze on the “Initializing…” status and the spinning wheel cursor. This happens when a Qlik NPrinting Engine goes offline and Verify connection is pressed before the Qlik NPrinting Scheduler is aware that it is offline. It can take up to 20 seconds before the Qlik NPrinting Scheduler determines the offline status of a Qlik NPrinting Engine.
Jira issue ID: OP-5914
When you:
The filters associated with each user are not uploaded, or displayed, for performance reasons. Waiting for all filters for thousands of users to import would take a long time. In most cases, importing this information is unnecessary, because filters created for users often contain something like the user IDs. You can change this behavior and make all filters visible by uncommenting the line <!--<add key="include-user-filters" />--> in the webengine.config file.
To make a specific filter visible in the lists, remove its association to all users, or create a new filter with the same fields and values not linked to any user.
Jira issue ID: OP-3986
The rollback that follows a Qlik NPrinting Server or Engine upgrade cancellation may corrupt the related Qlik NPrinting installation. A rollback is triggered by errors or by clicking the cancel button during the upgrade execution. After a corruption caused by a rollback, services may be uninstalled or cannot be started.
To restore a Qlik NPrinting Server to its original status:
You should always create a backup before starting an update. In any case, a backup is automatically created in the folder "%ProgramData%\NPrinting" at the beginning of the upgrade process. To restore a Qlik NPrinting Engine to original status:
Jira issue ID: OP-7560
Add title functionality is not supported on Qlik Sense objects with Assistance mode enabled. The workaround to restore the Add title functionality is to disable Assistance mode for the chart in Qlik Sense. Then reload the metadata of the connection.
Jira issue ID: OP-7568
Qlik Sense objects made in Assistance mode cannot be used as tables, columns, or cells in Qlik NPrinting. To restore them, disable Assistance mode on the chart in Qlik Sense; then reload the metadata of the connection. Furthermore, if a Qlik Sense object made with Assistance mode is exported as a table, column, or cell using Qlik NPrinting APIs, the request will fail.
Jira issue ID: OP-7165
Open Type Fonts (*.otf) are not supported in PixelPerfect templates. Generated reports will use a different font, and not look as expected.
Jira issue ID: OP-7747
The following functionalities are not supported for Qlik Sense tables that have a "Show column if" condition set on one or more of their columns: levels, single column export, and keep source formats.
Jira issue ID: OP-8382
Qlik Sense On-Demand reports with selections applied on calculated dimensions will fail. However, you can apply selections on dimensions based on Qlik Sense fields. The workaround is to move the formula to the load script and use the calculated fields to apply selections to your On-Demand reports.
Jira issue ID: OP-8985
Due to the internal way of exporting Qlik Sense histograms, you cannot add them to the Qlik NPrinting Designer Tables node. If you add a Qlik Sense histogram to the Tables node, you will not receive any errors or warning messages, but the exported data will be wrong.
Jira issue ID: OP-8921
QlikEntity reports support Qlik Sense objects with the following limitations:
Jira issue ID: OP-9087
You cannot embed an Excel worksheet in a PowerPoint report template. This will cause a Qlik NPrinting Designer crash. The workarounds are to insert the Excel worksheet without using the Qlik NPrinting Designer:
Jira issue ID: OP-9067
Dynamic views is a new Qlik Sense feature starting from June 2020.
If you connect Qlik NPrinting to a Qlik Sense app that contains a chart used to generate dynamic views, the chart and the containing sheet are excluded from the Qlik NPrinting connection cache and cannot be used in reports.
You can connect Qlik NPrinting to a Qlik Sense app containing dynamic views. However, after a dynamic view refresh, the connection will stop working.
Jira issue ID: OP-9628
Starting from November 2020, RabbitMQ Server (deployed as Qlik NPrinting Messaging Service) has been updated to version 3.8.3. It has an internal limit, not configurable, about messages size of 512MB. Previous limit was 2GB. As consequence, is not possible to generate Qlik NPrinting reports bigger than 512MB.
Jira issue ID: OP-9766
Excel worksheet print areas can contain more than one range if the generation of the report does not expand the print area. If it expands, you will see an error: “Invalid Cell Name”. For example, the default setting of the Expand Range option in a Qlik NPrinting table causes the print area to change during report production, and an error is received.
Jira issue ID: OP-9518
Using Cyrillic characters in the Search form of the Qlik NPrinting user interface is case sensitive.
Jira issue ID: OP-9995
The percentage “%” format is not kept in Excel reports when using QlikView 12.50 (12.50.20000) or newer due to a QlikView issue. You can solve this by upgrading to QlikView May 2021 SR2 (12.60.20200) or newer.
Jira issue ID: OP-95599
If you start a Run Verification on a connection to a QlikView document in QVF format, Qlik NPrinting cannot confirm whether the QlikView Desktop version installed locally on each Qlik NPrinting Engine is compatible with QVF file format. The check mark next to "QlikView can open the document" may be green, even if a version of QlikView that does not support QVF is installed. This is because verification only checks file permissions. If the installed QlikView Desktop does not support QVF format, metadata generation will fail.
Jira issue ID: OP-95682
QlikView objects with many different fields with exactly the same label are not supported. Duplicated labels cause an exception during the connection cache generation. To solve this issue, ensure that each field has a unique label.
Jira issue ID: OP-95797
Images linked by using URLs in Qlik Sense tables are exported as text. This affects only Qlik Sense connections. A workaround exists for PixelPerfect templates.
To upgrade to Qlik NPrinting May 2023 SR2, you must start from one of the following versions:
If you have a version of Qlik NPrinting older than April 2018, you must upgrade to Qlik NPrinting April 2018 before you can upgrade to Qlik NPrinting May 2023 SR2.
If you have a version of Qlik NPrinting older than 17.3, you must first upgrade to Qlik NPrinting 17.3. Then you
must upgrade to a version from April 2018 to May 2021 SR4 before you can upgrade to Qlik NPrinting May
2023 SR1.
If you are upgrading from a version older than February 2018, all metadata caches (QlikView and Qlik Sense) will be marked as "not generated". This is due to a breaking change in the format of the metadata cache. All connection caches must be regenerated before you can edit a template or create a new connection.
You must back up your data before you proceed. Data can become damaged if a problem occurs during the
upgrade. If data is damaged, a backup is required to restore the repository. See: Backup and restore of a
repository.
After backup, you must follow the instructions for upgrading on the help site page Qlik NPrinting upgrade.
If you are upgrading to May 2023 SR1 from September 2018 SR2 or older you must:
• Open port 4997 outbound on Qlik NPrinting Server and inbound on all Qlik NPrinting Engines.
• Reinstall all your Qlik NPrinting Engines and provide a password for certificate exchange.
• Open the Engine manager in the Web Console.
• Open the detail page for each Engine and send the certificate after inserting the same password you used during the engine’s reinstallation.
Qlik NPrinting Engines stay offline until the certificate exchange is performed. Older Engine versions cannot connect to a Qlik NPrinting May 2023 IR Server.
Setups are available at https://community.qlik.com/t5/Downloads/tkb-p/Downloads
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.