Does a Qlik Sense pivot table have a hard limit on its dimensions and measures?

Answer

Qlik Sense pivot tables have a limit of 1000 measures and 1000 dimensions. 

Approaching this limit is not recommended. Managing measures and dimensions of this volume will become difficult and impractical.

Environment

• Qlik Cloud Analytics
• Qlik Sense Enterprise on Windows

When you need to integrate auth0 JWT Bear Token auth with Talend tRestRequest component, it is possible to use JWT Bearer Token with Keystore Type : Java Keystore *.jks to achive this.

How To

Please follow the some similar steps from Obtaining a JWT from Microsoft Entra ID | Qlik Help

1. Open https://dev-xxxx.us.auth0.com/.well-known/jwks.json in a Web browser.
   Reference: json-web-key-sets| auth0.com 
2. Copy the String value from the x5c field of the matched key and save it to a text file.
   Convert the text file to an talend-esb.cer file, for example:

   -----BEGIN CERTIFICATE-----
   MGLqj98VNLoXaFfpJCBpgB4JaKs
   -----END CERTIFICATE-----

3. Import this trusted key into your keystore JKS using Java keytool.

   keytool -import -keystore talend-esb.jks -storepass changeit -alias talend-esb talend-esb.cer -noprompt

4. Use this talend-esb.jks in tRestRequest with the following configurations

   Security: JWT Bearer Token
   Keystore File: /path_to/talend-esb.jks
   Keystore Password : changeit
   Keystore Alias : talend-esb
   Audience: "https://dev-xxxx.us.auth0.com/api/v2/"

5. Use the bear token fetched from  https://dev-xxxx.us.auth0.com/oauth/token to send request to tRestRequest defined endpoint for testing.

Environment

• Talend Studio 
• Talend ESB 

Integration fails with the following error:

tap - CRITICAL 'search_prefix'
tap - Traceback (most recent call last):
tap - File "/code/tap-env/bin/tap-s3-csv", line 10, in <module>
tap - sys.exit(main())
tap - ^^^^^^
tap - File "/code/tap-env/lib/python3.12/site-packages/singer/utils.py", line 235, in wrapped
tap - return fnc(*args, **kwargs)
tap - ^^^^^^^^^^^^^^^^^^^^
tap - File "/code/tap-env/lib/python3.12/site-packages/tap_s3_csv/__init__.py", line 81, in main
tap - config['tables'] = validate_table_config(config)
tap - ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
tap - File "/code/tap-env/lib/python3.12/site-packages/tap_s3_csv/__init__.py", line 63, in validate_table_config
tap - table_config.pop('search_prefix')
tap - KeyError: 'search_prefix'
main - INFO Tap exited abnormally with status 1
main - INFO No tunnel subprocess to tear down
main - INFO Exit status is: Discovery failed with code 1 and error message: "'search_prefix'". 

Resolution

Improving the integration to gracefully handle the missing key when an update to the connection/config occurs is currently on the roadmap. The R&D team is working on this behavior and a minor version upgrade is expected down the line; however, there is currently no ETA.

If you encounter this error with your AWS S3 CSV integration, please reach out to Qlik Support for further assistance.

Cause

The issue occurs due to missing keys in the configuration. Specifically, an update to the connection settings removed or modified the search_prefix, resulting in the key being absent from the config expected by the integration.

Environment

• Stitch 

The following IBM mainframe error occurs with the ARC CDC Solutions endpoint when the wrong ARC installation files are used:

Daemon (ATTDAEMN): 09.30.44 STC06957 ASTB1001E CDC library provided in STEPLIB but ATYLIB DD card missing - no CDC 09.30.44 STC06957 ASTB1012E ERROR=ABEND in effect 

Sp15-620271-ARC-mvs.zip is confirmed to be the full patch while ARC_620271_mvs.zip is a partial patch.

Resolution

Use ARC installation files that have SP prefixes in the file name.

Cause

ARC installation files without the SP prefixes are partial installation files that may not contain all the components that you need.

Environment

• Qlik Replicate

The measure value is suddenly not displayed correctly, but it started to show null value instead. It used to show a proper data until Nov 2024 release or earlier.

The issue is observed when:

• Measures have no aggregation function (such as SUM(), COUNT())
• Fields include only one data and null value

Environment

• Qlik Cloud (at documentation)
• Qlik Sense Enterprise on Windows May 2025 and November 2025

Resolution

QCB-33031 will be fixed in Qlik Cloud at the first opportunity. Qlik Sense Enterprise on Windows will have the fix introduced in the next major release in 2026.

Workaround One

