QlikView May 2023users can now upgrade toService Release 1 (SR1)by logging into Qlik Community with their Qlik Account and visiting ourdownloads siteto install the latest version. This upgrade includes: Multiple resolved defects, such as fixes with drill-downs on calculated dimensions, and issues with quoting characters in CSV files, and more! Check out all the product upgrade details (including a list of fixes) in ourRelease Notes QlikView May 2023 SR1. Thanks for choosing Qlik! Qlik Global Support P.S. use the below filters to find the latest QlikView Service Release on ourDownload's site! ...View More

Hi everyone, Want to stay a step ahead of important Qlik support issues? Then sign up for our monthly webinar series where you can get first-hand insights from Qlik experts. Next Thursday, October 5th Qlik Support will host another Techspert Talks session and this time it's Visualization Day! But wait, what is it exactly?Techspert Talks is a free webinar held on a monthly basis, where you can hear directly from Qlik Techsperts on topics that are relevant to Customers and Partners today. In this session, we will cover: Future Visualization Updates New Layout Container Dynamic Linking with Bookmarks Click on this link to choose the webinar time that's best for you. The webinar is hosted using ON24 in English and will last 30 minutes plus time for Q&A.Hope to see you there!! ...View More

Welcome to September's Qlik Data Integration newsletter. Each month, we cover one endpoint and share our top resources, best practices, release updates and upcoming webinars. Subscribe to theQlikData Integrationtopic to be notified of future editions! Index WebinarResource HighlightsQlik Replicate November 2023 and FIPSKnowledgebase ArticleEndpoint Spotlight: DB2New Issues ReportedTips!Best PracticeRelease UpdatesFixesUpcoming EnhancementsTroubleshooting tipsAnalyze Qlik Replicate LogsQlik Replicate End of Life Versions Webinar Book your calendar for the upcoming Q&A with Qlik: Qlik Replicate Sources and TargetsQ&A sessionscheduled forOctober 24th at 10:00 AM EDT. It is a live Q&A session with a panel of Qlik experts. Bring your questions, and we do our best to answer them. Resource Highlights Qlik Replicate November 2023 and FIPS The November 2023 release of Qlik Replicate is not yet FIPS compliant. If you require a compliant environment, remain on the already FIPS compatible versions. See Qlik Replicate November 2023 and FIPS: Release not yet FIPS compliantfor details. Knowledgebase Article Endpoint Spotlight: DB2 Find our latest knowledge base articles for DB2 endpoints. New Issues Reported Qlik Replicate and R4Z after upgrade to 2023.5 SP02: additional download requiredThe Qlik Replicate service pack 02 release for 2023.5 includes old R4Z installation files from the previous SP01 build. To upgrade the R4Z component, additional files need to be downloaded and installed. See Qlik Replicate and R4Z after upgrade to 2023.5 SP02: additional download requiredfor details. SQL0551N The statement failed because the authorization ID does not have the required authorization or privilege to perform the operation.Qlik Replicate with a DB2 z/OS source endpoint (using R4Z) displays authorization and privilege errors. SeeQlik Replicate DB2 z/OS - [SOURCE_CAPTURE ]E: RetCode: SQL_ERROR SqlState: 42501 NativeError: -551 Message: [IBM][CLI Driver][DB2] SQL0551Nfor more information and how to resolve the issue. Tips! R4Z Db2 mainframe install is completed but no Changes are coming throughCheck that the Tables you wish to be performing CDC replication upon, have been "turned on" for capturing the changes from the DB2 z/OS Logs. SeeQlik Replicate: R4Z DB2z No CDC coming throughfor details. Qlik Replicate DB2 z/OS task may stop/fail withR4DB2: ALL CB ENTRIES ARE IN USEThis means that a task is trying to start, but the maximum number of R4Z Control Blocks (in the R4Z CDC service environment on the mainframe) is in use. Find the resolution in Qlik Replicate: DB2 z/OS R4Z [SOURCE_CAPTURE ]W: R4DB2: ALL CB ENTRIES ARE IN USE. Best Practice Match R4Z and Qlik Replicate versionsThe Qlik Replicate and R4Z versions you install must be part of the same release, which can either be an initial release or a patch/service release. This means that if you upgrade Qlik Replicate, you must also upgrade your R4Z installation (to the version that correlates with the Qlik Replicate release you are installing), unless it has the same build number as your currently installed R4Z. Note that despite being part of the same release, the Qlik Replicate and R4Z build numbers (reflected in their file names) might not be the same. For example, Qlik Replicate May 2022 SR2 includes the following files: QlikReplicate_2022.5.0.499_X64.zip (the Replicate installer) QlikReplicate_2022.5.0.290_r4z.zip (the R4Z installer). How to avoid WLM tasks being cancelled due to Work Load Manager Policy settingsWhen installing and using the DB2 z/OS endpoint in Qlik Replicate, WLM tasks on the mainframe may get cancelled. There are multiple root causes for this, but a common one can be addressed by reviewing the execution priority (WLM settings).See Qlik Replicate and R4Z: Best practice to ensure DB2 z/OS Workload Manager (WLM) tasks are not cancelledfor details. Release Updates Fixes Qlik Replicate May 2023 Patch 3 ID:RECOB-7408Type: IssueComponent/Process: IBM DB2 for z/OS SourceDescription: The capture process would not recover from a communication error in the metadata connection. ID:RECOB-7385Type: IssueComponent/Process: IBM DB2 for z/OS SourceDescription: 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.ID: RECOB-7220Type: IssueComponent/Process: DB2 z/OS SourceDescription: DB2 would sometimes abend in a data sharing environment when tasks moved back and forth between LPARs. Qlik Replicate May 2023 Patch 2ID: RECOB-7311Type: EnhancementComponent/Process: IBM DB2 for z/OS TargetDescription: Performance was improved when using the zload utility to load files. ID: RECOB-7146Type: IssueComponent/Process: IBM DB2 for z/OS TargetDescription:The task log would display the following incorrect warning when replicating from IBM DB2 on z/OS 13.1 (which is certified):Replicate has not been certified to work with DB2 z/OS version '13.01.0005', and therefore any issues you may encounter with this version are not covered by your license agreement. ID: RECOB-7114Type: IssueComponent/Process: IBM DB2 for z/OS TargetDescription: The R4Z DO4GRANT JCL was updated to grant the R4Z user permissions on the SYSIBM.SYSTABLEPART and SYSIBM.SYSPARMS tables. Upcoming Enhancements Qlik Replicate November 2023 IR Expose stream buffer tuning parameters in task settings (Replicate & QEM - Expose stream buffer tuning parameters in task settings) Confluent Schema Register using BOTH authentication methods (Public Key + Username & password) Snowflake - Support Transactions in Upsert Mode Boolean Data Type support for PG sources and Bit support for SQL Server targets Google BigQuery - Secure current authentication (no longer have credential files on customer file system) Aurora PostgreSQL source - without the "superuser" role certification Azure Database for MySQL Flexible Server - Source & Target Certification MariaDB 10.6 to 10.11 versions on MySQL - certification MariaDB 10.6 version on Amazon RDS - certification Google Cloud SQL for MSSQL Source endpoint Databricks 12.2 LTS Certification Databricks Serverless SQL warehouse certification Troubleshooting tips Analyze Qlik Replicate Logs An evergreen pair of articles helps you read and analyze Qlik Replicate log files: How to analyze a Qlik Replicate logList of the error types in Qlik Replicate Qlik Replicate End of Life Versions Version Release Date End of Support Date Qlik Replicate May 2023 May 9, 2023 May 9, 2025 Qlik Replicate November 2022 November 8, 2022 November 8, 2024 Qlik Replicate May 2022 May 10, 2022 May 10, 2024 Qlik Replicate November 2021 November 8, 2021 November 8, 2023 Qlik Replicate May 2021 May 11, 2021 May 11, 2023 Qlik Replicate November 2020 November 10, 2020 November 30, 2022 Qlik Replicate April 2020 (6.6) April 16, 2020 April 30, 2022 Qlik Replicate 6.5 November 14, 2019 November 30, 2021 Qlik Replicate 6.4 April 1, 2019 April 14, 2021 Qlik Replicate 5.5 August 1, 2017 November 30, 2020 For more information, see Qlik Product Lifecycles. ...View More

