ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Unable to edit IW data source job schedule via SQL Server Agent

book

Article ID: 237992

calendar_today

Updated On:

Products

Information Centric Analytics

Issue/Introduction

If an Integration Wizard (IW) data source query job has been scheduled to run on a daily cadence, the job schedule under the SQL Server Agent is configured to run a multiple of 1440 minutes (1 day = 1440 minutes) and cannot be edited except via the data source query's configuration in the Information Centric Analytics (ICA) console. If you attempt to edit the schedule via SQL Server Management Studio (SSMS), the following error is returned:

Value of '1440' is not valid for 'Value'. 'Value' should be between 'Minimum' and 'Maximum'.
Parameter name: Value (System.Windows.Forms)

Similarly, if an IW data source query job has been scheduled to run on an intraday cadence every n minutes (where n is any value greater than 100), the job schedule under the SQL Server Agent is also uneditable in SSMS and returns the same error (referencing the value in question, e.g. '101'). For the intraday cadence, note that this value needs to be entered in ICA as minutes, not hours and minutes (e.g., Hours: 0, Minutes: 101; not Hours: 1, Minutes 41).

Cause

This behavior is under investigation by ICA engineering.

Environment

Release : 6.5.4

Component : RiskFabric Processing

Resolution

No workaround has yet been identified and an ETA for a fix is not yet available.

Note that processing jobs still run successfully despite this behavior. No additional action is required.

Attachments