Health Dashboard - Snapshot - Missing Snapshot - Snapshot is missing in the Select your snapshot filter

This page provides the solution to the problem of snapshot not visible in the list of snapshots for a single version of the application on HD.

Refer to the screenshot below to understand the issue:

Below is the step-by-step scenario leading to the problem:

1. Take an application which has multiple snapshots of different versions in it.
2. Then consolidate the snapshots from central to measure schema using the HDConsolidation GUI.
3. Open the HD dashboard and check the number of snapshots shown for the application.
4. Some snapshot is missing even though they are present in the central schema and can be seen on CED/AED.

The impact of the problem on the analysis or the dashboard is: The user will not be able to see the snapshot data for the missing snapshot of the application on HD.

The issue occurs because of incorrect violation ratio that was computed due to Full Application Level consolidation setting. It is also shown in the Consolidation Logs of HDConsolidation GUI as stated below:

Found snapshot ID: 4
The snapshot you attempt to synchronize (4) has erroneous violation ratio.

To fix the problem, proceed as follows:

1. Connect the SQL Session to the central schema.

   set search_path= <central_schema_name>

2. Then run the below functions and queries on the central schema.

   select DSS_PROPAGATE_RESULTS_TO_APP(<snapshot_id for which the error came>); --4 in this case

3. Then run the below query to check if there are corrupt values present inside the CB:

   select count(*)
    from DSS_METRIC_RESULTS
    where (SNAPSHOT_ID, OBJECT_ID, METRIC_ID) in (select distinct dmr2.SNAPSHOT_ID, dmr2.OBJECT_ID, dmr2.METRIC_ID
    from DSS_METRIC_RESULTS dmr2
    left join DSS_METRIC_RESULTS dmr0
    on dmr0.SNAPSHOT_ID = dmr2.SNAPSHOT_ID
    and dmr0.METRIC_ID = dmr2.METRIC_ID
    and dmr0.OBJECT_ID = dmr2.OBJECT_ID
    and dmr0.METRIC_VALUE_INDEX = 0
    where dmr2.METRIC_ID in (select dmt.METRIC_ID
    from DSS_METRIC_TYPES dmt
    where dmt.METRIC_GROUP = 1
    )
    and dmr2.METRIC_VALUE_INDEX = 2
    and dmr2.METRIC_NUM_VALUE = 0
    and dmr0.METRIC_NUM_VALUE is null);

   If the above query returns a NON-ZERO value, then there is a corruption in the Central Schema.

4. If there is corruption in CB, then run the below query to remove the corruption:

   delete
    from DSS_METRIC_RESULTS
    where (SNAPSHOT_ID, OBJECT_ID, METRIC_ID) in (select distinct dmr2.SNAPSHOT_ID, dmr2.OBJECT_ID, dmr2.METRIC_ID
    from DSS_METRIC_RESULTS dmr2
    left join DSS_METRIC_RESULTS dmr0
    on dmr0.SNAPSHOT_ID = dmr2.SNAPSHOT_ID
    and dmr0.METRIC_ID = dmr2.METRIC_ID
    and dmr0.OBJECT_ID = dmr2.OBJECT_ID
    and dmr0.METRIC_VALUE_INDEX = 0
    where dmr2.METRIC_ID in (select dmt.METRIC_ID
    from DSS_METRIC_TYPES dmt
    where dmt.METRIC_GROUP = 1
    )
    and dmr2.METRIC_VALUE_INDEX = 2
    and dmr2.METRIC_NUM_VALUE = 0
    and dmr0.METRIC_NUM_VALUE is null);

5. Then run the below function, with the same snapshot_id which had the error in Consolidation.

   select DSS_CLEANUP_COMPUTE_METRIC(<snapshot_id for which the error came>); --4 in this case

6. After this, run the below query.

   update DSS_SNAPSHOTS
    set CONSOLIDATION_MODE = (select coalesce(min(cast(OPTION_VALUE as int)), -1)
    from SYS_SITE_OPTIONS sso
    where OPTION_NAME = 'ADG_CENTRAL_WEIGHT_METRIC')
    where SNAPSHOT_ID = 4;

7. After running the above functions and queries, please perform a full reset of the Measurement Schema using the HDConsolidationGUI.
8. Then consolidate the snapshots from the central schema into the measurement schema. Below is the screenshot of HD after applying the above solution.

Impact of the solution on the analysis or the dashboard is: The user will be able to see all the snapshots for the application and will be able to access the data for the snapshots.

If the above steps does not resolve your issue then please contact CAST Technical Support, with relevant input.

For CAST Technical Support only. Please refer to the page Health Dashboard - Information - How to reproduce HD issues