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



Connection is closed error displays and multiple open connections exist.
The system has three JBOSS application servers.

Error Messages

Caused by: 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


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.


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>.

Published August 19, 2019 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

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