CMDB Relationship Health Dashboard shows No Data Available<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Table of Contents IntroductionCauseNext StepsDisable Relationship Health Dashboard Jobs Introduction In the "Relationship Health Dashboard" visible within the CMDB Workspace, it may be observed that one or more tiles show no data or visualization with the message: No Data Available. There is no data available for the selected criteria. Cause The widgets inside the Relationship Health Dashboard query [relation_health_result] table, which is populated by the daily Relationship Health jobs: 'CMDB Health Dashboard - Relationship Compliance Processor' and 'CMDB Health Dashboard - Relationship Score Calculation' Each tile queries for its specific metric, i.e., the "Stale Relationships" tile will query for metric "REL_STALE" inside the [relationship_health_result] table. If there are no results in [relation_health_result] table for that metric, the bar-chart tile for that metric will show [No Data Available]. If the donut style visualization tile is available for the metric, and it shows that there were no failures for that metric, then this is expected behaviour and not indicative of an issue running the job. This only indicates an issue with running the job if the donut visualization is also not present, or shows No Data Available. Next Steps To confirm if there truly was an issue with the job, begin by checking the [relation_health_result] table to confirm if there are any results for the noted metric. Please note, this table only contains results if the job determines a relationship has failed a health check. An empty table, or lack of records for a particular metric could indicate that no relationships have failed that health check. Alternatively, please be aware that the Relationship Health Dashboard jobs utilise the results from the CMDB Health Dashboard jobs. When the CMDB Health Dashboard jobs run, one of the first actions taken is to mark all the previous day's results as "to_delete", which prevents the Relationship Health Dashboard from using these results. It has been observed that if the Relationship Health Dashboard jobs run at the same time as the CMDB Health Dashboard jobs, the jobs return incomplete or empty results for some Relationship Health metrics. To avoid this, ensure that the Relationship Health results run after the CMDB Health Dashboard jobs complete - consider finding the runtime of the CMDB Health Dashboard jobs by looking at [cmdb_health_result] table to find the most recently updated records and ensuring the Relationship Health jobs only run after these are all complete. Ultimately, however, it is recommended to disable the Relationship Health Dashboard - this dashboard is no longer active for newly provisioned instances. Disable Relationship Health Dashboard Jobs 1. Go to Health Preference -> Scheduled jobs 2. Set active to false for 'CMDB Health Dashboard - Relationship Compliance Processor' and 'CMDB Health Dashboard - Relationship Score Calculation' jobs