Featured Content
-
How to contact Qlik Support
Qlik offers a wide range of channels to assist you in troubleshooting, answering frequently asked questions, and getting in touch with our technical e... Show MoreQlik offers a wide range of channels to assist you in troubleshooting, answering frequently asked questions, and getting in touch with our technical 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:
- Support and Professional Services; who to contact when.
- Qlik Support: How to access the support you need
- 1. Qlik Community, Forums & Knowledge Base
- The Knowledge Base
- Blogs
- Our Support programs:
- The Qlik Forums
- Ideation
- How to create a Qlik ID
- 2. Chat
- 3. Qlik Support Case Portal
- Escalate a Support Case
- Phone Numbers
- Resources
Support and Professional Services; who to contact when.
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. - Error messages
- Task crashes
- Latency issues (due to errors or 1-1 mode)
- Performance degradation without config changes
- Specific questions
- Licensing requests
- Bug Report / Hotfixes
- Not functioning as designed or documented
- Software regression
- Deployment Implementation
- Setting up new endpoints
- Performance Tuning
- Architecture design or optimization
- Automation
- Customization
- Environment Migration
- Health Check
- New functionality walkthrough
- Realtime upgrade assistance
(*) reach out to your Account Manager or Customer Success Manager
Qlik Support: How to access the support you need
1. Qlik Community, Forums & Knowledge Base
Your first line of support: https://community.qlik.com/
Looking for content? Type your question into our global search bar:
The Knowledge Base
Leverage the enhanced and continuously updated Knowledge Base to find solutions to your questions and best practice guides. Bookmark this page for quick access!
- Go to the Official Support Articles Knowledge base
- Type your question into our Search Engine
- Need more filters?
- Filter by Product
- Or switch tabs to browse content in the global community, on our Help Site, or even on our Youtube channel
Blogs
Subscribe to maximize your Qlik experience!
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)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)Our Support programs:
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.Technical Adoption Workshops
Our in depth, hands-on workshops allow new Qlik Cloud Admins to build alongside Qlik Experts.Qlik Fix
Qlik Fix is a series of short video with helpful solutions for Qlik customers and partners.The Qlik Forums
- Quick, convenient, 24/7 availability
- Monitored by Qlik Experts
- New releases publicly announced within Qlik Community forums (click)
- Local language groups available (click)
Ideation
Suggest an idea, and influence the next generation of Qlik features!
Search & Submit Ideas
Ideation GuidelinesHow to create a Qlik ID
Get the full value of the community.
Register a Qlik ID:
- Go to register.myqlik.qlik.com
If you already have an account, please see How To Reset The Password of a Qlik Account for help using your existing account. - You must enter your company name exactly as it appears on your license or there will be significant delays in getting access.
- You will receive a system-generated email with an activation link for your new account. NOTE, this link will expire after 24 hours.
If you need additional details, see: Additional guidance on registering for a Qlik account
If you encounter problems with your Qlik ID, contact us through Live Chat!
2. Chat
Incidents are supported through our Chat, by clicking Chat Now 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:
- Answer common questions instantly through our chatbot
- Have a live agent troubleshoot in real time
- With items that will take further investigating, we will create a case on your behalf with step-by-step intake questions.
3. Qlik Support Case Portal
Log in to manage and track your active cases in the Case Portal. (click)
Please note: to create a new case, it is easiest to do so via our chat (see above). Our chat will log your case through a series of guided intake questions.
Your advantages:
- Self-service access to all incidents so that you can track progress
- Option to upload documentation and troubleshooting files
- Option to include additional stakeholders and watchers to view active cases
- Follow-up conversations
When creating a case, you will be prompted to enter problem type and issue level. Definitions shared below:
Problem Type
Select Account Related for issues with your account, licenses, downloads, or payment.
Select Product Related for technical issues with Qlik products and platforms.
Priority
If your issue is account related, you will be asked to select a Priority level:
Select Medium/Low if the system is accessible, but there are some functional limitations that are not critical in the daily operation.
Select High if there are significant impacts on normal work or performance.
Select Urgent if there are major impacts on business-critical work or performance.
Severity
If your issue is product related, you will be asked to select a Severity level:
Severity 1: Qlik production software is down or not available, but not because of scheduled maintenance and/or upgrades.
Severity 2: Major functionality is not working in accordance with the technical specifications in documentation or significant performance degradation is experienced so that critical business operations cannot be performed.
Severity 3: Any error that is not Severity 1 Error or Severity 2 Issue. For more information, visit our Qlik Support Policy.
Escalate a Support Case
If you require a support case escalation, you have two options:
- Request to escalate within the case, mentioning the business reasons.
To escalate a support incident successfully, mention your intention to escalate in the open support case. This will begin the escalation process. - Contact your Regional Support Manager
If more attention is required, contact your regional support manager. You can find a full list of regional support managers in the How to escalate a support case article.
Phone Numbers
When other Support Channels are down for maintenance, please contact us via phone for high severity production-down concerns.
- Qlik Data Analytics: 1-877-754-5843
- Qlik Data Integration: 1-781-730-4060
- Talend AMER Region: 1-800-810-3065
- Talend UK Region: 44-800-098-8473
- Talend APAC Region: 65-800-492-2269
Resources
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.
Recent Documents
-
Qlik Talend Cloud: Unable to save Task Configurations using "169.254.169.254" as...
In certain use cases, it may be necessary to use an IP address/path with the following root IP address, 169.254.169.254, with a custom connection or o... Show MoreIn certain use cases, it may be necessary to use an IP address/path with the following root IP address, 169.254.169.254, with a custom connection or other variables attached to a task in TMC. However, if you attempt to save the task for deployment/running while using this IP address, TMC may display an error message stating "Unable to Save Task Configuration".
Cause
The IP Address in question, 169.254.169.254, is a custom instance metadata IP address used across different Cloud Service Providers, such as AWS or Azure, which Qlik/Talend Cloud is hosted on. In many cases, these Cloud Service Providers utilize that IP address to retrieve information about Virtual Machines, such as configuration details and network settings. Consequently, the Cloud Service Providers will automatically block any application (such as TMC) from using that entry on the backend.
In terms of TMC, if the aforementioned IP address is used, TMC will attempt to save that entry on the backend. Nevertheless, since AWS/Azure has blacklisted that IP address, it will block the task from saving the entry on the backend. This will cause TMC to resend the request, displaying the message "Unable to Save Task Configuration".
Resolution
If the IP address in question is intended for use in a content, resource, or connection, there are a couple of suggested solutions.
- Use a DNS name that can either be resolved internally (such as DNS on the specific VLAN/internal network) or add the DNS name as an entry in the /etc/hosts file on the instance where the Remote Engine resides.
- Modify the Job to enable base64 encryption/decryption of the value, so it cannot be detected by the Cloud Service Provider.
- Split and concatenate the URL to ensure that the value is not directly provided by TMC to the Cloud Service Provider.
If, after testing and validating the aforementioned solutions, the issue persists with creating, saving, or modifying tasks, kindly contact Qlik Support.
Internal Investigation ID(s)
SUPPORT-1875
Environment
- Talend Data Integration 8.0.1
-
Replicate - DB2 LUW ODBC Client error Specified driver could not be loaded due t...
While working with DB2 LUW endpoint, Replicate reports error after the 64-bit IBM DB2 Data Server Client 11.5 installation: SYS-E-HTTPFAIL, Cannot con... Show MoreWhile working with DB2 LUW endpoint, Replicate reports error after the 64-bit IBM DB2 Data Server Client 11.5 installation:
SYS-E-HTTPFAIL, Cannot connect to DB2 LUW Server.
SYS,GENERAL_EXCEPTION,Cannot connect to DB2 LUW Server,RetCode: SQL_ERROR SqlState: IM003 NativeError: 160 Message: Specified driver could not be loaded due to system error 1114: A dynamic link library (DLL) initialization routine failed. (IBM DB2 ODBC DRIVER, C:\Program Files\IBM\SQLLIB\BIN\DB2CLIO.DLL).Resolution
Install the 64-bit IBM DB2 Data Server Client 11.5.4 (for example 11.5.4.1449) rather than 11.5.0 (actual version is 11.5.0.1077).
Environment
Qlik Replicate : all versions
Replicate Server platform: Windows Server 2019
DB2 Data Server Client : version 11.5.0.xxxxInternal Investigation ID(s):
Support cases, #00076295
-
How-to: Qlik Application Automation connectors to Office 365 require Admin Conse...
In Qlik Application Automation when trying to connect a connector of the Office 365 suite, some users will experience the following message during the... Show MoreIn Qlik Application Automation when trying to connect a connector of the Office 365 suite, some users will experience the following message during the authentication flow:
This error can show up for the Microsoft Teams, Microsoft Onedrive, Microsoft Sharepoint and Microsoft Excel connectors and depends on your Office 365 tenant. This article explains different methods on how to allow users to make a connector from Qlik Application Automation.
When an Azure admin navigates to the Consent and Permissions page inside Enterprise Applications, the following will be visible:
Admin Consent Request Workflow
If the option Do not allow user consent is selected, the only way to get the Microsoft connectors in Qlik Application Automation working is by enabling the Admin Consent Request workflow. To do this, the admin needs to navigate to Admin consent settings and enable the request box and assign reviewers for each request justification:
When a user now creates a connection, they will be asked to provide a justification. This request will be sent to the Azure Administrators of the tenant:
When this request is submitted, the reviewers of the request should now see the request:
The reviewer can review the request which takes the reviewer to the consent screen with the option to allow access for the organization. This will install an enterprise application in the Azure tenant of the user.
Classifying low impact permissions
An alternative option is if the Azure tenant selected the option Allow User Consent from verified publishers for selected permissions.
When this option is chosen, an Azure administrator of the tenant can head to the Permission Classifications page:
The following scopes will have to be classified as low impact for the different connectors:
Microsoft Teams Microsoft Sharepoint Microsoft Onedrive Microsoft Excel Microsoft Outlook User.Read
User.Read
User.Read
User.Read
User.Read
offline_access
offline_access offline_access offline_access offline_access profile Files.Read.All Files.ReadWrite.All Files.ReadWrite.All Mail.Send openid Files.ReadWrite.All email Sites.Read.All Team.ReadBasic.All Sites.Manage.All ChannelMessage.Send Sites.ReadWrite.All Channel.ReadBasic.All
Microsoft Teams/Sharepoint ( with admin consent )This connector will always require admin consent and these scopes cannot be classified as being low impact.
-
What does "Warning WorkingSet: Virtual Memory is . . . " log line mean?
The Qlik Sense Engine or QlikView Server service may register the following warnings in the logs: ... Warning WorkingSet: Virtual Memory is growing ... Show MoreThe Qlik Sense Engine or QlikView Server service may register the following warnings in the logs:
...Warning WorkingSet: Virtual Memory is growing beyond parameters ...
Warning WorkingSet: Virtual Memory is growing CRITICALLY beyond parameters ...
Warning WorkingSet: Possible cache depletion detected. Depletion factor=1.0...Environment:
Resolution:
The host operating system may be running out of sufficient resources for the Engine to perform its tasks. The numbers supplied by the system indicate the current usage of memory by the Engine service against the Low Working Set Limit configured for the Qlik Engine.The depletion warning indicates that a memory load needs to be addressed, e.g. through purging more aggressively or relocations apps, since the cache memory has dramatically reduced. So, it is an early warning to free memory that the generic cache one needs.
Example after startup:
Information WorkingSet: Configured Working Set Size is 4.200-5.400 GB (setting 70%-90%)
Where 70% is the (default) Low limit, translating to 4.200 GB.
Warning WorkingSet: Virtual Memory is growing beyond parameters - 5.205(4.200) GB
Warning WorkingSet: Virtual Memory is growing CRITICALLY beyond parameters - 5.496(4.200) GB
Additional Resources:Explanation of Memory in Sense: Qlik Engine Memory Management
Whitepaper: QIX engine memory management and CPU utilization
Determining requirements: How Much Memory Is Required For A Qlik Server Deployment?
-
Where do I get my certificiate and logo after I pass a Qlik certification exam?
All candidates can review their exam history and score reports by logging into Pearson VUE and utilizing the “My Account” menu. Qlik is partnering wit... Show MoreAll candidates can review their exam history and score reports by logging into Pearson VUE and utilizing the “My Account” menu.
Qlik is partnering with Credly to provide digital badges and certificates for our Qlik Product Certifications. 24-48 hours after you pass your exam, you will receive an email from Credly. Follow the instructions in the email to accept your digital badge and access your certificate.
If you experience issues while accepting your digital badge, please contact Credly support.
More information, see: Certifications and Qualificiations
-
Qlik Talend Cloud: Talend Remote Engine Heartbeat is failing hourly with 'GOAWAY...
Talend Remote Engine Heart Beat is failing hourly with 'GOAWAY received' error and the karaf.log shows below: 2024-08-01T10:16:58,638 | ERROR | pool-2... Show MoreTalend Remote Engine Heart Beat is failing hourly with 'GOAWAY received' error and the karaf.log shows below:
2024-08-01T10:16:58,638 | ERROR | pool-28-thread-1 | JAXRSUtils | 469 - org.apache.cxf.cxf-rt-frontend-jaxrs - 3.6.2 | | Problem with writing the data, class org.talend.ipaas.rt.engine.model.HeartbeatInfo, ContentType: application/json
2024-08-01T10:16:58,638 | WARN | pool-28-thread-1 | PhaseInterceptorChain | 467 - org.apache.cxf.cxf-core - 3.6.2 | | Interceptor for {http://pairing.rt.ipaas.talend.org/}PairingService has thrown exception, unwinding now
org.apache.cxf.interceptor.Fault: Problem with writing the data, class org.talend.ipaas.rt.engine.model.HeartbeatInfo, ContentType: application/json
Caused by: java.io.IOException: /<IP>:<port>: GOAWAY receivedThis could also be a possible solution when the following error is also showing in the log:
Caused by: java.io.IOException: HTTP/1.1 header parser received no bytes
Resolution
- Stop Remote Engine.
- Edit the <RemoteEngineInstallation>/etc/org.talend.ipaas.rt.pairing.agent.cfg file and replace the line
withheartbeat.interval=60 (by default)
heartbeat.interval=65
- In the file <RemoteEngineInstallation>/etc/system.properties, remove or comment out the line below (if it exists):
org.apache.cxf.transport.http.forceVersion=1.1
- Restart Remote Engine.
Do not set heart interval to more than 180 seconds(3 mins). If Talend Cloud does not receive a heartbeat from the Remote Engine for more than 3 mins, it will show the Remote Engine's status as unavailable.
Cause
The connection to the server pair.xx.cloud.talend.com is kept during 60 seconds and Heartbeat.interval > 60 seconds allows to close this connection and prevent "GOAWAY received" error message.
Related Content
For more information about heartbeat concept and heartbeat interval, please refer to documentation:
Monitoring-remote-engine-health
Internal Investigation ID(s)
Internal Jira Case ID: TMC-4122
Environment
-
How to configure OIDC with Google Workspace on Qlik Sense Enterprise on Windows
This article provides a guide on how to configure a Qlik Sense Enterprise on Windows Virtual Proxy with OIDC authentication. This customization is pro... Show MoreThis article provides a guide on how to configure a Qlik Sense Enterprise on Windows Virtual Proxy with OIDC authentication.
This customization is provided as is. Qlik Support cannot provide continued support of the solution. For assistance, reach out to our Professional Services or engage in our active Integrations forum.
On Google Workspace
- Follow the instructions in How To: Setting up OAuth 2.0 Google Cloud Platform
- Create an OAuth client ID
- Note your Client ID and Client Secret
- Configure the Authorized redirect URIs
Change the URIs per your environment's requirements.
In this case I’m using the same app to authenticate Qlik Sense Client-Managed and Qlik Cloud as well.
URIs must be a fully qualified domain name (FQDN) such as, https://qliksenseserver.domain.local. - Once finished, download the config json file
Setting up Qlik Sense for OIDC with Azure ID
- Create a new virtual proxy in the Qlik Sense Management Console and configure it based on your requirements (such as choosing an Engine to load balance to, your host allow list, and associating a Proxy service).
- Choose OIDC as the authentication method and configure it as follows:
The fields to pay attention to are:
- OpenID Connect metadata URI: https://accounts.google.com/.well-known/openid-configuration
- Client ID: Can be found in the Google Console > Additional information
- Client secret: Can be found in the Google Console > Client Secret, and is available when downloading the config json file
- scope: openid email profile
Environment
- Qlik Sense Enterprise on Windows
- Google Workspace
-
How to disable Lineage information in QlikView QVD files
QlikView QVD files contain lineage information of the stored data. Environment: QlikView any version The lineage information can be found in the ... Show MoreQlikView QVD files contain lineage information of the stored data.
Environment:
QlikView any version
The lineage information can be found in the QVD file XML header and might look like below, with connection details and the SQL statements used during reload.
Resolution:
The lineage information can be suppressed as follows:Setting in QlikView Desktop client- Open Qlikview Desktop client
- Go to Help > About Qlikview...
- Right click the QlikView logo in the bottom right corner
- Highlight the AllowDataLineage value
- Set the value to -1 to disable the Lineage information
- Click Set to store the value change
- Close the settings and about dialog boxes
- Reload the QVD generator application
Setting on QlikView Server- Open the QlikView Server’s batch settings.ini file in a text editor. Default file path; C:\Windows\System32\config\systemprofile\AppData\Roaming\QlikTech\QlikViewBatch\Settings.ini
- Add AllowDataLineage=-1 in the [Settings 7] section of the settings file.
- Save the settings file and close text editor
- Restart QlikView Server, to trigger loading of the altered settings
- Reload the QVW file from QlikView management console to see that the setting has been changed
- To enable the lineage information follow the steps above, but set the Value to 0 instead of -1 in step 5.
NOTE:The setting is not deployed permanent and will be removed by product upgrades. -
Qlik Sense: How to decrypt a SAML assertion or error message
How to decrypt a heavily encoded SAML message. If you have set up the Identity Provider to encrypt the SAML assertion, then in order to see what it c... Show MoreHow to decrypt a heavily encoded SAML message.
If you have set up the Identity Provider to encrypt the SAML assertion, then in order to see what it contains for troubleshooting, you will need to decrypt it.
Environment:
Qlik Sense Enterprise on Windows , all versions
It is important to understand the 3 below concepts when using SAML.
- Inflation and base-64 encoding
- Signing
- Encryption
A SAML AuthnRequest is:
- Inflated and base-64 encoded (If you use a SAML browser extension, it will deflate it and decode it automatically for you. In order to do that manually, https://www.samltool.com/decode.php can be used.)
No private key is needed to deflate/decode. - Signed, so that it cannot be altered. The signature does not hold any useful information for troubleshooting, it is just to make sure that the SAML request hasn't been altered. However if the certificate it has been signed with does not correspond, you won't be able to authenticate.
The Qlik Sense certificate is needed to validate the signature on the SAML assertion. (Note: Qlik Sense always signs SAML AuthnRequest, this cannot be disabled, however SAML AuthnRequest signature validation can be disabled in the Identity Provider)
A SAML assertion (The assertion is a section in the SAML response) is:- Inflated and base-64 encoded (If you use a SAML browser extension, it will deflate it and decode it automatically for you. In order to do that manually, https://www.samltool.com/decode.php can be used.)
No private key is needed to deflate/decode. - Signed, so that it cannot be altered. The signature does not hold any useful information for troubleshooting, it is just to make sure that the SAML request hasn't been altered. However if the certificate it has been signed with does not correspond, you won't be able to authenticate.
The Identity Provider certificate is needed to validate the signature on the SAML assertion. - Encrypted (Optionally). In this case, in order to see if information in the SAML assertion are correct, decrypting the SAML assertion is needed.
It can be decrypted with https://www.samltool.com/decrypt.php, just paste the deflated/decoded SAML request.
The Qlik Sense certificate private key is needed to see what the signature holds.
The SAML response is generated by the Identity Provider and the public certificate of the Service Provider (Qlik Sense) is used to encrypt. You will need the private key of Qlik Sense to decrypt it.
Resolution:
- Go to https://www.samltool.com/decrypt.php
- In Encrypted XML, paste the deflated/decoded SAML response.
- In Private Key*, paste the private key of Qlik Sense.
* It must be the private key in clear text, not protected by a passphrase. A protected private key will begin with -----BEGIN ENCRYPTED PRIVATE KEY----- while a clear text private key will begin with -----BEGIN RSA PRIVATE KEY-----
In order to decrypt a private key, you can use the command:
openssl rsa –in enc.key -out dec.key
You will be asked to enter the passphrase for your private key.
Please note that openssl must be installed and you should run this command from the command prompt in the folder where the binary for openssl is installed.Related Content:
-
Internal\sa_scheduler mandatory to reload apps with section access from Qlik Sen...
Scheduled tasks will fail in Qlik Sense, if the App contains Section Access while could be working fine from the script editor.Investigating the log f... Show MoreScheduled tasks will fail in Qlik Sense, if the App contains Section Access while could be working fine from the script editor.
Investigating the log file <Servername>_System_Engine.txt shows a warning message similar to:WARN domain System.Engine.Engine 89 6ac41964-2910-4a17-9162-c40119b2d3d6 domain\qliksense System: DetermineAccess: Failed to access the following document af18ffcb-6b60-4546-9fa5-f385172eebec with the user: 0 sa_scheduler 20181126T181325.903+0100 6864 7120 eaa1c5c2-1850-40cb-a490-0e6158df82b0 af18ffcb-6b60-4546-9fa5-f385172eebec 20181126T181055.000+0100 6ac41964-2910-4a17-9162-c40119b2d3d6
On the script log you will see:Execution Failed
Execution finished.Qlik Sense Enterprise on Windows governs access to resources (such as Apps) through the Repository Service. An account for each service is created in the PostgreSQL database during setup, such as the sa_scheduler account above. For the Scheduler to be able to access the App during reload, this account must be added into Section Access, not the account running the actual service.
See also the help documentation:
"The INTERNAL\SA_SCHEDULER account user is required to enable reload of the script in a Qlik Management Console task." Managing security with section accessResolution:
The following requirements must be met:
- Make sure the relevant account is added to Section Access with access ADMIN. This may be the Qlik Sense internal (non-Windows) account INTERNAL\SA_SCHEDULER or the account chosen to impersonate it during reload. See also Managing security with section access
- The app owner must have access to all data connections or at least all data connections used in the app
Example
Section Access; LOAD * INLINE [ ACCESS, USERID ADMIN, INTERNAL\SA_SCHEDULER ];
-
Qlik Talend Cloud fails to find endpoint type SAPExtractor
Qlik Talend Cloud establishing a connection to SAP using the Extractor Endpoint fails with: Status(StatusCode="Internal", Detail="SYS-E-HTTPFAIL, Fail... Show MoreQlik Talend Cloud establishing a connection to SAP using the Extractor Endpoint fails with:
Status(StatusCode="Internal", Detail="SYS-E-HTTPFAIL, Failed to load dynamic endpoint properties. SYS,GENERAL_EXCEPTION,Failed to load dynamic endpoint properties,Failed to find endpoint type 'SAPExtractor' from endpoint server 'Local' Failed to find endpoint type 'SAPExtractor' from endpoint server 'Local' XXXX, HTTP request failed, Failed to connect using Data Movement gateway local_repsrv. Verify the status in Management Console > Data gateways is "Connected" and then retry the operation.").
Resolution
- Stop the Gateway server:
systemctl stop repagent
- Download the SAP Java Connector 3.x (64-bit) for Linux from https://support.sap.com/en/product/connectors/jco.html
- Unzip the file. It includes the required sapjco3.jar and libsapjco3.so files.
- Install the Java connector into the Gateway Server by manually copying the Sapjco3.jar and libsapjco3.so files to the /opt/qlik/gateway/movement/endpoint_srv/endpoints/SAP directory
- Once the files have been copied, start the Gateway server:
- Verify you are root using:
sudo su
- Run the command:
systemctl start repagent
- Verify you are root using:
- Confirm the Gateway Server is up using the below command and example output:
systemctl status repagent
repagent.service - Qlik Data Gateway - Data Movement
Loaded: loaded (/etc/systemd/system/repagent.service; enabled; vendor preset: disabled) Active: active (running) since Tue 2025-03-25 14:18:57 GMT; 11min ago
Process: 176787 ExecStop=/opt/qlik/gateway/movement/bin/repagent stop (code=exited, status=0/SUCCESS)
Process: 176944 ExecStart=/opt/qlik/gateway/movement/bin/repagent start (code=exited, status=0/SUCCESS)
Main PID: 177014 (agentctl)
Tasks: 0 (limit: 49025)
Memory: 28.0K
CGroup: /system.slice/repagent.service
‣ 177014 /opt/qlik/gateway/movement/bin/agentctl -d /opt/qlik/gateway/movement/data service host -b
Mar 25 14:18:53 RHEL8.domain.local systemd[1]: Starting Qlik Data Gateway - Data Movement...
Mar 25 14:18:53 RHEL8.domain.local su[176967]: (to qlik) root on none
Mar 25 14:18:53 RHEL8.domain.local su[176967]: pam_unix(su-l:session): session opened for user qlik by (uid=0)
Mar 25 14:18:57 RHEL8.domain.local su[176967]: pam_unix(su-l:session): session closed for user qlik
Mar 25 14:18:57 RHEL8.domain.local systemd[1]: Started Qlik Data Gateway - Data Movement.
Cause
Missing Sapjco3.jar and libsapjco3.so files in the /opt/qlik/gateway/movement/endpoint_srv/endpoints/SAP directory.
Internal Investigation ID(s)
CC-16456
Environment
- Qlik Replicate
- Stop the Gateway server:
-
Qlik Sense Enterprise on Windows November 2024: Unable to create ODBC or OLE DB ...
Creating ODBC or OLE DB connections in the Data Manager fails while using Qlik Sense Enterprise on Windows November 2024. The ODBC connection The DSN ... Show MoreCreating ODBC or OLE DB connections in the Data Manager fails while using Qlik Sense Enterprise on Windows November 2024.
The ODBC connection
The DSN list is not shown:
The OLE DB connection
The connection screen loops with a spinning progression wheel:
Affected versions
- Qlik Sense Enterprise on Windows November 2024 IR to Patch 8
- Qlik Sense Desktop November 2024 IR to Patch 8
Resolution
This is caused by SUPPORT-1177 and SUPPORT-1180, which have been fixed in Patch 9 (release expectation: May 2025). Review the Release Notes for details at patch publication.
Workaround:
Use the Data Load Editor to create a new ODBC or OLE DB connections.
Fix Version:
- Qlik Sense Enterprise on Windows November 2024 Patch 9, May 2025
- Qlik Sense Desktop November 2024 Patch 9, May 2025
Cause
Product Defect ID(s): SUPPORT-1177, SUPPORT-1180
-
Do QlikView, Qlik Sense, and Qlik NPrinting support GMSA?
Do Qlik Products support the use of Standalone Managed Service Accounts (GMSA)? At this time, QlikView, Qlik Sense Enterprise on Windows, and Qlik NPr... Show MoreDo Qlik Products support the use of Standalone Managed Service Accounts (GMSA)?
At this time, QlikView, Qlik Sense Enterprise on Windows, and Qlik NPrinting do not support the use of managed service accounts.
For general service account requirements, see:
QlikView Service Account Requirements
Qlik Sense Sevice Account Requirements
Qlik NPrinting user account requirementsEnvironment
Qlik Sense Enterprise on Windows
Qlik NPrinting
QlikView -
Critical Security fix for Qlik Alerting (CVE-pending)
Executive Summary A security issue in a version of Qlik Alerting Windows has been identified. This issue was resolved in a later patch, which is alrea... Show MoreExecutive Summary
A security issue in a version of Qlik Alerting Windows has been identified. This issue was resolved in a later patch, which is already available. If the vulnerability is successfully exploited, it could lead to unauthorized access to the Qlik Alerting application.
Affected Software
Qlik Alerting Windows July 2023 Service Release 1
Severity Rating
Using the CVSS V3.1 scoring system (https://nvd.nist.gov/vuln-metrics/cvss), this issue is rated CRITICAL.
Vulnerability Details
CVE-Pending (QB-24808) Authentication bypass
Severity: CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H (9.8 Critical)
An unprivileged user with network access to the Qlik Alerting Server is able to bypass basic authentication.
Resolution
Recommendation
Customers should upgrade to Qlik Alerting July 2023 Service Release 2 or higher.
All Qlik software can be downloaded from our official Qlik Download page (customer login required).
-
Administrator approval and consent for Web Connectors (Azure storage, Office 365...
Account Types Personal Account: Once the connector has authorization to access the Microsoft account there will be a corresponding entry in "My app... Show MoreAccount Types
- Personal Account:
Once the connector has authorization to access the Microsoft account there will be a corresponding entry in "My apps"
https://myapps.microsoft.com/- Enterprise Account:
Granting Access for Enterprise Accounts:
Once the enterprise application is selected an application list will appear that the user can filter searching for Qlik Web Connector:Select Qlik Web Connectors (Office 365 SharePoint) and look for the properties page. The page should have the following checkboxes ticked.
Enabled for users to sign-in? (Yes)
User assignment required? (Yes) This field is only mandatory if the administrator wants to restrict access to the users.
Visible to users? (Yes)
Testing (With administrator rights)
Open Qlik Office 365 SharePoint connector and select "Can Authenticate" and the press the green button "Authenticate"
You will be redirected to a Microsoft login page that should look similar to the following picture:
If azure grants access, the Qlik Webconnector application will generate a code as the following one:
Testing (With NON administrator rights)
If a basic (Non admin) user tries to auth the following message would appear in azure:
In order to fix this the administrator needs to grant access to the users.
Once the administrator granted access to the user the message that should appear is the following one: -
Qlik Talend Cloud: Unable to use datasource using AD Password authentication
When attempting to create a datasource that enables routes/services to access an Azure-based SQL Server with AD Authentication, the datasource may fai... Show MoreWhen attempting to create a datasource that enables routes/services to access an Azure-based SQL Server with AD Authentication, the datasource may fail to connect. Despite providing the necessary ms__auth.dll to Runtime (either through the service or etc folder) and windows, the tesb log may still display the following error message:
"Failed": "com.microsoft.sqlserver.jdbc.SQLServerException:Failed to load MSAL4J Java library for performing ActiveDirectoryPassword authentication.
Cause
In many cases, the reason for this error is due to Runtime not having the specific library installed within it. Although they are very similar, Azure-based SQL Instances do require specific dependencies that may not be found with the regular Microsoft SQL JDBC drivers. This may affect those users who have a Runtime instance at or newer than the R2024-06 Patch.
Resolution
To address this issue, please follow these steps:
- Remove any SQL JDBC jars that may have been copied to the <Runtime>/lib folder.
- Use the karaf client (<Runtime>/bin/client.sh) to run "feature:install azure-msal4j" to install the bundle and library into Runtime.
- Redeploy any affected routes/services, and verify that both the datasource and the task run as expected.
If the datasource or task is still encountering connection issues, kindly contact Qlik Support.
Environment
- Talend Cloud 8.0.1
-
Qlik Sense Utility - Functions and Features
The QlikSenseUtil comes bundled with Qlik Sense Enterprise on Windows. It's executable is by default stored in: %Program Files%\Qlik\Sense\Repository\... Show MoreThe QlikSenseUtil comes bundled with Qlik Sense Enterprise on Windows. It's executable is by default stored in:
%Program Files%\Qlik\Sense\Repository\Util\QlikSenseUtil\QlikSenseUtil.exe
Qlik Sense Util is no longer supported as a backup and restore tool. For the officially supported backup and Restore Process, see Backup and Restore.
It serves as a:
- Qlik Sense Port Checker: Pings every active port Qlik sense is using for every node. Note that some ports can be for internal use and might not be exposed to the node you are pinging from.
- Data structure checker: Mostly applicable for a synchronized persistence deployment. Checks that the data references are not broken.
- Duplicate server nodes: Mostly applicable for a synchronized persistence deployment. Checks there are no duplicate server nodes in the database.
- Remove old app binaries: Remove deleted app binaries from the selected folder.
- Get system configuration: Returns the system configuration from the database.
- Connection string editor: A tool for editing the connection string.
- Service Cluster: Functionality for updating the service cluster in the database.
- Log Fetcher: A tool for fetching logs from the system. If the time span is shorter than 24h all logs will be summarized in one single file. This will make trouble shooting easier if you are looking for events what occurred within a short time frame.
- Fetching logs with a time span larger than 24h will copy the logs and paste them in their logical structure. The filter functionality selects every row with the specified keyword and creates log files based on rows selected.
Note : Qlik Support prefers using the Log Collector included in How To Collect Qlik Sense Log Files
- Fetching logs with a time span larger than 24h will copy the logs and paste them in their logical structure. The filter functionality selects every row with the specified keyword and creates log files based on rows selected.
- Service type checker: Mostly applicable for a synchronized persistence deployment. Checking for duplicated service types in the database.
-
QlikView & Qlik Sense Unified (Dual Use) License - User Allocation
With a Unified license (formerly called Dual Use License) the legacy QlikView license is complemented with a Qlik Sense license that can be applied to... Show More
With a Unified license (formerly called Dual Use License) the legacy QlikView license is complemented with a Qlik Sense license that can be applied to the QlikView server as it includes QlikView entitlement license attributes. Such license needs to be activated with the Signed License Key (SLK). When a customer enters an Analytics Modernization Program (AMP, formerly known as Dual Use program), QlikView CALs (e.g. Named User CALs, Document CALS, Session CALs and Usage CALs) are converted into Professional User, Analyzer User, and Analyzer Capacity User allocations based on the Analytics Modernization Program conversion ratios.Here are two scenarios:
I. If a customer transitions to AMP with on-premise (client-managed) Qlik software (e.g. converts to the perpetual estate or convert to subscription Qlik Sense Enterprise on Windows), a Unified License containing the converted quantity of Professional Users, Analyzer Users and Analyzer Capacity would be delivered. This license contains a customized Qlik Sense Enterprise Signed License Key (SLK) which can also be deployed on QlikView Server and/or QlikView Publisher. If a user is assigned a Professional or Analyzer user license, this assignment information is synchronized to all Qlik Sense and QlikView deployments activated using this Unified License key. As such one user just needs one license to access the entire Qlik software platform (regardless if it is Qlik Sense or QlikView).
In this scenario, as long as the QlikView Server and Qlik Sense edition use the same Identity Provider (IdP) the user can access apps on both environments consuming only one user license allocation.
If the user license is reallocated in any of the systems to a different user, the same will occur across both QlikView and Qlik Sense environments.
II. If a customer transitions to AMP with Qlik Sense Enterprise SaaS add-on, a Qlik Sense Enterprise SaaS tenant may use a Unified License for the on-premise deployment. The customer is able to upload QlikView document prepared by the on-premise QlikView software directly into Qlik Sense Enterprise SaaS for distribution.A QlikView Server or a Qlik Publisher software can be activated in two ways:
1) Using a legacy method with 16-digit QlikView license key and the corresponding control number
2) Using a modern Unified License with Signed License Key containing needed QlikView Server and Publisher Service attribute(s). In this latter scenario, user license assignment (Professional/Analyzer) and analyzer capacity would be synchronized with other deployments using the same Signed License Key as it is done in the Unified License model
If the customer opts to remain in Perpetual licensing, the existing QlikView license model can be retained. Otherwise, if the customer opts for conversion into Subscription licensing model, a set of QlikView subscription license attributes mirroring the existing QlikView perpetual license key setup would be delivered such that the customer switch to the subscription QlikView keys without the need for an immediate migration project towards using Unified licensing.
Note: Please note that Qlik is no longer starting clients on the Perpetual license model. See End of Perpetual License Sales
Environment:
Related Content:
-
How to count sessions in Qlik Sense
How are sessions counted in Qlik Sense? The following are examples of how sessions are counted within Qlik Sense. One user opens Qlik Sense Hub wi... Show MoreHow are sessions counted in Qlik Sense?
The following are examples of how sessions are counted within Qlik Sense.
- One user opens Qlik Sense Hub with One browser on One machine = 1 session
- One user opens Qllik Sense Hub with One browser but Multiple tabs on One machine= 1 session
- One user opens Qlik Sense Hub with Two different browsers on One machine= 2 sessions
- One user opens Qlik Sense Hub with One browser, then closes the browser and reopens it = 2 sessions
- One user opens Qlik Sense Hub with One browser on Two different machines = 2 sessions
- One user opens Qlik Sense Hub and two Apps in one browser, two different tabs and on a mobile device = 2 sessions
- One user opens Qlik Sense Hub from Two virtual proxy with One browser on One machine= 2 sessions
- One user opens Qlik Sense Management Console (QMC) with One browser on One machine = 1 session
- One user opens a Qlik Sense Mashup using Two Apps hosted from the same proxy = 1 session
Sessions will be terminated after the currently configured Session timeout in the Qlik Sense Proxy.
If the Qlik Sense engine or Proxy are terminated or crash, Sessions are ended right away.Once the maximum number of parallel user connections (5) is reached, this will be documented in the AuditSecurity_Repository log. To identify if this is the issue, review the relevant log and review how the user is interacting with the system.
The log is stored in:
C:\Programdata\Qlik\Sense\Log\Repository\Audit\AuditSecurity_Repository.txt
The related message reads:
Access was denied for User: 'Domain\USER', with AccessID '264ff070-6306-4f1b-85db-21a8468939b5', SessionID: 'e3cd957b-a501-4bec-a3f8-d35170a73efa', SessionCount: '5', Hostname: '::1', OperationType: 'UsageDenied'
Related content:
Troubleshoot too many sessions active in parallel
Qlik Sense April 2018 and later- Service account getting "You cannot access Qlik Sense because you have no access pass"
-
QlikView Service Account Requirements
The QlikView Services can be set up to either use the local QlikView Administrators Group, or Digital Certificates. The Service Account has specific r... Show MoreThe QlikView Services can be set up to either use the local QlikView Administrators Group, or Digital Certificates. The Service Account has specific requirements.
The two options during installation are Use digital certificates and Use QlikView Administrators Group.
Use digital certificates:
Authenticate communication between QlikView servers using digital certificates and SSL. This alternative is recommended in environments where not all servers have access to a common Windows Active Directory or when the security provided by certificate authentication is required. Note that digital certificates are only supported by Windows Server 2008 R2 and later.
Use QlikView Administrators Group:
Authenticate communication between QlikView services based on membership in the local Windows group QlikViewAdministrators. This alternative can be used in environments where all servers that are part of the QlikView installation can authenticate using a common Windows Active Directory.
Regardless of the option chosen, the service account used to run the services has to be:- A local administrator on the host operating system
- Be able to run as a network service
- Have access to all the QlikView related folder structure, such as ProgramData, Program Files, and configured application data (.qvw storage, .qvd storage, log files) locations.
Note: GMSA (Standalone Managed Service Accounts) are not supported for Qlik products
Environment:Related Content: