ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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.

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.

Environment

Release: 6.5.x

Component: Integration Wizard

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.