Health Dashboard - Views - Empty or blank view - Health Factor view is empty

This page is a troubleshooting guide for the problem where no data is visible when we click on a Health Factor as seen in the below screenshot -

 This problem occurs when the following steps are done:

1. Launch HD

2. Choose any application by clicking on + button on top left

3. From the application level view select any health factor

1. Check if there are any metrics which have been disabled and are not computed .
   If yes , then.

   1. Run the following query against the Dashboard Service schema (central) :

      select metric_id from DSS_METRIC_HISTO_TREE where METRIC_PARENT_ID=<BUSINESS_CRITERIA_ID> and metric_type = 0

      Replace the <BUSINESS_CRITERIA_ID> with External ID of the metric. Use this page to get the External ID of Business Criteria - CMS - Business Criteria tab
      Example Result

      select metric_id from DSS_METRIC_HISTO_TREE where METRIC_PARENT_ID=<BUSINESS_CRITERIA_ID> and metric_type = 0
      
      Result - 
      metric_id
      1500003
      1500004

      
      

   2. If the query does not return any rows then it means that no metric is disabled under that Business Criteria. If it returns some rows then insert fake grades manually for the disabled metrics using the below query , to be run on Measurement Database

      insert into DSS_METRIC_RESULTS values (<DISABLED_METRIC_ID>,3,0,1,'NULL',0,1,0)

      In our example we have two metrics that are disabled - 1500003 ,1500004 so we need to insert twice -

      insert into DSS_METRIC_RESULTS values (1500003,3,0,1,'NULL',0,1,0)
      insert into DSS_METRIC_RESULTS values (1500004,3,0,1,'NULL',0,1,0)

2. If you do not have any metrics disabled or if you have already applied the Solution and still facing the issue then contact CAST Technical Support with Relevant Input

 Relevant Input

1. CAST Support Tool (CST) - alias Sherlock export with option Export CAST Databases , Export Logs , Export Configuration files options checked
2. Screenshot of HD showing the problem