Error when running query in Query Inspector or Query Runner
Error occurs when running a query in the Query Inspector or Query Runner.
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
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.
ResolutionPerform 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"/>
33% found this useful