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

Description

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 -

Observed in CAST AIP

Observed on RDBMS

Step by Step Scenario

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

Action Plan

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](http://doc.castsoftware.com/display/DOC82/CMS+-+Business+Criteria+tab)  
      Example Result

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

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

Notes/comments

Related Pages