Description
When connecting to the Investigation-Application Drilldown page in the dashboard, the view does not show any values
Observed in CAST AIP
Release | Yes/No |
---|---|
8.3.x |
Observed on RDBMS
RDBMS | Yes/No |
---|---|
CSS |
Step by Step Scenario
- Run a snapshot
- Connect to the Dashboard
- Go to Investigation-Application Drilldown page and observe the issue
Action plan
- The issue can occur if there was an access to the dashboard when generating the snapshot leading to incorrect content in the CB due to parallel access to some tables. to solve the issue run a re-consolidation on the last snapshot. If this do not solve the issue then go to the next step
- Check if the central base contain one of the following inconsistencies:
DSS_OBJECT_DIAG_DETAILS does not contain any violation for the current snapshot:
SELECT Count(1) FROM dss_object_diag_details WHERE snapshot_id IN (SELECT Max(snapshot_id) FROM dss_snapshots)
Query result example:
--164824
If the above query returns 0 then DSS_OBJECT_DIAG_DETAILS does not contain any violation for the current snapshot:
Previous snapshot id is the same for all snapshots:
SELECT prev_snapshot_id FROM adg_delta_snapshots ORDER BY prev_snapshot_id
Query result example:
-- 1 -- 2
If the query above returns duplicated rows then the previous snapshot id is the same for several snapshots:
Notes/comments
Webcall 27340, Ticket # 9397
Related Pages