Search This Blog

Thursday, July 15, 2010

Master data Processing fails frequently with "Process Update"

Issue:
When you process a dimension by using the Process Update processing option or the Process Default processing option in Microsoft SQL Server 2005 Analysis Services, you may receive the following error message: "Description: File system error: A FileStore error from WriteFile occurred. Physical file: file://?/Z:/Program Files\Microsoft SQL Server\MSSQL.1\OLAP\Data\.395.db\.755.dim\1619.9- .bsstore. Logical file:.”
Analysis:
BSSTORE file is used for a valueColumn property of an attribute with a WCHAR datatype.The asstore and bsstore files do suffer from growth issues with processupdate. It seems that the growth might be worse for the bsstore than the asstore as well.
When the dimension is processed with Process Update, the bsstore file keeps on increasing as the update goes appending to this file whereas Process Full overwrite to this file restricting the size to a limit. Once this file reaches to the size of 4 gb, Master processing fails with Update Process.

Solution:
Solution 1: Process Full the dimension that has some assigned ValueColumn property.
Solution 2: Use the Value Column property only when it is needed, else avoid it.
The More information section in the following article does talk about the growth issues.912016 FIX: Error message when you process a dimension by using the Process Update processing option or the Process Default processing option in SQL Server 2005 Analysis Services: "Operation has been cancelled"http://support.microsoft.com/default.aspx?scid=kb;EN-US;912016 If the dimension is frequently processed that way, the string file store will become very large. When the string file store reaches 4 GB, you can no longer process the dimension by using the Process Update processing option or the Process Default processing option. You will receive an error message.

No comments: