I want do a spatial join with an if condition, so I'm attempting to use the Geoanalytics Desktop Tool version of a Spatial Join. I've got the input files stored locally and set the output path to be the same geodatabase. The geodatabase stored locally with a short filepath and no special characters in the path such as spaces.
Additionally ArcPro is not installed C:\Program Files (x86) (as I've seen this can be an issue) and have admin rights on the machine I'm using.
However each time I try to run the process I get the same error 'Failed to write to the output location'. Not sure if there's something specific with these tools I'm missing but any ideas would be very useful.
Edit note: changing the code snipped just to illustrate the fail that occured even with underscores etc removed
Join Features
=====================
Parameters
Target Layer C:\BusinessSchoolBiodiversityFinance\working.gdb\SDC
Join Layer C:\BusinessSchoolBiodiversityFinance\working.gdb\PADDDpoly
Output Dataset C:\BusinessSchoolBiodiversityFinance\working.gdb\SDCpadd
Join Operation JOIN_ONE_TO_MANY
Spatial Relationship NEAR_GEODESIC
Spatial Near Distance 999999 Kilometers
Temporal Relationship
Temporal Near Distance
Attribute Relationship
Summary Fields
Join Condition $join["YearPADDD"]<=$target["AnnouncementYear"]
Keep All Target Features
Include Distance true
Distance Unit METERS
=====================
Messages
Start Time: Thursday, June 20, 2024 4:45:10 PM
Started Spark Job 1 with 16 tasks.
Spark Job 1 completed in 6.3 seconds.
Started Spark Job 2 with 16 tasks.
Spark Job 2 completed in 0.3 seconds.
ERROR 001409: Failed to write to the output location.
Failed script Join Features...
Failed to execute (JoinFeatures).
Failed at Thursday, June 20, 2024 4:45:21 PM (Elapsed Time: 10.79 seconds)
