CMS Snapshot Analysis - Compute Snapshot - Performance Issue - Stuck at Compute Metrics - LOCAL_INIT_IFPUG
Description
This page outlines a performance issue where your snapshot is stuck at the Compute metrics step.
If you query in the DSS_History table fr local base, you will find the the below procedure has started execution but never ended and leads to the performance issue.
Start {LOCAL_INIT_IFPUG} (-3 60001 60002 69004)
The LOCAL_INIT_IFPUG SP is calling another SP, DSSAPP_SCOPE_INIT_IFPUG which is stuck.
Observed in CAST AIP
| Release | Yes/No |
|---|---|
| 8.3.x | ❌ |
| 8.2.x | ❌ |
| 8.1.x | ✅ x < 1 |
| 8.0.x | ✅ x < 3 |
| 7.3.x | ✅x<10 |
| 7.2.x | ✅ |
| 7.0.x | ❌ |
Observed on RDBMS
| RDBMS | Yes/No |
|---|---|
| Oracle Server | ? |
| Microsoft SQL Server | ? |
| CSS3 | ❌ |
| CSS2 | ✅ |
| CSS1 | ❌ |
Step by Step Scenario
- Run Snapshot
- Snapshot stuck at Compute Snapshot step for infinite time
Action Plan
Run the below scripts on KB
delete from SYS_SITE_OPTIONS where OPTION_NAME = ‘TCC Consider Only Tables for Transaction IsInput and DataFunction IsInternal’;
insert into SYS_SITE_OPTIONS (OPTION_NAME, OPTION_VALUE) values (‘TCC Consider Only Tables for Transaction IsInput and DataFunction IsInternal’, 1);
2. Run the snapshot again.
**Notes/comments**
Ticket # 4045
**Related Pages**