laptop and a wrench

Bug

Running the Add Join tool in batch mode fails with error 999999 when joining multiple tables or features layers to a single table or feature layer.

Last Published: August 9, 2018 ArcGIS for Desktop
Bug ID Number BUG-000114213
SubmittedMay 24, 2018
Last ModifiedJune 5, 2024
Applies toArcGIS for Desktop
Version found10.6
StatusWill Not Be Addressed

Additional Information

We apologize that we were unable to address this issue within the current product support cycle. If the issue continues to affect your work in a supported release, please contact Technical Support. Note that ArcGIS 10.8.2 is the current release of ArcGIS Desktop and will enter Mature Support in March 2024 (https://support.esri.com/en-us/products/arcmap/life-cycle). There are no plans to release an ArcGIS Desktop 10.9, and we recommend that you migrate to ArcGIS Pro. See Migrate from ArcMap to ArcGIS Pro (https://www.esri.com/en-us/arcgis/products/arcgis-pro/resources/migrate) for more information.

Workaround

- Run the Join Field tool in batch mode using the same parameters mentioned above.- Run a Python script (BatchAddjoin_1.py , attached to the bug) in the ArcPy window in ArcMap to join multiple tables in a workspace to a feature layer in the map using the arcpy.AddJoin_management.Steps:1. Add the shapefile or feature class to the map.2. Copy all of the tables to a single workspace, either a folder or a file geodatabase.3. Edit the script in Python IDLE.4. Within the script, edit the 'arcpy.env.workspace' parameter to point to the workspace of the tables.5. Edit the 'in_layer' parameter to name of the layer added in the map.6. Edit the in_field: Input join field.7. Edit the join_field: Output join field.8. Open the ArcPy window in ArcMap and copy the script into the ArcPy window.9. Run the script within the ArcPy window. The tables are joined to the feature layer in the map.

Steps to Reproduce

Bug ID: BUG-000114213

Software:

  • 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