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
Submitted	April 14, 2015
Last Modified	November 18, 2022
Applies to	ArcGIS for Server
Version found	10.3
Operating System	Windows OS
Operating System Version	10.0
Version Fixed	10.9
Status	Fixed

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 help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Workaround

Steps to Reproduce

Discover more on this topic