Troubleshooting an ArcSDE service

Most problems associated with starting an ArcSDE service occur because of a problem with the system environment. Often, a critical step was missed during the installation or configuration of the software.

The troubleshooting tips in this topic reference several different administration commands. See the Administration Command Reference, which is installed with the ArcSDE application server, for details on how the commands are used.

Identifying problems

Troubleshooting the ArcSDE service on UNIX servers

System path variable issues

If the system path variables are improperly set or not set at all, you can get the errors below. Review how to set the path variables in the ArcSDE application server installation guide specific to your DBMS.

Temporary file permission problems

If any ArcSDE temporary files exist and they are not owned by the ArcSDE administrator, the following error message is returned:

ERROR: Cannot Initialize Shared Memory (-79)
Delete /tmp/<service name> and /tmp<service
name>.lock if present.
Could not start ArcSDE - Check Network,
$SDEHOME disk, DBMS settings and dbinit.sde.

To fix this, delete the temporary files /tmp/<service name> and /tmp/<service name>.lock. For example, if the service name is esri_sde, you would delete the files /tmp/esri_sde and /tmp/esri_sde.lock. You may have to log in as the root user to delete these files.

Files have been deleted from /tmp

If, after the ArcSDE service has been started, the files stored under the /tmp directory are deleted, the ArcSDE service will fail when a user either connects or disconnects. The service relies on UNIX socket protocol files created under the /tmp directory. As a rule, you should not delete the files under the /tmp directory. However, if you absolutely must, you should shut down the ArcSDE service before doing so. See Stopping a local ArcSDE service on Linux or UNIX, Stopping a local ArcSDE service on Windows, or Stopping a remote ArcSDE service for instructions on how to do this.

Problems relating to the DBMS

The SE_OUT_OF_MUTEXES (-109) error on a Solaris server

The Solaris operating system uses files to implement the POSIX shared semaphores that ArcSDE uses. If these files get left behind after an operating system failure or power outage, they can sometimes cause problems. The location of these files is controlled by the Solaris operating system. You will find them under either the /tmp or the /var/tmp directories as follows:

/tmp/.SEMD/
SDE_9.0_<instance>_iomgr_shared_semaphore
/tmp/.SEML/
SDE_9.0_<instance>_iomgr_shared_semaphore

or

/var/tmp/.SEMD/
SDE_9.0_<instance>_iomgr_shared_semaphore
/var/tmp/.SEML/
SDE_9.0_<instance>_iomgr_shared_semaphore

Following an operating system failure, if you fail to start the ArcSDE service and receive a -109 error, it is probably because the two shared semaphore files exist. If you find either of these files in either the /tmp or /var/tmp locations, delete them and try to start the ArcSDE service again.

Troubleshooting the ArcSDE service on Windows servers

Listed below are errors often encountered when starting an ArcSDE service on Windows. This list includes the error numbers, where applicable, and their likely causes.

997 Error starting esri_sde service

This error can occur with an incorrect or incomplete installation or configuration of the ArcSDE application server:

"ESRI_sde service failed during initialization. 
Please check event log or error log files. 
Error starting ESRI_sde service(997) 
Could not start ArcSDE — Check Network, $SDEHOME disk, DBMS settings"

Solution

1068 Dependency failure

The DBMS to which the ArcSDE service is trying to connect could not be found. The most likely causes of this problem are

Make sure the DBMS server exists and the service is started, and check your DBMS connection information to ensure it is correct. If the error persists, use the sdeservice command to delete the existing ArcSDE service and re-create it.

1069 Login failure

Generally, this error implies that the Windows user who started the ArcSDE service is neither a Windows administrator nor a Windows power user. An incorrect password is another possibility.

If the system administrator account is not being used to start the service, make sure the user account is a member of the administrator or power user group.

1072 Registry was busy

Something is happening in the registry regarding the ArcSDE service entry. Perhaps the sdeservice with the delete operation was run, or the service has been opened with the registry editor. Alternatively, there may have been a problem with the Object Linking and Embedding Database (OLE DB) provider.

1075 Service dependency deleted

The ArcSDE service is unable to locate the DBMS service to which it should connect. Make sure the DBMS service exists and is started. If the problem persists, use the sdeservice command to delete and re-create the ArcSDE service.

2140 Internal Windows error

The ArcSDE service wasn't able to complete the startup process. Examine the sde error logfile—%SDEHOME%\etc\sde_<sde_instance>.log—for possible clues as to why the ArcSDE service will not start.

Possible causes and solutions

gsrvr.exe - DLL Initialization Failed or gsrvr.exe - Application Error: The application failed to initialize properly

On Windows, the ArcSDE service is started as a noninteractive desktop. The maximum amount of heap memory allocated to noninteractive desktops is limited by a Windows initialization parameter called SharedSection. If you receive this error message, you may need to change the SharedSection parameter.

The CONNECTIONS parameter in the SERVER_CONFIG (sde_server_config in SQL Server and PostgreSQL) table also restricts the number of concurrent connections that can be made to the geodatabase and may need to be increased.

11/14/2016