Support Article
Connection is closed error occurs
SA-69273
Summary
Connection is closed error displays and multiple open connections exist.
The system has three JBOSS application servers.
Error Messages
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
Unknown
Root Cause
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.
Resolution
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>.
Published August 19, 2019 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.