"Error in Run SQL Script sspm_px_rpt_src.sql : DatabaseToolException (The Specified Schema Name "dbo" Either Does Not Exist or You do not Have Permission to Use it.)" When Upgrading Database Using DBSetup.bat (Doc ID 1953745.1)

Last updated on MARCH 04, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.1.1.0 and later
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)

Symptoms

When attempting to upgrade a SQL Server, P6 database, using DBsetup.bat, the following error occurs.

ERROR
-----------------------
Error in Run SQL Script sspm_px_rpt_src.sql : DatabaseToolException (The specified schema name "dbo" either does not exist or you do not have permission to use it.)

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