Error: "Error in Run SQL Script sspm_px_rpt_src.sql : DatabaseToolException(CREATE VIEW Permission Denied in Database 'PMDB'.)for query::CREATE VIEW RESOURCELIMIT" When Upgrading a SQL Server Database.

(Doc ID 2162675.1)

Last updated on JULY 21, 2016

Applies to:

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

Symptoms

On : 15.2.0.0 version, Primavera P6 Enterprise Project Portfolio Management

When attempting to upgrade the database,
the following error occurs.

ERROR
-----------------------
Error in Run SQL Script sspm_px_rpt_src.sql : DatabaseToolException(CREATE VIEW permission denied in database 'PMDB'.)for query::CREATE VIEW RESOURCELIMIT


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Download P6 EPPM R15.2.0 installation files
2. Go to the database folder
3. Run dbsetup.bat
4. Fill in the database connection strings
5. Enter in pxrptuser credentials
6. Upgrade wizard fails at "Create Reporting Views"

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot upgrade the SQL Server database.

Cause

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 hundreds of Community platforms