Apply aggregation or Only() function to the affected measure.

Workaround Two

For Qlik Sense Enterprise on Windows, add the parameter UseTableEvaluatorWhenApplicable=0 to the Qlik Sense engine settings.ini file. The change must be done on all engines, if more than one is in use.

The setting indicates engine to use the old way to calculate the measures without aggregation. It is slower, but the behavior remains what it was back in Qlik Sense November 2024 and earlier.

See How to modify Qlik Sense Engine's Settings.ini for reference. 

Cause

The difference in behavior is due to an internal change in the Qlik Sense Engine introduced to improve performance.

Previously, when a measure was defined directly as a field without an aggregation, the Engine automatically applied the Only() function. This function returns a value if the field contains only a single distinct (non-null) value. 

See The importance of Only().

However, appending Only() function leads to slow performance. To optimize performance, the Engine now uses a more efficient calculation method. As a side effect, when a field contains one valid value and one null value, the result is returned as null instead of the expected value.

This issue has been identified as QCB-33031, and will be fixed to display the proper value instead of null in this scenario.

Internal Investigation ID(s)

QCB-33031

You may encounter this issue in which your Stitch integrations remain paused after your account has been renewed, reactivated after a 40-day inactivity pause | Qlik Stitch Documentation, or your account displays the error "You are over your current plan destination limit of 1. To continue loading data, remove any excess destinations or upgrade." 

Even though your account has been modified, the Stitch account itself has not fully updated and is preventing account activity.

Resolution

To resolve, please reach out to the Qlik Support team. They will be able to review your account if unpausing it will be possible or if you will need to discuss the status of your contract with your account management team.

Cause

The Stitch account is not capturing the changes to your billing and contract details.

Environment

• Stitch 

Google Ads extractions fail with:

tap - CRITICAL 504 Deadline Exceeded
tap - grpc._channel._InactiveRpcError: <_InactiveRpcError of RPC that terminated with:
tap - status = StatusCode.DEADLINE_EXCEEDED
tap - details = "Deadline Exceeded"
tap - debug_error_string = "UNKNOWN:Error received from peer {grpc_status:4, grpc_message:"Deadline Exceeded"}"
tap - >

main - INFO Exit status is: Discovery succeeded. Tap failed with code 1 and error message: "504 Deadline Exceeded". Target succeeded.

Resolution

This error is often transient and will not require any action to alleviate. If the error is persistent, review your Tables to Replicate and consider de-selecting unneeded tables or columns. If the issue remains, please reach out to Qlik Support to discuss your use-case and further review the integration settings.

Cause

The error "504 Deadline Exceeded" indicates that the extraction timed out due to a lack of response from the Google Ads API. By default, Stitch allows up to 15 minutes for a response before terminating the request.

Possible reasons the Google Ads API may exceed this threshold include:

• Large or complex queries: This can happen when Stitch issues requests with a wide date range, a large number of selected fields, or the source data has deeply nested data structures.
• Google Ads API Limits and Quotas| developers.google.com
• Network latency or backend delays: Delays between Stitch and Google Ads, or internal processing delays within Google Ads, can also contribute to timeouts.

Environment

Stitch 

Stitch Support frequently receives questions regarding the invocation of the PUBLIC role with Snowflake. When setting up a database user following Create a Stitch database and database user (Qlik Stitch Documentation), users will notice that the Stitch user executes GRANT statements on the PUBLIC role. This behavior can raise questions about role-based access and security implications within Snowflake.

Resolution

Manually adjust permissions in Snowflake as needed. If you prefer Stitch offers a more streamlined approach in its behavior, please submit a feature request. Refer to New Process for Submitting a Feature Request for All Talend Customers and Partners  on how to submit a feature request.

Cause

By default, Stitch grants the PUBLIC role access to schemas and objects it creates in Snowflake. This behavior often raises questions from users who are concerned about broad access permissions.

The reason Stitch does this is because it cannot assume which specific roles or users in your organization should have access to the data. Granting access to the PUBLIC role ensures that Stitch can write data successfully without making assumptions about your internal role structure.

This default behavior is not a requirement from Snowflake itself, but rather a design decision by Stitch to simplify initial setup and avoid permission-related sync failures.

If this approach does not align with your organization’s security policies, you may manually revoke access from the PUBLIC role after the initial sync. However, this step must be repeated each time a new integration runs or a new schema is created, which may not be scalable.

Snowflake supports granular permission control via the REVOKE command, allowing you to adjust access as needed:

🔗 REVOKE <privileges> … FROM ROLE | docs.snowflake.com

