Connection is closed error occurs
Connection is closed error displays and multiple open connections exist.
The system has three JBOSS application servers.
Caused by: com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: 17009 SQLState: 99999 Message: Closed Statement
INFO [stdout] (Log4j2-AsyncLoggerConfig-1) DatabaseException caused by prior exception: java.sql.SQLException: Closed Statement
INFO [stdout] (Log4j2-AsyncLoggerConfig-1) | SQL Code: 17009 | SQL State: 99999
Steps to Reproduce
A defect or configuration issue in the operating environment.
Multiple open connections exist due to the connection pool configuration in the application server.
The connection is closed when the connection served to the Pega application is not provided a valid connection. This is also driven by the connection pool definition within the application server.
Make the following change to the operating environment:
- Remove the PegaRULESAdmin connection pool.
- Set the min-pool-size for PegaRULES to 30.
- Make no changes to the max-pool-size (which is 120).
- Set the value <validate-on-match>true</validate-on-match>.