CMS Snapshot Analysis - Compute Snapshot - Performance issue - Snapshot stuck while executing procedure DSSAPP_INIT_SQL

This page provides solution for performance issue where your snapshot is stuck at the Compute snapshot step for the procedure - DSSAPP_INIT_SQL

Step by Step scenario

1. Compute snapshot

Perform the below actions

1. Issue occurs in CAST AIP versions 8.2.3 and higher. Apply the below solution
   
   1. Install the attached stored procedure DSSAPP_INIT_SQL on the Knowledge Base
   2. Run snapshot by skipping analysis
2. If the above steps do not solve your issue contact CAST Technical Support. with the following Relevant input

Ticket #11823

Specify pages indirectly related to this topic.(eg:side- effects)