Saturday, April 27, 2019

The Size Specified for a Binding too Small (SSAS Cube)

Getting an error when processing the Cube (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. Errors in the OLAP storage engine.”  This error is due to the size of the Attribute exceeds the Data Size defined in the attribute.

I have seen this error comes at two places that is 
1) when data size in physical fact table is changed.
2) when data size in physical dimension table is changed.

Resolution for

1) If dimensions are processing successfully only seeing the error when Cube itself is processed. Open the data source view right click and refresh. This will fix the cube. Now deploy the Cube and re-process.

2) If error comes when processing dimensions. This can be solved easily by two ways.
    
    A) If it is simple Dimension, delete and create new dimension link the keys with Fact.
    B) If the above is not an option then check data type of each attribute of the dimension, match this with physical dimension table. and update the data type in the dimension attribute. 

After updating Data types re-process the dimensions. 
Have a happy day.

No comments:

Post a Comment

Popular Posts