Query Runner issues
You are unable to run a query in Pega Platform Query Runner. You receive the below error message when trying to run it.
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
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: