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