While running the analysis the analysis crashes with the error in the CAST-MS log "Error while executing Procedure", please find the screen shot below:

Figure 1

Observed in CAST AIP
8.1.x(tick) x < 1
8.0.x(tick) x<3
Observed on RDBMS
Oracle Server(error)
Microsoft SQL Server(error)
Step by Step Scenario

Below is the step-by-step scenario leading to the problem:

  1. Package the source code.
  2. Deliver it and set it as current version.
  3. Run analysis, the analysis crashes at Execute Linker step with the error "Error while executing Procedure".
Impact of the Problem

The impact of the problem on the analysis or the dashboard is: There would be some links missing which were supposed to be created by Linker step.

Action Plan

To fix the problem, proceed as follows:

  1. Open the SQL session and run the below query to set your local base as current schema:

    set search_path=XXXXXXXXXXXXXXXXXxx_local;


  2. Run the attached query in a sequencial way to replace the existing procedure with the optimized one.
  3. Run the linker step manually by following the below step.
  4. Get the user project id

    set search_path=XXXXXXXXXXXXXXXXXxx_local;
    select IdKey from Keys where ObjTyp = 669 and KeyNam != 'KB Information Finalization'; 
    Query result example

    Figure 2

    Only one line will be returned by the query which is the user project Id as shown in the screen shot above:


  5. Run the linker in a sql session
  6. Set the user project id in the following query, then run it


    Please find the stored procedure result below, also find the time it took at the bottom right highlighted

    Query result example

    Figure 3

Impact of the Solution

Impact of the solution on the analysis or the dashboard is: No impact on the analysis result and dashboard.

Related Pages