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.
Release: 6.5.x
Component: Integration Wizard
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.
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;
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.