Dear Qlik Sense users,
We are pleased to confirm that the latest patch for Qlik Sense February 2019 is now available on our download site. February 2019 Patch 3 includes several product defect fixes and you can find details of all the fixes in the attached release notes.
The patch is installed as a MSP and must be installed on top of the full Qlik Sense February 2019 installation.
Thank you for choosing Qlik software. As always, please follow best practices when upgrading any software and make sure you back up your system before making changes.
Kind regards,
Global Support
...View More
Dear Qlik Sense users,
We are pleased to confirm that the latest patch for Qlik Sense November 2018 is now available on our download site. November 2018 Patch 5 only includes a few product defect fixes and you can find details of all the fixes in the attached release notes.
The patch is installed as a MSP and must be installed on top of the full Qlik Sense November 2018 installation.
Thank you for choosing Qlik software. As always, please follow best practices when upgrading any software and make sure you back up your system before making changes.
Kind regards,
Global Support
...View More
Hello Qlik NPrinting World!!Last time I talked about Qlik NPrinting with Qlik Sense -Qlik NPrinting 101: Connecting Qlik Sense AppsBut now it's time for QlikView.So, you have just purchased Qlik NPrinting and now you want to get started with Reports but what do you do with your QlikView Apps?Well look no further! Here is some information on how to get started if you are new to the wonderful world of NPrinting.Topics:1. Requirements2. Connection Rules3. App ConnectionRequirements:First, there are some requirements which are found detailed on ourQlik Help SitePlatform - Windows 2008 R2 (only if Qlik Sense connections are not required) / 2012 / 2012 R2 / 2016 64-bit architecture onlyProcessor - Multi-Core x64 compatible processorsMemory - 8 GB minimumDisk Space - 500 MB minimumDedicated Qlik NPrinting Server & Engine Service Account ConfigurationConnection Rules:You can create connections to your QlikView documents that are stored in the following locations:Local ComputerShared Network FolderQlikView Server that you have permission to accessQlikView ClusterYou can create connections from a Single Qlik NPrinting App to multiple QVWs.App Connection:So, you may be wondering, this is helpful, but now how do I connect my QVWs in Qlik NPrinting?Well I worked with the Education Team to help create a "Qlik Fix" video. The video is found here:It will take you through the basic steps of making an App Connection.To summarize the video:Login to the Qlik NPrinting WebConsole with the needed permissions to create an AppNavigate to Apps to create the "shell" for your AppNavigate to Apps - Connection to create your connectionEnsure that you are picking the appropriateAppfrom the list and yourSource is "QlikView"Choose if you would to connect to a Local, Server, or ClusterLocation Type. In the video we selected a Local ConnectionEnter the Document PathIf Section Access applies check the "connection requires authentication" checkboxRun Verification👍Congratulations! You have connected Qlik NPrinting with QlikView!👍If there are any error messages with the Run Verification step, the common causes of the errors are described on our Help Site:Verify connection errors when setting up a connection to QlikView in Qlik NPrintingI hope you have found this Blog helpful. If you have any questions, feel free to post them below.
...View More
Hi everyone,Want to stay a step ahead of important Qlik support issues? Then sign up for our monthly webinar series where you can get first-hand insights from our #QlikSupport experts.This Thursday, 23 May Qlik Support will host another Support Techspert Thursday session and this time we are looking at Extending Qlik Sense Enterprise with NPrinting On-DemandBut wait, what is it exactly?Support Techspert Thursdays is afreewebinar to facilitate knowledge sharing held on a monthly basis, on the third Thursday of each month.Hear directly from Qlik Techsperts on topics that are relevant to Customers and Partners today.In this session we will cover:One Click NPrinting ReportsConfiguring the buttonAvoiding pitfallsTroubleshooting tipsClick onthis link to choose the webinar time that’s best for you.The webinar is hosted using ON24 in English and will last 30 minutes plus time for Q&A.Hope to see you there!!
...View More
Hello Qlik NPrinting World!!You have just purchased Qlik NPrinting and now you want to get started with Reports but what do you do with your Qlik Sense Apps?Well look no further! Here is some information on how to get started if you are new to the wonderful world of NPrinting.Topics:RequirementsCertificatesEngine StatusApp ConnectionRequirements:First, there are some requirements which are found detailed on our Qlik Help SitePlatform - Windows 2012 / 2012 R2 / 2016 64-bit architecture onlyProcessor - Multi-Core x64 compatible processorsMemory - 8 GB minimumDisk Space - 500 MB minimumVersion - Qlik Sense must be on a version that is newer than 3.0.1 / Qlik NPrinting must be on a version that is newer than 17.2.1**Qlik Sense and Qlik NPrinting cannot be installed on the same Server. This is extremely important.**Certificates:After all the basic requirements have been met you must install the Qlik Sense certificates on the Qlik NPrinting Server.These certificates are obtained from your Qlik Sense Administrator, and the detailed export instructions are available here:Exporting Certificates through the QMCInstalling Qlik Sense CertificatesEngine Status:After the certificates have been successfully imported, navigate to the Qlik NPrinting WebConsole to the Admin - Engine Manager page. Ensure the hostname is filled out correctly. You should now see your Engine with an "Online" status as pictured below:Engine Status is OnlineWell done for Connecting Qlik NPrinting with Qlik Sense! You are a Rockstar!!⭐App Connection:So, you may be wondering, this is helpful, but now how do I connect my QVFs in Qlik NPrinting?Well I worked with the Education Team to help create a "Qlik Fix" video. The video is found here:It will take you through the basic steps of making an App Connection.To summarize the video:Login to the Qlik NPrinting WebConsole with the needed permissions to create an AppNavigate to Apps to create the "shell" for your AppNavigate to Apps - Connection to create your connectionEnsure that you are picking the appropriate App from the list and your Source is "Qlik Sense"Enter the Proxy Address - the full name of the Qlik Sense Server prefixed with http or httpsFor example: https://sense_proxy_computer_name.domain_nameOr if using a prefix: https://sense_proxy_computer_name.domain_name/prefixEnter the Sense App ID which is found in Qlik Sense via the QMC - Apps or the Qlik Sense HubChoose an Identity of a Qlik Sense user that has access to the AppFormat - windows domain name\user nameIf section access applies check the "Apply user section access for reports" checkboxRun VerificationIf there are any error messages with the Run Verification step, the common cause of the errors are described on our Help Site:Verify connection errors when setting up a connection to Qlik Sense in Qlik NPrintingThanks for taking the time to read my Blog and feel free to ask any questions!
...View More
Hello QlikView Users,
We are pleased to announce the release of QlikView Governance Dashboard 2.1.0!
This release of QlikView Governance Dashboard includes a new "Sense Profile Score" sheet which presents new insights into Qlikview app metadata to support the analysis of Qlikview apps in relation to their adoption rate and compatibility with Qlik Sense. Additional metrics are also available to assist QlikView app developers and administrators in prioritizing efforts to improve usability of existing QlikView apps.
For more details about this release, please see the attached release notes. Thank you for choosing Qlik software.
Kind regards
Global Support Team
...View More
The Global Support organization is happy to announce improvements to our Qlik Support Portal. The “new look” portal offers new designs aimed at helping you find answers and information more easily. By highlighting engaging content and using intuitive navigation, our goal is to enhance your self- service experience.
We look forward to providing you:
Topic and product based content for the anonymous user
Universal navigation and new custom page designs
Easy visibility and connectivity to additional Qlik resources (Community, Help, QCC, YouTube Channels, Cloud status)
Enhanced navigation to existing functions such as My Environments, My Licenses and My Cases for the authenticated users
More “1-click” navigation
Organized resources and knowledge content based on popular searches and usage
Finally, we’ve made it even easier for you to engage our vibrant Qlik community product forums where you can ask your questions and look for solutions, tips and tricks from over 68,000 Qlik product users.
Check out our preview videohttps://support.qlik.com/articles/000073402
Our maintenance window for Go Live is over the weekend of May 11/12. See Portal Maintenance announcement in the below comments.
If you have any questions, please feel free to comment. We’ll be monitoring and updating you as our progress for deployment continues.For those of you attending Qonnections, please visit our Support Kiosk to share your feedback.
Niall Gillick Senior Global Support Director, EMEA
...View More
Hi everyone,Starting with Qlik Sense September 2017, we introduced the Qlik Centralize Logging (QLogs) database. This database is managed by the Qlik Logging Service.Databases still need space though, so deployments that were using the QLogs database for an extended period already, or larger and active deployments, may find themselves accumulating big chunks of data. At this stage, your QLogs database might be consuming several GB of disk space.This situation can be a major problem for your System Administrator. But don’t worry. There are ways around this (housekeeping), and I’ll be going over what to do to prevent this from happening in the first place, as well as how to slim down an existing database.Here is what we will cover todayIntroductionAm I using Qlik Centralize logging?How much space does it take on disk?How can I better control the usage on disk?Help! What to do if it consumes all or almost all the available disk space?IntroductionThe Qlik Logging Service centralizes the logging by collecting all the messages and inserting them into a PostgreSQL database named QLogs.In addition to collecting the Qlik Sense Services logs, it also consumes the Windows Event logs and the Performance Counters, such as CPU, Memory, Disk latency and queue, Network, etcRight now, it is most commonly used as a default data source for the Monitoring Applications reload. If the Centralize Logging is not enabled, the monitoring applications will use the log files as a data source. More details to this are available in my previous post All you need to know about deploying the Qlik Sense Monitoring Applications.Am I using the DB or flat files? To verify if the Qlik Centralize Logging is enabled in your environment, you can run the following command from the central node.Microsoft Windows [Version 10.0.17134.619]
(c) 2018 Microsoft Corporation. All rights reserved.
C:\Windows\system32> cd C:\Program Files\Qlik\Sense\Logging
C:\Program Files\Qlik\Sense\Logging> Qlik.Logging.Service.exe validate
archive_age_in_hours: 720
last_forced_db_trim: 2019-04-02 16:32:52.107208+02
purge_age_in_hours: 1440
version: 0.5
CentralizedLoggingEnabled: True
LoggingToFileEnabled: True
MaximumDatabaseSizeInGB: Max db size not enforced
DB Host: QlikServer1.domain.local
DB Name: QLogs
DB Writer User: qlogs_writer
DB Reader User: qlogs_reader
DB Port: 4432Reference and additional information available in knowledge article: How To Verify Qlik Sense Is Running With Centralized Logging ServiceIf you wish to set up the Qlik Centralize Logging, you can refer to this help.qlik.com - Qlik Logging Service.How much space does it take on disk?To check how much disk space each database consumes, you can use the following SQL Request.I usually use PGAdmin4 to run this request. You simply need to right-click on one of the databases and select Query ToolSELECT d.datname AS Name, pg_catalog.pg_get_userbyid(d.datdba) AS Owner,
CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT')
THEN pg_catalog.pg_size_pretty(pg_catalog.pg_database_size(d.datname))
ELSE 'No Access'
END AS SIZE
FROM pg_catalog.pg_database d
ORDER BY
CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT')
THEN pg_catalog.pg_database_size(d.datname)
ELSE NULL
END DESC -- nulls first
LIMIT 20Reference: https://wiki.postgresql.org/wiki/Disk_UsageTo give you an example: below is the output from a single node environment without any usage, DEBUG log level enabled on all services and collected over about a week. name | owner | size
---------------------------------------------------------------------------
Qlogs | qlogs_writer | 548 MB
QSR | postgres | 40 MB
SenseService | qliksenserepository | 7223 kB
QSMQ | qliksenserepository | 7183 kB
postgres | postgres | 7055 kB
template0 | postgres | 6945 kB
template1 | postgres | 6945 bytesIt is also possible to narrow down to which node(s) or even service(s) is logging the highest number of entries using the following request.SELECT *
FROM (
SELECT d.process_host,d.process_name,d.entry_level,COUNT(id) AS message_volume
FROM (
SELECT id,process_host,process_name,entry_level
FROM public.log_entries
UNION ALL
SELECT id,process_host,process_name,entry_level
FROM public.archive_entries
) AS d
GROUP BY d.process_host, d.process_name, d.entry_level
) AS d
ORDER BY d.message_volume DESC;Output: Process_host | Process_name | entry_level | message_volume
---------------------------------------------------------------------------
QlikServer1 | proxy | DEBUG | 380020
QlikServer1 | proxy | INFO | 221839
QlikServer2 | proxy | INFO | 103589
QlikServer1 | repository | INFO | 98254
QlikServer2 | scheduler | INFO | 54269
QlikServer1 | repository | ERROR | 35874
QlikServer1 | repository | WARN | 34568How can I better control the usage on disk? Logging LevelTo make certain the QLogs database does not start consuming large amounts of disk space, you need first to control and limit the data you want to be logged.In order to not create unnecessary traffic, and to limit the amount of data logged in the database, we recommend to not set the logging level of any services to DEBUG for an extensive period of time.DEBUG level is mostly used while troubleshooting an issue and should be set back to INFO directly after that.Purge and limitIt is possible to purge the logs after a certain amount of days or limit the size of the databasePurge: (Where x and y are a day’s threshold and archive_age value must be lower than purge_age, otherwise it will fail)Microsoft Windows [Version 10.0.17134.619]
(c) 2018 Microsoft Corporation. All rights reserved.
C:\Windows\system32> cd C:\Program Files\Qlik\Sense\Logging
C:\Program Files\Qlik\Sense\Logging> Qlik.Logging.Service.exe update --archive_age x --purge_age yReference Knowledge article: Qlik Sense - How to control the size of the Qlik Sense Logging Database when using Centralized Logging Limit: (Where n is the size in GB)Microsoft Windows [Version 10.0.17134.619]
(c) 2018 Microsoft Corporation. All rights reserved.
C:\Windows\system32> cd C:\Program Files\Qlik\Sense\Logging
C:\Program Files\Qlik\Sense\Logging> Qlik.Logging.Service.exe update --maximum_db_size_in_gb nReference Knowledge article: Qlik Sense - How to control the size of the Qlik Sense Logging Database when using Centralized Logging Help! What to do if it consumes all or almost all the available disk space? First of all, you can take the steps mentioned above to control and limit the amount of information logged into the database.But the process to purge or reduce the size of the database can take a long time, so if you need a quick (but short-term) solution, you can temporarily increase the size of the disk while the purging process is working.If this is not possible you can trigger a manual archiving and then purge of the logs in the QLogs database. (Where X is in hours)Microsoft Windows [Version 10.0.17134.619]
(c) 2018 Microsoft Corporation. All rights reserved.
C:\Windows\system32> cd C:\Program Files\Qlik\Sense\Logging
C:\Program Files\Qlik\Sense\Logging> Qlik.Logging.Service.exe archive –cutoff_in_hours X
C:\Program Files\Qlik\Sense\Logging> Qlik.Logging.Service.exe purge --cutoff_in_hours XReference: Qlik logging service database urgently needs to be reduced in size in by going to help.qlik.com : If presented with a message stating the system is too busy, retry the command.If the second try generates the same message, try again at a less busy time on the server.Thank you for reading my blog post and I really hope it helps you.I’ll be watching for your questions, feedback or suggestions so please comment and share!
...View More
Hello Qlik Sense Users,
We are pleased to confirm that the latest patch for Qlik Sense February 2019 is now available on our download site. In addition to a small number of product defect fixes included in this release, we have improved the responsiveness of the Qlik Sense Hub Client by improving the way security rules, database access, and hub service work together. For more details on the improvements and/or fixes, please review the attached release notes.
As a reminder, please follow best practices when upgrading any software and make sure you back up your system before making changes. Thank you for choosing Qlik software!Kind Regards,Global Support Team
...View More