While this manual revocation process works, it requires ongoing attention. If tighter access control is a priority and manual intervention isn’t feasible, you may want to consider alternative destinations or workflows.

Environment

• Stitch 

Qlik Sense Enterprise Client-Managed offers a range of Monitoring Applications that come pre-installed with the product.

Qlik Cloud offers the Data Capacity Reporting App for customers on a capacity subscription, and additionally customers can opt to leverage the Qlik Cloud Monitoring apps.

This article provides information on available apps for each platform.

Content:

• Qlik Cloud
• Data Capacity Reporting App
• Access Evaluator for Qlik Cloud
• Answers Analyzer for Qlik Cloud
• App Analyzer for Qlik Cloud
• Automation Analyzer for Qlik Cloud
• Entitlement Analyzer for Qlik Cloud
• Reload Analyzer for Qlik Cloud
• Report Analyzer for Qlik Cloud
• How to automate the Qlik Cloud Monitoring Apps
• Other Qlik Cloud Monitoring Apps
• OEM Dashboard for Qlik Cloud
• Monitoring Apps for Qlik Sense Enterprise on Windows
• Operations Monitor and License Monitor
• App Metadata Analyzer
• The Monitoring & Administration Topic Group
• Other Apps

Qlik Cloud

Data Capacity Reporting App

The Data Capacity Reporting App is a fully supported app distributed within the product. For more information, see Qlik Help.

Access Evaluator for Qlik Cloud

For more information, see Qlik Cloud Access Evaluator.

Answers Analyzer for Qlik Cloud

For more information, see Qlik Cloud Answers Analyzer.

App Analyzer for Qlik Cloud

For more information, see Qlik Cloud App Analyzer.

Automation Analyzer for Qlik Cloud

For more information, see Qlik Cloud Automation Analyzer.

Entitlement Analyzer for Qlik Cloud

The Entitlement Analyzer is a Qlik Sense application built for Qlik Cloud, which provides Entitlement usage overview for your Qlik Cloud tenant for user-based subscriptions.

The app provides:

• Which users are accessing which apps
• Consumption of Professional, Analyzer and Analyzer Capacity entitlements
• Whether you have the correct entitlements assigned to each of your users
• Where your Analyzer Capacity entitlements are being consumed, and forecasted usage

For more information, see The Entitlement Analyzer.

Reload Analyzer for Qlik Cloud

For more information, see Qlik Cloud Reload Analyzer.

Report Analyzer for Qlik Cloud

For more information, see Qlik Cloud Report Analyzer.

How to automate the Qlik Cloud Monitoring Apps

Do you want to automate the installation, upgrade, and management of your Qlik Cloud Monitoring apps? With the Qlik Cloud Monitoring Apps Workflow, made possible through Qlik's Application Automation, you can:

1. Install/update the apps with a fully guided, click-through installer using an out-of-the-box Qlik Application Automation template. 
2. Programmatically rotate the API key that is required for the data connection on a schedule using an out-of-the-box Qlik Application Automation template. This ensures that the data connection is always operational. 
3. Get alerted whenever a new version of a monitoring app is available using Qlik Data Alerts. 

For more information and usage instructions, see Qlik Cloud Monitoring Apps Workflow Guide.

Other Qlik Cloud Monitoring Apps

OEM Dashboard for Qlik Cloud

For more information and to download the app and usage instructions, see Qlik Cloud OEM Dashboard & Console Settings Collector.

With the exception of the Data Capacity Reporting App, all Qlik Cloud monitoring applications are provided as-is and are not supported by Qlik. Over time, the APIs and metrics used by the apps may change, so it is advised to monitor each repository for updates and to update the apps promptly when new versions are available.

If you have issues while using these apps, support is provided on a best-efforts basis by contributors to the repositories on GitHub.

Monitoring Apps for Qlik Sense Enterprise on Windows

Operations Monitor and License Monitor

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. 

App Metadata Analyzer

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.

The Monitoring & Administration Topic Group

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.

Monitoring & Administration 

Other Apps

LogAnalysis App: The Qlik Sense app for troubleshooting Qlik Sense Enterprise on Windows logs 
Sessions Monitor, Reloads-Monitor, Log-Monitor 
Connectors Log Analyzer 

All Other Apps are provided as-is and no ongoing support will be provided by Qlik Support.

MySQL source tables with invisible columns crash a Qlik Replicate task on start. The following error is logged:

