laptop and a wrench

Bug

Querying a map service with the 'Order By' parameter results in the following error, "Failed to execute query." The failure occurs when the 'Order By' parameter is used on a text field from an Oracle database with 2001 or more characters allowed.

Last Published: August 3, 2016 ArcGIS for Desktop
Bug ID Number BUG-000096483
SubmittedMay 16, 2016
Last ModifiedJune 5, 2024
Applies toArcGIS for Desktop
Version found10.2.2
Operating SystemWindows OS
Operating System Version2012
StatusKnown Limit

Additional Information

This behavior is as designed. Ordering by NCLOB (or any other LOB data types) is not supported in Oracle databases. For more information, refer to the document available from the following link, http://bit.ly/2ahHWOk. When creating a text field larger than 2000 characters as Unicode, it gets mapped to NCLOB, as stated in the document from the following link, http://arcg.is/2akZQ01.

Steps to Reproduce

Bug ID: BUG-000096483

Software:

  • ArcGIS for Desktop

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options