My Oracle Support Banner

Error 'ORA-01720: Grant option does not exist for 'ADMUSER.RESOURCELIMIT'' When Upgrading a P6 8.x Database Hosted on Oracle 11.2.0.4 or Later (Doc ID 1964963.1)

Last updated on JUNE 04, 2019

Applies to:

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

Symptoms

When running the dbsetup tool to upgrade a P6 8.* database hosted on Oracle Database 11.2.0.4 or later, the following error appears during the Create Reporting Views portion of the upgrade.

orpm_px_rpt_src.sql: ORA-01720: grant option does not exist for admuser.resourcelimit

In addition, the following error appears in the DatabaseSetup.log file created in a user's local home directory (ex. C:\users\<username>\DatabaseSetup.log):

ORA-01720: grant option does not exist for 'ADMUSER.RESOURCELIMIT'
Database Error: error number=1720
Error Message: ORA-01720: grant option does not exist for 'ADMUSER.RESOURCELIMIT'
Could not complete because the job "Run SQL Script orpm_px_rpt_src.sql" failed.
com.primavera.database.tools.DatabaseToolException: ORA-01720: grant option does not exist for 'ADMUSER.RESOURCELIMIT'

If the orpm_px_rpt_src.sql script is run as the Extended Schema user (default pxrptuser) to fix the views, the following error occurs:

ORA-01720: grant option does not exist for 'ADMUSER.PROJWBS'
ORA-01720: grant option does not exist for 'ADMUSER.SECPAC'
ORA-01720: grant option does not exist for 'ADMUSER.WBSMEMOX'
ORA-01720: grant option does not exist for 'ADMUSER.WBSBUDGX'
.......

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!


In this Document
Symptoms
Changes
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.