Discussion

2
Replies
318
Views
Karuppan Chetty Atheppan (Karuppan)
PEGA
Senior Architect, Pega Diagnostic Cloud
Pegasystems Inc.
IN
Karuppan Member since 2011 30 posts
PEGA
Posted: December 14, 2015
Last activity: April 6, 2018
Posted: 14 Dec 2015 2:18 EST
Last activity: 6 Apr 2018 19:26 EDT
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)
System Administration Upgrades
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.