Health Dashboard - Quality Rules - Duplicate Quality Rules

Purpose (problem description)

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

Observed in CAST Version

Observed in RDBMS

Step by Step scenario

1. Deploy HD
2. Launch and observe duplicate QR

Action Plan

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. ```sql
update DSS_METRIC_TYPE_TREES
set metric_id = - metric_id;

  2. ```sql

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. ```sql
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.
5. 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

Notes/comments

Ticket # 23906

Related Pages