Recent Posts
-
Qlik SAP Netweaver Connector Question
Hi everyone,We are using SAP Netweaver Connector without problems to extract data of reports, extractors and tables from SAP R3 and running in QlikVie... Show MoreHi everyone,
We are using SAP Netweaver Connector without problems to extract data of reports, extractors and tables from SAP R3 and running in QlikView Server. We have the processes created and running and login to SAP using a SAP User Account with User Type configured as a Service User.
For compliance things we need to change this user type from Service to System or Communication type. Is that possible without generate any kind of impact in actual SAP extraction processes?.
Thanks for your help.
-
Tracking Stream names based on Custom Properties
Hi How I can track which streams have a particular CUSTOM PROPERTIES item value or I want to search all the Stream names which contain 1/many custom p... Show MoreHi
How I can track which streams have a particular CUSTOM PROPERTIES item value or I want to search all the Stream names which contain 1/many custom properties item value same was as tags(list of occurance).
Note: Those CUSTOM PROPERTIES are Resource Type: Streams and has different Values.
Thanks
-
Notify via SMTP when a task completes or app loads completes
Hi Other than using Qlik Cli or powershell, is there any other way we can configure or develop an app? Which notifies a group via SMTP/email, when a t... Show MoreHi
Other than using Qlik Cli or powershell, is there any other way we can configure or develop an app?
Which notifies a group via SMTP/email, when a task(or a batch of tasks) completes or an app loads successfully.
Thanks in advance.
-
UDC sync time stamp issue
We have a UDC (Active Directory) on Qlik Sense server. It has a daily trigger. In QMC, I found their last-sync time stamps are different. As you can s... Show MoreWe have a UDC (Active Directory) on Qlik Sense server. It has a daily trigger. In QMC, I found their last-sync time stamps are different. As you can see, user sync task was last executed on 3/18/2024 22:18. (see User sync task.png). But the UDC was last sync'd on 3/19/2024 14:23. (see UDC sync.png) Why the time are different?
-
Monitoring QCC (Qlik Continuous Classroom) usage
Hello! How can we monitor the use of our QCC licenses? We only know who has accepted an invitation, but would like to know the courses actually consum... Show MoreHello! How can we monitor the use of our QCC licenses?
We only know who has accepted an invitation, but would like to know the courses actually consumed by everyone.
Is there a way to do that?
-
Sense License Monitor
License Monitor: Explore license allocation and utilization over time by license type, user, and app. v7.18.0 (June 2019 release) *June 27, 2019 ... Show More- License Monitor: Explore license allocation and utilization over time by license type, user, and app.
- v7.18.0 (June 2019 release)
- *June 27, 2019 update: Fixes not showing anonymous usage of Analyzer Capacity minutes -- no change to data model (QLIK-96593)
- *Jun 7, 2019 update*: bugfix QLIK-96354 - reload fails if Analyzer Capacity allocated but unused.
- "Usage Snapshot" sheet for quick reference of license usage (easy one-page screen shot of historical license utilization)
- "Unified Licensing History" sheet showing Professional/Analyzer/Capacity usage across Sense and QlikView (requires signed license with Sense and QlikView Server April 2019; requires configuring the monitor_apps_qlikview_logs data connection)
- Addition of historical Analyzer Capacity Minutes used (Jun'19 and Apr19 patch 1 forward)
- Compatibility: April 2018 and later, but requires updating the following monitor_apps_REST data connections: *_user_condensed, *_license_analyzer, *_license, *_license_professional, *_license_overview
- v7.18.0 (June 2019 release)
- License Monitor: Explore license allocation and utilization over time by license type, user, and app.
-
What is needed to Prevent .DS_Store Vulnerabilities on Qlik Sense Servers
Hello Qlik Community, Recently I was posed with a question around .DS_Store Vulnerabilities that came up during a vulnerability scan on a Qlik Sense S... Show MoreHello Qlik Community,
Recently I was posed with a question around .DS_Store Vulnerabilities that came up during a vulnerability scan on a Qlik Sense Server that a customer of mine has. I reviewed the vulnerability, and it seems that if customers uses Apple Products and browse folder structures, they can leave junk files that can open vulnerabilities, like .DS_Store. I was wondering if there was a Qlik Sense Level way of preventing these vulnerabilities.
Outside of Qlik Security, in Windows GPO, you can block extension types. It would be required to remove any of the .DS_Store files to clear the vulnerability, but blocking the extensions at the user GPO level should prevent new .DS_Stores from being added. Regular File Scans for the extension type could also be a good practice.
I would like to be able to recommend a Qlik Level solution as I manage Qlik for the clients, not Windows. Any advice from the Qlik Community?
Thanks! -
Sense Connectors Log Analyzer
Sense Connectors Log Analyzer: Explore logs from Qlik Enterprise Connectors (ODBC & REST) to understand usage and search error messages. v1.0.0 GA r... Show More- Sense Connectors Log Analyzer: Explore logs from Qlik Enterprise Connectors (ODBC & REST) to understand usage and search error messages.
- v1.0.0 GA release in February 2019 patch 1 or April 2019 release
- Can be configured to also load other Sense log data generated by the Operations Monitor
- Requires REST connector version 1.7 or later and ODBC connector version 5.12 or later.
- v1.0.0 GA release in February 2019 patch 1 or April 2019 release
Details
Overview
- Sense Connectors Log Analyzer: Explore logs from Qlik Enterprise Connectors (ODBC & REST) to understand usage and search error messages.
-
Connecting Qlik Sense to Postgresql on linux
Hello Everyone,Need steps for the following.how to configure or map the existing qlik sense environment to new postgresql server ( linux ). We have ql... Show MoreHello Everyone,
Need steps for the following.
how to configure or map the existing qlik sense environment to new postgresql server ( linux ). We have qlik sense on Windows and Postgresql on Linux already.
We want to add a new postgresql vm to the existing qlik environment.
Need steps iin how to map this new VM - postgresql on linux to exisitng qlik sense on windows
-
Sense Operations Monitor
Operations Monitor: Investigate Sense system activity and performance, including app reloads, user sessions, sheet usage, QMC changes, Sense Engine p... Show More- Operations Monitor: Investigate Sense system activity and performance, including app reloads, user sessions, sheet usage, QMC changes, Sense Engine performance logs, and errors and warnings.
- v7.16.0.2 (April 2020 release)
- No change in data model, but just UI update to facilitate Export Links to QCS: New sheet called "Export Links for Cloud"
- v7.16.0 (September 2019 release)
- June 27, 2019: Fixes missing Export CSV (QLIK-96596) and checks for empty log files to avoid reload failure (QLIK-96349) - 7.16.1.qvf
- June 20, 2019 Fixes issue with mismatched Session End and Session Start visible on Session Details sheet (QLIK-93738)
- v7.15.0 (April 2019 release)
- Sheet usage within an app, including which sheets not used in given time periods (requires Sense February 2019 or later)
- Compatibility: February 2019 forward, though can be used with April 2018 and later with a few minor chart issues (missing "Always one selected value")
- Also update the monitor_apps_REST_user_condensed data connection to add the appropriate userId and password, the same userId & password for the other monitor_apps_REST data connections
- v7.16.0.2 (April 2020 release)
- Operations Monitor: Investigate Sense system activity and performance, including app reloads, user sessions, sheet usage, QMC changes, Sense Engine performance logs, and errors and warnings.
-
Qlik Sense Application Monitor missed months
Hello, i have a problem in the application Licence Monitor , I can't find all months in the dashboard : Any solution for this ? Thanks Re... Show MoreHello,
i have a problem in the application Licence Monitor ,
I can't find all months in the dashboard :
Any solution for this ?
Thanks
Regards
-
App Table list not loading in Metadata Analyzer app
Hi fellow admins, We have recently implemented Qlik Sense multi-node on premise in our small company. I wanted to use Metadata dashboard specifically... Show MoreHi fellow admins,
We have recently implemented Qlik Sense multi-node on premise in our small company. I wanted to use Metadata dashboard specifically to answer following question.
Which Qlik Sense App is using which QVD tables.
I did import the
It is showing me the list of apps and streams but not showing which table is being used in which app.
Am I missing any configuration?
Thank you
-
New Ideas For Qliksense Admins
is their any new ideas for Qliksense Admins which we can use it in our project apart from montioring tools?We need to implement few things which we ha... Show Moreis their any new ideas for Qliksense Admins which we can use it in our project apart from montioring tools?We need to implement few things which we havent implemented an where like sending task mails(success or failues) using nprinting...etc..pls let me know if you have any other ideas which admins can be usefu;l
-
I like to get the list of all the task names, Host Server, Where Status=Started
I like to get the list of all the task names, Host Server, Where Status=Started Scenario: We have 3-4 Qlik Engines, Schedulers in cluster. This morni... Show MoreI like to get the list of all the task names, Host Server, Where Status=Started
Scenario:
We have 3-4 Qlik Engines, Schedulers in cluster.
This morning, while some ETL pre-processing running, I manually checked each started tasks for the host server name. Found 2 servers where doing all the tasks. So immediately I restarted the Engine & Scheduler services on the 3rd server.
Because I took that proactive action, when the huge number of apps started to load, all servers started participating. Thus speeding the whole process.
So I need a good way to get the list of host servers which can give me a quick picture of whats happening with all the tasks recently processed/processing.
Hope I could explain properly.
*Qlik Sense November 2021 Patch 12.
-
Same Copies of logs in 2 locations ProgramData>Qlik>Sense>Log and Users>All Use...
Same Copies of logs in 2 locations C:\ProgramData\Qlik\Sense\Log and C:\Users\All Users\Qlik\Sense\Log Are these duplicate or pointed/referenced file?... Show MoreSame Copies of logs in 2 locations C:\ProgramData\Qlik\Sense\Log and C:\Users\All Users\Qlik\Sense\Log
Are these duplicate or pointed/referenced file?
Exactly same metadata (datetime, attributes, contents).
If duplicate, that means drive space feeling up x2 as much for each log.
Please let me know if any concerns or way arounds to avoid.
And Log>QlikMobilityRegistrar folder seems have millions of log files. Will it cause any performance bottleneck.
-
Sense System Performance Analyzer
Sense System Performance Analyzer: Dive into system and service performance counters, Windows events, and Sense logs captured by Qlik Logging service... Show More- Sense System Performance Analyzer: Dive into system and service performance counters, Windows events, and Sense logs captured by Qlik Logging service (QLogs database)
- v1.0.0 GA release in April 2019
- Requires Qlik Logging Service configured and enabled
- Compatibility: April 2019 and later
- Beta released in February 2019 but replaced by v1.0.0
- v1.0.0 GA release in April 2019
Regarding how to configure Qlik Logging Service, please refer to the help: Qlik Logging Service.
- Sense System Performance Analyzer: Dive into system and service performance counters, Windows events, and Sense logs captured by Qlik Logging service (QLogs database)
-
QlikView Governance Dashboard
QlikView Governance DashboardQlikView Governance Dashboard is a comprehensive analysis tool that allows QlikView administrators to effectively manage ... Show MoreQlikView Governance Dashboard
- QlikView Governance Dashboard is a comprehensive analysis tool that allows QlikView administrators to effectively manage the QlikView environment to gain a detailed understanding of its operation and performance. Optimize your company’s investment in QlikView and improve your productivity by streamlining tasks.
- Analyze QlikView Server performance, task reload history, license utilization, and QlikView app metadata.
- See a demo example of the Governance Dashboard HERE!
- v2.1.4 (Aug 7, 2019) Fixes blank [Node Name] (GOVDASH-191); Handles QVW and QVD names including [ ] ' (GOVDASH-190); Updated Help links (GOVDASH-189)
- v2.1.2 Sheet Usage in Sense Profile Score incorrect: only showing sheets used with AuditType=Document, AuditMessage=Open (The first sheet you open in a QV app). Fixes that issue (GOVDASH-188) -- June 21, 2019
- v2.1.1 Addresses issue of not loading tasks for which the Tasks.xml has not been modified within the configured months of history (GOVDASH-185)
- v2.1.0 Addition of "Sense Profile Score" (supersedes 2.0.5)
- It is highly recommended to split logging files daily or at least monthly, especially before an upgrade to 12.30 or later.
- NOTE: Audit logging must be enabled in QlikView Server in order for Sense Profile Scoring to work properly.
- Compatibility: QlikView 12.40, QlikView 11.20 SR10 and later, QlikView 12.10, 12.20. Note that if you upgraded to QV 12.30 GA you must split log files as described above (due to change in column order in QlikView Server log files.
-
Qlik Cloud Admin Playbook
Hey Qlik Admins, For Qlik Sense on Windows there is a massively useful resource in the Qlik Admin Playbook (https://adminplaybook.qlik-poc.com/) for a... Show MoreHey Qlik Admins,
For Qlik Sense on Windows there is a massively useful resource in the Qlik Admin Playbook (https://adminplaybook.qlik-poc.com/) for administrators to guide them in administering a Qlik Sense site. However, more and more of our customers are moving to Qlik Cloud and a lot of tasks in the playbook do not translate directly to tasks in managing a Qlik Cloud tennant.
Is there a similar resource available for managing Qlik Cloud Tennants? If so, please share!
If not, please share below tasks (and if possible the cadence you suggest) for activities that could be in such a playbook, so that we can start formulating some best practices together. To start, I have gone through all the topics in the current playbook to see if I think they are applicable to Qlik Cloud and added some of the tasks I can currently think of that should be added:
Cadence Section Daily Review Tasks Weekly Check for New Apps Weekly Analyze App Metadata Analyzer Weekly Check for New Tasks Weekly Analyze Tasks Weekly Check for New Data Connections Weekly Review License Allocations Monthly Analyze Data Connections Monthly Audit User Access Monthly Optimize License Allocations Monthly Remove/Disable Unused Tasks Monthly Remove Unused Data Connections Monthly Verify Backup Execution Quarterly Analyze App Adoption Quarterly Analyze/Curate Extensions Quarterly Flag Unused Base/Community Sheets Quarterly Optimize Batch Window Quarterly Optimize Sheet Order for Adoption Quarterly Remove/Quarantine Unused Apps Quarterly Remove Unused Private Sheets Quarterly Review/Optimize QVDs Quarterly Review/Update Capacity Plan Yearly Plan Disaster Recovery Yearly Practice Recovery Processes Yearly Review Architecture/Scale Plan Weekly Check new spaces Monthly Remove unused spaces Weekly Check new AutoML deployments Monthly Remove unused AutoML deployments Weekly Check new Automations Monthly Remove unused Automations Weekly Check new Alerts Monthly Remove unused Alerts Weekly Check new Subscriptions Monthly Remove unused Subscriptions Curious for your input!
Ps. My current focus is on the "Analytics Services" side of Qlik Cloud, but feel free to also suggest tasks for the "Data intergration" part if you have any.
-
Qlik alerting and Insight advisor integration with Teams
Hi Team, We are trying to do POC for Qlik alerting and Insight advisor integration with Teams/slack. Can you please define the steps what need to be ... Show MoreHi Team,
We are trying to do POC for Qlik alerting and Insight advisor integration with Teams/slack. Can you please define the steps what need to be check from server side for integration with teams/slack for insight advisors.
-
What is QRSSecurityManagement: Retrieved priveleges time? And High MS +5minute
Hello experts, From the logs Engine>Trace>System_Engine.txt i got the records which mention,"QrsSecurityManagement: Retrieved privileges in xx ms from... Show MoreHello experts,
From the logs Engine>Trace>System_Engine.txt i got the records which mention,
"QrsSecurityManagement: Retrieved privileges in xx ms from the QRS"
What is privleges means here? Is it section access or retrieving privileges from Security rules for app?
In some cases i saw consecutive records of this. Why does Qlik retrieve this info for same user and app three times?
example
TS AppID userid message proxysessionid sessionid 20211018T093106.812+0300 App1 xxx QrsSecurityManagement: Retrieved privileges in 106 ms from the QRS d0fb5a12-xxxxxx.... 6822b675-xxxxxxx..... 20211018T093106.988+0300 App1 xxx QrsSecurityManagement: Retrieved privileges in 107 ms from the QRS d0fb5a12-xxxxxx.... 6822b675-xxxxxxx..... 20211018T093107.124+0300 App1 xxx QrsSecurityManagement: Retrieved privileges in 69 ms from the QRS d0fb5a12-xxxxxx.... 6822b675-xxxxxxx..... Also i saw some records of this which takes retrieve info +300000ms which equals 5minute.