Question
UMKC
US
Last activity: 23 Jul 2024 8:46 EDT
Query Runner Error
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: <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"
Can someone help me fix this error?
Accepted Solution
Updated: 28 May 2024 7:12 EDT
Pegasystems Inc.
US
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.
Sorry for the issue!
Evoke Technologies
IN
Hi, Can you just verify the db table instance and check if the DataBase selected is PegaData or any other value selected from the dropdown?
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.
Updated: 20 May 2024 7:16 EDT
Tata Consultancy Services
IN
Hi @Abhiveer Jatla,
I have previously checked multiple times. The Query Runnver will not work for me in Community Edition.
Enabling and using Query runner to troubleshoot database issues and Running SQL queries on Pega Clou
Atikant Sinha @sinha3 Could you please help on this? What we have to do make it work this query runner in Our Community Edition?
@MarissaRogers Please help me on this.
Thanks,
Ashok
UMKC
US
Accepted Solution
Updated: 28 May 2024 7:12 EDT
Pegasystems Inc.
US
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.
Sorry for the issue!
Tata Consultancy Services
IN
Hi @MattE,
One more thing, I can see, We need to select the Right Data Base from the Drop Down. Otherwise it is not working.
Even If you not selecting the Right Data Base in Personal Edition and Enterprise Edition it is working.
Please make it available this feature in the Community Edition too.
Thanks,
Ashok
Pegasystems Inc.
US
@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.