4 Gig limit in SSAS 2008 [ Cube / Dimension Processing ]

OK that title might be a little bit over the top for what I’m dealing with but if you were in my situation that’s the exact kind of article title that you have been looking for.  I have been trying to migrate a set of cubes from Analysis Services 2000 to SQL Server Analysis Services 2008 and have run into a number of glitches but the most annoying of them was this one…

File system error: While attempting to read information from disk, a read error occurred for physical file: \\?\D:\MSSQL\MSAS10\OLAP\Temp\MSMDCacheRowset_1868_258c_nompm.tmp, logical file: . Errors in the OLAP storage engine: An error occurred while the ‘generated attribute’ attribute of the ‘MyDimension’ dimension from the ‘MyCubes’ database was being processed.
I searched online and saw that there is a KB that describes this same type of error message: http://support.microsoft.com/kb/970184/

…  And went on to say ” The fix for this issue was first released in Cumulative Update 2 for SQL Server 2008 Service Pack 1”. 970315  (http://support.microsoft.com/kb/970315/ )

Read more...