- Streams are disappearing an reapparing in the Hub, but security rule audit shows the correct settings.
- Performance issues in the QMC and Hub.
Internally Qlik Sense has a variety of methods available to it to process its rules, by default it uses an Entity Framework, but this can be changed if it causes problems evaluating security rules.Environment:
Qlik Sense Enterprise September 2017 Patch 2
Performance issues seen in Qlik Sense June 2017 and up
A large set of custom security rules, or a complicated security rule setup.
There is a configuration file that contains some options for the Qlik Sense repository. This config file is generated by the installer and replaced upon upgrade, so any changes made here have to be replicated after every upgrade.
One of the entries in this config file is the ReadAccessControlMode
This governs what tools Qlik Sense uses to process the various security and sync rules to determine access to applications and resources within Qlik Sense. By default it is set to EntityFrameworkFiltering
, which is an older more generic framework which handles large numbers of applications quite well but can run slowly if you have a large set of complicated rules.
One of the other options is Repository Filtering, this means that the Qlik Sense Repository service itself processes the rules, in general if you have complex rules this is a better choice.
These choices impact any time Qlik Sense needs to display a list of applications or resources, you will especially notice it when loading the hub or the apps list in QMC
To make the change simply:
- Edit the Repository.exe.config file in your Qlik Sense install directory (by default C:\Program Files\Qlik\Sense\Repository)
- Find ReadAccessControlMode
- Change the value to "RepositoryFiltering"
- Restart Qlik Sense Services