Discussion 373 Views Daniel Mercurio (mercd1) PEGA Manager, Knowledge Management Pegasystems Inc. US View Profile Send Message mercd1 Member since 2019 1 post PEGA Posted: March 11, 2020 Last activity: March 11, 2020 Posted: 11 Mar 2020 14:13 EDT Last activity: 11 Mar 2020 14:18 EDT Query Runner issues Report 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 Pega Platform 8.3 Pega Cloud Developer Knowledge Share Reply Likes (1) Arvind Malav Share Share this page Facebook Twitter LinkedIn Email Copy link Copying... Copied!