laptop and a wrench

Bug

Using the Spatial Join tool with large data returns null values or the "ERROR 999999" error message in ArcGIS Pro 3.0.3.

Last Published: March 4, 2023 ArcGIS Pro
Bug ID Number BUG-000155091
SubmittedJanuary 13, 2023
Last ModifiedNovember 5, 2024
Applies toArcGIS Pro
Version found3.0.3
Operating SystemWindows OS
Operating System Version11.0 64 bit
StatusKnown Limit

Additional Information

Use of large service layers as input to ArcGIS Pro geoprocessing tools can produce unhandled errors, as there can be service timeouts, network hiccups, and server overload, all causing data to stop being accessible to the geoprocessing tool running in ArcGIS Pro. In ArcGIS Pro 3.4, these unhandled errors are caught, and information from the failed or timed-out request from the server is returned. Computationally and data load-intensive operations that need to load all data locally for processing may never complete successfully when using a large service layer as input. Use a smaller subset of the service; for example, applying the Processing Extent environments produces smaller requests to the service, and the process will successfully complete consistently and in a reasonable run time. More discussion and workarounds are examined in the help documentation: https://pro.arcgis.com/en/pro-app/latest/tool-reference/appendices/geoprocessing-considerations-for-portal-and-service-data.htm

Workaround

  1. Separate the data into smaller parts and run the Spatial Join tool.
  2. Merge the output layers.

Steps to Reproduce

Bug ID: BUG-000155091

Software:

  • ArcGIS Pro

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