Support Article
Error when running query in Query Inspector or Query Runner
SA-52704
Summary
Error occurs when running a query in the Query Inspector or Query Runner.
Error Messages
There is no configuration (no Data-Admin-DB-Name instance) for database Read-only PegaDATA
Steps to Reproduce
- Log in to the Pega Developer portal
- Navigate to System > Database > Query Inspector
- Select PegaDATA from drop down and paste the SQL
- Click Generate Explain Plan
Root Cause
An issue in the custom application code or rules. The prconfig.xml file was not configured with the read-only user data source settings which are required to run queries from the application.
Resolution
Perform the following local-change:Add the below settings to the prconfig.xml file:
<env name="database/databases/PegaRULES/dataSourceReadOnly" value="java:comp/env/jdbc/PegaRULESReadOnly"/>
<env name="database/databases/PegaDATA/dataSourceReadOnly" value="java:comp/env/jdbc/PegaRULESReadOnly"/>
Published March 19, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.