[INFRASTRUCTURE ]E: Process crashed with signal 11, backtrace: !{/opt/attunity/replicate/lib/at_base.so!4db3bd,/opt/attunity/replicate/lib/at_base.so!3a3938,/opt/attunity/replicate/lib/at_base.so!505053,/usr/lib64/libc.so.6!4e5b0,/opt/attunity/replicate/lib/libarepmysql.so!2b931,/opt/attunity/replicate/lib/libarepmysql.so!2e094,/opt/attunity/replicate/lib/libarepmysql.so!2e3c9,/opt/attunity/replicate/lib/libarepbase.so!4cecbb,/opt/attunity/replicate/lib/libarepbase.so!4d814e,/opt/attunity/replicate/lib/libarepbase.so!4681e2,/opt/attunity/replicate/lib/libarepbase.so!55fd36,/opt/attunity/replicate/lib/libarepbase.so!560108,/opt/attunity/replicate/lib/libarepbase.so!56b0ee,/opt/attunity/replicate/lib/libarepbase.so!5a1bca,/opt/attunity/replicate/lib/libarepbase.so!77d496,/usr/lib64/libpthread.so.0!81ca,/usr/lib64/libc.so.6!398d3,}! [1000100] (at_system_posix.c:575)

Resolution

This issue is caused by defect RECOB-10177. Future patches for Qlik Replicate will incorporate the handling of invisible columns for MySQL tables. 

Fix Version

2025.5 SP03 and newer versions.

Cause

Qlik Replicate could not handle invisible columns for the MySQL source.

Internal Investigation ID(s)

2025.5 SP03

Environment

• Qli Replicate

Qlik Sense Repository service will log performance counters, and set them up on startup. Unfortunately sometimes the base counters are corrupt so the start can't proceed.

The error in the logs:

fatal exception during startup Cannot load Counter Name data because an invalid index '' was read from the registry. at System.Diagnostics.PerformanceCounterLib.GetStringTable(Boolean isHelp)?? ? at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)?? [...] at System.Threading.ThreadHelper.ThreadStart() 3facc7ff-8275-4847-b3b7-338d32c4d1c5 its the repo checking the counter which doesn't exist

Qlik Sense April 2019 will log information including instructions to resolve the issue. See the related Release Notes for ID QLIK-92800:

"Failed to initialize usage of Windows Performance Counters. Make sure that performance counters are enabled or try rebuilding them with "lodctr /R" 

Resolution

Option 1

A workaround is provided in repairing the Windows Performance Counters:

1. Open an elevated command prompt (run as administrator)
2. Rebuild the counters with the following commands: 
      
   cd c:\windows\system32
   lodctr /R
   cd c:\windows\sysWOW64
   lodctr /R
   
   If you get the response Error: Unable to rebuild performance counter setting from system backup store, error code is 2, run the same command once more.
   
   A successful run will say:
   
   Info: Successfully rebuilt performance counter setting from system backup store

Pitfalls:

If you get as a return:

Error: Unable to rebuild performance counter setting from system backup store, error code is 5

then your prompt was not elevated. Elevate the command prompt with administrator permissions.

If the commands are successful yet symptoms persist, perform Option 2.
 

Option 2 

Ensure that the counters are not disabled in the registry

The counters may be disabled via registry settings. Please check the following registry locations to ensure that the counters have not been disabled.

HKLM\System\CurrentControlSet\Services\%servicename%\Performance

%servicename% represents any service with a performance counter. For example: PerfDisk, PerfOS, etc.

There may be registry keys for "DisablePerformanceCounters" in any of these locations. As per the following TechNet article, this value should be set to 0. If the value is anything other than 0 the counter may be disabled.

Disable Performance Counters

http://technet.microsoft.com/en-us/library/cc784382.aspx

• A value of 1 means the counter is disabled.
• A value of 2 means the 32-bit counter is disabled.
• A value of 4 means the 64-bit counter is disabled.
• Please make sure that none of the Perfxxxxx are have a key within them called "DisablePerformanceCounters". If they do, please make sure that the value is set to 0.

ref. https://support.microsoft.com/en-us/help/2554336/how-to-manually-rebuild-performance-counters-for-windows-server-2008-6

Once done, return to Option 1 

Environment:

Qlik Sense Enterprise on Windows 

After a successful upgrade to Qlik Sense Enterprise on Windows November 2024 patch 8, changing the MS SQL Server connection's password from the Data Load Editor (DLE) generates the following error:

Bad request 400

This error occurs when clicking 'SAVE connection', even after the connection has been successfully tested. 

Changing the MS SQL Server connection's password from the Qlik Sense Enterprise Console (in the Data Connection view) works as expected.

Resolution

