laptop and a wrench

Bug

When querying a map service layer and calling output statistics for a field, the query fails and returns the error, "Unable to complete operation" if the ‘onStatisticField’ parameter references the Oracle ‘SHAPE.LEN’ field for a polyline service layer. The server logs display "Geodatabase error: Attribute column not found[ORA-00904: "SHAPE"."LEN": invalid identifier ]" or "General geodatabase error occurred."

Last Published: July 30, 2015 ArcGIS for Server
Bug ID Number BUG-000086888
SubmittedApril 14, 2015
Last ModifiedJune 5, 2024
Applies toArcGIS for Server
Version found10.3
Operating SystemWindows OS
Operating System Version10.0
Version Fixed10.9
StatusFixed

Workaround

1) Create a new field of Double data type, and use the Field Calculator to copy over the shape length values from 'SHAPE.LEN'. Statistics can then be called for this user-generated field rather than the geometry length field. 2) Place the data in the Sequential Query Language (SQL) Server to call on the 'Shape.STLength()' field successfully.

Steps to Reproduce

Bug ID: BUG-000086888

Software:

  • ArcGIS for Server

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options