Data Warehousing and Business Intelligence

3 December 2009

SSAS Error: Attempted to read or write protected memory

Filed under: Analysis Services — Vincent Rainardi @ 3:25 pm
Tags:

Error message: “Attempted to read or write protected memory. This is often an indication that other memory is corrupt”. I experienced this error message a few times.

It happened in BIDS, when I edited a named query, making a mistake by removing a column from the subquery. The column was removed from the main query automatically by BIDS. As a result, the dimension attribute has no column for its source. After this, any attempt to edit the named query ended up with the above error message.

The solution? I tried to restart PC but it didn’t help. Recreating the dim and the named query works. I deleted the dimension and the named query, then close and reopen the solution. Then I recreated the named query and the dimension.

PS. I tried unchecking the option for “Suppress JIT optimization on module load” as mentioned here, but it didn’t work.

Advertisements

1 Comment »

  1. Replace the query with a completely simple one..
    ie. select * from table
    This should save OK. Then reopen the named query and paste in the correct query. This should now save.

    This doesn’t fix the problem as it will reoccur but it does allow a way of editing the named query without rebuilding the dim.

    Comment by Tony Wilkinson — 16 November 2010 @ 9:44 am | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: