laptop and a wrench

Bug

Opening the mobile geodatabase feature attribute table after applying a join from the SQL query stand-alone table returns the following error message, "Underlying DBMS Error [ambiguous column name objectid]".

Last Published: March 14, 2023 ArcGIS Pro
Bug ID Number BUG-000155830
SubmittedFebruary 13, 2023
Last ModifiedMay 13, 2025
Applies toArcGIS Pro
Version found3.0.3
Operating SystemWindows OS
Operating System VersionN/A
StatusKnown Limit

Additional Information

Allowing ORDER BY clauses in subqueries is an extension beyond standard SQL. In this case, SQLite does not support referencing outer query columns within a subquery's ORDER BY clause.

Steps to Reproduce

Bug ID: BUG-000155830

Software:

  • ArcGIS Pro

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