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

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

1. Compute snapshot

Perform the below actions

1. Issue occurs in CAST AIP versions 8.2.3 and higher. It is currently planned to be fixed in CAST 8.3.17.  To resolve this issue in prior versions to the one which includes the fix, apply the below solution
   
   1. Install the attached stored procedure ADGCQ_COUNT_ALL_VIOLATIONS on the Central 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 #19389