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: <n>

Environment

Release : 6.5.x

Component :

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.

Resolution

An enhancement to address this condition was introduced in version 6.6.