NIM013923 for No Product Found

Bug ID Number	NIM013923
Submitted	December 19, 2007
Last Modified	April 2, 2025
Applies to	No Product Found
Version found	9.2
Version Fixed	N/A
Status	Fixed

Description

Any query based on the OBJECTID field for ArcSDE layers served in an ArcIMS Image or Feature service fails to return any results.

Similarly, when using ArcMap as a client, this failure is exhibited as an empty attribute table for the ArcIMS Image or Feature service layer.

Cause

Some clients, including ArcMap, use the fully qualified OBJECTID field name rather than #ID# when generating a SPATIALQUERY.

If the map configuration file contains a SPATIALQUERY with the #ID# subfield to represent the OBJECTID field, any query using a fully qualified OBJECTID field name fails since the Spatial Server is expecting the name #ID# for the OBJECTID field.

Workaround

For all fields of the ArcSDE layer and any joined tables, always specify the fully qualified name in subfields of SPATIALQUERY in the map configuration file.

Example: ARCSDENAME.TABLE.NAME

Note:
The map configuration file cannot be read locally in ArcIMS Author or ArcExplorer-Java Edition when using fully qualified names.

Steps to Reproduce

Bug ID: NIM013923

Software:

No Product Found

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Queries against ArcSDE layers, using SPATIALQUERY element with subfields, fail unless a fully-qualified OBJECTID is specified in the subfields list.

Description

Cause

Workaround

Steps to Reproduce

Get notified when the status of a bug changes

Discover more on this topic