Health Dashboard - Quality Rules - Duplicate Quality Rules

This page helps you to resolve the issue of duplicate quality rules which is observed only in Health Dashboard or Application Analytics Dashboard as shown below :

         D

1. Deploy HD
2. Launch and observe duplicate QR

If you observe duplicate quality rules in Health Dashboard then please perform the below actions :

1. Run the below query in central schema which will confirm if there are duplicate rules in dss_metric_histo_tree table. Last column from the result gives the count of rule.

   SELECT snapshot_id, metric_parent_id,
   metric_id,
   metric_index,
   metric_type,
   aggregate_weight,
   metric_critical,
   Count(1)
   FROM dss_metric_histo_tree dmht
   where dmht.snapshot_id=<snapshot_id_having_issue> --replace your snapshot_id
   GROUP BY snapshot_id,
   metric_parent_id,
   metric_id,
   metric_index,
   metric_type,
   aggregate_weight,
   metric_critical
   HAVING Count(1) >1
   ORDER BY snapshot_id,
   metric_parent_id,
   metric_id,
   metric_index,
   metric_type,
   aggregate_weight,
   metric_critical

2. If the count is more than 1 then rules are duplicated in dss_metric_histo_tree table which is due to some corruption.To resolve this, please perform the below steps:
   1. Take a backup of your central schema.
   2. Run below queries on central schema

      1. update DSS_METRIC_TYPE_TREES
         set metric_id = - metric_id;

      2. INSERT INTO dss_metric_type_trees
         (metric_parent_id,
         metric_id,
         metric_index,
         aggregate_weight,
         metric_scope_procedure_name,
         metric_scope_procedure_name_2,
         metric_critical)
         SELECT DISTINCT metric_parent_id,
         -metric_id,
         metric_index,
         aggregate_weight,
         metric_scope_procedure_name,
         metric_scope_procedure_name_2,
         metric_critical
         FROM dss_metric_type_trees;

      3. delete from DSS_METRIC_TYPE_TREES
         where METRIC_ID < 0;

   3. Take a snapshot skipping analysis.
   4. Consolidate the new snapshot to measurement using doc and check the result in dashboard.
3. If the above steps do not solve your issue contact CAST Technical Support. with the following Relevant input

Relevant input

• CAST Support Tool (CST) - alias Sherlock export with the following options  Export CAST Bases with Management Base, Knowledge Base, Central base, Measurement Base 
• Screenshot showing the issue

Ticket # 23906