ArcSDE 10 Error: Out of Server Memory

[MatthewGerbrandt]

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!

[AdaMallet]

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

[GaryFloyd]

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

[LeoDonahue]

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

[karthikeyansubramanian]

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

Karthi

[cgowens]

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.