laptop and a wrench

Bug

In ArcGIS Data Interoperability Esri Geodatabase reader skips all rows from feature class in Oracle Spatial Database Engine (SDE) geodatabase that are returned prior first row with shape=null when this shape=null row is returned in first 100 rows, and there is error message: "The error number from ArcObjects is: '-2147215975'" in translation log.

ArcGIS for Desktop
Bug ID Number BUG-000170621
SubmittedSeptember 10, 2024
Last ModifiedDecember 11, 2024
Applies toArcGIS for Desktop
Version found10.8.1
Operating SystemWindows OS
Operating System VersionN/A
StatusWill Not Be Addressed

Additional Information

Issue tested with ArcGIS Pro 3.3.2 and does not occur. Note that ArcGIS Desktop is in Mature Support. Refer this documentation https://support.esri.com/en-us/products/arcmap/life-cycle for more information.

Workaround

Add where condition to reader that uses 'order by' to put all NULLs at shape column first (so 0 rows are skipped).

For example: 1=1 ORDER BY (CASE WHEN SHAPE IS NULL THEN 1 ELSE 2 END)A

Steps to Reproduce

Bug ID: BUG-000170621

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