laptop and a wrench

Bogue

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.

Dernière publication: August 9, 2018 ArcGIS for Desktop
Numéro d’ID de bogue BUG-000114213
EnvoiMay 24, 2018
Dernière modificationJune 5, 2024
S’applique àArcGIS for Desktop
Version trouvée10.6
StatutWill Not Be Addressed

Informations supplémentaires

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.

Solution de contournement

- 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.

Étapes pour reproduire

ID de bogue: BUG-000114213

Logiciel:

  • ArcGIS for Desktop

Recevoir une notification lorsque le statut d’un bogue change

Télécharger l’application Esri Support

En savoir plus sur ce sujet

Obtenir de l’aide auprès des experts ArcGIS

Contacter le support technique

Télécharger l’application Esri Support

Accéder aux options de téléchargement