CMS Snapshot Analysis - Compute Snapshot - Performance issue - Snapshot stuck while executing procedure ADGCQ_COUNT_ALL_VIOLATIONS
Purpose (problem description)
This page provides solution for performance issue when your snapshot is stuck at the Compute snapshot step for the procedure - ADGCQ_COUNT_ALL_VIOLATIONS
Observed in CAST AIP
| Release | Yes/No |
|---|---|
| 8.3.x | ✅ |
| 8.2.x | ✅ |
| 8.1.x | ✅ |
| 8.0.x | ✅ |
Observed on RDBMS
| RDBMS | Yes/No |
|---|---|
| Oracle Server | ✅ |
| Microsoft SQL Server | ✅ |
| CSS3 | ✅ |
| CSS2 | ✅ |
Step by Step scenario
- Compute snapshot
Action Plan
Perform the below actions
- 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
- Install the attached stored procedure ADGCQ_COUNT_ALL_VIOLATIONSon the Central Base
- Run snapshot by skipping analysis
- If the above steps do not solve your issue contact CAST Technical Support. with the following Relevant input
Notes/comments
Ticket #19389
Related Pages