Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Search our knowledge base, curated by global Support, for answers ranging from account questions to troubleshooting error messages.
Qlik 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:
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 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)
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.
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 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:
Log in to manage and track your active cases in Manage Cases. (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.
When creating a case, you will be prompted to enter problem type and issue level. Definitions shared below:
Select Account Related for issues with your account, licenses, downloads, or payment.
Select Product Related for technical issues with Qlik products and platforms.
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.
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.
If you require a support case escalation, you have two options:
When other Support Channels are down for maintenance, please contact us via phone for high severity production-down concerns.
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.
Partial reloads can be performed in Qlik Sense via the in-app Button object. More information is available under Partial Reload - Qlik Sense on Windows.
For older versions of Qlik Sense, a third party extension is available which can be used to achieve Partial Reload. Note that this third party extension is not covered by Qlik Support. Please contact the extension vendor for assistance.
Download: Qlik Branch Project: Qlik Sense Reload Button
Or: GitHub repository for the Qlik Sense Reload Button.
Documentation on how to load new and updated records with incremental load can be found here: Loading new and updated records with incremental load
The Qlik Sense log files can be easily collected using the Log Collector.
The Log Collector is embedded in the Qlik Sense Management Console. It is the last item listed in the Configure Systems section.
For instructions on how to use the Log Collector, see Log collector (help.qlik.com).
Content
The user must be a root admin and have administrative permissions.
The best way to gather these logs is to use the Qlik Sense Log Collector. If the tool is not included in your install, it can be downloaded from this article.
This list provides an overview of what system information the Qlik Sense Log collector accesses and collects.
C:\Windows\System32\whoami.exe
C:\Windows\System32\netstat.exe -anob
C:\Windows\System32\tasklist.exe /v
C:\Windows\System32\netsh.exe advfirewall show allprofiles
C:\Windows\System32\ipconfig.exe /all
C:\Windows\System32\iisreset.exe /status
C:\Windows\System32\reg.exe query "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings" | find /i "ProxyEnable"
C:\Windows\System32\reg.exe query "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings" | find /i "proxyserver"
C:\Windows\System32\reg.exe query "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings" | find /i "AutoConfigURL"
C:\Windows\System32\reg.exe query "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings" | find /i "ProxyOverride"
C:\Windows\System32\ping.exe google.com
C:\Windows\System32\net.exe use
C:\Windows\System32\wbem\wmic.exe /OUTPUT:STDOUT logicaldisk get size
C:\Windows\System32\net.exe localgroup "Administrators"
C:\Windows\System32\net.exe localgroup "Qlik Sense Service Users"
C:\Windows\System32\net.exe localgroup "Performance Monitor users"
C:\Windows\System32\net.exe localgroup "QlikView Administrators"
C:\Windows\System32\net.exe localgroup "QlikView Management API"
C:\Windows\System32\systeminfo.exe
C:\Windows\System32\wbem\wmic.exe /OUTPUT:STDOUT product get name
C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe -command "gwmi win32_service | select Started
C:\Windows\System32\gpresult.exe /z
C:\Windows\System32\secedit.exe /export /areas USER_RIGHTS /cfg
C:\Windows\System32\secedit.exe /export /areas
C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe -command "Get-ChildItem -Recurse Cert:\currentuser\my | Format-list"
C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe -command "Get-ChildItem -Recurse Cert:\currentuser\Root | Format-list"
C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe -command "Get-ChildItem -Recurse Cert:\localmachine\my | Format-list"
C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe -command "Get-ChildItem -Recurse Cert:\localmachine\Root | Format-list"
$FormatEnumerationLimit=-1;$Session = New-Object -ComObject Microsoft.Update.Session;$Searcher = $Session.CreateUpdateSearcher();$historyCount = $Searcher.GetTotalHistoryCount();$Searcher.QueryHistory(0, $historyCount) | Select-Object Title, Description, Date, @{name="Operation"; expression={switch($_.operation){1 {"Installation"}; 2 {"Uninstallation"}; 3 {"Other"}}}} | out-string -Width 1024
C:\Windows\System32\netsh.exe http show urlacl
C:\Windows\System32\netsh.exe http show sslcert
Any versions of Qlik Sense Enterprise on Windows prior to May 2021, do not include the Log Collector.
If the Qlik Sense Log collector does not work then you can manually gather the logs.
For information on when logs are archived, see How logging works in Qlik Sense Enterprise on Windows.
Persistence Mechanism Current Logs(Active Logs) Archived Logs
Shared (Sense 3.1 and newer) | C:\ProgramData\Qlik\Sense\Log | Defined in the QMC under CONFIGURE SYSTEM > Service Cluster > Archived logs root folder Example enter (\\QLIKSERVER\QlikShare\ArchivedLogs) |
Synchronized (Sense 3.1 and older) | C:\ProgramData\Qlik\Sense\Log | C:\ProgramData\Qlik\Sense\Repository\Archived Logs |
Note: Depending on how long the system has been running, this folder can be very large so you will want to include only logs from the time frame relevant to your particular issue; preferably a day before the issue began occurring.
Sometimes a specific version JVM is needed rather than the shipped JVM, for example due to a known vulnerability in the JVM, the existing JVM need to upgrade to a higher verion. However, the new jvm folder may not contain two required security configuration files, causing Replicate to generate the following warning message:
JVM security configuration directory is missing or not a directory; unable to set the Java security policy
This warning message is reported by Replicate due to the missing of the following two security configuration files:
To resolve this issue, you can simply copy these two files from your backup or another Replicate server into the <Replicate folder>\jvm\conf\security folder.
#00163870
Introduction
Qlik Cloud produces a variety of report, print, file, and snapshot moments, generated by a platform level reporting service. This service supports:
The user driven reporting service events are written to the system event log (functionality based use of the service does not surface in the event log, the output would be too verbose).
Customers may be interested in seeing the result of report executions. This guide is designed to explain how to interpret the corresponding events.
The guide is divided into two sections:
Report production events are found by filtering within the Management Console > Events on the Event Type = com.qlik.v1.reporting-service.audit.
Content
{
"id": "663277a798eb2d13d2c3a333",
"contentType": "application/json",
"data": {
"appIds": [
"b31fe1c2-decd-4696-ac7e-7df27428789b"
],
"endTime": "2024-05-01T17:11:03.40535814Z",
"requestId": "88e96f5a-3892-4afd-a879-bc8b7f5a6818",
"startTime": "2024-05-01T17:11:01.347985863Z",
"success": true,
"tags": [
"sense-dialog.download"
],
"templateType": "sense-data-1.0",
"traceId": "172e801877587347357f9a5138c48701",
"version": "1.0.0"
}
Attribute | Value | Description |
tags | Sense-dialogue.Download | Sense dialog download is any form of user interactive download |
templateType |
Sense-data-1.0 |
Data export end point |
Note this is not yet a public API endpoint to call.
Attribute | Value | Description |
tags | Public.api | Public.API |
templateType |
Sense-data-1.0 |
Data export end point |
{
"appIds": [
"b31fe1c2-decd-4696-ac7e-7df27428789b"
],
"endTime": "2024-05-01T17:11:21.814030208Z",
"requestId": "3ae3c9c6-d28f-4fc6-8b2a-0be2b0cfcc71",
"startTime": "2024-05-01T17:11:17.66059892Z",
"success": true,
"tags": [
"sense-dialog.download"
],
"templateType": "sense-image-1.0",
"traceId": "95161d35acf1183a7b36f1f39faecd66",
"version": "1.0.0"
}
Attribute | Value | Description |
tags | Sense-dialogue. Download | Sense dialog download is any form of user interactive download |
templateType |
Sense-image-1.0 |
Image export (PDF, PNG) |
Attribute | Value | Description |
tags | Public.api | Public.API |
templateType |
Sense-image-1.0 |
Image export (PDF, PNG) |
{
"appIds": [
"b31fe1c2-decd-4696-ac7e-7df27428789b"
],
"endTime": "2024-05-01T17:11:43.175827418Z",
"requestId": "c3edbfcd-b847-4991-acad-348e338b7ee7",
"startTime": "2024-05-01T17:11:36.079944632Z",
"success": true,
"tags": [
"sense-dialog.download"
],
"templateType": "sense-sheet-1.0",
"traceId": "0c50ddaad377373f4672fdc64cd450b2",
"version": "1.0.0"
},
"eventId": "0e2da497-3a4a-439b-8b3c-5f3ebc31",
"eventTime": "2024-05-01T17:11:43.18Z",
"eventType": "com.qlik.v1.reporting-service.audit",
"eventTypeVersion": "1.0.0",
"source": "com.qlik/reporting-service",
"tenantId": "5rTVZhiekEho5Om7w3bdyfGtmwX8BumO"
}
Attribute | Value | Description |
tags | Sense-dialogue. Download | Sense dialog download is any form of user interactive download |
templateType |
Sense-sheet-1.0 |
Sheet export |
Attribute | Value | Description |
tags | Public.api | Public.API |
templateType |
Sense-sheet-1.0 |
Sheet export |
{
"appIds": [
"b31fe1c2-decd-4696-ac7e-7df27428789b"
],
"endTime": "2024-05-01T17:48:01.069046496Z",
"requestId": "8f0753a8-b5e6-4228-9116-810463798a00",
"startTime": "2024-05-01T17:47:53.073590738Z",
"success": true,
"tags": [
"sense-dialog.download"
],
"templateType": "sense-story-1.0",
"traceId": "85fcc96bbe90bf63a13ce7ab9cf80d34",
"version": "1.0.0"
},
"eventId": "dab6e663-d616-4709-ae95-7ff58205",
"eventTime": "2024-05-01T17:48:01.073Z",
"eventType": "com.qlik.v1.reporting-service.audit",
"eventTypeVersion": "1.0.0"
}
Attribute | Value | Description |
tags | Sense-dialogue. Download | Sense dialog download is any form of user interactive download |
templateType |
Sense-story-1.0 |
Story export |
{
"appIds": [
"b31fe1c2-decd-4696-ac7e-7df27428789b"
],
"endTime": "2024-05-01T17:59:01.740635217Z",
"requestId": "5e2c6c5e-a3e8-4d18-b615-3d4ef63c2418",
"startTime": "2024-05-01T17:58:56.867196577Z",
"success": true,
"tags": [
"subscription.execution"
],
"templateType": "sense-image-1.0",
"traceId": "947c5ed814b2806e1f999f23a84b5208",
"version": "1.0.0"
}
Attribute | Value | Description |
tags | Subscription.execution | In-app subscription to schedule ppt or pdf of sheet or object |
templateType |
sense-image-1.0 |
Image creation |
{
"appIds": [
"b31fe1c2-decd-4696-ac7e-7df27428789b"
],
"endTime": "2024-05-01T17:56:21.448612143Z",
"requestId": "7d7c7ed5-e502-45fe-a311-dae9e4fafcd8",
"startTime": "2024-05-01T17:56:13.972763031Z",
"success": true,
"tags": [
"subscription.execution"
],
"templateType": "composition-1.0",
"traceId": "5d4b3f75262d234dfac3ba7780251cce",
"version": "1.0.0"
}
Attribute | Value | Description |
tags | Subscription.execution | In-app subscription to schedule ppt or pdf of sheet or object |
templateType |
composition-1.0 |
(multi) Sheet export end point |
Attribute | Value | Description |
tags | Subscription.execution | In-app subscription to schedule ppt or pdf of sheet or object |
templateType |
Sense-sheet-1.0 |
(multi) Sheet export end point |
{
"appIds": [
"b31fe1c2-decd-4696-ac7e-7df27428789b"
],
"endTime": "2024-05-01T20:32:17.920285639Z",
"requestId": "8db9ff48-58db-45af-896a-1d24915fc092",
"startTime": "2024-05-01T20:32:13.516370912Z",
"success": true,
"tags": [
"share.execution"
],
"templateType": "sense-image-1.0",
"traceId": "2ffcee2d2880dd2332faef1ae3a3c180",
"version": "1.0.0"
}
Attribute | Value | Description |
tags | Share.execution | Manual image share option from a single image |
templateType |
Sense-image-1.0 |
image |
Attribute | Value | Description |
tags | Qlik-view-client.download | In app download from qlikview |
templateType |
Qv-data.20 |
Xls template execution |
{
"appIds": [
"1af4b714-2775-4953-83b8-987c0774c5c6"
],
"endTime": "2024-05-01T19:50:25.854202416Z",
"requestId": "d855651a-c903-4d9a-97f7-2814f0472120",
"startTime": "2024-05-01T19:50:07.855261952Z",
"success": true,
"tags": [
"automation.execution"
],
"templateType": "composition-1.0",
"traceId": "c619c6253bc91324d732ce33c283634e",
"version": "1.0.0"
}
Attribute | Value | Description |
tags | automation.execution | Sense dialog download is any form of user interactive download |
templateType |
composition-1.0 |
(multi) Sheet export end point |
Attribute | Value | Description |
tags | Public.ca | Public.api |
templateType |
composition-1.0 |
(multi) Sheet export end point |
{
"appIds": [
"09eea519-a69c-456e-8790-ef0bacc42310"
],
"endTime": "2024-05-01T20:43:28.164075781Z",
"requestId": "ea4c3813-ddc6-4b9a-9d6f-bf2661b344bc",
"startTime": "2024-05-01T20:43:14.954667825Z",
"success": true,
"tags": [
"reporttask.execution"
],
"templateType": "sense-excel-template-1.0",
"traceId": "85bed67c255d596f4758d9813a4c6ade",
"version": "1.0.0"
}
Attribute | Value | Description |
tags | reporttask.execution | Execution by the sharing service |
templateType |
Sense-excel-template-1.0 |
Xls template execution |
Executing users vary on a number of factors.
For Non-Section access the Report Task owner will always be the user associated with an attempted execution event
For Section Access control apps, if see a recipient is a Qlik Cloud users and has access to the app and is in the recipient list the attempted report execution will be in that users name. If a recipient is not a Qlik Cloud user the attempted execution will be in the name of the task owner.
Attribute | Value | Description |
tags | excel-addin.download | Preview/download from the xls-addin |
templateType |
Sense-excel-template-1.0 |
Xls template execution |
Attribute | Value | Description |
tags | Public.api | Preview/download from the xls-addin |
templateType |
Sense-excel-template-1.0 |
Xls template execution |
For those that make use of the Qlik Reporting Service with the integrated report task capability within a Qlik Sense App, a deeper understanding of the related events will be helpful. The in-app Report Task before executions performs two key checks:
The net of these pre-checks is that it is not possible to do a reliable sum-check on recipients vs reporting-service events.
A report task execution can be better understood by filtering within the Management Console > Events on the Event Type = com.qlik.reporting-task.summary.created
{
"appId": "09eea519-a69c-456e-8790-ef0bacc42310",
"createdDate": "2023-11-30T14:15:28Z",
"creatorId": "uzWYcE_cOycXMWhuD6BlRKH82I2dI-J8",
"description": "",
"distributionchannels": [
"email"
],
"emailRecipientDisabledExternalCount": 0,
"emailRecipientDisabledInternalCount": 0,
"emailRecipientEnabledExternalCount": 1,
"emailRecipientEnabledInternalCount": 2,
"emailRecipientsCount": 3,
"enabled": true,
"error": "",
"expiry": "",
"failedExecutions": 0,
"hassectionaccess": false,
"id": "65689900fbdb6445fe1fc0c7",
"insightLink": "",
"name": "Manager Report (Non SA)",
"ownerId": "uzWYcE_cOycXMWhuD6BlRKH82I2dI-J8",
"reportingServiceEventId": "91eb71cd-d406-4ab5-931b-12acc9e17ee8:0",
"resourceId": "65689900fbdb6445fe1fc0c7",
"resourceLink": "",
"resourceType": "reporting-task",
"sharingTaskExecutionId": "664cdd2c12581af546d192c7",
"sharingTaskOwnerId": "uzWYcE_cOycXMWhuD6BlRKH82I2dI-J8",
"sharingTaskType": "template-sharing",
"spaceId": "61263cd6de5df122d79348bb",
"status": "VALID",
"successfulExecutions": 2,
"thumbnail": "",
"transports": [
"email"
],
"typeOfSpace": "shared",
"workflowId": "664cdd2b12581af546d192c4"
}
EmailRecipientsCount | The email recipient counts reflect attempted emails sent (see Mail Transport below) |
SuccessfulExecutions |
The number of unique reports created as part of the task |
Failedexecutions |
The number of failed report creation executions for any reason as part of the submitted task structure. |
Another event that may be relevant to distribution use cases like Subscriptions, Tabular Reporting or event Data Alerts is the transport event found by filtering within the Management Console > Events on the Event Type com.qlik.transport-response.email.sent
There can be many reasons why a recipient suggests they did not recieve an email including spam filters, organization email filters, etc. However, an event is logged to capture the call to the tenant SMTP service. Note that this event only indicates that a connection was made and the payload was passed to the SMTP service, this event has no knowledge of any SMTP service processing of the payload.
{
"accepted": [
"658079d5374a6c533936afa8"
],
"connectionFailed": false,
"failure": false,
"message": "250 Ok: queued as cjnLv8frTyuJ9doIY1Q7JA",
"rejected": [],
"requestId": null,
"serviceProvider": "classicSMTP",
"smtpResponseCode": 250,
"tracking": null
}
The failure (400) of Nexus API service causes task execution failed and generates intermittent occurrences of "Unexpected Error" issues with low frequency from plan/task execution.
Nexus Log
10.80.3.171 - admin [01/Apr/2024:05:03:31 +0800] "GET /service/rest/v1/search/assets/download?repository=releases&maven.groupId=xxx&xx&version=2.0.0&maven.extension=zip.md5&maven.classifier= HTTP/1.1" 400 - 184 6 "Apache-HttpClient/4.5.10 (Java/1.8.0_292-ea)" [qtp661824503-136003]
TAC Log
2024-04-01 05:06:48 ERROR ExecutionTaskHandler - org.talend.exception.BusinessException: There is no artifact for task 'job_xxx_ingestion_v2' in NEXUS 3 Repository.
2024-04-01 05:06:48 ERROR ExecutionTaskHandler - java.util.zip.ZipException: error in opening zip file
2024-04-01 05:06:48 ERROR ExecutionTaskHandler - org.talend.json.JSONException: JSONObject["filePath"] not found.
These above logs from both TAC and Nexus reveal that the Nexus server's REST API failed to provide a correct status code (200), which is essential for the successful completion of the TAC zip downloading process. The Nexus API service response resulted in a 400 error and this failure (400) causes the execution of plans/tasks to fail.
The root cause of this failure (400) of Nexus API service issue could be attributed to
Boost the Nexus with longer session time by modifying the following UI settings
Session Timeout
Standard Request Timeout
Extended Request Timeout
Enhance Monitoring
Due to a limitation in MS-CDC source endpoint DDL changes on the source must be handled manually.
Table-level DDLs are not supported. When a table DDL is encountered, the DDL will be transferred to the target and the table will be suspended to allow the CT table to be manually aligned.
The following steps show how to handle a DDL change on a table.
Alternate DDL Change Handling for MS-CDC endpoint task only. Do not need to do this for a standard MS SQL endpoint.
1. Stop the Qlik Replicate task
2. Disable ms-cdc for the table in the source database
3. Modify the source table
4. Modify the target table
5. Start the task with metadata only run (Create missing tables and then stop). This will refresh the internal metadata without losing position.
6. Enable ms-cdc for the table (if task is not set to do it automatically)
7. Resume the task
Qlik Replicate
SQL Server MS-CDC
Limitations and considerations
Qlik Replicate: The metadata for source table 'table name' is different than the corresponding MS-CDC Change Table
Changing the Admin User in Talend Academy requires following specific steps and ensuring accurate details are provided.
For Customer Domain Administrators needing assistance, please refer to the templates provided below.
If encountering difficulties, use the support template to contact us for assistance.
Subject: Request to Change Admin User in Talend Academy
Dear Customer Domain Administrator,
I hope this message finds you well.
I am writing to request a change in the Admin User for our organization's Talend Academy account. Below are the necessary details:
Note: Please refer to the document attached to check if you have the authority to make the requested changes. If you are unable to proceed, kindly contact Talend Support for further assistance.
Your prompt assistance in changing the Admin User would be greatly appreciated.
Thank you for your support and consideration.
Best regards,
[Your Name]
Subject: Request to Change Admin User in Talend Academy
Dear Academy Team,
I hope this message finds you well.
I am writing to request a change in the Admin User for our organization's Talend Academy account. Below are the necessary details:
Your prompt assistance in changing the Admin User would be greatly appreciated.
Thank you for your support and consideration.
Best regards,
[Your Name]
Talend, the leader in data integration and integrity, proudly announces our Talend badging program that gives you the ability to securely share your verified technical skills on social media as you progress on the path to a recognized Talend expert.
If you are brand new to Talend, and want to learn more about how Talend products can help you get more value from your data, register for Talend Academy and start learning with the Talend Data Fabric Foundations learning plan. If you complete all the modules and quizzes, you will gain an understanding of the benefits delivered by Talend products, and you will earn the Talend Data Fabric Explorer badge.
With a Talend Academy subscription, new badge tracks become available to help you expand your knowledge of Talend products. You earn badges as you complete specific training in Talend Academy and pass certification exams.
On your path to expertise, Talend awards you badges that recognize your level of technical proficiency, from Explorer to Certified.
On completion of the Introduction to Talend Studio course on Talend Academy, you will receive the Talend Studio Explorer badge. It proves that you have a basic understanding of Talend Studio and how to perform basic tasks, such as creating and running a Job, parsing a delimited file, and connecting to a database. This is your first step on the journey to becoming a Talend expert.
Next, you will decide which track makes the most sense for you and your career development, depending on your role and area of interest. For more information, click the links to see the page for each track:
This list will increase over time to address more roles and areas of the Talend Data Fabric. Stay tuned!
To be awarded a Practitioner badge, you need to complete learning plans on Talend Academy based on the track you selected. For example, to get a Data Integration developer Practitioner badge, you need to complete the Data Integration Basics and Data Integration Advanced learning plans.
To guide you from the Explorer level to the Practitioner level, you can collect Talend Academy trophies along the way. In learning plans, you will find quizzes to assess your knowledge and understanding of the training material. If you achieve a score of 80% or more, then you will be awarded a trophy.
Each trophy demonstrates progress along the path towards the Practitioner badge. When you successfully complete your training and have collected the necessary trophies, you will earn a Practitioner badge to show that you are ready to contribute to projects. Now it’s time to celebrate and share your success with your peers!
Talend offers certification exams that assess your knowledge of product usage and the underlying methodology required to successfully implement quality projects. The exams are designed by Talend subject matter experts to ensure the quality and relevance of the technical topics covered in the exam. On completion of the certification exam, you will be awarded a Certified badge.
To be successful in the exam, participants are expected to have completed the recommended training on Talend Academy, earned the corresponding Practitioner badge, and have six months of hands-on experience on the product.
In addition to the formal training, Talend Academy offers certification preparation courses to help you get fully prepared for the exam. They include:
You’ll find all the details on our Certification Exams page.
Once you feel ready for the exam, register on the Kryterion Webassessor site.
Passed? Well done! Certified badge holders know how to implement quality projects, which may be an opportunity for you to expand your role. Make sure your peers know about this new achievement!
Claiming your Talend badge is simple. On completion of the earning criteria for each Talend badge, you will receive a notification email from Talend.
To claim your Talend badge, follow these simple steps:
If you don’t have an account, create one and validate it by clicking the link in the account creation email you will receive.
Note that you can have multiple email addresses attached to your badging account, such as professional and personal emails, or an email address from a previous employer. It means you have the ability to regroup all your badges into a single account so that peers and recruiters can view all your badges acquired over time.
This article contains steps on how to do backup and restore the Qlik Sense Enterprise on Windows (QSEoW) site.
For full instructions on how to backup and restore a Qlik Sense site, see the online help under Backup and restore Qlik Sense Enterprise on Windows.
For sole database backup information article can be found here: How to backup PostgreSQL database in Qlik Sense
Backup and Restore Targets:
Environment:
Note: These steps are provided as-is based on latest version available of Qlik Sense product at the time of writing and/or last update to the article. Please make sure to cross-reference these steps with the official documentation for your product version under Backup and restore Qlik Sense Enterprise on Windows.
Backing up Qlik Sense Repository Database:
! Downtime is required.
cd "C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6\bin"
.\pg_dump.exe -h localhost -p 4432 -U postgres -b -F t -f "c:\backup\QSR_backup.tar" QSR
Restoring Database (PostgreSQL):
Option 1: Restoring on the same machine (PostgreSQL)
cd "C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6\bin"
.\dropdb.exe -h localhost -p 4432 -U postgres QSR
.\createdb.exe -h localhost -p 4432 -U postgres -T template0 QSR
.\pg_restore.exe -h localhost -p 4432 -U postgres -d QSR "c:\backup\QSR_backup.tar"
For further reference, consult the Qlik Sense Help Site for your respective version.
Option 2: Restoring on a different machine (PostgreSQL)
cd "C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6\bin"
.\dropdb.exe -h localhost -p 4432 -U postgres QSR
.\createdb.exe -h localhost -p 4432 -U postgres -T template0 QSR
.\pg_restore.exe -h localhost -p 4432 -U postgres -d QSR "c:\Backup\QSR_backup.tar"
cd "C:\Program Files\Qlik\Sense\Repository"
.\repository.exe -standalone -restorehostname
Backing up The Certificate
Please refer to the Backing up Certificates Help site documentation for details and verify that the information matches your current version.
Restoring The Certificate
Please refer to the Restoring certificates Help site documentation for details and verify that the information matches your current version.
Backing up the Apps used by Qlik Sense
Restoring Apps used by Qlik Sense:
Backing up the Repository Content used by Apps:
Normally, It is similar to the section for apps, the path where these files live is in the StaticContent folder on the Share path.
Restoring the Repository Content used by Apps:
Restoring a Qlik Sense site to a machine with a different hostname
Security of Qlik Sense Enterprise on Windows can be approached in the below discrete areas. All these areas provide different options for increasing security in a deployment, and thereby mitigating vulnerabilities and protecting against attackers.
Content:
Be aware that a high level of server hardening can lead to failure in your deployment. Be mindful of always having a backup to restore to in case your configuration leads to irreversible failure.
Qlik Sense Enterprise on Windows supports multiple different Authentication Solutions;
Qlik can not specify which authentication method is appropriate for each deployment. It is advisable to review currently supported alternatives within your organization and/or Identity Provider (IdP) to implement the most suitable solution for your use case.
Qlik Sense Enterprise on Windows provides two levels of native authorization in the product.
Attribute based access control (ABAC), which is configured through Qlik Sense security rules. This article will not go in depth on how to best implement security rules for your requirements, but it is highly recommended to think of your users based on the capabilities that you intend to provide them. For example different roles and capabilities as shown in image below, allows for a security rule framework to be designed and implemented. This can be done either by yourself by referencing Qlik Sense Help for Administrators and available assets or by engaging with a Qlik Consultant or Qlik Partner.
Row level data reduction, which is configured through Section Access at Qlik Sense app level. This article will not go in depth on Section Access implementation, but with this reduction a single file can be used to hold the data for a number of users or user groups. Qlik Sense uses the information in the section access for authentication and authorization, and dynamically reduces the data, so that users only see their own data.
Qlik Sense Enterprise on Windows inherits the available protocols, cipher suites, key exchanges and other security hardening which are enabled on the Windows Server operating Qlik Sense.
Windows Server has a lot of protocols enabled by default; however protocols, ciphers, hashes and key exchanges that are considered deprecated or not secure enough should be disabled. There are many ways of doing this, and the Windows administrator and security experts should be consulted so that local policies are accurately applied. For simplicity, understanding and a good overview IIS Crypto 3.0 can be a good tool for evaluating current Windows configuration and applying changes.
Keep in mind that "Best Practice" today might not be recommended in the near future, what was considered "safe" a while ago is not necessarily considered so today. For this reason, it is also important to regularly scan servers for potential vulnerabilities and revisit configurations as required.
Windows Server needs to be restarted for these settings changes to take effect. It is also important to ensure that all components running on the server still operate as expected after hardening is applied, for example older non-Qlik software might not be compliant with the latest options and standards.
Firewalls typically should be closed, with required ports only opened for intended purposes.
See Qlik Sense Enterprise on Windows ports overview for details on required port based on the deployed architecture.
For most organizations, local administrator rights allow for an easier deployment, but Qlik Sense Enterprise on Windows does not require local administrator rights in order to function. This can be an attractive option inside some organizations. This will require additional configuration of boot strap mode as described in Qlik Sense Enterprise on Windows Services.
For a brief overview of the rights needed by a Qlik Sense Enterprise service account:
Qlik Sense Enterprise for Windows does not officially support Group Managed Service Accounts (gMSA), but it can operate using one. The initial barrier is that the installer requires a service account and password to be entered during installation. A domain or local account could be substituted for the install stages only to be swapped out in the Windows Services applet (services.msc) after installation. Some functionality may require workarounds (e.g. A User Directory Connection to Active Directory).
Qlik Sense Enterprise on Windows does require exceptions from anti-virus scan to avoid potential disk I/O conflicts. Refer to Qlik Sense Folder And Files To Exclude From AntiVirus Scanning for more details.
Qlik Sense Enterprise on Windows can run with Federal Information Processing Standards (FIPS) enabled on the Windows Server. This does require a few adjustments of configuration files due to Qlik using non-FIPS compliant algorithms for minor tasks like hash checks. See Running Qlik Sense on Windows systems with FIPS compliance enabled for more details on Qlik Sense and FIPS.
Qlik Sense Enterprise on Windows uses PostgreSQL to store meta-data relating to a Qlik Sense site. In multi-node sites or sites where PostgreSQL is isolated from Qlik Sense Enterprise for Windows additional security can be applied;
Qlik Sense Proxy service bundled with Qlik Sense Enterprise on Windows is simply a web-service. This means applying general practice guidance but in the context of Qlik Sense as described below.
Qlik Sense Enterprise on Windows acts as a Certificate Authority (CA) during initial installation and signs a certificate that is applied on all encrypted traffic between Qlik Sense services. The same Qlik Sense signed certificate is applied as default certificate also for incoming connections from users accessing Qlik Sense Hub and QMC. This default certificate is not intended for production use, unless user access to Qlik Sense comes through a network load balancer or reverse proxy that trusts the Qlik Sense certificate. For direct user access to Qlik Sense Proxy, a fully trusted certificate can typically be acquired from your local IT and then applied on the Qlik Sense Proxy service.
As of July 2019, Qlik Sense Enterprise on Windows support SHA1 and SHA2 certificates. If SHA384 or SHA512 certificates are needed, then a network load balancer or reverse proxy can be configured in front of Qlik Sense which offloads to Qlik Sense.
There are numerous HTTP response headers that can be used in attempting to secure a server. Below are a couple of the most common ones, but as always it is recommended to consult local IT and web security expert on what the recommendations are.
Any additional HTTP response header values can be configured in Qlik Sense Virtual Proxy settings under Additional response headers as shown in the below image and described in Qlik Sense for Administrators: Virtual Proxies. It is recommended to trial any header changes in a new virtual proxy, as poor configuration may accidentally lock you out from Qlik Sense access.
Policy is a placeholder for your policy of choice and cannot be used as a value. See Writing a Policy (Mozilla) for examples.
This Techspert Talks session covers:
- What to plan for
- Migration Pathways
- Cloud Best Practices
Chapters:
Resources:
If you need to resend a license email along with license installer links and the license key to a customer/user, follow the steps outlined below.
This guide will help you understand the process and the necessary details you need to provide.
Gather Necessary Information:
Send an Email Request:
Use the following template to structure your email request:
Subject: Resend License Email Request
Dear Support Team,
I hope this email finds you well.
I am writing to request that a license email be resent. Below are the details:
I would greatly appreciate your assistance in resending the license email. Thank you for your support and consideration.
Best regards,
[Your Name]
Subject: Resend License Email Request for Talend Data Integration
Dear Support Team,
I hope this email finds you well.
I am writing to request that the license email for Talend Data Integration be resent. Below are the details:
I would greatly appreciate your assistance in resending the license email. Thank you for your support and consideration.
Best regards,
Sam
Following these steps will help you effectively resend a license email to your customer.
If you have any further questions, feel free to reach out to the respective teams.
What is the default user session timeout for Qlik Sense Business and Qlik Sense Enterprise SaaS? Can the session timeout for Qlik Cloud be changed?
The default (fixed) value is set to 30 minutes. This is controlled by SESSION_TTL.
It is not currently possible to adjust the session timeouts in the Qlik Cloud.
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 Entitlement Analyzer is a Qlik Sense application built for Qlik Cloud, which provides Entitlement usage overview for your Qlik Cloud tenant.
The app provides:
For more information and to download the app and usage instructions, see The Entitlement Analyzer for Qlik Cloud.
The App Analyzer is a Qlik Sense application built for Qlik Cloud, which helps you to analyze and monitor Qlik Sense applications in your tenant.
The app provides:
For more information and to download the app and usage instructions, see Qlik Cloud App Analyzer.
The Reload Analyzer is a Qlik Sense application built for Qlik Cloud, which provides an overview of data refreshes for your Qlik Cloud tenant.
The app provides:
For more information and to download the app and usage instructions, see Qlik Cloud Reload Analyzer.
The Access Evaluator is a Qlik Sense application built for Qlik Cloud, which helps you to analyze user roles, access, and permissions across a tenant.
The app provides:
For more information and to download the app and usage instructions, see Qlik Cloud Access Evaluator.
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:
For more information and usage instructions, see Qlik Cloud Monitoring Apps Workflow Guide.
This article shows how to use the Qlik Application Automation Monitoring App. It explains how to set up the load script and how to use the app for monitoring Qlik Application Automation usage statistics for a cloud tenant.
For more information and to download the app and usage instructions, see Qlik Application Automation monitoring app.
The OEM Dashboard is a Qlik Sense application for Qlik Cloud designed for OEM partners to centrally monitor usage 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.
Although this dashboard is designed for OEMs, it can also be used by partners and customers who manage more than one tenant in Qlik Cloud.
For more information and to download the app and usage instructions, see Qlik Cloud OEM Dashboard & Console Settings Collector.
The 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.
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.
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.
The Qlik Sense Hub connection times out faster / sooner than configured in the Virtual Proxy.
When working with an app in the hub, the connection to the app times out faster than configured in virtual proxy (for example, after 5 minutes), and the error message below is displayed:
Connection lost. Make sure that Qlik Sense is running properly. If your session has timed out due to inactivity, refresh to continue working.
This issue occurs when accessing Qlik Sense through a reverse proxy or load balance, but does not occur when accessing Qlik Sense on the same server (https://localhost/hub).
The user is also being active on the sheet, i.e. they are making selections etc. to interact with sheet objects.
Here is an example log line that may be seen in the AuditActivity_Proxy logs:
76 12.20.4.0 20200115T101930.708-0500 QLIKSERVER 8cd6aa7c-fab5-4e82-a2cd-0681943e7d58 Command=Close connection;Result=0;ResultText=Success d62cfb0a-3355-44a5-9e34-5eaada84be67 1ba723cc-e754-4e24-a42b-0732b24ad924 0 DOMAINNAME user.name 5c5e98cf-3f1f-45ed-96f0-8e76d7c44473 Not available Proxy AppAccess /app/5c5e98cf-3f1f-45ed-96f0-8e76d7c44473?reloaduri=https%3a%2f%2domain.com%2fsense%2fapp%2f5c5e98cf-3f1f-45ed-96f0-8e76d7c44473%2foverview Close connection 0 Backend web socket connection Closed for session 'd62cfb0a-3355-44a5-9e34-5eaada84be67'.
Qlik Sense should not terminate a session earlier than configured in the Virtual Proxy (default is 30 minutes), and when it does the error message would be different:
Your session has timed out. Log back in to Qlik Sense to continue.
In this case, if the connection is being lost and it is occurring sooner than configured in the virtual proxy then this indicates that either:
Qlik Sense requires WebSockets. To verify WebSocket traffic, see Qlik Sense Websocket Connectivity Tester.
Check to see if this issue occurs when using Internet Explorer. Internet Explorer by default adds additional unnecessary traffic to the WebSocket which can help in these situations. If you do not receive early timeouts when using IE, you can try Enabling TCP Keep Alive Functionality In Qlik Sense.
The HTTP keep-alive timeout may be increased here which helps in environments exhibiting the behavior mentioned above. See the Keep-alive timeout under the Proxy configuration. See Editing Proxies - Advanced > Keep-alive timeout (seconds)
If the above does not work, then you will need to make changes to your network infrastructure. Sniffing the network traffic to confirm things further can be performed. As sniffer, Wireshark can be installed on both Qlik Sense Proxy server and Hub client PC to run captures on both ends simultaneously. This may assist confirming the following:
Qlik Support may assist in a best-effort basis with the above. Please check out the video below for additional guidance. If further assistance is required correcting the environmental behavior, unfortunately the the task falls outside the scope of Qlik Support as this often is specific to the network involved. If further assistance is needed please reach out to your Account Owner to arrange Consulting Services (or see How to Contact the Consulting Team?)
Click here for video transcript
Network appliances (e.g. Load balancers, reverse proxies, VPN solutions, firewalls, web accelerators, etc) may not see the websocket connection as an "alive" TCP connection, depending on the vendor, and therefore terminate the connection on behalf of the end-user.
The "Backend web socket connection Closed for session" string seen in the logs is registered when a WebSocket TCP layer connection is closed by the transmission of a TCP Packet containing the FIN flag set. This happens when either the browser window or tab is closed or when a network device in the environment drops the TCP connection sessions in a controlled fashion (sends the TCP FIN packet to the Sense server). This can also be sent by the client's computer if there is(are) any setting(s) preventing inactive TCP connections from staying open, as required by the Websocket protocol.
Windows Firewall blocking port 4747. Disable Firewall or apply all ports inbound and outbound
The max parallel session count cannot be configured.
Qlik Sense Enterprise on Windows allows for a maximum of five parallel sessions from one user. If the maximum is reached, the sixth connection will fail with:
You cannot access Qlik Sense because you have no access pass. Too many sessions active in parallel
For more information, see:
You cannot access Qlik Sense because you have no access pass
How to count sessions in Qlik Sense
Troubleshoot too many sessions active in parallel