AS2005 September CTP Memory Error

Hot Topic

Backup SQL 2000 SP4 and Restore on SQL 2005
Escape a SQL string programmatically?
Cannot connect to SQL Express Remotely
BUG? Extracting Data Stored in Multiple Languages
Unable to restore SQL Server 2005 Beta 2 databases in SS 2005 Final
Migrate Access 2002 to SQL Express 2005
IIF driving crazy
sub-reports don't start in the first page
Hide matrix rows?
Semi-additive measures in AS2005 Standard Edition

SQL Server

Cannot install SQL Server 2005 CTP on WinXP Pro machine
Biz Talk Server
Attach Database problem
2005 64 bit : Client Tools for 32 bit.
SSIS and its scale-up architecture
Database restore to new database
Will installing sql server management studio 05 upgrade enterprise manager 00?
In VB Express 2005, I cant save any record in database of sql server.
Class does not support aggregation
Pros and cons with table lock

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

  • dd1000

    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

  • jrryfn

    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!

  • eddieg

    I encountered this very same error.  Can you tell me where I could find a post-CTP build

  • Guruper

    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...

  • Rodrigao

    I have built and depolyed a non-Adventureworks cube on September CTP with no problems at all.

  • gfs

    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!

  • sureshkolluri

    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.]

  • wfoster3

    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.

  • Software Arch

    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

  • yousef.net

    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.



  • scritchy

     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

  • frusciante

    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



  • Rabarbers

    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

  • AG_MD

    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)
  • AS2005 September CTP Memory Error
Answer this question