I’m using Community Edition, I have added “PegaRULES:DatabaseAdministrator” as access role to access the Query Runner rule
I’m facing the below error when I try executing a query in Query Runner.
Error Message:
“The DataStoreConfiguration was not found for the DB Name “pegadata” as it is not registered in the configuration map Message:
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”
If the database value is any other value, then change the query from pegadata to the value present in the database. This verification is just rule-out the possibility of having different schema value on the DBTable rule.
Hi Kevin and all - Query Runner relies on a configuration that was not set by default on existing Community Edition systems. We will be correcting this going forward so that new systems will come with the required configuration and be able to use Query Runner.
Existing users who would like the configuration added to their systems can email [email protected] from the same email from which you signed up for the system and we will update your Community Edition instance to allow Query Runner to work.
@Bhumireddy Hi Ashok - the database also corresponds to the access granted to the pg user that Query Runner relies on. For Personal Edition there was no difference, but in Community Edition we are granting different access to PegaRULES and PegaDATA to prevent users from accidentally wiping out something required to run Pega.
