Error while processing the cube: There is not enough space on the disk
I am getting following error while processing SSAS cube using powershell script. Error is "There is not enough space on the disk." However there is 2 TB memory allocated on the server and the estimated cube size is not more than 8 GB. Can some one please advise me on why i am getting this error and how to resolve it.
The following system error occurred from a call to GetOverlappedResult for Physical file: '\?\K:\OLAP\Data\xxx.0.db\xyz.0.cub\Factx.0.det\Factx.0.prt\131.fact.data', Logical file: '' : There is not enough space on the disk. . Errors in the OLAP storage engine: An error occurred while processing the 'Factx' partition of the 'Factx' measure group for the 'Factx' cube from the xxx database. Server: The current operation was cancelled because another operation in the transaction failed.
thanks
Answer
Check the settings for TempDir under the advanced settings on your SSAS instance. By default this is set to c:\ and if your cube is heavy on aggregations they can be written out to TempDir as the cube processes and can fill up pretty quickly. Change the TempDir to a folder within your k:\ drive or similar.