Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Error on running any query using Query Runner



Unable to use Query Runner. The user is able to access Query Runner and view the tables using Schema Tools, however, on running any query, an error occurs.

Error Messages

Unable to fetch SELECT query results select * from data.xxxxx LIMIT 10: code: <none> SQLState: The DataStoreConfiguration was not found for the DB Name "pegadata" as it is not registered in the configuration map Message: <none>
DatabaseException caused by prior exception: com.pega.platform.datastore.ConfigurationException: The DataStoreConfiguration was not found for the DB Name "pegadata" as it is not registered in the configuration map

Steps to Reproduce

  1. Log in to Designer Studio
  2. Assign a Database Administrator role to the user
  3. Log off from the application. Verify that the Query Runner page link displays as expected for the user
  4. Execute the queries in PegaRULES or PegaDATA Schema

Root Cause

The PegaRULES and PegaDATA datasource is not configured in read-only to use the Query Runner feature.


Perform the following local-change:

  1. Add the following datasource in the context.xml file after the PegaRULES datasource:

    <Resource name="jdbc/PegaRULESReadOnly"

    Note : This is an additional source that is added as s read-only user from the Pega application. All configurations can be same except the JNDI name which is PegaRULESReadOnly.
  2. In the prconfig.xml, add the following JNDI entry for PegaRULES and PegaDATA:

     <env name="database/databases/PegaRULES/dataSourceReadOnly" value="java:comp/env/jdbc/PegaRULESReadOnly"/>
        <env name="database/databases/PegaDATA/dataSourceReadOnly" value="java:comp/env/jdbc/PegaRULESReadOnly"/>

  3. Restart the server and execute the query


Published August 15, 2019 - Updated December 2, 2021

Was this useful?

50% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us