Support Article

Query Runner is not working in Test Region

SA-49756

Summary



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.

Resolution



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: 

https://pdn.pega.com/support-articles/connection-has-been-closed 

 

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.