topic Re: ArcSDE 10 Error: Out of Server Memory in Data Management Questions

ArcSDE 10 Error: Out of Server Memory

MatthewGerbrandt — Thu, 03 Nov 2011 18:44:50 GMT

Good morning. Some of my users are getting the following error intermitantly:

Error
Out of server memory [sde.sde.GDB_Items]

I'm not sure how to keep this error from recurring. If anyone could help me out, I'd sure appreciate it.

Here are the server specs:
ArcSDE 10
MS SQL Server 2005
Windows Server 2003 - 15 GB RAM

Thanks for your help!

Re: ArcSDE 10 Error: Out of Server Memory

MariaGiarrusso — Tue, 29 Nov 2011 17:26:17 GMT

Just started having similar issues. I have more than one SQL server 2008 R2 SDE database running on the same virtual server. I only get the error when trying to connect to one of the databases but not the other. Any success getting it resolved?

Re: ArcSDE 10 Error: Out of Server Memory

DennisGilbertson — Tue, 20 Dec 2011 14:57:11 GMT

Just experienced the same error today. Any luck determining the problem?

Re: ArcSDE 10 Error: Out of Server Memory

ScottLongerbeam — Mon, 27 Feb 2012 12:38:45 GMT

Any solution to this yet? I am getting the same error messages in my nightly update scripts.

Re: ArcSDE 10 Error: Out of Server Memory

JonDeRose — Mon, 05 Mar 2012 12:38:21 GMT

Is this behavior occurring with all connection types (ie. direct-connections/ application server connections [3-t], OLEDB)?

Have you been able to capture any extended error information from the SQL Server logs, Event Viewer, sde_intercept, sdedc_SqlServer.log, etc.?

Viewing the SQL Server Error Log
http://msdn.microsoft.com/en-us/library/ms187885.aspx

HowTo: Diagnose ArcSDE connection and performance issues using SDEINTERCEPT
http://support.esri.com/en/knowledgebase/techarticles/detail/35704

Re: ArcSDE 10 Error: Out of Server Memory

Anonymous User — Tue, 06 Mar 2012 18:56:27 GMT

I have been getting this same error for a while now. Its driving me and my users crazy!!

Re: ArcSDE 10 Error: Out of Server Memory

JonDeRose — Tue, 20 Mar 2012 18:48:44 GMT

If you are able to capture any error logs (mentioned in my previous post) while this issue occurs please post this information for review or contact Esri Technical Support for further assistance.

Re: ArcSDE 10 Error: Out of Server Memory

Anonymous User — Mon, 26 Mar 2012 17:20:43 GMT

[/HR]Ok, Have been trying to trouble shoot this issue for a while. The trick was replicating the problem. It seemed to only happen every once in a while with no consistency. What I found is that if I Disable and then re-enable my network card with ArcMap open and layers loaded I can get the "Out of Server Memory" error. Interestingly, I also discovered that simply unplugging your network cable and plugging it back in does not cause ArcMap to throw the error.

I have also been using SDEIntercept and found that when I do receive the "out of server memeory" error. I find the message below in the logs.

[W 09:49:23.757] Command: NextBuffer
[W 09:49:23.757] Long: 1
[R 09:49:23.757] Long: -409
========================================
[W 09:49:23.757] Command: GetstreamError
[W 09:49:23.757] Long: 1
[W 09:49:23.757] Long: -51
[W 09:49:23.757] Long: 0
[R 09:49:23.757] NString: "Microsoft SQL Server Native Client 10.0: Communication link failure"
[R 09:49:23.757] NString: ""
========================================
[W 09:49:23.757] Command: CloseStream
[W 09:49:23.757] Long: 1
[W 09:49:23.757] Long: 1
[R 09:49:23.757] Long: 0
========================================

Re: ArcSDE 10 Error: Out of Server Memory

NAOMIPAUL — Tue, 01 May 2012 12:54:07 GMT

One of our users received the same error this morning, I have never seen it before.

Out of server memory [PublicGIS.sde.GDB_Items]

Has anyone found a solution to this?

ArcSDE10
MSSQL 2008
Windows Server 2008

Re: ArcSDE 10 Error: Out of Server Memory

Anonymous User — Tue, 01 May 2012 14:20:57 GMT

