where i have to edit the number of ConnectionPoolingMaxActive , because the below error appears on the production server and stops the service and it seems that this number is limited for 50 only ERROR - ConnectionBus: Opening JDBC connection to 18.104.22.168:5432 failed with SQLState: null Error code: 0 Message: Cannot get a connection, pool error Timeout waiting for idle object Retrying...(1/4) Do i have to add this ling on the settings.yaml and add a row that contains ConnectionPoolingMaxActive : 2000
If you are deploying in the Mendix Cloud, the instructions can be found here.
If you are running your app in a Docker, you can pass that as an environment variable as described here.
Although I have no experience with on premises Unix deployments, it seems the documentation can be found here. Furthermore, in this example m2ee yaml, you can search for connection pooling and see how you should configure it.
Rom van Arendonk
try increasing the pool size as it is 50 for you now
check out this document you may find what you need