ST_TRANSFORM on multi polygons fails

Question

Hi,

When using SDE.ST_TRANSFORM on multi polygons that has self interaction

return error:

ORA-20603: Spatial References are not compatible.

ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 720

ORA-06512: at "SDE.ST_GEOMETRY_OPERATORS", line 2704

The problem is on 10.2.2 it works well on 10.4, any idea what to do on 10.2.2?

thanks

Iris hadar

IAA

irishadar · Answer

thank you ,

It is working on 10.4.

I found a work around  using sql to convert from multi part to single one .

iris

George Thompson · Answer

Hi Iris,

This may be a known issue with 10.2.2 that was corrected in a later release.

BUG-000086328: Performing a transformation on a feature class in an Oracle database using the ST_Transform is producing a transform error: ORA-20603: Spatial References are not compatible.

http://downloads.esri.com/support/downloads/other_/104-IssuesAddressedList.pdf  - List of 10.4 fixes

http://support.esri.com/download/2266  - List of 10.2.1 UTUP4 fixes

I would reach out to technical support and have them investigate in more detail to verify that you are encountering the same issue.