[ERR2402] ArcSDE Related Error

Message:	[ERR2402] Field {field name} not found.
Message type:	Log error message. A message is written in the Spatial Server log file only. No message is sent to the Application Server and the client.
Used during service administration:	NO
Used during request:	YES

Notes:

• Connections to ArcSDE and Oracle Server was stopped using "shutdown abort". At this point, ArcSDE looks alive but user will see a blank map.
• Stopped Oracle but not ArcSDE. Then, brought Oracle back up. When you check for a list of users, according to ArcSDE, there are no users logged in. At the same time, ArcSDE says there are four server processes running. These processes are now orphans. Thus, if you type only "status", you'll be misinformed.
  
  sde on entropy > sdemon -o info -I users
  
  ArcSDE Instance esri_sde Registered Server Tasks on entropy at Tue Sep 23 11:12:50 2003
  -------------------------------------------------------------------------
  There are no ArcSDE users logged in.
  
  However, from an ArcIMS point of view, ArcSDE still appears to be running. ArcIMS keeps the connections, even though they are no longer valid. Note the four server processes when a status is asked for.
  
  sde on entropy > sdemon -o status
  
  ArcSDE Instance esri_sde Status on entropy at Tue Sep 23 11:13:08 2003
  -------------------------------------------------------------------------
  Server Connection Mode: Accepting Connections
  Active Server Processes: 4
  
  End result is a blank map is sent to the client.

Examples for ERR2402:

[Jan 15, 2004 11:30:13 AM][476 1332 INFO1] Begin Request [Jan 15, 2004 11:30:13 AM][476 1332 INFO3] REQUEST: <GET_IMAGE> <PROPERTIES> <ENVELOPE minx="-180" miny="-90" maxx="180" maxy="90" /> <IMAGESIZE width="800" height="600"/> </PROPERTIES> </GET_IMAGE> [Jan 15, 2004 11:30:13 AM][476 1332 INFO1] GET_IMAGE: aaaa [Jan 15, 2004 11:30:13 AM][476 1332 INFO2] AXL Parse Time: 0.032000s [Jan 15, 2004 11:30:15 AM][476 1332 INFO2] RENDERER SETUP: 1.625000s [Jan 15, 2004 11:30:15 AM][476 1332 INFO2] FEATURE LAYER: WORLD [Jan 15, 2004 11:30:15 AM][476 1332 ERROR] (SDE) SE_table_describe : Underlying DBMS error [Jan 15, 2004 11:30:15 AM][476 1332 ERROR] [ERR2402] Field #SHAPE# not found. [Jan 15, 2004 11:30:15 AM][476 1332 INFO2] DATA SEARCH TIME: 0.109000s [Jan 15, 2004 11:30:15 AM][476 1332 INFO2] SR FEATURES PROCESSED: 0 [Jan 15, 2004 11:30:15 AM][476 1332 INFO2] DATA RETRIEVAL TIME: 0.031000s [Jan 15, 2004 11:30:15 AM][476 1332 INFO2] FEATURE LAYER: US_STATES [Jan 15, 2004 11:30:15 AM][476 1332 ERROR] (SDE) SE_table_describe : Underlying DBMS error [Jan 15, 2004 11:30:15 AM][476 1332 ERROR] [ERR2402] Field #SHAPE# not found. [Jan 15, 2004 11:30:15 AM][476 1332 INFO2] DATA SEARCH TIME: 0.000000s [Jan 15, 2004 11:30:15 AM][476 1332 INFO2] SR FEATURES PROCESSED: 0 [Jan 15, 2004 11:30:15 AM][476 1332 INFO2] DATA RETRIEVAL TIME: 0.000000s [Jan 15, 2004 11:30:15 AM][476 1332 INFO2] FEATURE LAYER: WORLD_CITIES [Jan 15, 2004 11:30:15 AM][476 1332 ERROR] (SDE) SE_table_describe : Underlying DBMS error [Jan 15, 2004 11:30:15 AM][476 1332 ERROR] [ERR2402] Field #SHAPE# not found. [Jan 15, 2004 11:30:15 AM][476 1332 INFO2] DATA SEARCH TIME: 0.000000s [Jan 15, 2004 11:30:15 AM][476 1332 INFO2] SR FEATURES PROCESSED: 0 [Jan 15, 2004 11:30:15 AM][476 1332 INFO2] DATA RETRIEVAL TIME: 0.000000s [Jan 15, 2004 11:30:15 AM][476 1332 INFO2] LABEL ENGINE TIME: 0.000000s [Jan 15, 2004 11:30:15 AM][476 1332 INFO2] TOTAL PROCESSING TIME: 0.172000s [Jan 15, 2004 11:30:15 AM][476 1332 INFO2] OUTPUT TIME: 0.140000s [Jan 15, 2004 11:30:15 AM][476 1332 INFO3] RESPONSE: <?xml version="1.0" encoding="UTF-8"?> <ARCXML version="1.1"> <RESPONSE> <IMAGE> <ENVELOPE minx="-180" miny="-135" maxx="180" maxy="135" /> <OUTPUT url="http://mymachine/output/aaaa_MYMACHINE4761332159.jpg" /> </IMAGE> </RESPONSE> </ARCXML> [Jan 15, 2004 11:30:15 AM][476 1332 INFO1] Total Request Time: 2.110000s [Jan 15, 2004 11:30:15 AM][476 1332 INFO1] End Request