Processing is stuck on Risk Models or Event Scenarios

Products

• Information Centric Analytics

Issue/Introduction

The Process Risk Models step of the nightly RiskFabric Processing job and/or the Process Event Scenarios job step of the RiskFabric Intraday Processing job runs longer than historical norms or even interminably.

Environment

Release : 6.x

Resolution

This is a known issue with processing time series event scenarios through version 6.6 MP1 that was fixed in version 6.6 MP2 (6.6.2.0). An additional performance enhancement will be included in the next release of Information Centric Analytics (ICA).

Additional Information

Executing the following query shows processing is running on 'ScenarioID = <scenario-ID> | Process True Start and Match events from all Data Sets', executed by the stored procedure spEventScenario_CreateTimeSeriesInstances:

SELECT * FROM RiskFabric.dbo.Log_DataTransformation WITH (NOLOCK) WHERE StatusFlag = 'R' AND StoredProcedureName = 'spEventScenario_CreateTimeSeriesInstances' ORDER BY 1 DESC;