Question
Credera
Credera
AU
Credera
Posted: Aug 29, 2023
Last activity: May 22, 2025
Last activity: 22 May 2025 6:27 EDT
Closed
Query runner in onprem Oracle Database
Query runner in on-prem Oracle database is not working and throwing below error:
Unable to fetch SELECT query results select * from pc_assign_worklist: 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
Pega platform: v8.6.3
Default Schema names PegaRULES and PegaDATA are changed at customer end say xyzRULES and xyzDATA
***Edited by Moderator Marije to add Capability tags***
To see attachments, please log in.
Posted: 2 years ago
Updated: 10 months ago
Updated: 22 May 2025 6:27 EDT
MOD
Pegasystems Inc.
GB
@DharanitharanR The error you're encountering is due to the DataStoreConfiguration not being found for the DB Name "pegadata".
This issue occurs when the database configuration is not properly registered in the configuration map.
To resolve this issue, you may need to check your database configuration settings and ensure that they are correctly set up and registered in the configuration map.
This answer came from a Pega gen-AI assistant using the below references. As a Support Center moderator, I reviewed the answer and references for accuracy:
Unable to conenct to external database after the ugprade to 8.6.2
SQL Query Runner
**************** Note ***************
"As of version 8.8 onwards, Query Runner, Query Inspector, and Schema Tools in Pega Platform are for Pega cloud environments only.
These database tools are not available to on-premises clients.
ffhttps://docs.pega.com/bundle/platform/page/platform/system-administration/database-sql-queries-running.html
*********************************************