ArcSDE Errors

[SDE error -XXX][Error desc=ESRI_ARCSDE_MESSAGE]

e.g.

[SDE error -110][Error desc=THIS CONNECTION IS LOCKED TO A DIFFERENT THREAD.] 

Solution:

When ever there is a message from ArcSDE to indicate that a problem has occured on the ArcSDE server the follow type of error will be seen in the log file. ArcSdeException: [SDE error ARCSDE_ERROR_NUMBER][Error desc=ARCSDE_ERROR_MESSAGE] Where the error number defined in SDE (see http://edndoc.esri.com/arcsde/9.1/capi_functions/returncodes_incl.htm for more details)

For more detailed information regarding error codes and messages from ArcSDE please refer to the following webpage which generally goes into more detail than the ArcSDE return codes go into. You may need to search around the site for the specific error and note that you may not find the specific error code as not all have been documented. Cohga has not relationship with the author of the page.

http://bingluo.blogspot.com/2007/12/arcsde-error-codes-reason-and-solution.html

The one to look out for is the dreaded

[SDE error -51][Error desc=DATABASE LEVEL ERROR OCCURRED.] Underlying DBMS error. 

The above message indicates that something has gone very wrong on the database that ArcSDE communicates with. It is best that you contact you ArcSDE administrator and investigate the ArcSDE log files to determine why the error occurred. You may have to enable more fine grained logging in ArcSDE to ascertain the exact problem.