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.
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
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.
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.
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
Qlik Sense offers a range of Monitoring Applications that come pre-installed with the product. This article aims to provide information on where to find information about them or where to download them.
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.
How can I track the usage of my Tenant over time? How are my entitled users using the Tenant?
How can I better understand the usage of Analyzer Capacity vs. Analyzer & Professional Entitlements?
These are a couple of the questions we frequently hear. To enable you to find better answers for those, we are happy to share with you the new Entitlement Analyzer for Qlik Sense Enterprise SaaS!
For more information and to download the app and usage instructions, see The Entitlement Analyzer for Qlik Sense Enterprise SaaS customers is available NOW!
These are a couple of the questions that you can answer with the App Analyzer.
For more information and to download the app and usage instructions, see The App Analyzer for Qlik SaaS customers is available NOW!
“How can I monitor reloads across the tenant?”
“How can I see what data connections and files are being used?”
“How can I view reload concurrency and peak reload RAM over time?”
These are a few of the questions we frequently hear. To enable you to find better answers for those, we are happy to share with you the new Reload Analyzer for Qlik SaaS!
For more information and to download the app and usage instructions, see The Reload Analyzer for Qlik SaaS customers is available NOW!
“What users and groups have access to space <X>?”
“What users and groups have access to app <X>?”
“How does a user have access to app <X>; via direct assignment, group, or app share?”
“Are there redundancies in policies? E.g., does a user have the same access to a space via a direct assignment as well as a group?”
“Who has what roles across the tenant?”
These are a few of the questions we frequently hear. To enable you to find better answers for those, we are happy to share with you the new Access Evaluator for Qlik SaaS!
For more information and to download the app and usage instructions, see New Monitoring App for Qlik Cloud: Access Evaluator
The OEM Dashboard is an application for Qlik Cloud designed for OEM partners to centrally monitor data across their customers’ tenants. It provides a single pane to review numerous dimensions and measures, compare trends, and quickly spot issues across many different areas—which would otherwise be a tedious process. This application includes data from the App Analyzer, Entitlement Analyzer, and the Reload Analyzer, all of which are other monitoring applications for Qlik Cloud that provide deep levels of detail on their respective areas. Together, a complete picture can be formed which is crucial to the successful management of an OEM environment.
For more information and to download the app and usage instructions, see OEM Dashboard - Qlik Cloud Application.
This monitoring app presents various information on the Qlik Application Automation usage in the current tenant.
For more information and to download the app and usage instructions, see How to: automation monitoring app for tenant admins with Qlik Application Automation
The Operations Monitor loads service logs to populate charts covering performance history of hardware utilization, active users, app sessions, results of reload tasks, and errors and warnings. It also tracks changes made in the QMC that affect the Operations Monitor.
The License Monitor loads service logs to populate charts and tables covering token allocation, usage of login and user passes, and errors and warnings.
For a more detailed description of the sheets and visualizations in both apps, visit the story About the License Monitor or About the Operations Monitor that is available from the app overview page, under Stories.
Basic information can be found here:
The License Monitor
The Operations Monitor
Both apps come pre-installed with Qlik Sense.
If a direct download is required: Sense License Monitor | Sense Operations Monitor. Note that Support can only be provided for Apps pre-installed with your latest version of Qlik Sense Enterprise on Windows.
The App Metadata Analyzer app provides a dashboard to analyze Qlik Sense application metadata across your Qlik Sense Enterprise deployment. It gives you a holistic view of all your Qlik Sense apps, including granular level detail of an app's data model and its resource utilization.
Basic information can be found here:
App Metadata Analyzer (help.qlik.com)
For more details and best practices, see:
App Metadata Analyzer (Admin Playbook)
The app comes pre-installed with Qlik Sense.
Looking to discuss the Monitoring Applications? Here we share key versions of the Sense Monitor Apps and the latest QV Governance Dashboard as well as discuss best practices, post video tutorials, and ask questions.
System Performance Analyzer
Sessions Monitor, Reloads-Monitor, Log-Monitor
Connectors Log Analyzer
Qlik Replicate tasks error out, and tables are suspended.
RetCode: SQL_ERROR SqlState: 22007 NativeError: 100035 Message: Timestamp '0000-00-00 00:00:00.000000' is not recognized Failed (retcode -1) to execute statement: 'INSERT INTO "XXXXX_CTRL"."public_refer__ct"
Qlik Replicate
Snowflake Endpoint
'0000-00-00 00:00:00' is not a valid timestamp in Snowflake. A transformation will need to be added to change this to your desired value.
Here is an example, in this case we are replacing the timestamp to '1970-01-01 00:00:00':
coalesce(
CASE WHEN substr($AR_M_SOURCE_COLUMN_DATA,1,4) = '0000'
THEN '1970-01-01 00:00:00'
WHEN substr($AR_M_SOURCE_COLUMN_DATA,1,4) = ''
THEN '1970-01-01 00:00:00'
ELSE
$AR_M_SOURCE_COLUMN_DATA
END
,$AR_M_SOURCE_COLUMN_DATA)
Update operations to the Nvarchar(max) data types will cause the values to become 'NULL' values when the target is Microsoft Azure SQL Database.
Qlik Replicate 2021.11.0.165
Microsoft Azure SQL Database
The behavior was resolved in Replicate 2022.11.0.475
Upgrade to Qlik Replicate sp03-2022.11.0.475 or later.
Case 00072614
Working with an Amazon RDS for Oracle endpoint as a source, we might encounter an issue where CDC doesn't start and fails with the following error:
Cannot create Oracle directory name 'ATTUREP_XXXXXX_XXX' with path '/XXXXX/log/arch'
This is because of undocumented access request required which is not available in the User Guide yet. We have to execute the following grant statements to provide read only access to Qlik user to the online and archive redo logs:
grant read on directory ONLINELOG_DIR to qlik;
grant read on directory ARCHIVELOG_DIR to qlik;
or
exec rdsadmin.rdsadmin_util.grant_sys_object('ONLINELOG_DIR','QLIK','READ');
exec rdsadmin.rdsadmin_util.grant_sys_object('ARCHIVELOG_DIR','QLIK','READ');
Where qlik/QLIK is the user specified in the source endpoint connection.
The Apply Exceptions table is a Qlik Replicate Control Table created on the target endpoint when the corresponding table is selected in the Control Tables tab.
You may notice that you cannot turn off the Apply Exceptions in the Qlik Replicate control table settings. The option to do so is greyed out and cannot be unchecked. See img 01.
img 1
Change Processing errors are recorded in the attrep_apply_exceptions
table. The data in this table is never deleted. For more information on the Apply Exceptions table please review attrep_apply_exceptions.
Additional tables and data take up space and resources in the database, so some people prefer to opt out of having this table for a Replicate task. This can be done with some additional configuration.
"common_settings": {
"support_lobs": false,
"change_table_settings": {
"handle_ddl": false,
"header_columns_settings": {
}
},
"full_load_enabled": false,
"audit_table_settings": {
},
"dr_settings": {
},
"statistics_table_settings": {
},
"bidi_table_settings": {
},
"task_uuid": "c24fe2e3-9d04-334c-80c4-35f4b349f9e4",
"status_table_settings": {
},
"status_table_enabled": true,
"suspended_tables_table_settings": {
},
"suspended_tables_table_enabled": true,
"history_table_settings": {
},
"history_table_enabled": true,
"exception_table_settings": {
},
"recovery_table_settings": {
},
"data_batching_settings": {
},
"data_batching_table_settings": {
},
"log_stream_settings_depricated": {
},
"ddl_history_table_settings": {
},
"customized_charset_settings": {
"validation": {
"sub_char": 0
}
}
}
},
"common_settings": {
"exception_table_enabled": false,
"support_lobs": false,
"change_table_settings": {
"handle_ddl": false,
"header_columns_settings": {
}
},
"full_load_enabled": false,
"audit_table_settings": {
},
"dr_settings": {
},
"statistics_table_settings": {
},
"bidi_table_settings": {
},
"task_uuid": "c24fe2e3-9d04-334c-80c4-35f4b349f9e4",
"status_table_settings": {
},
"status_table_enabled": true,
"suspended_tables_table_settings": {
},
"suspended_tables_table_enabled": true,
"history_table_settings": {
},
"history_table_enabled": true,
"exception_table_settings": {
},
"recovery_table_settings": {
},
"data_batching_settings": {
},
"data_batching_table_settings": {
},
"log_stream_settings_depricated": {
},
"ddl_history_table_settings": {
},
"customized_charset_settings": {
"validation": {
"sub_char": 0
}
}
}
},
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.
Getting data out of Qlik Sense Enterprise SaaS, and distributing it to different users in formatted Excel, has been a manual task until now.
Thanks to the release of Qlik Application Automation, it is now possible to automate this workflow by leveraging the connectors for Office 365 - specifically Microsoft SharePoint and Microsoft Excel.
Here I share two example Qlik Application Automation workspaces that you can use and modify to suit your requirements.
Video:
Note - These instructions assume you have already created connections as required in Example 1.
This On-Demand Report Automation can be used across multiple apps and tables. Simply copy the extension object between apps & sheets, and update the Object ID (Measure 3) for each instance.
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 Qlik Replicate server service in Windows used to be named Attunity Replicate Server.
This name has changed to Qlik Replicate Server. The change was introduced in the 2022.11 release.
If you are running a Windows Cluster and are monitoring Qlik Replicate through it, or if you have deployed third-party applications monitoring the service uptime, these applications must be modified to look for the correct service name.
2021.11 and later
All on-premise Qlik Products can be downloaded from Qlik's Product Download Site.
To access the Download Site, you need an active QlikID. You will be able to see all products your account is eligible for.
If you encounter issues with the download site, start a chat with us and we will be able to help you right away.
You can access the Download Page directly here, or navigate to it from the Community Home page:
This shows the download page with the Latest release and patch preselected.
Alternatively, instead of selecting your product directly, you can also search all available columns:
Click here for video transcript