Support Article

Not returning connection error whlie starting prweb.war



After upgrade from PRPC 6.3 to Pega 7.2, user was not able to bring the server up.

The Pega instance has a single-schema database and the executed without errors.

After startup, warning appear in the log file: "WARN - The database Pegadata is only defined in the bootstrap configuration; create a Data-Admin-DB-Name definition".

Error Messages

2016-08-31 13:33:35,935 [fault (self-tuning)'] [ ] [ ] [ ] (l.access.ConnectionManagerImpl) ERROR - Not returning connection 0 for database "pegarules" to the pool as it previously encountered the following error
User ID: (unknown)
Last SQL: select pzPVStream from .pr4_base where pxObjClass = 'Data-Admin-DB-Name'
java.sql.SQLSyntaxErrorException: ORA-00903: invalid table name

at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.processError(
at oracle.jdbc.driver.T4CTTIfun.receive(
at oracle.jdbc.driver.T4CTTIfun.doRPC(
at oracle.jdbc.driver.T4C8Oall.doOALL(
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(

Steps to Reproduce

Start the prweb.war file from Weblogic console.

Root Cause

During deploying the prweb.war file on Weblogic, user did not updated the plan.xml file to reflect the database schema details.


Pega installation media ships plan.xml for Weblogic application server.

This can be found at the location "archives\prpc\weblogic\war.

​User updated the  plan.xml  to reflect the correct schema name and re-deploy the prweb.war file


Published September 22, 2016 - Updated October 6, 2016

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.