Error running Add Spatial Join tool more than once on same target layer

JoshMakesMaps — Tue, 09 Jan 2024 19:35:27 GMT

*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:

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:

Re: Error running Add Spatial Join tool more than once on same target layer

DanPatterson — Wed, 27 Dec 2023 20:39:40 GMT

Can't reproduce using Pro 3.2 and the add spatial join and remove joins from ArcToolbox

JoshMakesMaps — Wed, 27 Dec 2023 21:35:47 GMT

Good to know, thanks Dan