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

book

Article ID: 224711

calendar_today

Updated On:

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:

Message Executed as user: domain\username. <return xmlns="urn:schemas-microsoft-com:xml-analysis"><results xmlns="http://schemas.microsoft.com/analysisservices/2003/xmla-multipleresults"><root xmlns="urn:schemas-microsoft-com:xml-analysis:empty"><Exception xmlns="urn:schemas-microsoft-com:xml-analysis:exception" /><Messages xmlns="urn:schemas-microsoft-com:xml-analysis:exception"><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="" /><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="" /><Error ErrorCode="3239116920" Description="Errors in the back-end database access module. The read operation was cancelled due to an earlier error." Source="Microsoft SQL Server 2012 Analysis Services" HelpFile="" /><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="" /><Error ErrorCode="3239837702" Description="Server: The current operation was cancelled because another operation in the transaction failed." Source="Microsoft SQL Server 2012 Analysis Services" HelpFile="" /></Messages></root></results></return>. The step failed.

 

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.

Environment

Release : 2.x.x

Component : Cubes

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.