Error: Invalid SDE transaction or Spatial Reference for output is invalid
When inserting a feature or creating a spatial index, the following error message may be encountered:
"Invalid SDE transaction ID"
Or, when executing a geoprocessing tool, the following error message may be encountered:
"ERROR 000372: Spatial Reference for output is invalid"
After applying the Spatial Reference Consistency Patch and upgrading an Oracle geodatabase, client applications that do not have the Spatial Reference Consistency Patch applied can encounter errors when editing, creating spatial indexes or when executing geoprocessing tools.
To prevent further geodatabase spatial reference inconsistencies by geodatabase client applications without the Spatial Reference Consistency Patch, triggers are added to several geodatabase data dictionary objects during the upgrade. The triggers prevent non-patched applications from reintroducing spatial reference inconsistencies.
The specific bugs that cause the spatial reference inconsistencies include:
Oracle errors, ORA-29877, ORA-20085 and ORA-06512 are encountered when attempting to make object schema changes, spatial index changes, add Global IDs, registering data as versioned (Register as Versioned tool), or creating a raster dataset in ArcCatalog after upgrading certain ArcSDE 10.0 Oracle geodatabases.
Editing data that was upgraded from ArcSDE 9.3 to ArcSDE 10.1 returns the error, "ORA-20085: Insert Spatial Reference SRID 2274 does not match dataowner.A833.SHAPE registered Spatial Reference SRID 3."
To avoid the errors described above, it is recommended that the Spatial Reference Consistency Patch be applied to all client applications connecting to an Oracle geodatabase.
Solution or Workaround
- ArcGIS 10.2.1 for (Desktop, Engine, Server) Spatial Reference Consistency Patch
- ArcGIS 10.2.2 for (Desktop, Engine, Server) Spatial Reference Consistency Patch
- KB42461: Unable to insert or update Oracle st_geometry feature classes, encountering ORA-20085 errors
- KB42335: Invalid spatial reference (4326) set when inserting/updating the sde gdb_items table...
- KB42776: HowTo upgrade an Oracle geodatabase after applying the Spatial Reference Consistency Patch