CMS Snapshot Analysis - Compute Snapshot - Performance Issue - Stuck while executing the procedure DSS_UPDATE_ANY_MODULE_LINKS
Description
This page outlines a performance issue where your snapshot is stuck at the Compute snapshot step.
Observed in CAST AIP
| Release | Yes/No |
|---|---|
| 8.3.x | ✅ |
| 8.2.x | ✅ |
| 8.1.x | ✅ |
| 8.0.x | ✅ |
| 7.3.x | ✅ |
Observed on RDBMS
| RDBMS | Yes/No |
|---|---|
| Oracle Server | ✅ |
| Microsoft SQL Server | ✅ |
| CSS3 | ✅ |
| CSS2 | ✅ |
Step by Step Scenario
- Run Snapshot
- Snapshot stuck at Compute Snapshot step for infinite time.
Action Plan
Follow the below steps:
- Cancel the current snapshot
- Purge the current snapshot
- Take a backup of the 3 bases
- Find the attached script and execute it on your central base which will replace you current proc dss_update_any_module_links with a new optimized one.
- Relaunch snapshot
Notes/comments
Ticket # 9087
This issue is planned to be fixed in 8.2.5.
Related Pages