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
