February 2, 2015 at 12:50 am
hi
I am getting below error while processing the one of the dimension
File system error: A FileStore error from WriteFile occurred. Physical file: \\?\D:\MSSQL2008R2\MSAS10_50.PMGBSSAS01\TEMP\MSMDCacheRowset_3488_434c_aueaks.tmp.
1.We tried failed dimension full processing but it was failed
2.Dimension has around 16963258 rows.
3.Data folder size of failed dimension is 6GB.
4.We have sufficient space on drive.
Could you please give us some idea to resolve this issue
February 2, 2015 at 2:19 am
You are hitting the 4GB string store limit. A (possible) solution is found here, along with a link to a technical description of the issue.....http://stackoverflow.com/questions/420193/process-dimension-fails-with-message-a-filestore-error-from-writefile-occurred
February 2, 2015 at 2:49 am
we tried their suggested points but it didn't work
February 2, 2015 at 3:11 am
Ok....but the fact remains that your problem is the 4gb string store limit. If you're on 2012+ then this can be disabled. It can be mitigated on lower versions but not disabled entirely. It is all discussed in this thread: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/973f4d41-b9d9-4c2b-96d2-876ec1679f97/way-to-get-beyond-4gb-string-store-limit
February 2, 2015 at 4:47 am
yes we are on MS Sql sever 2008 R
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply