RiskFabric Processing job step Run Staging Procedures fails
search cancel

RiskFabric Processing job step Run Staging Procedures fails

book

Article ID: 184788

calendar_today

Updated On:

Products

Information Centric Analytics

Issue/Introduction

While running the RiskFabric Processing job, the job step Run Staging Procedures fails and returns an error similar to the following:

Message
ParentLogGroupID=13968;LogGroupDescription=spIW_RunStandardProceduresParallel @i_sProcedureType = 'Staging', @i_bIntraday = 0;StatusFlag=F;RunMinutes=.00

Errors
----------------
LogGroupID=13979;LogID=623848;LogGroupDescription=Integration Wizard - spIW_RunImportRuleMappingStaging @i_nImportRuleMappingID = 10;ErrorDesc=Error Msg: String or binary data would be truncated.Line Number: 3

The values for ParentLogGroupID, LogGroupID, LogID, and @i_nImportRuleMappingID will be specific to your environment.

Environment

Release: 6.5.x

Component: Integration Wizard

Cause

One or more staging columns contain values with string lengths that exceed the defined maximum length of the preprocessing table columns to which they are mapped, or string data is being inserted into a preprocessing column that is assigned a numeric data type. This can be from either a source column or a hardcoded value.

Resolution

To resolve this error, the source data needs to be investigated and corrected (if necessary) upstream from Information Centric Analytics (ICA), or a trimming function should be used in the IW mapping within ICA.

To assist with troubleshooting, the following queries can be used to identify and isolate the offending columns:

--Query 1
USE RiskFabric;
GO
SELECT irmcppc.ImportRuleName,
  irmcppc.ImportRuleMappingName,
  ls.LinkedServerLabel,
  irmcppc.DataSourceQueryID,
  dsq.DataSourceQueryName,
  irmcppc.DataSourceQueryDestinationTableName,
  irmcppc.DefaultValue,
  irmcppc.FormulaValue,
  irmcppc.SourceColumnName,
  irmcppc.StagingColumnName,
  irmcppc.PreProcessTableName,
  irmcppc.ImportRuleMappingPreProcessTableName,
  irmcppc.PreProcessColumnName,
  irmcppc.ParentEntityName,
  irmcppc.ParentEntityDestinationTableName,
  irmcppc.MappingType
FROM vIW_ImportRuleMappingColumnPreProcessColumn AS irmcppc
JOIN LinkedServers AS ls
ON  irmcppc.LinkedServerID = ls.LinkedServerID
JOIN IW_DataSourceQuery AS dsq
ON  irmcppc.DataSourceQueryID = dsq.DataSourceQueryID
WHERE ImportRuleMappingID =  --Insert the ImportRuleMappingID from the job step failure message here;
--Query 2
SELECT  TABLE_CATALOG,
   TABLE_SCHEMA,
   TABLE_NAME,
   COLUMN_NAME,
   DATA_TYPE,
   CHARACTER_MAXIMUM_LENGTH
FROM  INFORMATION_SCHEMA.COLUMNS
WHERE  TABLE_NAME = '' --Insert the name of the DataSourceQueryDestinationTableName from Query 1
ORDER BY COLUMN_NAME;

Additional Information

For additional information, please refer to the following section of the Symantec Information Centric Analytics 6.5.4 Integration and Solution Accelerator Guide:

Using the Integration Wizard to Create a User-defined Data Source

Please note that IW mappings and formulas are the responsibility of the customer. If additional assistance is required, please contact a member of your Broadcom account team.