AS2005 September CTP Memory Error

I get "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." while executing query set with cube browser in SQL Server BI Dev Studio. The same error I get while executing query with VB code (via ADOMD). The source of the error is AS2005 OLEDB Provider.

One important information: I have installed Sept CTP on clean Windows XP Pro, there were no previous versions of SQL 2005 installed.

Any ideas what's up Maybe some missing parameter in connection string

Answer this question

AS2005 September CTP Memory Error

Andrero
Same problem here. Was this functionality available in earlier betas, and did it work properly I suppose that would be far easier than trying to get a NEWER build...
PRIDE

Is there a download for the hotfix It seems ridiculous to have to back out the CTP16 or to have to wait until the RTM is released. I need to start developing on SSAS 2005 immediately. Help
????
Trying to work thru the as2005 tutorial and am stopped by said memory issue.

Any solutions to this Any measure,dimension that i use causes the problem.
Reworking the cube structure to reduce record sizes Anyone been successfull w/ that

Are there any post-CTP (september) builds available
thanks
Alexander Dsugan

Same problem here.

I've been trying to track this down for a few days now. The problem is reportably fixed in the Nov release, but no hot fix is available.

Based on some configuration testing, the problem appears to be in either the PTS layer or specifically in the OLE DB drivers. I managed to recreate the issue in the June CTP (CTP 15) configuration, where the Sept drivers were installed. I could access the server fine from a remote PC, but localling, the error poped up.

Ranga Krishnan

Luther Smith wrote:
I tried deploying a cube from a SQL 2000 data source using the September CTP, but ran into the same problem. Do you have any idea whether your successful deployment had a smaller string size and if so how it got one

Sorry, I wasn't specific enough - I just meant that I had deployed non-AdventureWorks cubes sucessfully on SeptCTP. I don't know how to find out the string size, but if you tell me, I'll check it out and let y'all know.

disclaimer - I'm using SQL2005 Sept CTP x64

FloatingPoint
I agree. I have gone through all sorts of uninstalls and reinstalls between the June and September CTP's. Nothing worked to get past the memory error. I need to start learning 2005 right away!
TaylorClark
I tried deploying a cube from a SQL 2000 data source using the September CTP, but ran into the same problem. Do you have any idea whether your successful deployment had a smaller string size and if so how it got one
Andrei Plinda
I have built and depolyed a non-Adventureworks cube on September CTP with no problems at all.
skyover
I encountered this very same error. Can you tell me where I could find a post-CTP build
DellS
I currently use April CTP and everything works fine. I encountered two minor problems: slow first initialization of metadata during reading it with ADOMD (not NET) and there is no way to get value of unary operator property of member.

Best regards!
deacon
Yup. Same here. Any chance of a hotfix or something This basically halts SSAS development for my team on Sept CTP (we will have to roll back :P)
Nathalieg23
From another message board:

This is a known issue with the September CTP and it has been fixed in
post-CTP builds. The problem surfaces with client-side record sizes greater
than 1k, so a possible workaround might be to rework the cube structure to
reduce record sizes.

--
-Raman Iyer
[This posting is provided "AS IS" with no warranties, and confers no
rights.]
rEaXX
ttt

Same problem here.

There seems, however, to be some users on the forum who have gotten through the AS2005 tutorial without a hitch. I would assume these people did not have to reduce record sizes or anything like that.

Has anyone had any luck yet Has anyone tried building a cube from non-AdventureWorks data I tried but had a problem deploying so I didn't get to even test the memory error.

Anyone from MS have a solution or workaround
Rogdie
I'm having the same problem after I uninstalled the June CTP and installed Sept CTP. I'm getting the error in BIDS and SSMS, I can browse dimensions but when I try to drag a dimension or measure onto cube browser I get the error. I tried deleting the AS database, redeploying, and reprocessing and I'm still getting the error. Any help would be appreciated.
AS2005 September CTP Memory Error

Answer this question