Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team
Qlik offers a range of opportunities to assist you in troubleshooting, answering frequently asked questions, and contacting our experts. In this article, we guide you through all available avenues to secure your best possible experience.
For details on our terms and conditions, review the Qlik Support Policy.
Index:
We're happy to help! Here's a breakdown of resources for each type of need.
Support | Professional Services (*) | |
Reactively fixes technical issues as well as answers narrowly defined specific questions. Handles administrative issues to keep the product up-to-date and functioning. | Proactively accelerates projects, reduces risk, and achieves optimal configurations. Delivers expert help for training, planning, implementation, and performance improvement. | |
|
|
(*) reach out to your Account Manager or Customer Success Manager
Your first line of support: https://community.qlik.com/
Looking for content? Type your question into our global search bar:
Leverage the enhanced and continuously updated Knowledge Base to find solutions to your questions and best practice guides. Bookmark this page for quick access!
Subscribe to maximize your Qlik experience!
The Qlik Design Blog
The Design blog is all about product and Qlik solutions, such as scripting, data modelling, visual design, extensions, best practices, and more! (click)
The Product Innovation Blog
By reading the Product Innovation blog, you will learn about what's new across all of the products in our growing Qlik product portfolio. (click)
The Support Updates Blog
The Support Updates blog delivers important and useful Qlik Support information about end-of-product support, new service releases, and general support topics. (click)
Q&A with Qlik
Live sessions with Qlik Experts in which we focus on your questions).
Techspert Talks
Techspert Talks is a free webinar to facilitate knowledge sharing held on a monthly basis.
Qlik Fix
Qlik Fix is a series of short video with helpful solutions for Qlik customers and partners.
Suggest an idea, and influence the next generation of Qlik features!
Search & Submit Ideas
Ideation Guidelines
Get the full value of the community.
Register a Qlik ID:
Incidents are supported through our Chat, by clicking Contact Support on any Support Page across Qlik Community.
To raise a new issue, all you need to do is chat with us. With this, we can:
How to create a case using chat
Log in to manage and track your active cases in Manage Cases. (click)
Your advantages:
If you require a support case escalation, you have two options:
A collection of useful links.
Qlik Cloud Status Page
Keep up to date with Qlik Cloud's status.
Support Policy
Review our Service Level Agreements and License Agreements.
Live Chat and Case Portal
Your one stop to contact us.
Qlik Cloud is a modern analytics and data platform built on the same software engine as QlikView and Qlik Sense Client-Managed and adds significant value to empower everyone in an organization to make better decisions daily. Qlik Cloud allows you to use one common platform for all users – executives, decision-makers, and analysts.
Navigation:
Migrating to Qlik Cloud can help your organization:
Q&A with Qlik: Qlik Sense Migration to Qlik Cloud
Articles relevant to migration and new Qlik Cloud users
This site provides you the tools to monitor, manage, and execute a migration from Client-Managed Qlik Sense to Qlik Cloud.
Index and home
Planning your migration
Setting up the Qlik Cloud migration tools
Create and configure a cloud tenant
This site provides you the tools to begin your journey to move from QlikView to Qlik Sense and Qlik Cloud.
This article explains how a reload task chain can be built that will run longer than the maximum automation run limit of 4 hours.
This is an advanced article, if you’re new to automations or task chaining, I suggest you first read this basic article.
Content:
The maximum run time of an automation is 4 hours. This can be a problem when you want to build a task chain of multiple reloads of big apps that could take longer than that. To solve this, we'll build a system of two automations that run together:
Automation 1: Task Chain Initiator, this automation will run once and start the task chain. It will trigger the first app reloads.
Automation 2: Task Chain Manager, this automation will be scheduled to run every 5 minutes. It will verify if any reloads have finished, whether they were successful and if any new reloads should be triggered.
The Task Chain Manager automation will need to know which reloads were triggered by the Task Chain Initiator and will need a way to store which reloads it already processed in previous runs. In other words: these automations need some sort of state to track the progress of the reload task chain. We’ll use Google Sheets for this, but of course, feel free to use any other cloud storage tool.
The state will be stored in one file and divided over 4 sheets. Go ahead and create a new file in Google Sheets.
Sheet 1: Apps for initial reload, this sheet contains the ids and names of the apps that should be reloaded in the first automation. They will be executed by the Reload Initializer automation and run in parallel. Add a new sheet to the file you created, give it the name “Apps for initial reload” and add each app's id and name as in the below example. The order of the apps in the sheet is ignored.
Sheet 2: Queued reloads, this sheet will keep track of which apps were already triggered for reloading.
Add the sheet to the file and name it “Queued reloads” but don’t fill in any fields, the content of the sheet is autogenerated by the automations.
Sheet 3: Finished reloads, this sheet keeps track of all reloads that have finished, it contains their id, name, the status of the reload, and the reload log. Add the sheet to the file and name it “Finished reloads” but don’t fill in any fields, the content of the sheet is autogenerated by the Task Chain Manager automation.
Sheet 4: Chained reloads, this sheet dictates which apps should be reloaded after certain apps finished reloading. Add a new sheet to the file and name it “Chained reloads” specify the order in which apps should be executed.
The order of the rows in the sheet is ignored, the sheet is processed as follows:
If a reload has finished for an app from column “First_id”, then trigger a new reload for the app that’s specified in the column “Next_id” on the same row.
Add this sheet to the file and specify the apps as in the example below:
This automation will only run once at the beginning of the full task chain process, it will execute the following steps:
Note: an export of this automation is attached to this article as a JSON file named "Task chain initiator.json".
This automation will run on a schedule and will be the engine of our task chain process. Feel free to adjust the schedule according to your needs. On each run of the automation, the following steps will be executed:
Note: an export of this automation is attached to this article as a JSON file named "Task chain manager.json".
The reloads in the Finished reloads sheet will look like this:
When scheduled every 5 minutes, the "Task Chain Manager" automation will generate 288 daily runs. This bonus paragraph explains how the number of total runs can be reduced. Instead of having an automation that has many executions that run short, we'll build an automation that has only a few executions that run for a longer time.
The information in this article is provided as-is and to be used at your own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.
How to task chaining with Qlik Application Automation
How to import and export automations
Some customers might have Spaces associated with deactivated Forts. Since those Spaces contain apps, it's not possible to delete them.
qlik item ls --spaceId SPACEID
qlik item rm 634682a8cc899cfd5b95ac43 (REPLACE THE ID)
Qlik Catalog Install Error:
PostgreSQL psql not found when launching Catalog
The issue is typically caused by insufficient internet access. This leads to the automatic install failing as it is unable to download the required files.
You are seeing a large number of tasks failing.
When checking your QlikView Distribution Service logs you can see issues to open files.
Example:
20220316T134429.704+0000 Error: Cannot open file: '\\qlikview.domain.local\Qlikview\QlikViewStorage\Reporting\QVD\2021\xyz.qvd' (System error: Failed to open file in write mode for file: \\qlikview.domain.local\Qlikview\QlikViewStorage\Reporting\QVD\2021\xyz.qvd)
When checking for the QVD on its network location you can observe a size at 0 KB
QlikView April 2020 SR3 (12.50)
To troubleshoot this issue please follow these steps:
If Qlik Catalog is running on a virtual machine, the easiest way to create a reliable backup is to pause the VM and take a snapshot.
If Qlik Catalog is not run on a virtual machine, or snapshots do not meet your requirements, then the following three resources need to be manually backed up (and consequently restored):
The Qlik Sense installer fails with an error describing to call Qlik Support or to instead perform a silent installation.
The Qlik Sense Installation logs show:
Unexpected error during configuration: System.AggregateException: One or more errors occurred. ---> System.Management.ManagementException: Invalid class
Qlik Sense Enterprise on Windows
Microsoft Windows 2012 to 2016
The note to contact Qlik Support is misleading. The issue is caused by a corrupt repository for the WMI (Windows Management Instrumentation).
For information on how to resolve this issue, see winmgmt - Win32 apps | Microsoft Learn
You can verify the integrity of your Windows OS files by running sfc /scannow in a command prompt. This may lead to further information about any required repairs.
A corrupt repository for the WMI (Windows Management Instrumentation). There are several way to confirm if this is in fact the problem:
If the above steps didn't solve your problem there is an alternative solution by creating the batch file below. This one will reset your current WMI configuration, and generate a new one after a system reboot. This also worked in cases where the above check under point 2b sends the response Repository is consistent but Qlik Sense would still not install.
on
cd /d c:\temp
if not exist %windir%\system32\wbem goto TryInstall
cd /d %windir%\system32\wbem
net stop winmgmt
winmgmt /kill
if exist Rep_bak rd Rep_bak /s /q
rename Repository Rep_bak
for %%i in (*.dll) do RegSvr32 -s %%i
for %%i in (*.exe) do call :FixSrv %%i
for %%i in (*.mof,*.mfl) do Mofcomp %%i
net start winmgmt
goto End :FixSrv
if /I (%1) == (wbemcntl.exe) goto SkipSrv
if /I (%1) == (wbemtest.exe) goto SkipSrv
if /I (%1) == (mofcomp.exe) goto SkipSrv
%1 /Regserver
:SkipSrv
goto End
:TryInstall
if not exist wmicore.exe goto End
wmicore /s
net start winmgmt
:End
To start it save the block above as cleanwmi.bat in e.g. C:\temp\ and run the script as an administrative user. If its finished please reboot the machine.
Qlik offers a range of opportunities to assist you in troubleshooting, answering frequently asked questions, and contacting our experts. In this article, we guide you through all available avenues to secure your best possible experience.
For details on our terms and conditions, review the Qlik Support Policy.
Index:
We're happy to help! Here's a breakdown of resources for each type of need.
Support | Professional Services (*) | |
Reactively fixes technical issues as well as answers narrowly defined specific questions. Handles administrative issues to keep the product up-to-date and functioning. | Proactively accelerates projects, reduces risk, and achieves optimal configurations. Delivers expert help for training, planning, implementation, and performance improvement. | |
|
|
(*) reach out to your Account Manager or Customer Success Manager
Your first line of support: https://community.qlik.com/
Looking for content? Type your question into our global search bar:
Leverage the enhanced and continuously updated Knowledge Base to find solutions to your questions and best practice guides. Bookmark this page for quick access!
Subscribe to maximize your Qlik experience!
The Qlik Design Blog
The Design blog is all about product and Qlik solutions, such as scripting, data modelling, visual design, extensions, best practices, and more! (click)
The Product Innovation Blog
By reading the Product Innovation blog, you will learn about what's new across all of the products in our growing Qlik product portfolio. (click)
The Support Updates Blog
The Support Updates blog delivers important and useful Qlik Support information about end-of-product support, new service releases, and general support topics. (click)
Q&A with Qlik
Live sessions with Qlik Experts in which we focus on your questions).
Techspert Talks
Techspert Talks is a free webinar to facilitate knowledge sharing held on a monthly basis.
Qlik Fix
Qlik Fix is a series of short video with helpful solutions for Qlik customers and partners.
Suggest an idea, and influence the next generation of Qlik features!
Search & Submit Ideas
Ideation Guidelines
Get the full value of the community.
Register a Qlik ID:
Incidents are supported through our Chat, by clicking Contact Support on any Support Page across Qlik Community.
To raise a new issue, all you need to do is chat with us. With this, we can:
How to create a case using chat
Log in to manage and track your active cases in Manage Cases. (click)
Your advantages:
If you require a support case escalation, you have two options:
A collection of useful links.
Qlik Cloud Status Page
Keep up to date with Qlik Cloud's status.
Support Policy
Review our Service Level Agreements and License Agreements.
Live Chat and Case Portal
Your one stop to contact us.
A Qlik Replicate DB2 z/OS task may stop/fail with the following message:
[SOURCE_CAPTURE ]W: R4DB2: ALL CB ENTRIES ARE IN USE
This 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. The task will not be able to start unless the MAXSESSIONS setting is increased to allow more than 32 R4Z sessions to start. One temporary solution is to stop some other tasks that are unnecessary to have running at the moment. Another possible long-term solution is to implement LOGSTREAM tasks to reduce the number of sessions being created on the mainframe. Below are the steps to resolve this issue by increasing the total number of sessions.
All versions of Qlik Replicate using R4Z
UDTF: 'XXX.your_R4Z_UDTF__CDC1' <<< Your UDTF's CDC server environemnt CDC1, CDC2, DB2T, DB2P as examples.
APPLENV: 'XXX.your_R4Z_APPLENVF__CDC1' <<< Your APPLENV 's CDC server environment CDC1, CDC2, DB2T, DB2P as examples.
March 14th 2023: You may have upgraded Qlik Sense and located a warning banner in your Management Console stating that this version of PostgreSQL is not supported. If you are running a standalone PostgreSQL database later than 9.6, this message can be disregarded. We are working on resolving the underlying cause.
In this article, we walk you through the requirements and process of how to upgrade an existing Qlik Sense Repository Database from PostgreSQL 9.6 to PostgreSQL 12.5 (see supported scenarios) or install a brand new Repository based on PostgreSQL 12.5.
We will use the Qlik PostgreSQL Installer (QPI).
For a manual method, see: How to manually upgrade the bundled Qlik Sense PostgreSQL version to 12.5 version
PostgreSQL 9.6 has reached End of Life Reference: PostgreSQL Versioning Policy.
Download the installer here.
Qlik PostgreSQL installer version 1.2.1 Release Notes
Before using the Qlik PostgreSQL Installer, upgrade to a supported version of Qlik Sense Enterprise on Windows. Then use the Qlik PostgreSQL Installer to upgrade PostgreSQL.
We tested and validated Qlik Sense Enterprise on Windows from February 2022 to February 2023. Note that November 2022 and later do not support 9.6, and a warning will be displayed during the Sense upgrade.
Qlik Sense Enterprise on Windows installations other than in C:\Program Files\Qlik\Sense are currently not supported.
If the upgrade was unsuccessful and you are missing data in the Qlik Management Console or elsewhere, contact Qlik Support.
No further steps are needed unless you plan to upgrade Qlik Sense Enterprise on Windows to the next major release. If you plan to upgrade to, for example, November 2022, the old Qlik Sense Repository Database service must be removed from the server.
Perform the following steps to delete the Qlik Sense Repository Database Service:
This version of the upgrade tool is fully compatible with the official PostgreSQL installers from https://www.enterprisedb.com/downloads/postgres-postgresql-downloads.
If you need to upgrade to a higher release than Qlik provides, you can install the same minor PostgreSQL release 12.x.
The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support. The video in this article was recorded in a earlier version of QPI, some screens might differ a little bit.
Qlik PostgreSQL installer version 1.2.1 Release Notes
Techspert Talks - Upgrading Qlik Sense Repository Service
Backup and Restore Qlik Sense Enterprise documentation
Migrating Like a Boss
Optimizing Performance for Qlik Sense Enterprise
Qlik Sense Enterprise on Windows: How To Upgrade Standalone PostgreSQL
How-to reset forgotten PostgreSQL password in Qlik Sense
How to configure Qlik Sense to use a dedicated PostgreSQL database
Troubleshooting Qlik Sense Upgrades
This article shows how to generate a report from a Qlik Sense app, upload the report to any cloud storage platform, create a sharing link, and send out an email with the link in the body.
We can send the report as an attachment using the Send Mail block in the Mail connector, but this block only supports attachments of size 40MB. An alternative solution is to store reports in any of the cloud storage platforms that support the creation of sharing links and send emails with the links.
I will go through a few examples to show how this can be achieved using the following cloud storage connectors:
I will not go through the steps on how to generate the report using Qlik Reporting blocks as it's already explained in this article.
The four automation files used in the examples are attached to this article. More information on importing automations can be found here.
The following steps explain how to create a public URL using the Dropbox connector.
The following steps explain how to create a public URL using the Microsoft OneDrive connector.
The following steps explain how to create a public URL using the Microsoft SharePoint connector.
Amazon S3
The following steps explain how to create a public URL using the Amazon S3 connector.
Qlik AutoML is a tool within Qlik Cloud where you can quickly train and deploy models, and the make predictions against said models. In this article, we address best practices for preparing training datasets for ML experiments and/or apply datasets for generating predictions.
We will continue to update this list as we encounter other issues related to data used in Qlik AutoML.
The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.
If you require further details on an error code or if you encounter error codes we do not have listed, please contact support. We will investigate further.
Authentication and authorization with the Microsoft Excel Connector in Qlik Application Automation works through oAuth2. When a user attempts to connect a Microsoft Excel datasource, the user will be redirected to the Microsoft login page where a user is prompted to give permission for Qlik Application Automation to access their Office 365 tenant.
The following scopes are being requested by Qlik Application Automation:
The Microsoft Excel connector has blocks available to perform actions on worksheets, data inside worksheets and tables inside worksheets. When working with data, we always recommend to work with tables rather than data on the worksheet due to ease of use.
This block obtains values from an excel file worksheet from a specified range. The following input parameters are used:
The block returns a double nested array. The first level contains a row, the second level contains the value of a column in that row.
The same block also exists for working with tables. Here the start cell and end cell are replaced by a Table ID.
With the block Add Worksheet to Excel File a user can add a new worksheet to an Excel document. It takes the following input parameters:
Using the block Update Rows in Excel Sheet you can specify a range in which you want to overwrite existing data. The following input parameters are required:
Using the block Create Excel Table With Headers a user can create a table in Excel. Using the block Add Table to Excel File Worksheet a user can also create a table without headers. The following input parameters are being requested:
Aside from creating a table, we can also delete is by the use of the Delete Table from Excel File Worksheet block. This requires an item ID, worksheet and Table ID.
Two blocks serve to find a matching row in an Excel Table. These blocks are Find Row in Excel Worksheet Table and Find Rows in Excel Worksheet Table. The first one will only return the first row found, the second one will return all rows found matching these criteria. The following input parameters are required:
Functionality to share workbooks is not included in the Microsoft Excel connector. These actions can be done using the Microsoft Onedrive or Sharepoint connector.
The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.
Loading data from Oracle may fail on a full load with the error:
ORA-01555: snapshot too old: rollback segment number string with name "string" too small
This is an Oracle configuration issue which must be resolved for the task to be able to continue.
In Automatic Undo Management mode, increase the setting of UNDO_RETENTION. Otherwise, use larger rollback segments.
You can verify your current settings:
SHO PARAMETER UNDO;
SELECT SUM(BYTES)/1024/1024 "MB", TABLESPACE_NAME FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME
Verify how large the problematic table is and what the current settings are. Then increase the sizes as per your findings.
Oracle references:
http://www.dba-oracle.com/t_ora_01555_snapshot_old.htm
https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:275215756923
http://www.dba-oracle.com/oracle_tips_rollback_segments.htm
It caused by rollback records needed by a reader being overwritten by other writers.
The message may be shown despite of the user having been allocated a license.
In Qlik Sense June 2019 and later, an additional version of the error message was introduced, indicating when a user has reached their maximum allowed concurrent sessions:
* See You cannot access Qlik Sense because you have no access pass - intermittent problem.
Environment:
Qlik Sense Enterprise on Windows
Verify if the user has a license assigned.
For Signed License Keys this could be a:
For licenses still using Tokens, this could be a:
Solution:
Assign a License or ensure you have sufficient Capacity minutes
This often occurs when a user is being assigned a license or token based on an active directory group, and has not yet been synchronized. The license check for user-based licenses (professional and analyzer) and tokens occurs when you access the hub.
If you access the hub without a license and subsequently are assigned a token or professional or analyzer access, the license check has already occurred, and you will get a "no access pass" error, stopping you from interacting with apps. Log out and log in again for the license to be recognized.
Solution:
If a signed license key cannot be verified with the license backend for 5 days, licenses will be disabled.
The below log entities can be found from Licenses Log
{"caller":"handler.go:61","level":"info","message":"invalid license error, license verification error: lic is stale","res.errorType":"licenses.InvalidLicenseError","res.statusCode":403,"timestamp":xxxxxx"}
Or:
{"caller":"sync.go:290","corrId":"26ab589a897f6e56:26ab589a897f6e56:0:1","level":"info","licenseNumber":"XXXXXXXX","message":"re-syncing assignments with the backend","timestamp":"2020-01-20T08:13:32.7038396Z"}
{"caller":"handler.go:44","corrId":"35b5cbb055734329:35b5cbb055734329:0:1","errorMessage":"Too much time has passed since the last license update","errorType":"LICENSES-OutdatedLicense","level":"info","statusCode":403,"timestamp":"2020-01-20T08:13:32.7438444Z"}
Verify that the Qlik Sense server has an active internet connection and that connectivity to license.qlikcloud.com on port 443 is possible from the server running the Qlik Sense licensing service.
See Using a Qlik signed license in an offline environment for details.
Solution:
The license will be refused as it's an incorrect one. This action will force the license synchronization.
During the conversion, the client has to prepare and switch the users from tokens to professional/analyzer licenses.
After this conversion date, a periodic cleanup of tokens in the backend license server will occur. If this clean up happens and an admin has not finished the conversion, all tokens will be removed from the users. The result will be the 'no access pass' message.
Solution:
Allocate new professional analyzer licenses according to the conversion plan.
A log stream from SQL was being loaded into Microsoft Azure Databricks Delta Target, but the process failed. The error occurred during a full load of a table:
00007080: 2023-02-20T19:32:08 [TARGET_LOAD ]E: Failed (retcode -1) to execute statement: 'COPY INTO `raw_iso_les`.`text_translation` FROM(SELECT cast(_c0 as INT) as `TextID`, cast(_c1 as INT) as `LanguageID`, _c2 as `Micro`, _c3 as `Short`, _c4 as `Medium`, _c5 as `Extended`, _c6 as `Text`, _c7 as `MicroAudioURL`, _c8 as `ShortAudioURL`, _c9 as `MediumAudioURL`, _c10 as `LongAudioURL`, _c11 as `TextAudioURL`, _c12 as `SmallIconURL`, _c13 as `MediumIconURL`, _c14 as `LargeIconURL`, cast(_c15 as INT) as `OrgChecksum`, cast(_c16 as INT) as `CustChecksum`, cast(_c17 as INT) as `ReferenceID`, cast(_c18 as TIMESTAMP) as `LastUpdateOn`, _c19 as `LastUpdatedBy`, cast(_c20 as TIMESTAMP) as `CreatedOn`, _c21 as `CreatedBy`, cast(_c22 as BOOLEAN) as `Active`, cast(_c23 as TIMESTAMP) as `LastDeleteOn`, _c24 as `LastDeletedBy`, cast(_c25 as TIMESTAMP) as `LastReactivateOn`, _c26 as `LastReactivatedBy`, cast(_c27 as INT) as `ArchiveID`, cast(_c28 as TIMESTAMP) as `LastArchiveOn`, _c29 as `LastArchivedBy`, cast(_c30 as TIMESTAMP) as `LastRestoreOn`, _c31 as `LastRestoredBy`, cast(_c32 as INT) as `RowVersionStamp` from 'abfss://XXXX') FILEFORMAT = CSV FILES = ('/X/X/X/X/12/X.csv.gz') FORMAT_OPTIONS('nullValue' = 'attrep_null', 'multiLine'='true') COPY_OPTIONS('force' = 'true')' [1022502] (ar_odbc_stmt.c:4906)
00007080: 2023-02-20T19:32:08 [TARGET_LOAD ]E: RetCode: SQL_ERROR SqlState: HY000 NativeError: 35 Message: [Simba][Hardy] (35) Error from server: error code: '0' error message: 'org.apache.hive.service.cli.HiveSQLException: Error running query: org.apache.spark.SparkException: Job aborted due to stage failure: Task 0 in stage 3805190.0 failed 4 times, most recent failure: Lost task 0.3 in stage 3805190.0 (TID 32173534) (10.139.64.145 executor 2621): com.univocity.parsers.common.TextParsingException: java.lang.ArrayIndexOutOfBoundsException - 20480
Identified line separator characters in the parsed content. This may be the cause of the error. The line separator in your parser settings is set to '[lf]'. Parsed content: ... [1022502] (ar_odbc_stmt.c:4913)
00007080: 2023-02-20T19:32:08 [TARGET_LOAD ]E: Failed to copy data of file x\x.csv to database [1022502] (cloud_imp.c:6497)
To resolve the issue, the user updated Qlik Replicate to the November 2022 version and reloaded the table. This will resolve the current issue and prevent the table from failing again in the future.
Qlik Replicate
Microsoft Azure Databricks Delta Target
To connect to Snowflake using ODBC with keypair authentication, you can use the following connection string format:
Driver={SnowflakeDSIIDriver};Server=<account_name>.<region_name>.snowflakecomputing.com;User=<username>;PrivateKey=<path_to_private_key>;Db=<database_name>;Schema=<schema_name>
Each part of the connection string represents:
Note that you may also need to include additional connection parameters, such as Warehouse, Role, and SSL. Here's an example connection string that includes these parameters:
Driver={SnowflakeDSIIDriver};Server=<account_name>.<region_name>.snowflakecomputing.com;User=<username>;PrivateKey=<path_to_private_key>;Db=<database_name>;Schema=<schema_name>;Warehouse=<warehouse_name>;Role=<role_name>;SSL=on
Replace the placeholders in the connection string with the appropriate values for your Snowflake account and keypair authentication setup.
Qlik Replicate
Snowflake Target
Due a product defect, users deleted in mid-March 2023 might still keep a license assigned to them.
The issue was solved on March 21st, and deleting users correctly deallocates licenses.
Qlik is working on finding a solution for removing licenses still allocated to users that were deleted during this period for both Qlik Sense Enterprise and Qlik Sense Business subscriptions.
To speed up things, customers on Qlik Sense Enterprise can import and run the attached automation.