Tuesday, March 27, 2012

Analysis Services

I am trying to work through the tutorial when you load SQL 2005. I am running the 64 bit version. I have deployed my cube and am trying to display data in the browser. I move over the sales amount into the data area I get the below message. What should I do to fix this issue?

The query could not be processed:

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.

Sounds similar to the problem discussed in this thread:

http://groups.google.com/group/microsoft.public.sqlserver.olap/msg/d2ca4c8981db915a
>>

" noWrap width="1%" bgColor=#b71c0c>Mosha Pasumansky [MS] Oct 17, 2:24 pm show options

Newsgroups: microsoft.public.sqlserver.olap From: "Mosha Pasumansky [MS]" <mos...@.online.microsoft.com> - Find messages by this author Date: Mon, 17 Oct 2005 11:24:25 -0700 Local: Mon, Oct 17 2005 2:24 pm Subject: Re: AS 2005: ....a string was found that was larger than the page size Reply | Reply to Author | Forward | Print | View Thread | Show original | Report Abuse

Please read this thread - there is plenty of feedback from the product team.
It is a bug in CTP16 that is fixed in RTM. If you are TAP customer - you can
get CTP16 hotfix for it.

--
==============================­====================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL­og/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==============================­====================
>>

No comments:

Post a Comment