laptop and a wrench

Bug

Using SDE.ST_TRANSFORM returns the error message, "ORA-20603: Spatial References are not compatible."

Last Published: September 25, 2020 ArcSDE/Enterprise Geodatabase
Bug ID Number BUG-000132060
SubmittedJuly 6, 2020
Last ModifiedJune 5, 2024
Applies toArcSDE/Enterprise Geodatabase
Version found10.4.1
Operating SystemWindows OS
Operating System Version10.0 64 Bit
StatusNon-Reproducible

Additional Information

This issue is not reproducible in geodatabase versions 10.6.1, and 10.8.

Workaround

  • Use the Project geoprocessing tool. 
  • Add a geographic ID to allow for the query to give the correct results. Refer to the following sample:

SELECT SDE.ST_Y(SDE.ST_TRANSFORM(SHAPE, 4326, 108190)) Latitude FROM <dataowner.tablename>;

Steps to Reproduce

Bug ID: BUG-000132060

Software:

  • ArcSDE/Enterprise Geodatabase

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