SSAS – 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

The key is to find out which attribute of which dimension is giving the error:

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.

Usually when through SQL Server agent, it will be the first one.

Using SSMS do the processing and navigate to the dimension processing errors and find out which attribute of which dimension is this error associated with.

Once we know that we should be able to fix it by:

  • Increasing the value of the property called DataSize for the attribute under both NameColumn and KeyColumns.
  • Associate if any of the NameColumn or KeyColumns, is missing

MSDN Reference

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s