Is OpenCities Map with Oracle 19c an 3d data working?

Hi,

I'm checking the new OCM Advanced Update 16 in combination with Oracle 19c and 3-dimensional data.

Data consists of simple lines, has a valid 3d spatial index and is listed in user_sdo_geom_metadata.

I created a project in Geospatial Administrator, registered a feature, created a workspace an tried to extract data in OpenCities Map.

That's working fine as long as I'm not querying by fence or view. In these cases it throws:

     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 671

I guess the operator is: WHERE SDO_ANYINTERACT ( SDOGIS.HOEHENLINIEN_SDO.OGC_GEOMETRY, :1) = 'TRUE'

DesignFile is 3D and I was assuming that the Connector is using the correct 3D operators when querying data.

When I connect to a 12g database it's working fine and I can extract 3d data via fence.

Is anyone else affected by this behavior? Or do I miss anything?

Kind Regards,

Maik

Parents Reply Children
No Data