|
Home > Archive > Commerce Server General > July 2005 > Not enough memory to allocate buffer for SQL statements. Catalog: Profile Definitions
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Not enough memory to allocate buffer for SQL statements. Catalog: Profile Definitions
|
|
|
| I get these errors several times a day. I can not find any usefull
information on these errors. I need to find out what this means, a
probable cause and possibly a resolution to it.
It is followed by several other errors.
Event ID: 32784
Not enough memory to allocate buffer for SQL statements. Catalog:
Profile Definitions
Event ID: 32785
Could not create the catalog (-2147024882)
Event ID: 32773
DataSource::Init(DS-1237-Profile Definitions) failed on catalog load
(-2147024882)
Event ID: 32769
In BindArgs::OpenDataSrc(), failed initializing data source
(-2147024882)
Event ID: 14
Thanks in advance!
AD
| |
| Vinod Kumar[MSFT] 2005-07-24, 5:50 pm |
| CAUSE
=====
The system may be configured with a large quantity of physical memory. Tools such as Task Manager and Performance Monitor may indicate that a large portion of that memory is available. For example, if the
system is configured with four gigabytes of physical memory, less than one gigabyte of this memory may be in use. However, if the virtual memory for the Internet Information Services (IIS) DLLHost process for
Medium Isolation mode approaches two gigabytes, problems start to occur. Even if the server has large memory resources that are available to the system, the virtual memory of the IIS process may become
fragmented. Various errors may be reported, indicating that memory resources have been used up.
The Commerce Server OLE DB provider typically uses the SQL OLE DB provider to perform database operations. In a large E-Commerce site, the Commerce Profile services must continually retrieve data from
the SQL database. The SQL OLE DB provider tries to allocate large contiguous blocks on demand to perform these operations. These allocations are performed in the virtual memory address space of the IIS
process. If this process is approaching the process limit for virtual memory that is established by Microsoft Windows 2000, errors result. If no blocks of contiguous virtual memory are available because of
fragmentation, the application may return error messages indicating that no memory is available.
RESOLUTION
==========
To alleviate these symptoms, the system must be configured to prevent each IIS process from using up the virtual memory that is available. By default, Windows 2000 with IIS 5.0 is configured in Medium Isolation
mode. In this configuration, the Commerce 2000 and Web site code use a shared DLLHost process. Use Performance Monitor to make sure that the virtual memory for this process does not approach two
gigabytes.
Thanks
-Vinod
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
--------------------
From: "AD" <allan.dempsey@gmail.com>
Newsgroups: microsoft.public.commerceserver.general
Subject: Not enough memory to allocate buffer for SQL statements. Catalog: Profile Definitions
Date: 14 Jul 2005 20:26:09 -0700
Organization: http://groups.google.com
Lines: 25
Message-ID: <1121397969.946483.63330@g14g2000cwa.googlegroups.com>
NNTP-Posting-Host: 66.190.67.16
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1121397975 9996 127.0.0.1 (15 Jul 2005 03:26:15 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 15 Jul 2005 03:26:15 +0000 (UTC)
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: g14g2000cwa.googlegroups.com; posting-host=66.190.67.16;
posting- account=W6BrmA0AAACqBvvnyLqovDOtBGleRVJ3
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!nntp.giganews.com!newscon06.news.prodigy.com!
newscon02.news.prodigy.com!prodigy.net!news.glorb.com!postnews.google.com!g14g2000cwa.googlegroups.com!not-for-mail
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:3022
X-Tomcat-NG: microsoft.public.commerceserver.general
I get these errors several times a day. I can not find any usefull
information on these errors. I need to find out what this means, a
probable cause and possibly a resolution to it.
It is followed by several other errors.
Event ID: 32784
Not enough memory to allocate buffer for SQL statements. Catalog:
Profile Definitions
Event ID: 32785
Could not create the catalog (-2147024882)
Event ID: 32773
DataSource::Init(DS-1237-Profile Definitions) failed on catalog load
(-2147024882)
Event ID: 32769
In BindArgs::OpenDataSrc(), failed initializing data source
(-2147024882)
Event ID: 14
Thanks in advance!
AD
|
|
|
|
|