locked
Cube processing error RRS feed

  • Question

  • I have SSIS package that process a cube.. I got below error message :

    Process Dimensions Analysis Services Execute DDL Task     Description: File system error: A FileStore error from WriteFile occurred. Physical file: \\?\C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\Finace_Cube.3.db\Fact Invoice Details.2.dim\389.Fact invoice Details.asstore. Logical file: . .  End Error  Error: 2010-01-27 03:20:13.43     Code: 0xC11F000D  

    Currently  Fact invoice details dimension ( large degenerated diemnsion)  is using Process Update...

    What could be the reason for this error and how can i fix this?

    Thanks
    Wednesday, January 27, 2010 3:59 PM

Answers

  • ".. Currently  Fact invoice details dimension ( large degenerated diemnsion)  is using Process Update .." - does the attribute storage required for this dimension exceed 4 GB (see Forum thread below)? If so, does the error go away if you (temporarily) reduce the storage?

    way to get beyond 4GB string store limit?
    ...
    There are two ways a user can run into the 4GB string store limit: 1) exceeding the limit in one of the temporary string stores created during processing; 2) exceeding the limit in one of the final string stores, such as attribute key/name string stores.  In the first case, there is a server configuration property, PropertyBufferRecordLimitEnabled, inside msmdsrv.ini which, when set to 1, can reduce the maximum number of records inside a temporary processing buffer, hence indirectly limiting the number of strings added to the temporary string store associated with the temporary buffer.  That may help when an attribute has a lot of directly related attributes which have string keys.  But if your problem is not the same, then the configuration property doesn't help and I am not aware of any other configuration properties that can address the 4GB limit of a single string store.
    ...


    - Deepak
    • Proposed as answer by Raymond-Lee Friday, January 29, 2010 6:21 AM
    • Marked as answer by Raymond-Lee Saturday, February 6, 2010 4:51 AM
    Thursday, January 28, 2010 12:49 AM