Urgent Notice - Application Analytics Dashboard - Missing Data - The tile interface for top critical rules is empty in CAST AIP 8.1.0 - 7th April 2017

This page handle the issue when CAST Application Analytics Dashboard tile interface for  "Top critical rules"  is empty. This is applicable only to  CAST AIP 8.1.0.

The root cause and the remediation for this bug is explained below.

1. Upload the snapshot from the dashboard service to the measurement service.
2. Open AAD.

Root causes

This issue can occurs when:

1. You consolidate a snapshot on the Dashboard service from the consolidate button, then you upload the snapshot from the Dashboard service to the measurement service.
   
   
   In order to fix the issue, please refer to remediation. Note tha this was fixed in CAST AIP 8.1.1.
   
   

2. You upload snapshots from the Dashboard service to the measurement service known that you have a full content module and you do the folowing:

   • delete a snapshot between 2 snapshots
   • delete the latest snapshots between several
   • delete the only snapshot in central
     
     

3. You upload snapshots from the Dashboard service to the measurement service known that you have modules with one technology:

   • delete a snapshot between 2 snapshots
   • delete the latest snapshots between several
   • delete the only snapshot in central

4. You upload snapshots from the Dashboard service to the measurement service known that you have modules with several technologies:

   • delete a snapshot between 2 snapshots
   • delete the latest snapshots between several
   • delete the only snapshot in central

There is no workaround for the cases 1, 2, 3 and 4, you have to build a new measurement service and upload your snapshot(s) from the dashboard service to the measurement service. This issue will be fixed permanently

Remediation 

1. If your issue concern the first root cause then please proceed as follows (The below queries should be executed on the Dashboard service):

   • Get the snapshots ids:

     select snapshot_id from dss_snapshots

     Example result:

     --2
     --3

   • Run the following procedure for each snapshot id:

     select DSS_PROPAGATE_RESULTS_TO_APP(<snapshot_id>)

     In our example we have 2 snapshot ids, so we should execute the following

     select DSS_PROPAGATE_RESULTS_TO_APP(2)
     select DSS_PROPAGATE_RESULTS_TO_APP(3)

   • Cleanup DSS_METRIC_RESULTS table:

     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); 

   • Run the following procedure for each snapshot id:

     select DSS_CLEANUP_COMPUTE_METRIC (<snapshot_id>)

     In our example we have 2 snapshot ids, so we should execute the following

     select DSS_CLEANUP_COMPUTE_METRIC (2)
     select DSS_CLEANUP_COMPUTE_METRIC (3

   • Upload your snapshot(s) from the dashboard service to the measurement service

     
     

2. There is no workaround for the cases 1, 2, 3 and 4, you have to build a new measurement service and upload your snapshot(s) from the dashboard service to the measurement service.

Impact after applying the remediation's:  The  tile for  "Top critical rules" will be populated with the expected values.

Ticket # 7154, 8017