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