Hi,

I'm currently getting the following error upon processing a cube in
SASS 2005:

....The size specified for a binding was too small, resulting in one or
more column values being truncated. ...

Is there anyway to determine which binding is causing the problem?

Thanks in advance,
Kent

Hi,
The error message specifies what is the object for which the error occured ?
At least the dimension or cube or dimension attribute.

Usually this problem happens because the specified DataSize is too small for
KeyColumns of type WChar or NameColumns for DimensionAttributes.

Adrian.


"Kent" <roberts (AT) saintpatrick (DOT) org> wrote

Thanks Adrian. Yes, it does specifiy the measure group, but not which
column. I have checked all the key fields and, frankly, I'm not sure
what to look for. I was getting the same error on a couple dimensions
and found a foreign key defined as smallint and the related primary key
to be int. When I matched those, that error went away. I've been
looking for the same type of problem with the measure group and have
yet to find it. It seems strange that the message doesn't indicate
exactly which column is the problem.

Where did you changed the data type (from smallint to int) to fix the
dimension errors ? In the DataSourceView or you changed the DataType for the
KeyColumns of DimensionAttributes ?

Adrian Dumitrascu.



"Kent" <roberts (AT) saintpatrick (DOT) org> wrote

Hi Kent. I just went through this last week.

I changed a dimension attribute from nvarchar(20) to nvarchar(50) and
updated the dsv (assuming it would also update the dimensions) but
processing failed with the binding too small exception.

The column binding on one of the dimensions was still set to the former
size. The DSV was updated to nvarchar(50), the dimension was not. You'll
have to find out what columns were changed then manually update the size on
the attributes that bind to the column.


For dimensions, it will probably be either the Name column,Value column.or
Key Column(s).

For facts, expand the Source property until you find the data type and size.

These are accessible through the properties window.

-T

"Kent" <roberts (AT) saintpatrick (DOT) org> wrote

I just can't understand why the error can't indicate which column is
posing the problem. I have been trying to figure out which one for
going on two days now. ARRRRGGGG!!!!

Thanks for responding Tim. I'll just keep trying.