laptop and a wrench

Bug

The Union (Analysis) tool returns 'Error 999999' for some data when writing an output to an enterprise geodatabase.

Last Published: November 20, 2019 ArcGIS for Desktop
Bug ID Number BUG-000126742
SubmittedNovember 13, 2019
Last ModifiedJune 5, 2024
Applies toArcGIS for Desktop
Version found10.6.1
Operating SystemWindows OS
Operating System Version10.0 64 Bit
StatusWill Not Be Addressed

Additional Information

The issue occurs because the SpatialReference XYResolution is not set to default and probably due to the difference between the modified XYRes and the set XYTolerance. For more information on fixing the data, refer to ArcGIS Blog: Geoprocessing, Resolution, Tolerance, and Hair (https://www.esri.com/arcgis-blog/products/arcgis-pro/analytics/geoprocessing-resolution-tolerance-and-hair/). The issue in this case is overlapping polygons in the ConveyanceDivision feature class. There are multiple polygons with barely overlapping boundaries (close to XYTol width), so during the union process, 'nearly' slivers are generated. Slivers do not fall within the parameters for a feature in a file geodatabase (FGDB) to collapse and remove. When inserted into an enterprise geodatabase (EGDB), a shape validation process that is different than for FGDB takes place on the server side and the features are rejected (due to the validation assuming they are collapsing) and cause failure. Kindly asked the analyst for a copy of the repaired data and a copy of the EGDB output successfully generated.

Workaround

Determine features rejected using CopyFeatures to copy the FGDB union output to the EGDB. To fix the issue:
  • Identify the polygons that overlap (CheckGeometry on the FGDB union output identifies some) and edit the polygons manually so the boundaries meet correctly.
  • Use a copy of the data for this. After fixing the data Spatial Reference according to the instructions in ArcGIS Blog: Geoprocessing, Resolution, Tolerance, and Hair, use the Integrate tool to integrate the data (leave the XYTolerance parameter at its default). Run the Integrate tool on each individual input first (and maybe more than once on each. The boundaries that overlap move) and run Integrate on both at the same time. Use these integrated feature classes in the Union tool. The Union tool runs fine with the output set to an EGDB output.

Steps to Reproduce

Bug ID: BUG-000126742

Software:

  • ArcGIS for Desktop

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