Problem:

You are unable to run a query in Pega Platform Query Runner. You receive the below error message when trying to run it.

Error Message:

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

Solution:

If the environment is Pega Cloud Services, raise a Cloud SR in My Support Portal. Describe the error message, and our team will be able to update your schema as needed.

If the environment is not Pega Cloud Services, you will need to add the following to the PegaRULES schema.

testOnBorrow="true" testOnConnect="true" testOnReturn="true" testWhileIdle="true" validationQuery="select 1"

Note: In order for users to be added to this Access Group, they require an operator profile of PegaRULES: DatabaseAdministrator.

For more information on Query Runner issues, see:

https://community.pega.com/support/support-articles/query-runner-not-working-test-region

https://community.pega.com/support/support-articles/tomcat-does-not-revalidate-connections

https://community.pega.com/support/support-articles/tomcat-does-not-revalidate-connections