My Oracle Support Banner

The "manual_script_before_install" Script Fails on a Microsoft SQL Server Database (Doc ID 2435288.1)

Last updated on DECEMBER 04, 2019

Applies to:

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

Symptoms

When attempting to execute the 'manual_script_before_install.sql', the following error occurs:

ERROR

Msg 15151, Level 16, State 1, Line 8
Cannot find the object 'DBMS_REPUTIL', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 11
Cannot find the object 'DBMS_JOB', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 14
Cannot find the object 'DBMS_LOB', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 17
Cannot find the object 'DBMS_SQL', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 20
Cannot find the object 'DBMS_RANDOM', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 32
Cannot find the object 'gv_$TRANSACTION', because it does not exist or you do not have permission.

STEPS

The issue can be reproduced at will with the following steps:
1. Connect to the SQL Server instance as 'sa'.
2. Execute the 'manual_script_before_install.sql' script on the P6 EPPM database.

BUSINESS IMPACT

The issue has the following business impact:
Due to this issue, users cannot complete the P6 EPPM database install\upgrade process.

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


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