Error: column name does not exist in the target table or view

Products

• Information Centric Analytics

Issue/Introduction

The Process Event Scenarios step (14) of the RiskFabric Intraday Processing job or the Process Risk Models step (17) of the nightly RiskFabric Processing job fails and logs the following error:

Error Msg: Exit processing of ScenarioID = <ID> Column name '<column_name>' does not exist in the target table or view. Line  Number: 1

The error message is also logged in the dbo.Log_DataTransformation table in the RiskFabric relational database each time event scenarios are processed by the stored procedure spEventScenario_CreateTimeSeriesInstances under the following LogName:

ScenarioID = <ID> | Building Indexes and Page Compressing dbo.Stg_ScenarioID_<ID>_instances | RunOrder = 0

Environment

Version : 6.x

Cause

The underlying event scenario sets used by the scenario are misconfigured and return no entity identifiers.

Resolution

Using the Analyzer, edit the underlying event scenario sets to return entity identifiers, or disable the event scenario in question.