Enough disk space error when processing the dimensions

Amy Jandreau 61 Reputation points
2021-12-07T14:39:26.783+00:00

Hi All,
I have created an SSIS package to process the dimensions , when I execute the package I am getting the below error
[Analysis Services Execute DDL Task] Error: The following system error occurred from a call to GetOverlappedResult for Physical file: '\?\O:\OLAP\DataBusinessIntelligenceDEV.1.db\Dim Res Primary Identifier.0.dim\929.Dim Res Primary Identifier.fact.data', Logical file: '' : There is not enough space on the disk.
I logged on to the server and navigated to the folder (O:\OLAP\Data\BusinessIntelligenceDEV.1.db) , here are my findings.
On december 1st I processed the dimensions (FULL) and I can see the (.dim) as type XML documents, and I processed the same set of dimensions yesterday December 6th and I see the same dimensions as folders and when I click on them I see different types of files with extensions (ASTORE,DSTORE,HSTORE...)
and when I tried to delete these folders I get the below message, please advice.
"The action can't be completed because the file is open in SQL Server Analysis Services SSAS
close the file and try again
928.(All).ahstore
Type:AHSTORE File
Thanks

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,344 questions
{count} votes

2 answers

Sort by: Most helpful
  1. CarrinWu-MSFT 6,891 Reputation points
    2021-12-08T06:27:11.487+00:00

    Hi @Amy Jandreau ,

    There is not enough space on the disk.

    Please refer to this thread, see below:

    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.

    Best regards,
    Carrin


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  2. Olaf Helper 47,436 Reputation points
    2021-12-08T08:02:48.877+00:00

    There is not enough space on the disk.

    The easiest way is to add more disk space.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.