Job processing failure: The size specified for a binding was too small

Products

• IT Analytics

Issue/Introduction

When running a cube processing job from the IT Analytics (ITA) console, the job fails and the SQL Server Agent log contains an error similar to the following:

<Warning WarningCode="2165374978" Description="Errors in the back-end database access module. The size specified for a binding was too small, resulting in one or more column values being truncated." Source="Microsoft SQL Server 2012 Analysis Services" HelpFile="" />

Environment

Release : 2.x

Component : Cubes

Cause

The length of a string in the data source exceeds the length of the column in which it is being inserted in IT Analytics' Analysis Services database object.

This portion of the error message identifies the dimension and attribute where the insert is failing:

<Error ErrorCode="3240034317" Description="Errors in the OLAP storage engine: An error occurred while the 'Incident History - Detail' attribute of the 'DLP Incident History Detail' dimension from the 'ITAnalytics' database was being processed." Source="Microsoft SQL Server 2012 Analysis Services" HelpFile="" />

Note that this is just one example; attributes and dimensions other than these may be identified in the error message.

Resolution

Many of these errors have been addressed in IT Analytics version 2.9.1. If you are running version 2.9.1 and see this error, please contact Broadcom support for assistance.