laptop and a wrench

Bug

Running more than one Add Join tool with a query layer in ModelBuilder fails with the error, "Error 000728: Field does not exist within table" or "ERROR 160090: A persisted domain record with the specified name does not exist".

ArcGIS Pro
Bug ID Number BUG-000159343
SubmittedJune 23, 2023
Last ModifiedJune 2, 2025
Applies toArcGIS Pro
Version found3.1.2
Operating SystemWindows OS
Operating System Version10.0 64 Bit
StatusKnown Limit

Additional Information

The Add Join tool requires a unique table name and a unique field name to work properly. Upon joining the second time, this violates this uniqueness. A possible solution is to use %memory% data instead of the query layer, then use the Join Field tool.

Workaround

Use %memory% data instead of the query layer, then use the Join Field tool.

Steps to Reproduce

Bug ID: BUG-000159343

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