laptop and a wrench

Bug

The Remove Join tool fails after a Flag field is added to a view definition, the view is joined to a feature layer, and fields in the joined table are reordered and sorted.

ArcGIS Pro
Bug ID Number BUG-000157875
SubmittedApril 27, 2023
Last ModifiedJune 2, 2025
Applies toArcGIS Pro
Version found3.1.1
Operating SystemWindows OS
Operating System VersionN/A
StatusNon-Reproducible

Additional Information

This is not reproducible in ArcGIS Pro 3.2. Please contact Esri Support if this still occurs. Steps that are tested: 1. Copy the mobleGDB locally and add the lines layer to a map. 2. In the Catalog pane, right-click the mobleGDB > New > Click View. 3. In the Geoprocessing pane, name the view 'myView' and use the following query: Select OBJECTID, case when type='NT' then 1 end as a flag from Lines. 4. Join both layers using the ObjectID field. 5. Examine the join layer and reorder the fields. 6. Remove the join, and note that the join name is correct. Select the join name and run. Note: Everything is working. If the steps are incorrect, please resend.

Workaround

From the Joins menu, choose to remove all joins, or select the Main.viewname join in the Remove Join tool.

Steps to Reproduce

Bug ID: BUG-000157875

Software:

  • ArcGIS Pro

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