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 |