Discussion 95 Views × Close popover Daniel Mercurio (mercd1) PEGA Information Curator 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 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 Cloud Services Pega Cloud Developer Knowledge Share × Close popover Facebook Twitter Linkedin Email Copy Link Copied!