I called esri support to discuss this issue. They had no concrete fix but did recomend the following:

1. Please close all ArcGIS ArcObjects applications (ArcCatalog, ArcMap) when not in use and at the end of each day.

2. Verify within the SQL Server database table, sde.sde_process_information table that client connections are closed, or to review the time stamp listed for open connections.

3. It is highly recommended, though not required, to verify that all client connections are disconnected prior to executing an ArcSDE database compress. Any connection to the database will generate locks on the data and will thus prevent a full compress from being achieved.

4. Check the Firewall refresh / recycle rate, it may be possible that it could be conflicting with the ArcGIS Server map services refresh / recycle rate

5. It may be possible that the many scheduled tasks being completed each night are competing for server memory resources, please review and evaluate the concurrency of these tasks and consider alter the start times of these tasks so that they are more evenly spread out when using these server resources.

If additional errors continue to persist, please attempt to capture a Client Intercept trace, in hope that we can gather additional error logging.

Re: ArcSDE 10 Error: Out of Server Memory

AdaMallet — Wed, 06 Jun 2012 06:45:48 GMT

We had the same problem with ArcSDE 10 on SQL Server 2008 (Windows 2008) using Windows Authentication.
The problem only occured to a single user when user logs on to any machines.
The issue is with Windows Authentication and Kerberos Environment. When the user logs and connects to ArcSDE using direct connect (this is connecting directly to SQL Server), a token containing the user details (such as the domain groups that the user belongs) is sent to the server.
The token size is set to a maximum size on the server and so user who belongs to a number of domain groups can cause the token size to reach the max size.

So, the fix is to change the maxtokensize registry settings on the server and then restart ther server.

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Lsa\Kerberos\Parameters

See link below:
http://support.microsoft.com/kb/327825
http://www.mssqltips.com/sqlservertip/1557/configure-maxtokensize-for-sql-server-authentication/

Good luck.
Ada Mallet
Woodside Energy Ltd,
Perth, Australia

Re: ArcSDE 10 Error: Out of Server Memory

GaryFloyd — Tue, 16 Oct 2012 18:31:50 GMT

I had this problem for quite some time and I just lived with it, would restart ArcMap and cross-my-fingers.
I was pretty sure it was not SQL*Server resources or OS related. We went to new hardware which sped things up, but then the problem returned intermittently. It only occured on a couple of tables I was using for large queries and edits, etc.
I had a flakey issue with the geodatabase domains on one of the tables and was told by ESRI to copy and paste the table to a .gdb, then rename/delete the original, and copy-and-paste it back into the geodatabase/data set.
That fixed the domains AND over time I realized that I was not receiving the out-of-server-memory message any more.
I started receiving the out-of-server-memory message again a few weeks later on another "complicated" feature class when editing, so I copied it out and copied it back in. I haven't received the out-of-server-memory in over 2-weeks, when I would get it every day at least once.
-G.Floyd
Oak Lodge Sanitary District

Re: ArcSDE 10 Error: Out of Server Memory

LeoDonahue — Fri, 08 Mar 2013 18:30:09 GMT

This happened to us today. We got the error trying to open a connection to our SDE from ArcCatalog.

Last night, our server admins shut down all servers to rack a new one, and move the others around and re-cable everyting. When the servers came back up, I noticed that the SQL Server process that was set to Automatic startup had started, but that the SQL Agent (also set to automatic startup) had not started. Our ArcSDE (esri_sde) processes that were also set to start automatically were also not started.

Starting the SQL Server Agent and the esri_sde processes fixed it, for us.

ArcSDE 10.0 SP5 (64 bit)
Windows Server 2008 R2
SQL Server 2008 R2

Re: ArcSDE 10 Error: Out of Server Memory

karthikeyansubramanian — Tue, 17 Dec 2013 14:05:32 GMT

I was able to resolve this issue by simply closing ARCMAP and reopen the connection .

Karthi

Re: ArcSDE 10 Error: Out of Server Memory

cgowens — Tue, 28 Jan 2014 21:03:23 GMT

I have experienced this many times through the years even though I have done all those things for tuning, like increasing HEAP, etc. Today it happened when I tried to delete a feature class via arccatalog. All the symptoms above were observed. Restarting services in sql server did nothing, but closing arccatalog and reopening again cured the illness.