Health Dashboard - Violations - Missing Violations - Added and Removed Critical Violations are showing NA

This page provides the solution for the issue of empty tiles coming on the HD for Added and Removed Critical Violations even though there are values displayed for these metrics on CED.

Please refer to the below screenshots to get a better idea about the issue:

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

1. Take a snapshot of an application.
2. Then consolidate the snapshot from central schema to measurement schema.
3. Configure the custom tiles of Added and Removed Critical Violations in app.json and cmp.json file of HD.
4. Open HD and see the tiles returning empty results.

The impact of the problem on the analysis or the dashboard is: The HD User won't be able to see Added and Removed Critical Violations on HD.

To fix the problem, proceed as follows:

1. Open the SQL Editor in pgAdmin and run the below query on measure schema.

   select *
   from dss_objects
   where object_type_id = -102

   
   The above query will return the list of the applications that are available in the measure schema. Below is an example:

   Query Result

   7;-102;"j2ee-oracle";"";"j2ee-oracle"
   19;-102;"PHP";"";"TestApp"
   23;-102;"LienCS_test";"";"LienCS"

2. Copy the object_id of the application for which the Critical Violations (Added/Removed) are to be inserted.

3. Then Run the below query :

   insert into DSS_METRIC_RESULTS
   select h.METRIC_ID,<object_id>,1,
   (select METRIC_NUM_VALUE from DSS_METRIC_RESULTS 
   where METRIC_ID = h.METRIC_ID and OBJECT_ID = <object_id> and SNAPSHOT_ID = h.SNAPSHOT_ID and METRIC_VALUE_INDEX = 60017),'null',0,h.SNAPSHOT_ID,0
   from DSS_METRIC_HISTO_TREE h
   where h.METRIC_ID in (67901,67902)

   67901 and 67902 are the Metric ID's of Added and Removed Critical Violations respectively.

4. Replace the <object_id> with the object_id that the 1st query returns.
   For example :

   insert into DSS_METRIC_RESULTS
   select h.METRIC_ID,7,1,
   (select METRIC_NUM_VALUE from DSS_METRIC_RESULTS 
   where METRIC_ID = h.METRIC_ID and OBJECT_ID = 7 and SNAPSHOT_ID = h.SNAPSHOT_ID and METRIC_VALUE_INDEX = 60017),'null',0,h.SNAPSHOT_ID,0
   from DSS_METRIC_HISTO_TREE h
   where h.METRIC_ID in (67901,67902)

5. After applying the above mentioned workaround, reload the cache of browser and open HD. Below is a screenshot showing that the issue is not occurring anymore:
   
   

The impact of the solution on the dashboard is: The user will be able to see the values on dashboard.

Ticket # 6833

This is a bug which has been fixed in CAST 8.3.x and above.