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, 2015ArcGIS for Server
Bug ID Number
April 14, 2015
November 18, 2022
ArcGIS for Server
Operating System Version
The bug has been fixed. See the Version Fixed and Additional Information, if applicable, for more information.
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.