Support Article
AES71[Error]ORA-00942 for PR_DATA_ADMIN
SA-12539
Summary
In Pega 7.1.7 application, there are many occurrences of "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist" related to the table PR_DATA_ADMIN.
Error Messages
2015-05-15 10:09:53,046 [fault (self-tuning)'] [TABTHREAD1] [ PegaRULES:07.10] (l.access.ConnectionManagerImpl) ERROR a_hostname|win245.xx-yyy.zz a_user - Not returning connection 1 for database "pegadata" to the pool as it previously encountered the following error
User ID: a_user
Last SQL: SELECT count(pyLabel) myDBResults FROM pr_data_admin WHERE pxObjClass='Data-Admin-Nodes' AND UPPER(pyLabel) = UPPER('a_hostname pegappaes 2015-05-12 09:48:12.878 GMT')AND pxInsName !='2B9C68FF0D68EE5D5A1D8B558AE99D3E'
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
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.execute(OraclePreparedStatement.java:3694)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1378)
at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
at com.pega.pegarules.data.internal.access.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:576)
...........
at com.pegarules.generated.activity.ra_action_validate_1d97360fe3d909311f09ed421e80277e.step3_circum0(ra_action_validate_1d97360fe3d909311f09ed421e80277e.java:371)
at com.pegarules.generated.activity.ra_action_validate_1d97360fe3d909311f09ed421e80277e.perform(ra_action_validate_1d97360fe3d909311f09ed421e80277e.java:109)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3375)
Steps to Reproduce
Modification of the “Node description" of the system node instance can trigger this error.
Root Cause
The root cause of this problem is a defect in Pegasystems’ code/rules.
Resolution
Install HFix-23084 to resolve the issue.
Published July 31, 2015 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.