In a SQL Server 2005 Analysis Services project I have the following problem:
when a column width is changed (e.g from 5 to 6) in the relational database and I refresh the dsv in the analysis services project. Not in all places the column value gets updated. When I check the dsv and the dimensions containing this column is set to the right value.
But when I deploy and process the cube I get the following 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.
Errors in the OLAP storage engine: An error occurred while processing the 'Gefactureerde Dienst' partition of the 'Gefactureerde Dienst' measure group for the 'FMR DWH Afgenomen Dienst' cube from the FMR_Kubus database.
When I check the XML of the cube I see that not all widths are updated to the new value.