Discussion

2
Replies
297
Views
Karuppan Member since 2011 30 posts
PEGA
Posted: 4 years ago
Last activity: 3 years 4 months ago
Closed

Upgrade Failed with ORA-00942: table or view does not exist – pr4_base

The upgrade failed stating pr4_base table not exists. But when we connect to SQL Developer, we were able to see the table present in the migrated schema.

[java] 2015-11-24 09:03:49,326 [             WHE-304] [          ] [                    ] ( priv.management.MBeanSecurity) INFO    -                 deny.DatabaseManagement.DatabaseConnectionDetails=true
     [java] 2015-11-24 09:03:49,621 [             WHE-304] [          ] [                    ] (riv.management.MBeanManagement) INFO    - MBean Management (Web) initialized for DefaultDomain
     [java] 2015-11-24 09:03:49,645 [             WHE-304] [          ] [                    ] ( internal.mgmt.PRRequestorImpl) INFO    - RecordWorkInProgress is not enabled
     [java] 2015-11-24 09:03:49,851 [             WHE-304] [          ] [                    ] (orization.SessionAuthorization) INFO    - RSL Update Behavior: Eager
     [java] 2015-11-24 09:03:49,951 [             WHE-304] [          ] [                    ] (  internal.access.DatabaseImpl) INFO    - Bytes input per interaction warning threshold:    50M
     [java] 2015-11-24 09:03:49,954 [             WHE-304] [          ] [                    ] (ternal.dictionary.ClassMapImpl) INFO    - ClassMap using multi-tenant environment: false
     [java] 2015-11-24 09:03:49,954 [             WHE-304] [          ] [                    ] (ternal.dictionary.ClassMapImpl) INFO    - Reading the class group definitions
     [java] 2015-11-24 09:03:49,961 [             WHE-304] [          ] [                    ] (l.access.ConnectionManagerImpl) ERROR   - Not returning connection 0 for database "pegarules" to the pool as it previously encountered the following error
     [java] User ID: (unknown)
     [java] Last SQL: select pzPVStream from RULESNEW.pr4_base where pxObjClass = ?
     [java] java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
     [java]
     [java]                 at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
     [java]                 at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
     [java]                 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn