Analysis Services 2005 database processing fails when run from Integration Services

Posted on 2007-10-11
Medium Priority
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
  • 2
  • 2
LVL 18

Expert Comment

ID: 20056340
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

ID: 20057527
I have tried both client and on the server
LVL 18

Accepted Solution

PFrog earned 2000 total points
ID: 20059707
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

ID: 20066364
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.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
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…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Suggested Courses

601 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