Incorrect values on the Import Data Report dashboard

Products

• Information Centric Analytics

Issue/Introduction

When viewing the dashboard Import Data Report, located in the Information Centric Analytics (ICA) console under Dashboards > Risk Fabric Health > Data Import Report tab, the Started and Minutes Ran values for one or more jobs are incorrect.

Cause

One or more data import jobs were manually started on step 5 (Execute Staging Query), bypassing the job steps that record the job start timestamp. Consequently, the most recent recorded job start time is displayed as the Started value, with the Minutes Ran value calculated using that timestamp and the most recent job completion timestamp.

Resolution

When manually running data source query jobs using SQL Server Management Studio (SSMS), always run each data source query job beginning with step 1 (Update Data Source Query State and Log Job Start).

The naming syntax of these jobs is RiskFabric_IW_DataSourceQueryID_<n>, where <n> is the data source query ID which can be found by executing the following query:

SELECT DataSourceQueryID, DataSourceQueryName, DataSourceQueryDescription FROM RiskFabric.dbo.IW_DataSourceQuery;