The following error is logged in the Qlik Sense central node's repository log:
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
This is typically logged in the System_Repository log.
Environment
Qlik Sense Enterprise on Windows
Resolution
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. See PostgreSQL: postgresql.conf and pg_hba.conf explained for details.
