Description
This page outlines the WA to deactivate some of the metrics that use this SP, DIA_MANY_UNREFFUNCTION in the local base.
When you are facing a performance problem while running snapshot, and looking at the DSS_History table for local you find that the snapshot is stuck at executing DIA_MANY_UNREFFUNCTION which is still being executed or has taken the maximum time to execute
For example:
Observed in CAST AIP
Release | Yes/No |
|---|---|
| 8.3.x |  |
| 8.2.x | |
| 8.1.x | |
| 8.0.x | |
| 7.3.0 |  |
| 7.2.x x<=3 | |
| 7.0.x | |
Observed on RDBMS
RDBMS | Yes/No |
|---|---|
| Oracle Server | |
| Microsoft SQL Server | |
| CSS3 | |
| CSS2 | |
| CSS1 | |
Step by Step Scenario
- Run the snapshot.
- Observe that it is stuck for unacceptable time (say 4 days as in the example)
- Run the below query on the local base to find out the step being executed or stuck is at this SP.
select * from <LOCAL>.DSS_HISTORY order by ACTION_ID
Action Plan
The WA is to disable the below metric using the particular SP causing the performance problem when computing metric.
Avoid unreferenced Functions
- Disable this metric from assessment model and then KB and CB to be synchronized to run the snapshot again.
Impact on Analysis Results and Dashboard
These metrics will not be executed and will be missing from the dashboard.
Notes/comments
This SP has been optimized and the performance problem is already fixed in 7.2.4 and 7.3.1 version.
This issue has been seen in 7.0.19 and 7.3.0.
Related Pages
