Geek Answers Handbook

A process error with the message "Error FileStore from WriteFile"?

I am trying to process a measurement using SQL Server 2005 Analysis Services . This worked in the past without any problems, but has recently failed.

The dimension is hierarchical, using 4 columns from one table (the whole cube uses one table).

Received error message (regardless of whether I am processing the entire cube or dimension, regardless of whether I am processing the "Process completely" or not):

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

I guess this is due to the amount of growing data (there are currently 15 million rows in a particular table).

  • It worked before that (no changes were made)
  • Processing displays 11 million lines before displaying the error.
  • The physical memory on the server runs out during error display.
  • When an error message is triggered as a result of several hits, the size of the column is indicated as a problem.

Can someone point me in the right direction? I suppose one way would be to try using smaller columns (varchar (x) instead of varchar (y)), but this seems to solve the problem instead of solving the problem.

Regards, Eric Larsson

+5
source share
3 answers

Check the "ProcessingGroup" size property for all relevant dimensions. If it is installed on 'ByTable', try installing it on'ByAttribute'

, (# , # ..), , ByTable .

+2

.asstore. 4Gb ProcessUpdate, ProcessFull, .

+2

, .

+2

More articles:


All Articles