search

eapowertools-archive / qs-governance-dashboard

Unsupported - Collects metadata and parses script logs for Qlik Sense applications for use with Qlik Sense Governance
Other
38 stars 14 forks source link

Opening several files through the Governance Collector #22

Open gustafssone opened 7 years ago

gustafssone commented 7 years ago

Couldn't resist investigating further as we have an internal project that we are looking into fields being used...

Prerequisites

Description

When you have several apps, the governance collector tries to open them all after each other. If you have a lot of big apps, this causes an immediate crash, when memory usage goes through the roof.

Steps to Reproduce

  1. Add a bunch of large apps, that is usually not open at the same time.

Expected behavior: [What you expect to happen] Perhaps waiting/closing a document? Actual behavior: [What actually happens] Server crash through aggressive memory consumption Reproduces how often: [What percentage of the time does it reproduce?] Easy to do if you have plenty of apps

Versions

You can get this information by looking on the version page for the web app, agent or the config.js file located in the config directory of the distribution. Also, please include the OS and what version of the OS you're running. Windows Server 2012 R2 Qlik Sense 3.2 SR3 (also June patch 1) Governance Collector released 2017-08-10 or so.

Additional Information

I worked around this one by reloading the apps with only 100 rows on my own VM. There is no way to limit which apps to run with. Suggestions is to have an intermediate option between: Single app (how to do this through the GUI?) All apps

E.g: Some apps (checkboxes) Apps with limited amount of data. ("first 1000") Close apps after they are done in the loop (which I don't think QS Server does, as expected. A workaround - lower the Server App timeout low enough to allow them to time out - it's better to allow these operations take a loong time than exhausting the server)

Also, Section Access (if not on the access list) makes the app show nothing. Expected, but annoying :)

DiegoBormann commented 6 years ago

Hi, I was experiencing the same problem but solved it like this:

You can change the agent so that it opens the app without data.

  1. Open the .../EAPowerTools/GovernancenCollector/agent/config/config.js file with an text-editor
  2. Scroll down to agent sections
  3. Change option: noData: true
  4. save and close the file
  5. Restart the: Qlik EAPowerTools Service Dispatcher