My Oracle Support Banner

Errors When Manually Creating SQL Server Database Via Scripts (Doc ID 2620231.1)

Last updated on DECEMBER 18, 2019

Applies to:

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

Symptoms

When attempting to manually create a SQL Server project management database and running script sspm_src.plb,

the following error occurs.

Error

Creating procedure TA_GATHER_MULTI_TIMESHEETS
Msg 2715, Level 16, State 3, Procedure TA_GATHER_MULTI_TIMESHEETS, Line 8957
Column, parameter, or variable #4: Cannot find data type intarray.
Parameter or variable '@pts_id_list' has an invalid data type.
Msg 1087, Level 16, State 1, Procedure TA_GATHER_MULTI_TIMESHEETS, Line 8990
Must declare the table variable "@pts_id_list".
Msg 1087, Level 16, State 1, Procedure TA_GATHER_MULTI_TIMESHEETS, Line 8996
Must declare the table variable "@pts_id_list".
Msg 1087, Level 16, State 1, Procedure TA_GATHER_MULTI_TIMESHEETS, Line 9029
Must declare the table variable "@pts_id_list".
Msg 1087, Level 16, State 1, Procedure TA_GATHER_MULTI_TIMESHEETS, Line 9040
Must declare the table variable "@pts_id_list".
Msg 1087, Level 16, State 1, Procedure TA_GATHER_MULTI_TIMESHEETS, Line 9071
Must declare the table variable "@pts_id_list".
Msg 1087, Level 16, State 1, Procedure TA_GATHER_MULTI_TIMESHEETS, Line 9081
Must declare the table variable "@pts_id_list".
Msg 15151, Level 16, State 1, Line 9103
Cannot find the object 'TA_GATHER_MULTI_TIMESHEETS', because it does not
exist or you do not have permission.

Creating procedure WBSES_HAVE_TIMESHEETS
Msg 2715, Level 16, State 3, Procedure WBSES_HAVE_TIMESHEETS, Line 9421
Column, parameter, or variable #1: Cannot find data type intarray.
Parameter or variable '@pwbs_id_list' has an invalid data type.
Msg 1087, Level 16, State 1, Procedure WBSES_HAVE_TIMESHEETS, Line 9427
Must declare the table variable "@pwbs_id_list".
Msg 15151, Level 16, State 1, Line 9500
Cannot find the object 'WBSES_HAVE_TIMESHEETS', because it does not exist or
you do not have permission.

Creating procedure CLEAN_PX_DELETE_PER_PROJ
Msg 2715, Level 16, State 3, Procedure CLEAN_PX_DELETE_PER_PROJ, Line 13201
Column, parameter, or variable #1: Cannot find data type intarray.
Parameter or variable '@p_proj_id_list' has an invalid data type.
Msg 1087, Level 16, State 1, Procedure CLEAN_PX_DELETE_PER_PROJ, Line 13204
Must declare the table variable "@p_proj_id_list".
Msg 15151, Level 16, State 1, Line 13243
Cannot find the object 'CLEAN_PX_DELETE_PER_PROJ', because it does not exist
or you do not have permission.

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
References


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