Error message with Orace11g 3d/4d-geometries and SDE

peterplumber — Mon, 19 Dec 2011 10:52:10 GMT

we are migrating our database from Oracle10g to Oracle11g.
for displaying the spatial data we are using an ArcSDE-Service
which also was updated from ArcSDE9.2 to ArcSDE9.3.

at first glance all seemed to work, but then we found out
that we could not query 3 or 4 dimensional layer anymore.

the error is
ORA-29902: Fehler bei der Ausführung von Routine ODCIIndexStart()
ORA-13243: Angegebener Operator wird für 3-dimensionalen oder höher-dimensionalen R-Baum nicht unterstützt
ORA-06512: in "MDSYS.SDO_INDEX_METHOD_10I", Zeile 333

probably that is
ORA-29902: error in executing ODCIIndexStart() routine
ORA-13243: specified operator is not supported for 3- or higher -dimensional R-tree
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 416

the probem is, that the column has a 2-dimensional index
where the layer is defined as "sl3+M" (using sdelayer for registration).

the error disappears when the layer is registered as "sl+"
but then I cannot display hatches

the error also disappears when I change the index to 4-dimensional
but then I get the error in the other applications that assume a 2-dimensional index.

(bwt: there was no problem with ArcSDE9.2 for Oracle10g. here
the 2-dimensional index worked well)

is there a way in ArcSDE9.3/Oracle11g to give SDE a hint to make all queries
with 2-dimensional geometries even if the layers are defined as "sl3+M"?

thanks

Peter

Re: Error message with Orace11g 3d/4d-geometries and SDE

peterplumber — Tue, 20 Dec 2011 15:38:51 GMT

have found the issue

NIM049887 - When using Oracle 11g, spatial queries against three dimensional feature classes do not return any results.

included in 9.3.1 Service-Pack1

thanks

Peter

topic Error message with Orace11g 3d/4d-geometries and SDE in Data Management Questions

Error message with Orace11g 3d/4d-geometries and SDE

Re: Error message with Orace11g 3d/4d-geometries and SDE