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

Environment

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

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.

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..