Support Article

Query Runner is not working in Test Region



Query Runner is not working with Postgres database and Tomcat application server.

Error Messages

There was a problem performing a database query: Database-General Problem encountered when getting connection for database pegadata 0 08003 This connection has been closed.
DatabaseException caused by prior exception: org.postgresql.util.PSQLException: This connection has been closed.
| SQL Code: 0 | SQL State: 08003

Steps to Reproduce

Run Query Runner with Pega 7.3.

Root Cause

A defect or configuration issue in the operating environment

The database connection pool on the application server has stale connections.


Make the following change to the operating environment: 

Restart the system to reset the connection pool.  Also enable validate connections in the pool to avoid this type of issue in the future.

SA-30878 provides the changes needed for a Tomcat/Postgres environment: 


Published April 10, 2019 - Updated October 8, 2020

100% found this useful

Have a question? Get answers now.

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