This is a known defect (QCB-32467 | SUPPORT-4457) in Qlik Sense November 2024 and Qlik Qlik Sense May 2025.

Fix Version

Upgrade to:

• Qlik Sense November 2024 Patch 16 or later: Release Notes
• Qlik Sense May 2025 Patch 4 or later: Release Notes

Internal Investigation ID(s)

QCB-32467 | SUPPORT-4457

Environment

• Qlik Sense Enterprise on Windows

Your company might need to migrate its users from an old Active Directory domain to a new one. Sometimes usernames will also be renamed.

In some cases, it won't be possible to use the QMC to perform the migration of a document permission, due to users having the same name in the old and new domain.

Environment:

QlikView 

Resolution

If documents are being distributed using the QlikView Publisher functionality, then the DistributionDetail.xml can be edited to have the new and old domain and user names replaced.

Prior to doing this, ensure that a QVPR backup exists. 

1. Locate the QVPR folder in: C:\ProgramData\QlikTech\ManagementService\QVPR 
2. Stop the QlikView Management Service
3. Locate the DistributionDetail.xml file.
4. In the file, locate the old User ID 
   
   Example: 
   

   RecipientName="domain1\user1"

    

5. Replace the domain and/or user ID
   
   Example:
   

   RecipientName="domain2\user2"

6. Save the file
7. Start the service
8. Verify in the Distribution List that the Users have been changed. 

This article describes the procedure for when QlikView Server is migrated to a new domain. In this scenario, the existing QlikView Server that will be moved to a new domain is a single server QlikView Server installation and  has a static IP address.

Environment:

QlikView 

Resolution:

High-level procedure in 8 steps:

What you need to take into account are permissions  (Service Account, User access to files) and the name of the machine in case that changes as well. License assignments such as User CALs and Document CALs will need to be redone, as those will reference the previous domain name.

1. Create a backup of all your QlikView Server settings (C:/ProgramData/QlikTech) and of your QlikView documents (*.qvw, .META files and .SHARED/.TSHARED files).
2. Stop QlikView services. 
3. Migrate the machine to the new domain/machine. See QlikView: Migrating to a different machine. 
4. If the service account is a domain account, change this account and replace it with an account on the new domain that belongs to the QlikView Administrators and Local Administrators group.
   Note: be sure the same account is used for all services, or you may encounter an authentication related issue and not be able to see any documents when doing the collaboration objects piece below.
5. Restart services. 
6. Configure the DSC (Directory Service Connector) in the Management Console and add the new domain name/remove the old domain name so that it can find users from the new domain. 
7. Check that access rights on QlikView files are correctly configured (QlikView Access rights settings through DMS mode and/or section access usually contain the domain name and username)
8. Make sure that distribution tasks are distributed to the users on the new domain.

If the hostname has to change:

Changing the hostname of the QlikView Server requires a change of the references to the hostname for each service.  See Migrate and restore your backup in the QlikView upgrade and migration section on our Help for details. 

What happens to assigned CALs?

CALs will not automatically refer to the new domain\ prefix. You will need to manually re-assign them. 

Refer to the Power Tools for QlikView and the User Management.

NOTE: The CALs will not be available for 7 days; no exceptions. Plan to perform the migration period during an appropriate date range. The only possible alternative to avoid the quarantine is to completely clear the license and then, after reapplying it, reassign all the CALs.

Can Collaboration Objects / User Objects be migrated?

The QlikView Administrator will have to edit the domain\ prefix for all available objects. 
The QlikView Shared File Cleanup tool can be used to change ownership of objects. See How to change Server Object Owner in QlikView using the inbuilt Cleanup Tool for details. 

If Distribution Lists need to be changed in bulk

See How to migrate Active Directory Users in QlikView for details.
 

When replicating data from MySQL integration, users may encounter the following extraction error:

Fatal Error Occurred - Streaming result set com.mysql.cj.protocol.a.result.ResultsetRowsStreaming@xxxx is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries.

Resolution

1. Review the extraction logs and what is occurring just before the error, usually you will find the last query Stitch issued before erroring, for example,
   

   2025-09-30 20:30:00,000Z    tap - INFO  [main] tap-hp-mysql.sync-strategies.common - Querying: SELECT `pk_col`, `col1`, `col2`, `col3` FROM `schema`.`table` WHERE ((`pk_col` > ? OR `pk_col` IS NULL)) AND ((`pk_col` <= ?)) ORDER BY `pk_col` (<last PK value checked>, <max PK value>) 
   2025-09-30 20:32:00,000Z    tap - FATAL [main] tap-hp-mysql.main - Fatal Error Occurred - Streaming result set com.mysql.cj.protocol.a.result.ResultsetRowsStreaming@XXXX is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries.

