While installing a multi-tier configuration of CA Business Service Insight, I see errors from the schema creation

Products

• CA Business Service Insight

Issue/Introduction

While installing BSI in a multi-tier configuration, running through the schema creation process with the command 'main.bat -so' shows three errors 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

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 haven't been created at this stage in the installation process.

Environment

CA Business Service Insight, in a two-tier or multi-tier configuration, with a separate database server.

Resolution

To fix this problem we can compile them manually, by executing the following SQLPlus commands in the 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;

This will compile the procedures correctly, as after the load the dependent elements now exist..