How to resolve 'File system error: A FileStore error from WriteFile occurred. Physical file...' error message?

Cubes processing failed in SSAS 2008 R2

Error:

File system error: A FileStore error from WriteFile occurred. Physical file:  \\?\L:\Microsoft SQL Server\MSSQL.3\OLAP\Data\MSMDCacheRowset_xxx.tmp.
Logical file:

Workaround:

Check the dimensional property "ProcessingGroup" for all the relevant dimensions. If it's set to 'ByTable' try setting it to 'ByAttribute'

 

The reason this can cause processing issues with large dimensions (# of members, # of attributes, etc.) is because when using the ByTable setting, it will try to put the entire dimension into memory.

URL: http://mssql-tech.blogspot.com/2011/11/how-to-resolve-file-system-error.html


References:

http://stackoverflow.com/questions/420193/process-dimension-fails-with-message-a-filestore-error-from-writefile-occurred

http://social.msdn.microsoft.com/forums/en-US/sqlanalysisservices/thread/709ca808-12b1-49cd-9013-7f354a1b26b0/

http://mssqlbase.blogspot.com/2010/04/process-olap-dimensions-error-file.html

http://blogs.msdn.com/b/sqlcat/archive/2009/04/01/using-processinggroup-dimension-property-option-bytable-vs-byattribute-may-error-with-string-keys.aspx