Unable to test connectivity on Data-Admin-DB-Table
We noted that at stat up Pega platform is having trouble finding database definition with this error message: "ERROR - Definition mismatch detected for database ubi; the entry in the preferences will be preferred."
That is unexpected because there is a DB-Name entry with the ID "UBI". Yes the definition is in capital letters. This was working fine in 6.3. Should it be in lower case ? we tried changing it to lower case but we still had the error.
Then when we try to "test connectivity" on a table that is using this database definition, Pega crashes with the error :
com.pega.pegarules.pub.database.BadDatabaseDefinitionException: Database-BadDBDef-Missing ubi
at com.pega.pegarules.data.internal.store.DatabaseConfigurationMap.getDBConfig(DatabaseConfigurationMap.java:165) ~[prprivate.jar:?] (complete stack trace attached)
We think, we started to have this issue moving to Java 8 and the new JDBC8. I've heard in the past that the new jndi/xxx under JDBC8 is not managing "auto-commit" the same way.
Does anyone know if Pega is expecting the connection from the pool to be in "auto-commit" mode or not ?
Pegasystems Inc.
US
Not sure how auto commit can play a role of the problem here. Is ubi configured properly as a data source in WAS? Did we see a problem of testing the connection from WAS?
Intact Financial Corporation
CA
No problem on the WAS side. I'm referring to the auto-commit part because I saw something about "autocommit" in the stack trace and I remember having some issues with the configuration of the connection pool when we upgraded to JDBC8 in the past for other app servers.
Intact Financial Corporation
CA
I forgot to add that if we do the folowing steps we can restore the situation:
- open the instance of the DB-Name
- save it
- use the button "test connection"
- open the table entry (in DB-Table)
- save it
- use the "test connectivity" button
We need to do that after each restart of the JVM
Intact Financial Corporation
CA
We are now running Pega 7.3.1. and the Oracle DB is Oracle 11g.
from the PegaRules log:
PRPC-7.3.1-184: 2017-10-14 00.41 EDT
Database version: Oracle Database 11g Enterprise Edition
Driver: Oracle JDBC driver
Driver version: Proprietary information hidden.0
Vendor: IBM Corporation, JVM version: 1.8.0_161
VM Name: IBM J9 VM(build Proprietary information hidden -