Qlik Community

Security & Governance

Discussion board where members can learn more about Qlik Sense deployments which are governed and self-service.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Devendra_Babar
Partner
Partner

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

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.

Labels (2)
2 Solutions

Accepted Solutions
JHuis
Contributor III
Contributor III

Andrea,

 

it was a security role issue.

 

Thanks for the question

View solution in original post

agigliotti
Partner
Partner

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

 

View solution in original post

13 Replies
Levi_Turner
Employee
Employee

@Tyler_Waterfall may have more thoughts here, but:

  • Does the monitor_apps_REST_appobject data connection return data?
dwighttrumbower
Creator
Creator

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

JHuis
Contributor III
Contributor III

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

 

Thanks in advance.

Andrea_Spinetti
Support
Support

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?

If the issue is solved please mark the answer with Accept as Solution.
JHuis
Contributor III
Contributor III

Andrea,

 

it was a security role issue.

 

Thanks for the question

Andrea_Spinetti
Support
Support

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 😊

If the issue is solved please mark the answer with Accept as Solution.
agigliotti
Partner
Partner

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 

Andrea_Spinetti
Support
Support

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!

If the issue is solved please mark the answer with Accept as Solution.
agigliotti
Partner
Partner

Hi @Andrea_Spinetti ,

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