Query Runner is not working in Test Region
Query Runner is not working with Postgres database and Tomcat application server.
Error MessagesThere 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.
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