Windows Server

AD · Guest

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] · Guest

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

Allan · Guest

Thank you Very much!!!
Couple of follow up questions:
Is 2G hard set as the limit to the amout of virtual memory IIS can use?
Is there anyway to change this? Same question for Commerce?
I will continue to try and monitor this with Perfmon and let you know my
findings.

"Vinod Kumar[MSFT]" wrote:

David Messner [MSFT] · Guest

Allan

Can you make sure that you're not creating ProfileContext (.NET) or
ProfileService (COM) objects anywhere in your application other than at
startup?

Typically this problem would be solved by creating one ProfileContext
object for the site (which is done automatically for you with the
CommerceProfileModule if you are using it) and re-using that ProfileContext
object throughout the site. If you are creating them on a per-request
basis, bad things like this will happen - ProfileContext/ProfileService is
an exceptionally expensive object to create because it reads in the entire
profile definition catalog and creates large caches and connection pools.

-djm
--
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2005 Microsoft Corporation. All rights
reserved.

Subject: RE: Not enough memory to allocate buffer for SQL statements. Catal
Date: Wed, 27 Jul 2005 11:11:02 -0700

Thank you Very much!!!
Couple of follow up questions:
Is 2G hard set as the limit to the amout of virtual memory IIS can use?
Is there anyway to change this? Same question for Commerce?
I will continue to try and monitor this with Perfmon and let you know my
findings.

"Vinod Kumar[MSFT]" wrote:

Mike · Guest

Hi David,

I am working with Allan on this Commerce Server and I am seeing Event ID 14
messages in the Application Event Log.

[snip]

This is the exact event ID message.

Event Type: Error
Event Source: Commerce Server 2002
Event Category: None
Event ID: 14
Date: 8/10/2005
Time: 10:57:12 AM
User: N/A
Computer: Server1
Description:
The description for Event ID ( 14 ) in Source ( Commerce Server 2002 )
cannot be found. The local computer may not have the necessary registry
information or message DLL files to display messages from a remote computer.
You may be able to use the /AUXSOURCE= flag to retrieve this description; see
Help and Support for details. The following information is part of the event:
..

[snip]

This from the Event Log on the commerce server itself, so I would think that
it would have the necessary .dlls to display the messages. It is CS 2000 SP3
on Windows 2003. Can you suggest which .dll should be registered to display
the contents of the event?

Thank you

--
Mike

"David Messner [MSFT]" wrote:

David Messner [MSFT] · Guest

I hate to be the bearer of bad news, but event ID 14 doesn't seem to exist
anywhere in the CS2002 code base. I've searched low and I've searched
high. It's not in any of our message resources. That doesn't mean that it
wasn't an aberrent piece of code somewhere in the system that logged that
event number but it's beyond my earthly abilities to locate it. It's
possible, however improbable, that some other piece of code that is not
part of Commerce Server logged that event, e.g. using the
Commerce.AdminEventLog object. It may or may not be significant to your
problem.

Sorry I can't be more helpful. If you have any other info...?
-djm

--------------------
From: "=?Utf-8?B?TWlrZQ==?=" <Mike@discussions.microsoft.com>
Subject: RE: Not enough memory to allocate buffer for SQL statements. Catal
Date: Wed, 10 Aug 2005 20:52:04 -0700

Hi David,

I am working with Allan on this Commerce Server and I am seeing Event ID 14
messages in the Application Event Log.

[snip]

This is the exact event ID message.

Event Type: Error
Event Source: Commerce Server 2002
Event Category: None
Event ID: 14
Date: 8/10/2005
Time: 10:57:12 AM
User: N/A
Computer: Server1
Description:
The description for Event ID ( 14 ) in Source ( Commerce Server 2002 )
cannot be found. The local computer may not have the necessary registry
information or message DLL files to display messages from a remote
computer.
You may be able to use the /AUXSOURCE= flag to retrieve this description;
see
Help and Support for details. The following information is part of the

Mike · Guest

Hi David,

Well, I appreciate your efforts greatly on this, I have been searching
diligently as well but nothing else so far. The only other events I see in
the Event Logs pertaining to Commerce Server as the ones that Allan posted
previously regarding memory and such. The Event ID 14 messages come up fairly
regularly, in groups of 3-5 or so, spaced about 1-5 minutes apart. They do
not come up every day, and the pattern is not exact where they are exactly 1
minute apart for that grouping. It could be at 11:40, then the next one at
11:42, then at 11:43, then at 11:47, then at 11:49. The next grouping might
be the next day, or maybe two days, or a week apart. Very strange.

Thanks again,

Mike

"David Messner [MSFT]" wrote:

> I hate to be the bearer of bad news, but event ID 14 doesn't seem to exist...

Not enough memory to allocate buffer for SQL statements. Cat

	Windows Server Forum Index -> Commerce Server	All times are GMT
Page 1 of 1