laptop and a wrench


The Dissolve tool fails on query layer with the error, "ERROR 000972: Table must have Object IDs in order to be sorted."

Last Published: September 17, 2015 ArcGIS for Desktop
Bug ID Number BUG-000090740
SubmittedSeptember 15, 2015
Last ModifiedJune 5, 2024
Applies toArcGIS for Desktop
Version found10.2.2
Operating SystemWindows OS
Operating System Version7.0 64 Bit
StatusKnown Limit

Additional Information

When an OID is required, by a GP tool or ArcMap itself (to draw these DB Views) use MakeQueryLayer to create a query layer from the DB View.

Steps to Reproduce

Bug ID: BUG-000090740


  • ArcGIS for Desktop

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