While processing Cubes - Error: Memory error: Allocation failure : Not enough storage is available to process this command

Published 27 August 07 03:47 AM | SQL Master 

Got an email to inbox asking a resolution for : I can't find a remedy for this problem on Google either. Any help would be appreciated. When performing the data mining cube process -
Error: Memory error: Allocation failure : Not enough storage is available to process this command.

For the error text it looks like the system is unable to fine disk space for storage, which is not correct. You may assume that there is plenty of space left on the hard disks on that machine. The first text of error is memory related, that means Analysis Server services estimated amount of memory it would need to perform processing operation and there is not enought memory. To resolve this you could do:

Force Analysis Server to disregard the estimate and proceed with processing operation. You might get a memory allocation later down the road during processing. For that change MemoryLimitErrorEnabled server property. For description of server properties see ThisArticle.

Take a look at processing operation, see if you can process fewer things at the time. For that you can change CoordinatorExecutionMode. Take a look at the processing architechture WhitePaper

Further help you can get from  this KBA917885.

Comments

# SSQA.net - SqlServer-QA.net said on August 27, 2007 4:28 AM:

Got an email to inbox asking a resolution for : I can't find a remedy for this problem on Google

# Other SQL Server Blogs around the Web said on August 27, 2007 7:46 AM:

Got an email to inbox asking a resolution for : I can't find a remedy for this problem on Google

Anonymous comments are disabled

About SQL Master

**__________________________________** SQL Server MVP, Sr. DBA & industry expert. - Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it. It is also a power and you will gain by sharing it.