[ERR2106] DBF Related Error

Message:	[ERR2106] User specified SQL clause is invalid. WHERE string is: {'where' clause}
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:	YES
Used during request:	YES

Notes:

'Where' clause is incorrect in SPATIALQUERY. Check the 'where' clause for valid syntax and field names.
In a GET_IMAGE request, a map is generated, but no features for the layer with an invalid SPATIALQUERY are shown.

Examples for ERR2106:

Example 1: GET_FEATURES request.

[Jan 15, 2004 12:45:56 PM][3032 2120 INFO1] Begin Request
[Jan 15, 2004 12:45:56 PM][3032 2120 INFO3] REQUEST: <GET_FEATURES featurelimit="25" beginrecord="0" outputmode="xml" geometry="false" envelope="true" compact="true">
<LAYER id="4">
</LAYER>
<SPATIALQUERY subfields="#ALL#" where="NAME1  =  'Los Angeles'" >
</SPATIALQUERY>
</GET_FEATURES>

[Jan 15, 2004 12:45:56 PM][3032 2120 INFO1] GET_FEATURES: world
[Jan 15, 2004 12:45:56 PM][3032 2120 INFO2] <GET_FEATURES> QS start processing...
[Jan 15, 2004 12:45:56 PM][3032 2120 ERROR] [ERR2106] User specified SQL clause is invalid. WHERE string is: NAME1  =  'Los Angeles'
[Jan 15, 2004 12:45:56 PM][3032 2120 ERROR] [ERR2106] User specified SQL clause is invalid. WHERE string is: NAME1  =  'Los Angeles'
[Jan 15, 2004 12:45:56 PM][3032 2120 ERROR] RESPONSE: <ERROR machine="MYMACHINE" processid="3032" threadid="2120">[ERR2106] User specified SQL clause is invalid. WHERE string is: NAME1  =  'Los Angeles'</ERROR>
[Jan 15, 2004 12:45:56 PM][3032 2120 INFO1] Total Request Time: 0.110000s
[Jan 15, 2004 12:45:56 PM][3032 2120 INFO1] End Request

Example 2: GET_IMAGE request.

[Jan 15, 2004 12:43:55 PM][4044 3904 INFO1] Begin Request
[Jan 15, 2004 12:43:55 PM][4044 3904 INFO3] REQUEST: <GET_IMAGE>
<PROPERTIES>
<ENVELOPE minx="-141.872382298026" miny="-85" maxx="175" maxy="80.8298430640359" />
<IMAGESIZE width="600" height="400"/>
<LAYERLIST order="FALSE" >
<LAYERDEF id="4" visible="true">
<SPATIALQUERY subfields="" where="POPULATION1  >  5000000" >
</SPATIALQUERY>
<SIMPLERENDERER>
<SIMPLEMARKERSYMBOL type="" color="0,0,0" width="16" />
</SIMPLERENDERER>
</LAYERDEF>
<LAYERDEF type="point" id="Cities" visible="true"/>
</LAYERLIST>
</PROPERTIES>
</GET_IMAGE>

[Jan 15, 2004 12:43:55 PM][4044 3904 INFO1] GET_IMAGE: world
[Jan 15, 2004 12:43:55 PM][4044 3904 INFO2] AXL Parse Time: 0.015000s
[Jan 15, 2004 12:43:55 PM][4044 3904 INFO2] RENDERER SETUP: 0.000000s
[Jan 15, 2004 12:43:55 PM][4044 3904 INFO2] FEATURE LAYER: Countries
[Jan 15, 2004 12:43:55 PM][4044 3904 INFO2] DATA SEARCH TIME: 0.000000s
[Jan 15, 2004 12:43:55 PM][4044 3904 INFO2] SR FEATURES PROCESSED: 165
[Jan 15, 2004 12:43:55 PM][4044 3904 INFO2] DATA RETRIEVAL TIME: 0.094000s
[Jan 15, 2004 12:43:55 PM][4044 3904 INFO2] FEATURE LAYER: Cities
[Jan 15, 2004 12:43:55 PM][4044 3904 ERROR] [ERR2106] User specified SQL clause is invalid. WHERE string is: POPULATION1  >  5000000
[Jan 15, 2004 12:43:55 PM][4044 3904 ERROR] [ERR2106] User specified SQL clause is invalid. WHERE string is: POPULATION1  >  5000000
[Jan 15, 2004 12:43:55 PM][4044 3904 INFO2] DATA SEARCH TIME: 0.078000s
[Jan 15, 2004 12:43:55 PM][4044 3904 INFO2] DATA RETRIEVAL TIME: 0.000000s
[Jan 15, 2004 12:43:55 PM][4044 3904 INFO2] LABEL ENGINE TIME: 0.000000s
[Jan 15, 2004 12:43:55 PM][4044 3904 INFO2] TOTAL PROCESSING TIME: 0.391000s
[Jan 15, 2004 12:43:55 PM][4044 3904 INFO2] OUTPUT TIME: 0.062000s
[Jan 15, 2004 12:43:56 PM][4044 3904 INFO3] RESPONSE: <?xml version="1.0" encoding="UTF-8"?>
<ARCXML version="1.1">
<RESPONSE>
<IMAGE>
<ENVELOPE minx="-141.872382298026" miny="-107.709205900657" maxx="175" maxy="103.539048964693" />
<OUTPUT url="http://mymachine/output/world_MYMACHINE404439049.png" />
</IMAGE>
</RESPONSE>
</ARCXML>

[Jan 15, 2004 12:43:56 PM][4044 3904 INFO1] Total Request Time: 0.531000s
[Jan 15, 2004 12:43:56 PM][4044 3904 INFO1] End Request