2. Note the time difference between when the query was issued and when the error occurred, this can help isolate what the timeout value is (for example, 2 minutes) which can then help determine what timeout parameter is being exceeded.
3. You can isolate the impacted table(s) by de-selecting the recently errored table from replication to determine if the issue is with one table or multiple.
4. Run the query from the extraction logs directly in your source database and observe how long it takes to run and complete, assuming it completes. 
   • If it does not complete, you know that the timeout is in your database itself. If it does complete, it is likely due to a network setting in your SSH host.
   • If the query runs long in the source, you should reach out to your DBA team to make sure it is indexed.
     Example of query syntax to run in the source

     SELECT `pk_col`, `col1`, `col2`, `col3`
     FROM `schema`.`table`
     WHERE (`pk_col` IS NULL OR `pk_col` > [last PK value checked])
       AND `pk_col` <= [max PK value]
     ORDER BY `pk_col`;

   • If the query completes within a reasonable time in the source database, do the following: 
     1. Prepare the following queries in your database:

        SHOW FULL PROCESSLIST;
        SELECT ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO 
        FROM information_schema.PROCESSLIST 
        WHERE STATE = 'Sending data';

     2. Manually start an extraction in the Stitch UI
     3. As the extraction is running, execute those queries and capture the results
     4. Note the status of the process owned by the Stitch user and which query it is executing - if it is sleeping, you can considering killing the process(es)
5. Consult with your DBA team to increase the net_read_timeout and net_write_timeout parameters in your MySQL configuration, for reference: Server System Variables | dev.mysql.com/

If you are unable to alleviate the error following the above, please reach out to Qlik Support.

Cause

This error occurs when Stitch has an active server-side streaming ResultSet on a MySQL connection and tries to execute another statement on that same connection before the stream is fully consumed and closed. MySQL’s JDBC driver allows only one active statement per connection while a streaming result is open.

Potential Contributors

• Especially large source tables (for example, wide rows, JSON columns)
• Long-running queries (due to size or volume of tables)
• Slow networks or strict timeout settings (for example, connecting via SSH)

Environment

Stitch 

When using an Amazon S3 as a target in a Qlik Replicate task, the Full Load data are written to CSV, TEXT, or JSON files (depending on the endpoint settings). The Full Load Files are named using incremental counters e.g. LOAD00000001.csv, LOAD00000002.csv. This is the default behavior. 

In some scenarios, you may want to use the table name as the file name rather than LOAD########.

This article describes how to rename the output files from LOAD######## to <schemaName>_<tableName>__######## format while Qlik Replicate running on a Windows platform.

In this article, we will focus on cloud types of target endpoint (ADLS, S3, etc...) The example uses Amazon S3 which locates remote cloud storage.

This customization is provided as is. Qlik Support cannot provide continued support for the solution. For assistance, reach out to Professional Services.

Resolution

1. Open and modify repctl.cfg 
   
   Default file location: C:\Program Files\Attunity\Replicate\bin
   
   Set enable_execute_user_defined_commands from false to true 
   
   Example: "enable_execute_user_defined_commands": true,
   
   
2. Download and run the AWS CLI MSI installer for Windows (64-bit) (aws-cli/2.13.9  is used in this sample)
3. Set up the AWS CLI, and Configuring using AWS CLI commands. Sample steps of short-term credentials: 
   C:\Users\demo>aws configure
   AWS Access Key ID [None]     : DEMO~~~~~~~~~~~~UXEM
   AWS Secret Access Key [None] : demo~~~~~~~~~~~~ciYW7pugMTv/0DemoSQtfw1m
   Default region name [None]   : us-east-1
   Default output format [None] : json
4. Restart the Qlik Replicate Server service. 
   
   
5. Create a text/batch file named myrename_S3.bat and save it in the Qlik Replicate Server folder: C:\Program Files\Attunity\Replicate\bin
   
   Content of the file:
   

   @Echo on
   setx AWS_SHARED_CREDENTIALS_FILE C:\Users\demo\.aws\credentials
   for  %%a in (%1) do set "fn=%%~na"
   echo %fn%
   set  sn=%fn:~4,8%
   echo %sn%
   aws s3 mv s3://%1 s3://qmi-bucket-1234567868c4deded132f4ca/APAC_Test/%2.%3/%2_%3__%sn%.csv

   where  C:\Users\demo\.aws\credentials is generated in above step 3. The values are obfuscated in the above sample.

6. Set the Amazon S3 Target endpoint and configure it with the following settings: 
   
   

   General
       Bucket name       : qmi-bucket-1234567868c4deded132f4ca
       Bucket region     :  US East (N. Virginia)

       Access options   : Key pair
       Access key            :  DEMO~~~~~~~~~~~~UXEM
       Secret key             :  demo~~~~~~~~~~~~ciYW7pugMTv/0DemoSQtfw1m

                Target folder        : /APAC_Test

1. 
   

   
   Advanced
       Post Upload Processing, choose "Run command after upload"
       Command name  : myrename_S3.bat
       Working directory: leave blank
       Parameters             : ${FILENAME} ${TABLE_OWNER} ${TABLE_NAME}
   

   

    

   7. Startup or Reload the Full Load ONLY task and verify the file output.
   
   By using command "aws s3 ls", it will typically looks like:
   

   C:\Users\demo>>aws s3 ls s3://qmi-bucket-1234567868c4deded132f4ca/APAC_Test --recursive --human-readable --summarize
   2023-08-14 11:20:36 0 Bytes APAC_Test/
   2023-08-15 08:10:24 0 Bytes APAC_Test/SCOTT.KIT/
   2023-08-15 08:10:28 9 Bytes APAC_Test/SCOTT.KIT/SCOTT_KIT__00000001.csv
   2023-08-15 08:10:24 0 Bytes APAC_Test/SCOTT.KIT500K/
   2023-08-15 08:10:34 4.0 MiB APAC_Test/SCOTT.KIT500K/SCOTT_KIT500K__00000001.csv
   2023-08-15 08:10:44 4.0 MiB APAC_Test/SCOTT.KIT500K/SCOTT_KIT500K__00000002.csv
   2023-08-15 08:10:54 4.0 MiB APAC_Test/SCOTT.KIT500K/SCOTT_KIT500K__00000003.csv
   2023-08-15 08:11:05 4.0 MiB APAC_Test/SCOTT.KIT500K/SCOTT_KIT500K__00000004.csv
   2023-08-15 08:11:15 4.0 MiB APAC_Test/SCOTT.KIT500K/SCOTT_KIT500K__00000005.csv
   2023-08-15 08:11:24 2.7 MiB APAC_Test/SCOTT.KIT500K/SCOTT_KIT500K__00000006.csv

   Total Objects: 10
   Total Size: 22.7 MiB

   
   Where SCOTT is the source table schema name, KIT/KIT500K are source table name, 0000000<n> is the unique incremental number.
   
   You can tailor the myrename_S3.bat file for any particular needs.

Environment

Qlik Replicate  
Amazon S3 target

Related Content:

Qlik Replicate and File target: How to rename output files LOAD######## to table name format on Wind...
Qlik Replicate and File target: How to rename output files LOAD######## to table name format on Linu...

Qlik Replicate and ADSL target: How to rename output files LOAD######## to table name format (Replicate runs on Windows)

QVS files (read more) cannot be uploaded to Managed Spaces in Qlik Cloud.

Resolution

.qvs (QlikView Script) files cannot be directly uploaded to a managed space in Qlik Cloud. QlikView Script files are intended as reusable load script blocks and are not considered application files (such as .qvf and .qvw). 

To use a .qvs file, copy the script's contents into an app's load script editor or use an $(Include=...) statement to reference the file, which needs to be stored elsewhere and made accessible to the app.

Related Content

• Creating QVS files
• Uploading and sharing a QlikView app in Qlik Cloud

Environment

• Qlik Cloud Analytics

This capability has been rolled out across regions over time:

1. May 5th: India, Japan, Middle East, Sweden (completed)
2. June 4th: Asia Pacific, Germany, United Kingdom, Singapore (completed)
3. June 9th: United States (completed)
4. June 12th: Europe (completed)
5. June 26th: Qlik Cloud Government

With the introduction of shared automations, it is now possible to create, run, and manage automations in shared spaces. 

Content

• Allow other users to run an automation
• Collaborate on existing automations
• Collaborate through duplication
• Extended context menus
• Context menu for owners:
• Context menu for non-owners:
• Monitoring
• Administration Center
• Activity Center
• Run history details
• Metrics

Allow other users to run an automation

Limit the execution of an automation to specific users.

Every automation has an owner. When an automation runs, it will always run using the automation connections configured by the owner. Any Qlik connectors that are used will use the owner's Qlik account. This guarantees that the execution happens as the owner intended it to happen.

The user who created the run, along with the automation's owner at run time, are both logged in the automation run history.

These are five options on how to run an automation:

