Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
To install or upgrade your existing Qlik NPrinting governance dashboard, simply deploy the new QVF and reload the app: NPrinting Governance Dashboard - version3
If and only if you have altered the engine.config file(s) on your NPrinting Engine computer(s) to change the default 'resolvers-count' value, then go to the 'deployment summary' sheet and enter the 'resolvers-count' value under 'Available Resolvers'. This value sets a baseline that the new concurrency metric can evaluate to ensure your NPrinting environment is not core constrained.
Please enjoy and post comments/suggestions in GitHub preferably, or in the community comments below.
Version 3.0 (4/12/2022)
-Fixed a bug introduced by NP May 2021 SR3 where the reload fails in the load script:
< Field 'id' not found FROM "nprinting"."public"."task_execution" >
-Updated background colours on the "Task Recipients" Pivot Table to green
Version 2.0
Deployment Summary Sheet:
-New KPI "Peak Connection Concurrency". This is the number of unique connections used at any one time by executing publish tasks, subscriptions, on-demand requests, or metadata reload requests. It does not include preview requests. If this number exceeds 60% of your resolver count, queuing is expected to occur and reports will take longer to run. The metric will turn red indicating it is time to add logical engine processors to your NPrinting Engine(s) to a maximum of 16 logical processors per engine.
-New KPI "Peak Execution Concurrency". This is the number of concurrent execution requests at any one time . It is the sum of executing publish tasks + executing subscription requests + executing onDemand Requests + executing Metadata reload requests. If multiple reports are running in a single publish task, it counts as just '1' in this resolver . Does not include 'preview' requests.
Report Delivery Sheet:
-New filters added
Data Connections Sheet:
-New filters added
-Section Access field (yes/no ) added
Qlik Lineage Sheet:
-New filters added
-New KPIs added: Complex reports , Medium reports, simple reports
App Content Sheet:
-new filters added
Task Recipients Sheet:
-new filters added
Execution Analysis Sheet:
-New table "Days when Concurrency Exceeded". Shows the number of days where the peak concurrency connections exceeds 60% of vResolvers.
-New table "Peak Concurrency by Day". Shows peak concurrency by day.
Report Performance Sheet:
-Container with 4 distribution plots showing execution length for publish tasks, subscriptions,ondemand requests and metadata reloads. Colored by status (green = success, red = failed)
-Container with 4 tables showing detailed executions
Users Sheet:
-New Filters added
Execution Log Messages:
-New Filters added
Load Script / Model:
- vResolvers variable set to the sum of logical processors on each NP engine found
section access field added to connections
New master date table intervalmatched to executions.
vMonthsToLoad variable determines how many trailing months to generate in the master date table (default is 3 months)
For anybody upgrading you will need to re-edit the data source in the load script and if and only if you have changed the resolvers-count setting in the NPrinting engine.config file .... then after reloading the app , go to the deployment summary sheet and update the vResolvers variable to be equivalent to the same value as 'resolvers-count' in the engine.config. If you have multiple NP engines, sum the number together and set vResolvers to the sum of the values found in the engine.config files.
@santhoshkumar i can see a few issues. One is that the page is secure , requiring an NPrinting Admin to access. Our Web file connector which can consume the HTML table cannot handle the authorization to my knowledge . a 403 is returned to the Qlik Sense Engine trace logs and the UI just says 'access denied'. This is even when my Qlik Sense Engine service account is a windows nprinting admin with SSO already configured. I'm not sure its source , but its not postgresql, it could be rabbit and i'm not sure the connectivity there. The second issue is that for it to be useful you need to poll it frequently to get a graphic of the request queue over time . It would be valuable i agree and it can be linked to a connection which is cool. I doubt i would scope this work for now but its probably doable in one way or another.
I like the Qlik Lineage sheet but it appears that it doesn't have the "QlikEntity" objects listed. I'd like to be able to select a report and see what object is used for the QlikEntity reports. Has anybody else run across this and if so, have you figured out how to add this to the load?
Update:
Add the last entry (in bold) to this load to include Entity objects.
right join(AppObjectsInReports)
load * inline [
TemplateObjectType1,TemplateObjectType
TNSCOfficeReportCellEntity,Cells
TNSCOfficeReportCustomDatasetEntity,LevelOrPage
TNSCOfficeReportImageEntity,Image
TNSCOfficeReportSingleValueDataEntity,Variable
TNSCOfficeReportSingleValueFormulaEntity,Formula
TNSCOfficeReportTableEntity,Table
TNSCOfficeReportSomethingEntity,Entity];
I noticed Qlik Entity reports weren't associating to app objects or data connections. I added support for them in the data model and the Lineage sheet should now reflect the data connections and app objects associated to Qlik Entity reports.
You can grab the QVF with the changes here.
https://github.com/eapowertools/NPrintingGovernanceDashboard
Thanks Jonny,
We have migrated your latest load scripts to QlikView. While we're getting things setup, we found a couple more things I'd like to ask you to double check. Formulas and LevelOrPage don't appear to be associating correctly.
We really appreciate all your work on the dashboard.
@louiswinter Can you retest in Qlik sense and share a screenshot of the issue ? Fudge out any names from the screenshot that you need to keep private .
@JonnyPoole The report shown has multiple formulas as well as a Level/Page and none of them show in the dashboard.
Louis
Yeah i see that issue. Strange i'm still checking if the database changed schemas recently and caused a breakage but for now i've updated the release https://github.com/eapowertools/NPrintingGovernanceDashboard/releases/tag/v1.0
if your copying to QlikVIew, there were some load script edits to grab from the 'ConnectionContent Dimensions' section.
@JonnyPoole It's getting closer. The Level/Page now shows but I'm still not getting any Formulas to show. None of our reports show any Formulas (every row is 0) and we use them a lot.
got it. just updated again.
Looks good now, thanks @JonnyPoole !!!