topic $SDEHOME/temp is full in Data Management Questions

$SDEHOME/temp is full

ArinStark — Tue, 11 Sep 2012 19:25:51 GMT

I have many enterprise SDE connections that recently stopped working. When I try to connect, I get a message reading "Failed to connect to database. Temporary file I/O error -- possibly $SDEHOME/temp is full." This is on my local desktop, not the SDE servers. I am still able to connect to some SDEs.

Details: Am using ArcInfo 9.3.1. The connections are all direct, but otherwise no consistent similarities. Some are Oracle, some SQL Server; some are Windows-authenticated, others contain names/passwords. The very few connections that still work are also varied. And I seem to be the only user in the group having this problem.

Any ideas would be appreciated.

Re: $SDEHOME/temp is full

VinceAngelo — Wed, 12 Sep 2012 01:25:10 GMT

The SDEHOME for a Direct Connect connection is on the client (usually the ArcGIS install directory).
Check for permission issues on any "temp" directories in your install.

- V

Re: $SDEHOME/temp is full

ArinStark — Wed, 12 Sep 2012 16:02:01 GMT

Thanks for the suggestion. I expanded permissions on any "Temp" directory I could find. There is no "SDEHOME" environment variable set on my local machine. Still having the problem.

Re: $SDEHOME/temp is full

VinceAngelo — Wed, 12 Sep 2012 16:31:58 GMT

I've never heard of this problem before, so it's probably pretty rare. You'll probably
need to work with Tech Support, but first try a re-install of ArcGIS Desktop.

- V

Re: $SDEHOME/temp is full

ArinStark — Wed, 12 Sep 2012 19:04:36 GMT

Unfortunately, a complete re-install from scratch didn't fix the problem either. But I do appreciate your time and suggestions.

Re: $SDEHOME/temp is full

EricSonger — Thu, 28 Mar 2013 13:47:02 GMT

I had this same problem. I had changed my $TEMP system variable to C:\temp from the default location. When I changed it back to the stupid Microsoft location my SDE connection worked fine.

Talk about chasing your tail for no benefit.

At least I didn't re-install...

-Eric

Re: $SDEHOME/temp is full

ClaudioSantos — Thu, 28 Jan 2016 18:41:53 GMT

I got this error, add full control for all user on $SDEHOME and I got the same error.

Then I check if the user that run the service that start the program using arcobjects code, then I see that the user who has the permission to run this service was deleted.

Then I change for an user that exist and had permission and works fine.

Soooo... as usually the message error could betray you.

Re: $SDEHOME/temp is full

BrendanBladdickEsri — Fri, 30 Jun 2017 12:43:40 GMT

When trying to connect to a database in ArcCatalog or ArcMap, a user gets this error: "Failed to connect to database. Temporary file I/O error -- possibly $SDEHOME/temp is full"

This is due to the temp folder being full

Solution:

Set the Windows Environmental Variables to "c:\temp" then logged out and logged back in and the connection was successful (see screenshot)