SSAS Cube Refresh Failing

  • Hi

    We have a 64 Bit SQL 2005 EE Server with 16G of RAM.

    We have both SQL Server and SSAS running on the same server.

    Currently we have 10G allocated to SQL and SSAS total memory limit to set at 60%.

    The paging file is set to 4G

    All the SQL-related portions of the job finished as expected, then when it gets to the point of refreshing the cube itself, things error out..and the memory consumption hits 98-99% during some times when the processes are running.

    We're really not concerned with SQL performance on that box - as long as things complete successfully.

    What changes, if any, can we make to our current configuration to avoid these errors? Any inputs are much appreciated.

    Thanks!

  • Is the cube partitioned? how many records in the cube? Have you tried to manually refresh the cube?

  • What are the errors you are getting?

  • We are running an SSIS package that first refreshes a SQL database, processes the data and the data is then fed to the cubes from SQL View. The Job/Package is failing during the cube refresh process.

    The application log has "The system is out of memory" error.

    The Job errors with the following message -

    Message

    Executed as user: ..... ...0.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 7:45:00 PM Error: 2008-09-11 05:07:06.85 Code: 0xC1030001 Source: Process BOMViewer Database Analysis Services Execute DDL Task Description: Error during memory operation. Error Code = 0xC1030001, External Code = 0x00000000:. End Error Error: 2008-09-11 05:07:07.53 Code: 0xC1000007 Source: Process BOMViewer Database Analysis Services Execute DDL Task Description: Internal error: The operation terminated unsuccessfully. End Error Error: 2008-09-11 05:07:08.36 Code: 0xC1030001 Source: Process BOMViewer Database Analysis Services Execute DDL Task Description: Error during memory operation. Error Code = 0xC1030001, External Code = 0x000005AF: The paging file is too small for this operation to complete. . End Error Error: 2008-09-11 05:07:09.07 Code: 0xC1030001 Source: Proces... The package execution fa... The step failed.

  • To answer the other question:

    Yes, the cube is partitioned.

    Not sure how many records or how to find out how many records there are in it, but we know that when it was first setup, the Microsoft engineer thought we may have issues with it in the future, so it's a lot.

    Manually refreshing the cube works just fine, but when I refresh it manually, it doesn't do all of the SQL-related activities (table copies and pre-processing) just before the refresh, so I suspect that's why we don't get the same error refreshing it manually.

    Thanks

  • - The paging file is too small for this operation to complete -

    You have a memory pressure issue. Break out PerfMon and log the memory usage for all of the processes as well as page file usage while you are processing the cube to see what is overwhelming your server. You probably need to decrease the amount of memory allocated to MSSQL and allow SSAS more.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply