Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
@Tyler_Waterfall may have more thoughts here, but:
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
Did anyone find a solution? Because i have the same problem after reloading a month ago.
Thanks in advance.
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?
Andrea,
it was a security role issue.
Thanks for the question
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 😊
Hi @JHuis ,
I have the same issue.
Could you share how did you solve it?
Many thanks in advance for your collaboration.
Best Regards
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!
Hi @Andrea_Spinetti ,
I'm using QSEoW v14.54.6 February 2022 Patch 3