The query could not be processed:
o Memory error: While attempting to store a string, a string was larger than
the page size selected. The operation cannot be completed.

Any idea what this is about and how to fix it?

This is a known bug in the September CTP. I didn't find a workaround so
installed a newer version...


"Paul Joubert" <paulspam (AT) telkomsa (DOT) net> wrote

Where can I get the newer version?

Regards,
Paul
"Pieter van Maasdam" <pieter.van.maasdam (AT) macaw (DOT) nl> wrote

It is fixed in the RTM bits which are now available for downloading from
MSDN.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Paul Joubert" <paulspam (AT) telkomsa (DOT) net> wrote

We are running SQL 2005 Enterprise RTM (32 bit).

I am getting the following very similar error:

"Memory error: While attempting to store a string, a string was found
that was larger than the page size selected. The operation cannot be
completed."

I get this only on one cube via a particular client on a different
machine from the one running SQL2005.

The client machine likely has pre-RTM bits of AS2005 client components.
You'll need to update the MSOLAP.3 OLE DB provider on it - you can find the
package here (look for Microsoft SQL Server 2005 Analysis Services 9.0 OLE
DB Provider):
http://www.microsoft.com/downloads/d...displaylang=en

--
-Raman Iyer
SQL Server Data Mining
[This posting is provided "AS IS" with no warranties, and confers no
rights.]

"Renato" <renato_buda (AT) iprimus (DOT) com.au> wrote

Installing the latest Microsoft SQL Server 2005 Analysis Services 9.0
OLE
DB Provider on the client fixed the problem for me.

Thanks Raman.