Support Article
Unable to access external database after upgrade to Pega 8.1.4
SA-79353
Summary
Post upgrade to Pega Platform 8.1.4, unable to access an external database. Error is encountered on executing a report definition. According to the error, the Data-Admin-DB-Name record is missing, however, the record is present.
Error Messages
com.pega.pegarules.pub.database.BadDatabaseDefinitionException: Database-BadDBDef-Missing yourexternaldb
at com.pega.pegarules.data.internal.store.DatabaseConfigurationMap.getDBConfig(DatabaseConfigurationMap.java:209) ~[prprivate.jar:?]
Steps to Reproduce
- Upgrade Pega Platform 7.3.0 to Pega Platform 8.1.4
- Run the report definition.
Root Cause
A defect or configuration issue in the operating environment.
The Data-Admin-DB-Name rule included a database username and password which were not required since the connection used JNDI. The mismatch between the rule and the data source prevented the database from being included in the database configuration map.
Startup logs included a line as below:
WARN - Node state has not been captured for the db name YOUREXTERNALDB as db connection could not be made to it.
Resolution
Perform the following local-change:
Remove the database username and password from the Data-Admin-DB-Name rule and save.
Published May 11, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.