Support Article

Not returning connection error whlie starting prweb.war

SA-28324

Summary



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 Upgrade.sh 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(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3593)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3637)
................................


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.

Resolution



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


    <variable>
      <name>defaultDataSchema</name>
      <value></value>
    </variable>
    <variable>
      <name>defaultRulesSchema</name>
      <value></value>
    </variable>

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.