Error: 'Invalid Object Name 'Prmaudit'' When Upgrading a P6 Database to 16.2 or Later When Running the Dbsetup.bat Utility (Doc ID 2222037.1)

Last updated on FEBRUARY 17, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 16.2.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempt to upgrade a P6 database from 8.3.2 to 16.2 the following error is observed:

ERROR

-------------------------------------------

Invalid object name 'prmaudit'.SQL Query:
insert into paudit( AUDIT_TS,TABLE_NAME ,pk1 ,pk2 ,pk3 ,pk4
,oper,prm_user_name,audit_old,audit_ext_old
,LOGICAL_DELETE_FLAG,RDBMS_USER_NAME,OS_USER_NAME ,PROGRAM ,HOST_NAME
,APP_NAME ,NETADDRESS ) select AUDIT_DATE ,TABLE_NAME TABLE_NAME,pk1 pk1,pk2
pk2,pk3 pk3,pk4 pk4,oper oper,prm_user_name prm_user_name,audit_info
audit_old,audit_info_extended audit_ext_old, LOGICAL_DELETE_FLAG
LOGICAL_DELETE_FLAG,RDBMS_USER_NAME RDBMS_USER_NAME,OS_USER_NAME
OS_USER_NAME ,PROGRAM PROGRAM,HOST_NAME HOST_NAME,
APP_NAME APP_NAME,NETADDRESS NETADDRESS from prmaudit

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms