.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Memory error: Allocation failure : Not enough storage is available to process this command. .

Posted By:      Posted Date: October 04, 2010    Points: 0   Category :Sql Server


I get the error message above. Cube has 3 measure groups, 1 main fact and 2 many to many facts. Main fact has 450k rows, other two have 165 rows and 2200k rows. It also has 4 dimensions. Dimensions have max 10000 rows.

I get the errors when I add a "calculated" fact to the the main fact group, which is a distinct count on a key. When I remove that fact, the error is gone.

I am using sql 2005 enterprise with the latest sp's and patche on a windows 2003 server with 4GB 32 bit. Any ideas ?


View Complete Post

More Related Resource Links

Error Message "Not enough server storage is available to process this command" thrown when using Dia


I've been trying to make a library that uses the System.Diagnostics.PerformanceCounters to monitor perfmon on a variety of machines in C#. While the system seems to run fine, I've noticed after three weeks or so of polling that I just started receiving the error:

"Not enough server storage is available to process this command" on Windows Server 2003 machines

which the stack trace identifies as being from:

at System.Diagnostics.PerformanceMonitor.GetData(String item)
   at System.Diagnostics.PerformanceCounterLib.GetPerformanceData(String item)
   at System.Diagnostics.PerformanceCounterLib.get_CategoryTable()
   at System.Diagnostics.PerformanceCounterLib.GetCategories()
   at System.Diagnostics.PerformanceCounterLib.GetCategories(String machineName)
   at System.Diagnostics.PerformanceCounterCategory.GetCategories(String machineName)


The same error occurs when I try hitting System.Diagnostics.Process.GetProcesses().


I can "fix" the issue by restarting the Remote Registry, but it's not really a long term solution since I won't be able to do this going forward on all of the machines.


I've noticed that on the machines that fail, around the time the failure occurs, I start to see warnings in the

Connection Error: (provider: Shared Memory Provider, error: 0 - No process is on the other end of th

Hello,Please bear with me as I am no Sql Server guru, but am getting this error that is preventing me from continuing with my development work.  I am the only developer on my team running Sql Server 2005 and it has been working just fine for the last week.  I opened the Management Studio this morning, just like every other morning and got this error:TITLE: Connect to Server------------------------------ Cannot connect to (local). ------------------------------ADDITIONAL INFORMATION: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233) Of course the help page says no help is available.  I have googled myself sick and still have not found a way so resolve this...has anyone else had this error and/or a fix?  I am using XP Pro SP2...any help would be greatly appreciated!Thanks!Steph

"Not enough storage is available to process this command" exception on BitmapSource.Create


Hello all,

i've been developing an application that uses Directshow Sample grabber to take snapshots from a video capture and to show it in a WPF control and save it to a local file. I'm using VS2010. Every thing went fine in the development and tests, except when i tried the app in a non-development computer with Windows 7 installed. I caught this exception on application logs:

System.ArgumentException: Not enough storage is available to process this command.  ---> System.Runtime.InteropServices.COMException (0x88982F8C): Excepção de HRESULT: 0x88982F8C
   em System.Windows.Media.Imaging.CachedBitmap.InitFromMemoryPtr(Int32 pixelWidth, Int32 pixelHeight, Double dpiX, Double dpiY, PixelFormat pixelFormat, BitmapPalette palette, IntPtr buffer, Int32 bufferSize, Int32 stride)
   em System.Windows.Media.Imaging.BitmapSource.Create(Int32 pixelWidth, Int32 pixelHeight, Double dpiX, Double dpiY, PixelFormat pixelFormat, BitmapPalette palette, IntPtr buffer, Int32 bufferSize, Int32 stride)

The code that generates this exception follows

byte[] imageBytes = new byt

Event 18210 error - Operating system error 1130 (not enough server storage is available to process t


I tried for the last three days to do a restore over the network or copy the files from one server to another. I kept getting NOT Enough space but there is 500GB free for 49GB file.

OS: Windows Server 2008 64bits

SQL Server 2008 R2 Enterprise 64bits

Restoring using T-sql got the following error:

Msg 3203, Level 16, State 1, Line 1

Read on "\\servername\backup\xxxxx\xxxxx_backup.bak" failed: 1130(Not enough server storage is available to process this command.)

Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

Event log as the following:

BackupIoRequest::ReportIoError: read failure on backup device '\\servername\backup\xxxxx\xxxxx_backup.bak'. Operating system error 1130(Not enough server storage is available to process this command.).

I did some research and I found stuff for SQL 7 or windows XP or NT old s

command object error


Could someone please tell me what is wrong with my syntax here?  I'd be much appreciative.


objCmd = New SQLCommand("SELECT CASE WHEN objDR('Item') = 'Enter Bill of Lading' then enterbol " _  

& "WHEN objDR('Item') = 'Bill of Lading History' THEN bolhistory " _  

& "WHEN objDR('Item') = 'Request Transfer' or objDR('Item') = 'View Transfer in Progress' THEN transfers " _  

& "END  from plantGroups where plantgroupid=@plantgroupid", objConn)

Tools for memory error check in VS2005


Dear all,

I am going to write vs2005 program with ASP.NET and C++.

As you know that C++ will involve a lot of memory error handling.

Do you know is there any tools for checking memory error in Code Behind C++??

Visual C++ 6.0: Don't Let Memory Allocation Failures Crash Your Legacy STL Application


Most C++ developers make extensive use of the Standard Template Library (STL) in their code. If you are one of them and are using STL and Visual C++ 6.0 directly out of the box, your application is at high risk of crashing under low memory conditions. The problem arises because checking for failure of operator new is such an uncommon practice. To make things worse, when new does fail, the response is not standard. Some language compilers return NULL while others throw an exception.In addition, if you are using STL in an MFC project, be aware that MFC has its own set of rules. This article discusses these problems, explains how the default behavior has changed in Visual C++ .NET 2003, and outlines the changes you must make if you're using Visual C++ 6.0 so that you can safely use the STL when operator new fails.

James Hebben

MSDN Magazine September 2003

Error "The process cannot access the file ....." occurs while using function "ExportToStream"


Dear all,

   I sometimes get the following error while printing crystal report to pdf:

   System.Runtime.InteropServices.COMException (0x80004005): The process cannot access the file because
it is being used by another process. at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export
(ExportOptions pExportOptions, RequestContext pRequestContext) at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream
(ExportRequestContext reqContext) at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext)
 at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportOptions options) at
 CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportFormatType formatType) at
 CommonWA.CommonFunc.GetPDFMemoryStream(DCMSReportDoc _dcmsreportdoc, Boolean& _DataExist) in E:\wwwroot\ASPWA\CommonWA\CommonCom.vb:line 382

  The error not occurs frequently but sometimes it will happen, can someone tell me why the error occurs and how can I solve the problem?

Thank you very much.


Problem while creating process memory dumps.

Hi, I have following piece of code: Imports System Imports System.IO Imports System.Runtime.InteropServices Imports Microsoft.Win32.SafeHandles Imports System.ComponentModel Module Module1 <Flags()> Friend Enum NativeMiniDumpType MiniDumpNormal = &H0 MiniDumpWithDataSegs = &H1 MiniDumpWithFullMemory = &H2 MiniDumpWithHandleData = &H4 MiniDumpFilterMemory = &H8 MiniDumpScanMemory = &H10 MiniDumpWithUnloadedModules = &H20 MiniDumpWithIndirectlyReferencedMemory = &H4 MiniDumpFilterModulePaths = &H80 MiniDumpWithProcessThreadData = &H100 MiniDumpWithPrivateReadWriteMemory = &H200 MiniDumpWithoutOptionalData = &H400 MiniDumpWithFullMemoryInfo = &H800 MiniDumpWithThreadInfo = &H1000 MiniDumpWithCodeSegs = &H2000 MiniDumpWithoutAuxiliaryState = &H4000 MiniDumpWithFullAuxiliaryState = &H8000 End Enum <DllImport("dbghelp.dll", CharSet:=CharSet.Auto, SetLastError:=True)> Friend Function MiniDumpWriteDump(ByVal hProcess As IntPtr, ByVal processId As Int32, ByVal hFile As SafeFileHandle, ByVal dumpType As NativeMiniDumpType, ByVal exceptionParam As IntPtr, ByVal userStreamParam As IntPtr,

How to check how much memory from .NET process is allocated in pagefile?

Hi How to check how much memory from .NET process is allocated in pagefile? I was trying use task manager and perfmon but I could not find any counter/column that would tell me how much memory from specific .NET process is in pagefile. Regards

sql 2005 sp2 memory error FAIL_VIRTUAL_RESERVE

We're running SQL Server 2005 SP (9.00.4035.00) 32 bit on Windows Server 2008 SP2 Enterprise.   The server has 8gb of RAM and is only used for SQL Server.  Since Windows 2008 SP2 was installed on 8/23/2009, once every week or so the server has become unresponsive.  Early in in the course of the problem I notice the following error in the SQL Server error log:  Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 1048576 That's followed by the output of DBCC MEMORYSTATUS, which I'll include at the end of this post. After that, things work normally for several hours, except for some occurences of Downgrading backup log buffers from 1024K to 64K That appear in the SQL Server error log when our transaction log backups occur.  Some time after that, we begin to receive Event ID: 701 There is insufficient system memory to run this query. In the event logs of our server. At that point, the server becomes unresponsive.  Restarting the SQL Server Service resolves the issue. Is anyone else experiencing this? It's only been happening 1 time per week (not consistently the same time) and has only occurred since Windows Server 2008 SP2 was installed.  I don't know if that's related, but it's the only real change to that server.  Workload has been consistent on that server for months. Can someone please help? Thanks. Here's the DBCC output. Memory Manager     VM Reserved =

Failed to generate a user instance of SQL Server due to failure in starting the Process for the User

Could someone help with this please? I'm using VWD 2010 to build a new web site - I tried to add a new database file but it won't do it. I started by clicking on the folder 'App_Data', then right clicking and selecting 'Add new item' - after that I tried to add an SQL Server Database but received this message...  'Failed to generate a user instance of SQL Server due to failure in starting the Process for the User Instance' What does this mean? How do I start the 'Process for the User Instance'?  I imagined all that was done for me at the install stage, when I installed VWD2010, but it appears not.  Thank you for any help at all.    Regards

Execute Process task - On Error (i want to override the error message)

Hi, In my package I am calling one exe to copy the files from local folders to SFTP. I am using a execute process task and I am passing the parameters like (address, username, password,....). The exe and syntax are given below. SFTPCopier.exe <<machinename>> <<username>> <<password> <<local directory path>> The problem is when the exe is failing to copy the files to SFTP due to some reason, the SSIS package is outputting the entire command in the log information (including the username & password). I dont want to write the password in the log information. I want to remove that password from the log information when an error occured in the execute process task. Can some one please tell me the way to override the message? Can I put a on error handler for that execute process task and use a script task to modify the "ErrorDescription" variable? Will that works? Thanks in advance.  

AdomdDataAdapter.Fill returns memory error when querying an SSAS Cube(2008)

For certain SQL's I will get the following error when calling the Fill method on an AdomdDataAdapter object. "Memory error: While attempting to store a string, a string was found that was larger than the page size selected. The operation cannot be completed."   Snippet of Code: DataSet ds1 = new DataSet(); AdomdCommand acmd1 = cn1.CreateCommand(); acmd1.CommandText = "SELECT ..."; AdomdDataAdapter ad1 = new AdomdDataAdapter(acmd1); ad1.Fill(ds1);   Now when we run this query in Ms Sql Studio we don't get any errors but the query returns 1 row with over 40,000 columns. I'm guessing the # of columns might be an issue but not sure.   When doing a Google search it appears that this problem was found in the 2005 and fixed in that version. Have any of you come across this problem?  

SSAS 2008 - Memory Error

During our unit and load testing of the SSAS database using VSTST 2010 Ultimate; we are getting a memory error with some of our MDX queries (below).  Futher analysis showed: The adomdDataAdapter "Fill" command is our error point The error is occuring when the result data set has getter than 16,384 Columns; actual returned column count is 41,339 columns - business requirement does not let us change this query at this time. The MDX query works fine in MS Excel 2007 The MDX Query works fine in MS SQL Studio 2008 How can we resolve the unit test data set with such a large column count? Memory error: While attempting to store a string, a string was found that was larger than the page size selected. The operation cannot be completed. In reference to thread: http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/4220adbb-438c-42e7-9612-56aebf8df435/ Thank you, Craig  

processing measure group : memory error : the operation cannot be completed because the memory quota

Hi, I'm stucked with this problem. Untill last week, the cube processed without any problem. Since last week, I'm getting this error. I have been searching in different forums, and I tried some suggestions, like changing memory limit properties, ... It is getting worse.. So I reset all properties to default again. I am running SQL-Server + MS-AS 2005 SP2 on server with 4GB of memory. This is a dedicated server, nothing else is running on it. The fact table has +/- 14 million records, several dimensions en 2 measure groups. I don't have problems to process the dimensions, but when I try to process the cube or the measure groups of that cube separately , the error persists. I have changed the datasource view, and replaced the fact table by a Named query. Even when I put a 'WHERE datapart( year , fact_date ) >= 2009 ' clause to reduce the number of records to +/- 5 million, I'm still getting the error. I don't understand what is wrong, the cube always processed since +/- 2 years. As I said, I have found a lot of this kind of Issues on different websites, I have been trying to change some properties. But this still does not solve the problem. Could it be that MS-AS settings are corrupt somewhere ? Is it a good idea to re-install MS-AS 2005 + SP1 + SP2 ? Or is there another reason possible ? I really appreciate any kind of help, because I'm
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend