Analysis Services 2005 database processing fails when run from Integration Services

Posted on 2007-10-11
Last Modified: 2016-02-13
Hello, I have a problem when trying to fully process an SSAS database using Integration Services "Analysis Services Processing Task" task.  I have 2 of these tasks which are responsible for processing the Dimensions then the Cubes.  When I run the package either via the BIDS environment or on the local server from the Integration Services engine, I will get an error after about 20 minutes stating:

"Error: Memory Error: Allocation failure. Not enough storage is available to process this command"
"Error: Errors in the metadata manager. An error occurred when loading the <cube name> cube from the file \\?\D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\MyWarehouse\<cube file>.xml"

The cube name is not specific, it will fail and any of my cubes could be in the error log

If I fully process the AS database using the AS engine (logon to local AS server, right-click AS database and click Process), I get no errors at all, it processes and completes fine.  The processing options are identical when I run in AS or via the SSIS "Analysis Services Processing Task" task.

I've searched quite a lot online but no joy, the information I have gleaned from various sites does not directly link SSIS with SSAS processing problems.

When either the AS processing starts via SSAS or SSIS the memory usage of MSMDSRV.exe increases to around 1.4 / 1.5 GB but never goes to 2GB ever, even when the error appears.

I've done the following with no effect.

"      Have run via AS and works fine
"      No specific cube it fails on
"      Have created a Dimension only package, same problem
"      Changed the maxmemorylimit
"      Changed the connections to localhost
"      Memory DOES NOT max out on server

Server Specs:
Windows Server 2003 Standard + Service Pack 2
4GM ram, 2GB paging file

SQL Server 2005 + Service Pack 2

Can anyone help?

Question by:janineo
    LVL 18

    Expert Comment

    Where are you launching the SSIS package from?  Are you initiating it from a client PC (to run on the server) or actually initiating it from the server itself?

    If from a client, try it directly on the server and see if that makes a difference...

    Author Comment

    I have tried both client and on the server
    LVL 18

    Accepted Solution

    Are you processing it in parallel or sequential? And in a single or seperate transactions?

    If it is not already, try sequential and seperate.

    Author Comment

    I've changed it to Separate Transactions in the AS Processing Task in IS and have processed it via SSIS perfectly.

    Thank you very much, perfect outcome, well done.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    SQL Command Tool comes with APEX under SQL Workshop. It helps us to make changes on the database directly using a graphical user interface. This helps us writing any SQL/ PLSQL queries and execute it on the database and we can create any database ob…
    Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now