Analysis Services 2005 database processing fails when run from Integration Services
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 logIf 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 serverServer Specs:Windows Server 2003 Standard + Service Pack 24GM ram, 2GB paging fileSQL Server 2005 + Service Pack 2Can anyone help?Andy
October 11th, 2007 2:48pm

Hi all. I encountered same problem. Can anyone help us?
Free Windows Admin Tool Kit Click here and download it now
April 4th, 2011 9:24pm

what is your Processing Order? is it sequential or parallel? what is your Transaction Mode? is it one transaction or separate transaction? try with separate transaction and let me know the result.http://www.rad.pasfu.com
April 5th, 2011 1:14am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics