CMS Snapshot Analysis - Execute Linker - Error - Error while executing Procedure

Description

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

Observed on RDBMS

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](https://doc-data.castsoftware.com/TG/attachments/566532920/566532922.7z) 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

   ```sql
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

select LINKER_ProcessSet(USERPROJECTIDXXXXXXXXXX);

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.

Notes/comments

Related Pages