My Oracle Support Banner

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 MARCH 21, 2018

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 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

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.