Hello Qlik Users, A security issue in Qlik Sense Enterprise for Windows has been identified, and patches have been made available. Details can be found in the Security Bulletin Critical Security fixes for Qlik Sense Enterprise for Windows (CVE-pending). Today, we have released eight service releases across the latest versions of Qlik Sense to patch the reported issues. All versions of Qlik Sense Enterprise for Windows prior to and including these releases are impacted: August 2023 Patch 1 May 2023 Patch 5 February 2023 Patch 9 November 2022 Patch 11 August 2022 Patch 13 May 2022 Patch 15 February 2022 Patch 14 November 2021 Patch 16 No workarounds can be provided. Customers should upgrade Qlik Sense Enterprise for Windows to a version containing fixes for these issues. The listed fixes also address CV-2023-41266 and CVE-2023-41265 (link). August 2023 Patch 2 May 2023 Patch 6 February 2023 Patch 10 November 2022 Patch 12 August 2022 Patch 14 May 2022 Patch 16 February 2022 Patch 15 November 2021 Patch 17 This issue only impacts Qlik Sense Enterprise for Windows. Other Qlik products including Qlik Cloud and QlikView are NOT impacted. All Qlik software can be downloaded from our official Qlik Download page (customer login required). Follow best practices when upgrading Qlik Sense. Qlik provides patches for major releases until the next Initial or Service Release is generally available. See Release Management Policy for Qlik Software. Notwithstanding, additional patches for earlier releases may be made available at Qlik’s discretion. The information in this post and Security Bulletin Critical Security fixes for Qlik Sense Enterprise for Windows (CVE-pending)is disclosed in accordance with our published Security and Vulnerability Policy. Clarifications and Frequently Asked Questions: What can be done to mitigate the issue? No mitigation can be provided. An upgrade should be performed at the earliest. As per Qlik's best practices, the proxy should not be exposed to the public internet, which reduces theattack surface significantly. What authentication methods are affected? All authentication methods are affected. Are environments with HTTP disabled impacted? Environments will be affected regardless if HTTP or HTTPS are in use. These vulnerabilities affect the HTTP protocol overall, meaning even if HTTP is disabled, the environment remains vulnerable. These attacks don’t rely on intercepting any communication, and therefore, are indifferent whether the HTTP communication is encrypted or not. Kind regards, and thank you for choosing Qlik, Qlik Global Support ...View More

