Metrics table not populated with SnapShotDate values

Products

• Information Centric Analytics

Issue/Introduction

The Metric Collector job step of the RiskFabric Processing job completes successfully but the table dbo.Metrics doesn't update the field SnapshotDateOnly and other fields.

Environment

Release : 6.x

Component : RiskFabric Collector

Cause

This condition is caused by the Risk Fabric Collector timing-out because operations initiated by the table trigger TRG_MetricHistory_SnapShotDate are taking longer than usual to complete.

Resolution

To work around this, increase the timeout value for the general portal setting Database Query Timeout (seconds).

Alternatively, disable the trigger so that the Collector can backfill all missing values, then manually initiate the trigger to update the date values for the completed set.