*UPDATE*:
Confirmed BUG by ESRI: BUG-000164073
Description:
Add Spatial Join tool fails on subsequent runs when attempted on same target layer.
Steps to Reproduce:
- Run Add Spatial Join successfully on a target layer.
- Remove all joins from the target layer.
- Attempt to run Add Spatial Join again on the same target layer.
Observed Behavior:
Receive error "ERROR 000210: Cannot create output C:\Users\...\scratch.gdb\target_layer_AddSpatialJoin".
Expected Behavior:
- The Add Spatial Join tool should run successfully again on the same target layer.
- Or at least display a warning if the issue is related to the formatting of the layer name.
Notes:
- Issue persists after restarting ArcGIS Pro or re-adding layers.
- Seems related to special characters in layer names (e.g. periods in naming format: "Layer.Name").
- Can work around by removing special characters from target layer name before re-running tool.
- This is mainly an issue when creating automation tools, as the user would usually not have the option to alter the target layer name.
Environment:
- ArcGIS Pro 3.1.3
- Windows 10 Enterprise 21H2