Error: Unable to load history for job

Products

• Information Centric Analytics

Issue/Introduction

The following error is thrown in the Risk Fabric console when attempting to view a job's details under Admin > Integration > Job Status > View Details:

Unable to load history for job <job-name>

A generic error dialogue box is presented:

Request Failed

Your request failed. Click 'OK' to close this window or 'Refresh' to refresh the page.
Try again or contact the site administrator.

Error ID: <ID>

After clicking the OK button, the details load as expected.

Environment

Version : 6.6 MP2

Component : Dashboards

Resolution

This is resolved in Information Centric Analytics (ICA) 6.7.

Additional Information

The Log_Client table captures the exception with the following detail:

-- Request/response – url:/api/jobs/<GUID> api:null params:undefined extraParams:null Status: 400 StatusText: Bad Request responseText: "Unable to retrieve Jobs" – portalConfig – _PortalUserId :<GUID> _Administrator :true _CanViewMetrics :true _CanViewDIMRemediation :true _CanRemediateDIM :true _CanViewComplianceRemediation :false _CanRemediateCompliance :true _ExceptionAdministrator :true _CanViewScanExclusionS3 :false _CanViewScanExclusionAdmin :null _ScanExclusionAdministrator :true _CanViewPII :true – S3 – User.SelectedUser :0 User.TopUser :0 

Tracing the error reveals the failure is in executing spJobs_GetJobHistoryByID when converting run_duration. The run_duration column is an int in HHMMSS format for time periods up to 24 hours. If the value in this column exceeds 235959, the conversion fails and throws this error:

Conversion failed when converting date and/or time from character string.