My Oracle Support Banner

Error: "Create Synonym P6audit_Settings For Audit_Settings" When Attempting to Upgrade to 18.8.5.0 (Doc ID 2515671.1)

Last updated on DECEMBER 04, 2019

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 18.8 to 18.8.5.0 [Release 18.8]
Information in this document applies to any platform.

Symptoms

When upgrading the database, it fails with the following error on step "Create Reporting Views":


ERROR

Error in Run SQL Script orpm_pxrptuser.sql : DatabaseToolException (Closed Connection)

A full rollback to 1808.0005.0000.0002 is not possible, clicking OK will run a partial-rollback process which will return the database to an intermediate state which can be re-upgraded to 1808.0005.0000.0002 after the error(s) have been resolved.

Closed ConnectionSQL Query:
create synonym P6AUDIT_SETTINGS for AUDIT_SETTINGS

ADDITIONAL

Issue may occur also for the following synonyms:

create synonym P6AUDIT_SETTINGS for AUDIT_SETTINGS
create synonym P6AUDIT_USERS for AUDIT_USERS
create synonym P6AUDIT_PROJINFO for AUDIT_PROJINFO
create synonym P6PRMAUDIT_FULL for PRMAUDIT_FULL
create synonym P6PRMAUDIT_PROJ for PRMAUDIT_PROJ
create synonym P6REFRDELETE for REFRDELETE
create synonym P6USER_LOGIN_DTLS for USER_LOGIN_DTLS
create synonym P6USER_NOT_LOGGED_DTL FOR USER_NOT_LOGGED_DTL
create synonym P6NEVER_LOGGED_USER_DTL FOR NEVER_LOGGED_USER_DTL

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!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.