Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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:
  1. Remove the PegaRULESAdmin connection pool.
  2. Set the min-pool-size for PegaRULES to 30.
  3. Make no changes to the max-pool-size (which is 120).
  4. Set the value <validate-on-match>true</validate-on-match>.
Suggest Edit

Published August 19, 2019 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us