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, 2015ArcGIS for Desktop
Bug ID Number
September 15, 2015
March 14, 2023
ArcGIS for Desktop
Operating System Version
7.0 64 Bit
After review by the development team, it has been determined that this issue is related to a known limitation with the software that lies outside of Esri's control. The issue's Additional Information section may contain further explanation.
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.