Primavera P6 Upgrade Error: ORA-00942: table or view does not exist

062317_2336_PrimaveraP61 Primavera P6 Upgrade Error: ORA-00942: table or view does not exist

I have recently upgraded the Primavera P6 database from 16.1 to 16.2 and got above error during the upgrade. It says table or view does not exist. Even I used Oracle SYSDBA account (sys). Still, it fails.

Instead of upgrading it through automatic, I followed the manual procedure to upgrade the database. That also fails and gives the following errors

I followed the Oracle doc for the manual Primavera P6 upgrade, Page 14

  1. Login as SYS as sysdba
  2. Cd \scripts\upgrade\PM_<VERSION>
  3. ORPM_P161.sql

SQL> @ORPM_P161.sql

DROP VIEW PRIVUSER.PRMAUDIT

*

ERROR at line 1:

ORA-00942: table or view does not exist

DROP VIEW PRIVUSER.PRMAUDITX

*

ERROR at line 1:

ORA-00942: table or view does not exist

 

Solution

The answer is simple. Use the Oracle SYSTEM user account to upgrade the Primavera P6 database. Also make sure to run the script manual_script_before_upgrade.sql in <P6_HOME>\database\scripts\install\PM_16_02_00 before running the upgrade script

govindan Primavera P6 Upgrade Error: ORA-00942: table or view does not exist
Connect me

Govind

Thank you for visiting my personal blog. Myself Govindan, Software Developer by profession since 2006 and hence I started this blog early in 2016 and ever since I've been writing about technologies experienced and learnings of everyday life.

The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.

Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply 🙂
govindan Primavera P6 Upgrade Error: ORA-00942: table or view does not exist
Connect me
Like us on Facebook.
Connect!