CMS Snapshot Analysis - Compute Snapshot - Performance issue - Snapshot stuck while executing procedure DSSAPP_INIT_SQL
Purpose (problem description)
This page provides solution for performance issue where your snapshot is stuck at the Compute snapshot step for the procedure - DSSAPP_INIT_SQL
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. Apply the below solution
- Install the attached stored procedure DSSAPP_INIT_SQL on the Knowledge 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 #11823
Related Pages
Specify pages indirectly related to this topic.(eg:side- effects)