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 DECEMBER 04, 2023

Applies to:

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

Cause

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