1. Run an automation from the Hub and Catalog
   
   
   
   
2. Run an automation from the Automations activity center
   
   

    

3. Run an automation through a button in an app
   
   You can now allow other users to run an automation through the Button object in an app without needing the automation to be configured in Triggered run mode. This allows you to limit the users who can execute the automation to members of the automation's space.
   
   More information about using the Button object in an app to trigger automation can be found in How to run an automation with custom parameters through the Qlik Sense button.
   
   
4. Programmatic executions of an automation
   
   
   1. Automations API: Members of a shared space will be able to run the automations over the /runs endpoint if they have sufficient permissions.
   2. Run Automation and Call Automation blocks
      
      
5. Note for triggered automations: the user who creates the run is not logged as no user specific information is used to start the run. The authentication to run a triggered automation depends on the Execution Token only.

Collaborate on existing automations

Collaborate on an automation through duplication.

Automations are used to orchestrate various tasks; from Qlik use cases like reload task chaining, app versioning, or tenant management, to action-oriented use cases like updating opportunities in your CRM, managing supply chain operations, or managing warehouse inventories.

Collaborate through duplication

To prevent users from editing these live automations, we're putting forward a collaborate through duplication approach. This makes it impossible for non-owners to change an automation that can negatively impact operations.

When a user duplicates an existing automation, they will become the owner of the duplicate. This means the new owner's Qlik account will be used for any Qlik connectors, so they must have sufficient permissions to access the resources used by the automation. They will also need permissions to use the automation connections required in any third-party blocks. 

Automations can be duplicated through the context menu:

As it is not possible to display a preview of the automation blocks before duplication, please use the automation's description to provide a clear summary of the purpose of the automation:

Extended context menus

• Start a run from the context menu in the hub
• Duplicate automation
• Move automation to shared space
• Edit details (owners only)
• Open in new tab (owners only)

Context menu for owners:

 

Context menu for non-owners:

 

 

Monitoring

The Automations Activity Centers have been expanded with information about the space in which an automation lives. The Run page now also tracks which user created a run.

Note: Triggered automation runs will be displayed as if the owner created them.

Administration Center

The Automations view in Administration Center now includes the Space field and filter.

The Runs view in Administration Center now includes the Executed by and Space at runtime fields and filters.

Activity Center

The Automations view in Automations Activity Center now includes Space field and filter.

Note: Users can configure which columns are displayed here.

The Runs view in the Automations Activity Center now includes the Space at runtime, Executed by, and Owner fields and filters.

In this view, you can see all runs from automations you own as well as runs executed by other users. You can also see runs of other users's automations where you are the executor.

Run history details

To see the full details of an automation run, go to Run History through the automation's context menu. This is also accessible to non-owners with sufficient permissions in the space.

The run history view will show the automation's runs across users, and the user who created the run is indicated by the Executed by field.

Metrics

The metrics tab in the automations activity center has been deprecated in favor of the automations usage app which gives a more detailed view of automation consumption.

Qlik is aware of some industry concerns around the use of the NPM library fast-glob. To address these concerns, Qlik is taking steps to remove this library from the Qlik Sense for Windows product. The removal is expected to be complete as of the November 2025 release.

Environment

• Qlik Sense Enterprise on Windows

A replication fails with the following:

[TARGET_APPLY ]I: ORA-03135: connection lost contact Process ID: 19637 Session ID: 1905 Serial number: 3972 [1022307] (oracle_endpoint_load.c:862) 
[TARGET_APPLY ]I: Failed to truncate net changes table [1022307] (oracle_endpoint_bulk.c:1162) 
[TARGET_APPLY ]I: Error executing command [1022307] (streamcomponent.c:1987) 
[TASK_MANAGER ]I: Stream component failed at subtask 0, component st_0_PCA UAT DW Target [1022307] (subtask.c:1474) 
[TARGET_APPLY ]I: Target component st_0_PCA UAT DW Target was detached because of recoverable error. Will try to reattach (subtask.c:1589) 
[TARGET_APPLY ]E: Failed executing truncate table statement: TRUNCATE TABLE "PAYOR_DW"."attrep_changesBF9CC327_0000402" [1020403] (oracle_endpoint_load.c:856) 

Resolution

This may require additional review by your database admin. 

In this instance, the issue was caused by a database-level trigger to monitor drop, truncate, and alter statements by name TSDBA.AUDIT_DDL_TRG, which is currently invalid.

To resolve, validate the trigger and add logic to not consider attrep_changes% tables, as this is just a temporary table for Qlik Replicate batch processing.

Environment

• Qlik Replicate