It may be necessary to configure the Repository PostgreSQL database to listen to additional requests from the rim nodes to allow database access to the rim nodes. The number of connections will increase by 110 connections per node.
Based on the above, the central node repository log files will show warnings and errors such as:
ERROR: occurred because all pooled connections were in use and max pool size was reached.
...
Error when committing remaining connection slots are reserved for non-replication superuser connections↵↓The underlying provider failed on Open.↵↓Exception of type 'Repository.Core.Exceptions.TransactionException' was thrown
Environment:
To resolve this issue, follow these eight steps:
- Stop all Qlik Sense Services on all nodes
- Open the file located in C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.6 (for Qlik Sense June 2017 and higher)
Open Notepad with Administrative rights
- Search for the string max_connections
- Adjust the value here to be 110 x the number of Nodes in Qlik Sense including the Central node
- In a multi-node environment, this should be adjusted to the sum of all repository connection pools + 20.
e.g: A Central node and 2 RIMs would require 350 connections
- Search further in the config file for max_connections to ensure that there is only 1 entry for this setting
- Save the file
- Start all Qlik Sense services on all nodes
See referenced help page section Configuration PostgreSQL multi-node connections