Schema Creation errors

Products

• CA Business Service Insight

Issue/Introduction

While installing CA Business Service Insight in a multi-tier configuration and running the schema creation process with the command 'main.bat -so', three errors appear in the output log:

Procedure PRC_ASSIGN_SVC_TO_CATEGORY

Warning: Procedure created with compilation errors.

Errors for PROCEDURE OBLICORE.PRC_ASSIGN_SVC_TO_CATEGORY:

LINE/COL ERROR
-------- -----------------------------------------------------------------
76/4 PL/SQL: Statement ignored
76/4 PLS-00201: identifier 'OBLICORE.PRC_ENSURE_SVC_TO_CATEGORY' must
be declared
--
Procedure PRC_ACE2_RELOAD

Warning: Procedure created with compilation errors.

Errors for PROCEDURE OBLICORE.PRC_ACE2_RELOAD:

LINE/COL ERROR
-------- -----------------------------------------------------------------
22/4 PL/SQL: Statement ignored
22/4 PLS-00201: identifier 'OBLICORE.PRC_CLEAN_ACE2_DATA' must be
declared
--
Procedure PRC_CREATE_METRIC_CALC_TABLES

Warning: Procedure created with compilation errors.

Errors for PROCEDURE OBLICORE.PRC_CREATE_METRIC_CALC_TABLES:

LINE/COL ERROR
-------- -----------------------------------------------------------------
11/4 PL/SQL: Statement ignored
11/4 PLS-00201: identifier 'OBLICORE.PRC_LOG_MESSAGE' must be declared

Environment

CA Business Service Insight 8.3.x

Multi-tier configuration with a separate database server

All Supported Oracle Database versions

Cause

For these three tables, PRC_ASSIGN_SVC_TO_CATEGORY, PRC_ACE2_RELOAD and PRC_CREATE_METRIC_CALC_TABLES, their compilation depends on other procedures that have not yet been created at this stage in the installation process.

Resolution

Compile the tables manually by executing the following SQLPlus commands against the BSI database:

ALTER PROCEDURE OBLICORE.PRC_ASSIGN_SVC_TO_CATEGORY COMPILE;
ALTER PROCEDURE OBLICORE.PRC_ACE2_RELOAD COMPILE;
ALTER PROCEDURE OBLICORE.PRC_CREATE_METRIC_CALC_TABLES COMPILE;