CMS Snapshot Analysis - Execute Linker - Error - Failed to execute Linker

Problem

This page deals with the issue encountered while running a huge analysis (more than 200 AU) where the analysis finally fails at “Execute Linker” step.
The analysis fails at this step and also consumes all of the available disk space as high as 400 GB.
This issue is caused due to some of the SQL Procedure in the Linker, that were not efficient leading to performance problem and crash.

Observed in CAST AIP

ReleaseYes/No
8.3.x
8.2.x
8.1.x
8.0.x✅ x < 1
7.3.x✅ x < 8
7.2.x
7.0.x

Observed on RDBMS

RDBMSYes/No
Oracle Server
Microsoft SQL Server
CSS3
CSS2
CSS1

Step by Step Scenario

  • Package Generation.
  • Create an Execution Unit for each Project
  • Run the Analysis
  • The analysis fails in the “Execute Linker” job

Solution

The SQL Procedure used in the Linker have been optimized for better performance.
This issue is resolved in CAST 7.3.8 version.

Impact on Analysis Results and Dashboard

TBD

Notes/comments