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

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

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

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.

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

   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 on the analysis or the dashboard is: No impact on the analysis result and dashboard.