Discussion

49
Views
mercd1 Member since 2019 1 post
PEGA
Posted: March 11, 2020
Last activity: March 11, 2020

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
Share this page LinkedIn