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

Document ID:  TEC1553383
Last Modified Date:  07/06/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Business Service Insight

Releases

  • CA Business Service Insight:Release:8.3.5

Components

  • CA Business Service Insight:OBLCRE
Problem:

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

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >

Chat with CA

Just give us some brief information and we'll connect you to the right CA ExpertCA sales representative.

Our hours of availability are 8AM - 5PM CST.

All Fields Required

connecting

We're matching your request.

Unfortunately, we can't connect you to an agent. If you are not automatically redirected please click here.

  • {{message.agentProfile.name}} will be helping you today.

    View Profile


  • Transfered to {{message.agentProfile.name}}

    {{message.agentProfile.name}} joined the conversation

    {{message.agentProfile.name}} left the conversation

  • Your chat with {{$storage.chatSession.messages[$index - 1].agentProfile.name}} has ended.
    Thank you for your interest in CA.


    Rate Your Chat Experience.

    {{chat.statusMsg}}

agent is typing