New Risk Model instances are not generated during RiskFabric Processing

Products

• Information Centric Analytics

Issue/Introduction

After running the nightly RiskFabric Processing job, no new risk model instances are generated and displayed in the Information Centric Analytics (ICA) console.

The following errors appear in the Log_DataTransformation table:

LogDescription:
Populate dbo.Stg_PreProcess_RiskModelInstances from dbo.LDW_EntityCollectionToEntities

ErrorDescription:
Error Msg: Conversion failed when converting from a character string to uniqueidentifier. Line Number: nnn

Cause

SQL implicitly converts the CardID column to a character string instead of treating it as a unique ID when running the stored procedure spRiskModel_CreateInstances.

Environment

Release : 6.5.x

Component :

Resolution

A fix for this bug will be included in the next release of ICA.