I getting this error when processing a very large dimension:
File system error: A FileStore error from WriteFile occurred. Physical file: ....
I've found a bunch of threads discussing the problem. The most detailed on this blog:
It seems that there is a 4GB limit on the file size that SSAS generates. Which is fair enough - everything has it limits. But my question is how do I work around it? The dimension is based on a table that has these columns:
ID bigint PK,
Two key columns, ID1 int & MD5 uniqueidentifier - these make a unique key I use to join to the measure group.
Then a varchar(800) column which contains a URL (which is the attribute I'm interested in).
The table contains 200 million rows+ which is roughly 22GB in SQL. There are no columns I can remove here. My question is surely I cannot be the first person to hit this problem. How have others worked around it? Can I somehow partition the dimension
(on rows not columns)? The URL field is the bulk of the data - in theory a URL can be 2000 chars so I'm already limiting the
View Complete Post