Errors loading job status and data integrations data

Products

• Information Centric Analytics

Issue/Introduction

The following out-of-the-box Risk Fabric Health dashboards return errors instead of displaying job and integration statuses:

Dashboards > Health Summary > SQL Job Status - Summary

Error loading SQL Job Status - Summary data

Dashboards > Data Integrations > Data Integrations

Error loading Data Integrations data

Environment

Release : 6.5.4

Component : Dashboards

Cause

These errors are caused by the use of the datetime format dd/mm/yyyy on the application server, coupled with the input parameters StartDate and EndDate in these dashboard widgets being set to type String instead of type DateTime. Consequently, when these datetime values are converted on dates after the 12th day of any given month, it returns an invalid datetime value in the ISO 8601 format.

Resolution

Change the Input Parameter Setting of the d_startdate and d_enddate parameters to DateTime for both the SQL Job Status - Summary widget and the widget on the Data Integration tab.

1. In the Risk Fabric console, navigate to Admin > Dashboards > Dashboards tab
2. In the list of dashboard folders, expand the folder Dashboards > Risk Fabric Health
3. Right-click the Health Summary dashboard and select Unlock
4. Confirm you wish to unlock this dashboard by clicking the Yes button
5. Right-click Health Summary and select Edit
6. Click the gear icon for the SQL Job Status - Summary widget
7. In the Query Editor section, double-click the filter d_startdate under Input Parameters
8. In the Input Parameter Settings window, change the Type from String to DateTime
9. Repeat steps 7 and 8 for the filter d_enddate
10. Click the Save button
11. Click the Save button
12. Click the SAVE AND CLOSE button
13. Right-click the Health Summary dashboard and select Lock
14. Confirm you wish to lock the dashboard by clicking the Yes button
15. Repeat steps 3 through 14 for the Data Integrations dashboard located under Dashboards > Risk Fabric Health