topic Re: Operations Monitor Application not showing data for 'Sheet Usage' and 'Apps' sheet in Management & Governance

Operations Monitor Application not showing data for 'Sheet Usage' and 'Apps' sheet

Devendra_Babar — Wed, 29 Jan 2025 17:03:10 GMT

Hi Everyone,

We have installed Qlik Sense April 2019 Enterprise version.

I tried to monitor 'Sheet Usage' and 'Apps' data using Operations Monitor application provided into 'Monitoring apps' stream. But both sheets are not showing data.

I tried to debug this application, and then I found that there is a table called 'app_object' which is used in 'Sheet Usage' and 'Apps' sheet. But this 'app_object' table doesn't have any data into it.

Is there any configuration I have to do? so that data will get reloaded into application and it will start working fine.

Please do let me know if anything can be done to fix this issue.

Thanking you in advance.

Re: Operations Monitor Application not showing data for 'Sheet Usage' and 'Apps' sheet

Levi_Turner — Tue, 03 Sep 2019 13:54:50 GMT

@Tyler_Waterfall may have more thoughts here, but:

Does the monitor_apps_REST_appobject data connection return data?

Re: Operations Monitor Application not showing data for 'Sheet Usage' and 'Apps' sheet

dwighttrumbower — Thu, 04 Mar 2021 21:10:39 GMT

I have the same issue. Rows returned = 0

SQL SELECT
20210304T143829.346-0600 1478 "id" AS "id_u2",
20210304T143829.346-0600 1479 "engineObjectId",
20210304T143829.346-0600 1480 "createdDate",
20210304T143829.346-0600 1481 "modifiedDate",
20210304T143829.346-0600 1482 "modifiedByUserName",
20210304T143829.346-0600 1483 "description",
20210304T143829.346-0600 1484 "objectType",
20210304T143829.346-0600 1485 "publishTime" AS "publishTime_u0",
20210304T143829.346-0600 1486 "published" AS "published_u0",
20210304T143829.346-0600 1487 "approved",
20210304T143829.346-0600 1488 "name" AS "name_u2",
20210304T143829.346-0600 1489 "__KEY_root",
20210304T143829.346-0600 1490 (SELECT
20210304T143829.347-0600 1491 "userId",
20210304T143829.347-0600 1492 "userDirectory",
20210304T143829.347-0600 1493 "__FK_owner"
20210304T143829.347-0600 1494 FROM "owner" FK "__FK_owner"),
20210304T143829.347-0600 1495
20210304T143829.347-0600 1496
20210304T143829.347-0600 1497
20210304T143829.347-0600 1498
20210304T143829.347-0600 1499 (SELECT
20210304T143829.347-0600 1500 "id" AS "id_u1",
20210304T143829.347-0600 1501 "__KEY_app",
20210304T143829.347-0600 1502 "__FK_app"
20210304T143829.347-0600 1503 FROM "app" PK "__KEY_app" FK "__FK_app")
20210304T143829.347-0600 1504 FROM JSON (wrap on) "root" PK "__KEY_root"
20210304T143830.515-0600 19 fields found: userId, userDirectory, __FK_owner, id_u1, __KEY_app, __FK_app, id_u2, engineObjectId, createdDate, modifiedDate, modifiedByUserName, description, objectType, publishTime_u0, published_u0, approved, name_u2, __KEY_root, __extra_,
20210304T143830.535-0600 0 lines fetched

Re: Operations Monitor Application not showing data for 'Sheet Usage' and 'Apps' sheet

JHuis — Fri, 07 Jan 2022 09:54:22 GMT

Did anyone find a solution? Because i have the same problem after reloading a month ago.

Thanks in advance.

Re: Operations Monitor Application not showing data for 'Sheet Usage' and 'Apps' sheet

Andrea_Spinetti — Wed, 12 Jan 2022 09:25:45 GMT

Hello @JHuis, do you get any errors when reloading the Operation Monitor, or does the reload end successfully? Have you tried to delete and re-import the App? Are you using any proxy? Is the REST Connector working correctly?

Re: Operations Monitor Application not showing data for 'Sheet Usage' and 'Apps' sheet

JHuis — Thu, 13 Jan 2022 08:12:49 GMT

Andrea,

it was a security role issue.

Thanks for the question

Re: Operations Monitor Application not showing data for 'Sheet Usage' and 'Apps' sheet

Andrea_Spinetti — Thu, 13 Jan 2022 09:34:27 GMT

Hello @JHuis, I'm happy to know you have solved the issue! If you have a minute, feel free to share the full resolution here in the community so other people can take advantage of it. Cheers 😊

Re: Operations Monitor Application not showing data for 'Sheet Usage' and 'Apps' sheet

agigliotti — Mon, 09 May 2022 08:06:43 GMT

Hi @JHuis ,

I have the same issue.

Could you share how did you solve it?

Many thanks in advance for your collaboration.

Best Regards

@Andrea_Spinetti @dwighttrumbower @Devendra_Babar

Re: Operations Monitor Application not showing data for 'Sheet Usage' and 'Apps' sheet

Andrea_Spinetti — Mon, 09 May 2022 13:07:58 GMT

Hi @agigliotti, could you please let me know which version of QlikSense are you using? Your issue may be linked to a defect investigation we are currently handling. Thanks!

Re: Operations Monitor Application not showing data for 'Sheet Usage' and 'Apps' sheet

agigliotti — Mon, 09 May 2022 15:46:14 GMT

Hi @Andrea_Spinetti ,

I'm using QSEoW v14.54.6 February 2022 Patch 3

Re: Operations Monitor Application not showing data for 'Sheet Usage' and 'Apps' sheet

Andrea_Spinetti — Tue, 10 May 2022 07:05:02 GMT

Hey @agigliotti, actually your version doesn't match the affected one 🤔

In this case, I would suggest recreating the Operations Monitoring app using certificate authentication: How to configure Certificate Authentication for Qlik Sense Monitoring Applications

After this, configure the new app to load from logs and add the data connections for all the engine nodes. You can follow this: Configuring the Monitoring apps

Re: Operations Monitor Application not showing data for 'Sheet Usage' and 'Apps' sheet

agigliotti — Tue, 10 May 2022 08:22:10 GMT

Hi @Andrea_Spinetti ,

I just noted the monitoring apps need a virtual proxy using windows authentication, but in my case TICKET and SAML authentication methods are used.
Could this be the reason why i get no data in sheet usage ?
If yes is there any other way to get these informations out ?

Please let me know.

Best Regards

Re: Operations Monitor Application not showing data for 'Sheet Usage' and 'Apps' sheet

Andrea_Spinetti — Wed, 11 May 2022 08:47:42 GMT

Hi @agigliotti, exactly, the Monitoring apps require Windows authentication to be used on the virtual proxy it uses to connect. You can either use it or follow these steps to configure the Qlik Sense Monitoring Applications to use Certificate Authentication instead of default Windows Authentication.

Re: Operations Monitor Application not showing data for 'Sheet Usage' and 'Apps' sheet

agigliotti — Wed, 11 May 2022 10:11:41 GMT

Hi @Andrea_Spinetti ,

I understood the cause of the issue.
It was related to the Qlik Service user role.
Actually that user did not have any role, once I applied the RootAdmin role then the "Sheet Usage" showed all data.
I much appreciated your collaboration.

Best Regards