Risk Fabric Health Dashboard error: Error loading Risk Fabric - SQL Job Status - Detail data

Products

• Information Centric Analytics
• Data Loss Prevention Core Package

Issue/Introduction

The following error is displayed on the Dashboards > Risk Fabric Health dashboard in the Risk Fabric - SQL Job Status - Detail widget:

Environment

Release : 6.5.3

Component :

Cause

When a SQL job has an invalid schedule (e.g., no future occurrences), it will fail and cause the Risk Fabric Health Dashboard to fail.

Resolution

The reported behavior was caused by a defect that was addressed in 6.5.4.

Alternatively, deleting invalid job schedules will temporarily address this issue.

Additional Information

The following query will identify any jobs scheduled without a future run date:

SELECT
 *
FROM msdb..sysjobschedules SJS
JOIN msdb..sysjobs SJ
 ON SJS.job_id = SJ.job_id
WHERE next_run_date = 0
;