September 26 at 10:00 EST / 16:00 CET

...View More

Hello Qlik Users, Beginning October 10, 2023, access to the tenant recovery URL for tenants (https://<tenant name>.<region>.qlikcloud.com/login/recover) will be restricted to the Service Account Owner of the tenant. This update is performed on all Qlik Cloud tenants to handle circumstances in which the service account owner for a tenant was changed or will be changed. If you are using the recovery login URL to access your tenant regularly, we recommend you use the standard login URL for your tenant (https://<tenant name>.<region>.qlikcloud.com/login) instead. You cannot access the tenant through the recovery login after October 10, 2023. Thank you for choosing Qlik,Qlik Support ...View More

We understand that when you encounter issues or have questions, you need quick and convenient access to assistance. That's why we're thrilled to introduce our latest beta enhancement: In-Product Support Chat for Qlik Cloud Administrators. We're taking customer support to the next level by making it more accessible and user-friendly. Whether you're a seasoned pro or a new administrator, getting the help you need is easier than ever. You'll find our Support Chat right under the Resource Center in your cloud tenant: Whether it's troubleshooting technical issues, getting guidance on using our features, or simply asking a question, our always-learning chatbot is at your service 24/7. Or you can be easily connected to our support team to provide you with personalized assistance tailored to your specific needs, Monday-Friday. We’re excited to embark on this journey with you. Please be sure to share feedback on your chat experience at the end of each conversation so we can continuously make improvements. Thank you for choosing Qlik, we look forward to chatting with you! If you have any questions about our new in-product Support, don’t hesitate to reach out. Sincerely, Qlik Global Support ...View More

Hello Qlik Users, As previously announced, the Blendr.io platform will be sunset and all access to the platform will be discontinued on its Retirement Date, July 11, 2024. Customers with existing active subscriptions can continue renewing their subscriptions prior to theRetirement Date. However, please note that all subscriptions, including renewals, willautomatically end on the Retirement Date.All existing Blendr.io platform customers have received notice of the Retirement Date as of January 11, 2023. Due to the platform’s retirement, no new platform updates, except for patches for security issues, will be made. However, customers with existing active subscriptions can still reach out to Qlik Support in the event of interruptions in the platform’s service or if an active automation is no longer working. Please note that Qlik Support is not available for new automations built by customers. Further, connector development work will not be provided for new block or connector requests. Please keep in mind that Qlik is not responsible for updating the platform due to changes in any third-party vendor’s API. We appreciate your long-standing support of Qlik/Blendr.io.For Qlik Cloud customers, you can achieve the same results with our Qlik Application Automation capabilities. Explore more about this feature here. Please contactyourQliksales representative,the product team, orQlik Customer Supportif you have any questions. ...View More

Hi everyone, Want to stay a step ahead of important Qlik support issues? Then sign up for our monthly webinar series where you can get first-hand insights from Qlik experts.The Techspert Talks session from September looked at Migrating NPrinting to Qlik Cloud Reporting. But wait, what is it exactly?Techspert Talks is a free webinar held on a monthly basis, where you can hear directly from Qlik Techsperts on topics that are relevant to Customers and Partners today. In this session we will cover: What Qlik Cloud Reporting can do Alerts and Subscriptions Migration process Click on this link to see the presentation ...View More

Welcome to August's Qlik Data Integration newsletter. Each month, we cover one endpoint and share our top resources, best practices, release updates and upcoming webinars. Subscribe to theQlikData Integrationtopic to be notified of future editions! Index Resource HighlightsReminder! Qlik Replicate Endpoint RetirementKnowledgebase ArticleEndpoint Spotlight: DatabricksNew Issues ReportedTips!Release UpdatesFixesUpcoming EnhancementsTroubleshooting tipsAnalyze Qlik Replicate LogsQlik Data Integration Product End of Life Versions Resource Highlights Reminder! Qlik Replicate Endpoint Retirement As of July 31st, 2023, the following endpoints have been retired: Source Endpoints: HP Non-Stop Source Open VMS RMS Source Hadoop Source Target Endpoints: MapR Target MapR Streams Target MS APS PDW Target SAP Sybase IQ Target HP Vertica Target Actian Vector Target Netezza Target Pivotal Greenplum Target SeeRetirement for Specific Qlik Replicate Endpointsfor details. Knowledgebase Article Endpoint Spotlight: Databricks Find our latest knowledge base articles for Databrick endpoints. New Issues Reported Error SSL_connect: wrong version number when using Databricks Lakehouse (Delta) as target Find the resolution in Qlik Replicate with Databricks Lakehouse (Delta) as target: Error SSL_connect: wrong version number. Performing operations in transactions apply mode is not supported with Databricks Lakehouse (Delta) as target TheApply Changesreplication mode supports tables with a Primary Key only. For solutions seeQlik Replicate with Databricks Lakehouse (Delta) as target: Performing operations in transactions apply mode is not supported in log. Table is failing on full load when loading into Microsoft Azure Databricks Delta Target Find the resolution inQlik Replicate: Table is failing on full load when loading into Microsoft Azure Databricks Delta Target. Qlik Replicate Server crashes when browsing databases in Microsoft Azure Databricks Target ClickingBrowsein the database endpoint settings of a Microsoft Azure Databricks target crashes the Qlik Replicate server.Find the resolution inQlik Replicate Server crashes when browsing databases in Microsoft Azure Databricks Target. Tips! Qlik Replicate and Databrick Unity Catalog feature flag support Qlik Replicate added support for Databricks Unity Catalog using feature flag from 2022.11 SP02. SeeQlik Replicate added support for Databricks Unity Catalog using feature flag from 2022.11 SP02for details. Qlik Replicate: Databricks Operations per second is over the account limit Qlik Replicate tasks may fail with Operations per second is over the account limiterrors. Find the resolution in Qlik Replicate: Databricks Operations per second is over the account limit. Best Practice:Qlik Replicate: Databricks Delta Wstring data type truncation Starting withDatabricks Delta Driver version to 8.x and above, Varchar data type will be used for strings. Varchar data type is no longer limited by this character size so no truncation will occur when Wstring data type is used with limits higher than 255 characters. Release Updates Fixes Qlik Replicate May 2023 patches Component/Process: Databricks (Cloud Storage) Description: When reconnecting after recoverable error on uploading file, the last file does not get uploaded, resulting in missing data. 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. Upcoming Enhancements Qlik Replicate August 2023 IR New Confluent Endpoint (based on Kafka) S3 authentication support with AWS IAM Roles Anywhere on S3/Redshift endpoints Ability to Set Isolation Level on ODBC with CDC (Ability to Set Isolation Level on ODBC with CDC) Qlik Replicate November 2023 IR Expose stream buffer tuning parameters in task settings (Replicate & QEM - Expose stream buffer tuning parameters in task settings) Confluent Schema Register using BOTH authentication methods (Public Key + Username & password) Snowflake - Support Transactions in Upsert Mode Boolean Data Type support for PG sources and Bit support for SQL Server targets Google BigQuery - Secure current authentication (no longer have credential files on customer file system) Aurora PostgreSQL source - without the "superuser" role certification Azure Database for MySQL Flexible Server - Source & Target Certification MariaDB 10.6 to 10.11 versions on MySQL - certification MariaDB 10.6 version on Amazon RDS - certification Troubleshooting tips Analyze Qlik Replicate Logs An evergreen pair of articles helps you read and analyze Qlik Replicate log files: How to analyze a Qlik Replicate logList of the error types in Qlik Replicate Qlik Data Integration Product End of Life Versions Qlik Release Qlik Replicate / Enterprise Manager End of Support Date Qlik Compose End of Support Date February 2021 November 2020 SR1 November 2022 February 2021 February 2023 May 2021 May 2021 May 2023 May 2021 May 2023 August 2021 May 2021 SR1 May 2023 August 2021 August 2023 November 2021 November 2021 November 2023 November 2021 November 2023 For more information, see Qlik Product Lifecycles. ...View More