Error: SDE Server xyzxy exit'd with status 0

SathiaG — Fri, 28 Jun 2024 16:48:05 GMT

Hi

We are facing a problem in our SDE service while running/starting. The log file always prints "ERROR: Cannot Read SERVER_CONFIG table" whenever its been called by the appln.

The SDEHOME is properly defined with correct path. The basic DB arch is, two DBs in Production thus two SDE services. In both the DBs we have tables in schemas registered with SDE. SDE is the only Geodatabase we have in the DB.

The giomgr*.log file has the following.

Tue Nov 8 10:19:53 2011 - ALL SDE Servers Stopped.
Tue Nov 8 10:19:53 2011 - ********** SDE System Shutdown **********
Tue Nov 8 11:11:57 2011 - ****** Spatial Database I/O Manager ******
Tue Nov 8 11:11:57 2011 - SDE System Startup Initiated . . .
Tue Nov 8 11:11:57 2011 - Validated System Paths.
Tue Nov 8 11:11:57 2011 - SDE IOMGR going into background . . .
Tue Nov 8 11:11:57 2011 - System Parameter table 'SERVER_CONFIG' Read.
Tue Nov 8 11:11:58 2011 - Initialized Shared Memory Segment.
Tue Nov 8 11:11:58 2011 - Validated License.
Tue Nov 8 11:11:58 2011 - IOMGR Process ID (PID): 16273
Tue Nov 8 11:11:58 2011 - Initialized Client Tables.
Tue Nov 8 11:11:58 2011 - Server Validated.
Tue Nov 8 11:11:58 2011 - Waiting for Client Requests . . .
Tue Nov 8 11:12:15 2011 - SDE Server Pid 16299 Registered, User: TAAM Schema: sde.
Tue Nov 8 11:12:20 2011 - SDE Server Pid 16302 Registered, User: GDM Schema: sde.
Tue Nov 8 11:12:23 2011 - SDE Server 16302 exit'd with status 0
Tue Nov 8 11:12:23 2011 - SDE Server Pid 16302 Stopped, User: GDM Schema: sde.
Tue Nov 8 11:12:30 2011 - SDE Server Pid 17104 Registered, User: GDM Schema: sde.
Tue Nov 8 11:12:38 2011 - SDE Server Pid 17111 Registered, User: TAAM Schema: sde.
Tue Nov 8 11:13:33 2011 - SDE Server 17104 exit'd with status 0

The SERVER_CONFIG is as follows

PROP_NAME NUM_PROP_VALUE
CONNECTIONS 64
RASTERBUFSIZE 102400
MINBUFSIZE 16384
MAXBUFSIZE 65536
MINBUFOBJECTS 512
MAXTIMEDIFF -1
TEMP /tmp 0
MAXBLOBSIZE 1000000
BLOBMEM 1000000
AUTOCOMMIT 1000
MAXINITIALFEATS 10000
MAXDISTINCT 512
SHAPEPTSBUFSIZE 400000
ATTRBUFSIZE 50000
MAXARRAYSIZE 100
MAXARRAYBYTES 550000
STREAMPOOLSIZE 6
STATECACHING 1
TCPKEEPALIVE 0
READONLY 0
STATUS 1
DEFAULTPRECISION 64
TLMINTERVAL 1
STATEAUTOLOCKING 0
LAYERAUTOLOCKING 0
INT64TYPES 0
MAXSTANDALONELOGS 0
ALLOWSESSIONLOGFILE 0
LOGFILEPOOLSIZE 0
HOLDLOGPOOLTABLES 1
LARGEIDBLOCK 0
SMALLIDBLOCK 16
ERRLOGMODE 7
PROCSTATS -1
PRECISION10 0
DETECT8XNULLSHAPE 0
DISABLEAUTOREG 1
DISABLEDC 0
TRIMLOCKINGTYPE 3
MAXGRIDSPERFEAT 8000

Is this affecting the performance of our SDE connections?.. It even got hanged after Nov 8 11:112:23. It wasnt accepting any connections and wasnt even giving proper error messages as it should be giving.

Pls find the config details below.

ArcGIS 9.3.1 SP1
ArcSDE 9.3.1 SP1
Oracle 11g R2 64Bit Prod on HP UX 11i v3 HAQE.

Kindly let us know any solution to overcome the same.

Regards
Sathia G

Re: Error: SDE Server XXXXX exit'd with status 0

VinceAngelo — Tue, 08 Nov 2011 09:54:28 GMT

None of the information you have provided indicates that any error has occurred (status 0 is
"Success", not an error). You really ought to contact Tech Support with information about
the "cannot read" error. It's possible that they'll recommend you install 9.3.1 SP2 (released
a year ago).

- V

Re: Error: SDE Server XXXXX exit'd with status 0

SathiaG — Wed, 09 Nov 2011 01:59:27 GMT

Hi VWe have initiated the process for installing SP2. Thanks !There is another line in the log which appears now and then after a process is registered. "No shared information block established". I do not know why this appears?.

topic Re: Error: SDE Server XXXXX exit'd with status 0 in Data Management Questions

Error: SDE Server xyzxy exit'd with status 0

Re: Error: SDE Server XXXXX exit'd with status 0

Re: Error: SDE Server XXXXX exit'd with status 0