topic ST_TRANSFORM on multi polygons fails in Geodatabase Questions

ST_TRANSFORM on multi polygons fails

irishadar — Tue, 31 May 2016 09:41:28 GMT

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

Re: ST_TRANSFORM on multi polygons fails

George_Thompson — Tue, 31 May 2016 12:19:58 GMT

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.

Re: ST_TRANSFORM on multi polygons fails

irishadar — Tue, 31 May 2016 18:01:28 GMT

thank you ,

It is working on 10.4.

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

iris