BUG

Spatial queries on raster catalogs with SDO_GEORASTER and SDO_GEOMETRY or ST_GEOMETRY columns fail with ORACLE ORA-21500 error

Last Published: April 25, 2020

Description

Spatial queries that include both an SDO_GEORASTER and a geometry type (SDO_GEOMETRY or ST_GEOMETRY) fail with an ORACLE ORA-21500 error.

For example, if there is a raster catalog with a raster column stored as an SDO_GEORASTER and a geometry column stored as either an SDO_GEOMETRY or an ST_GEOMETRY, load data into the raster catalog, then open the raster catalog in ArcMap and pan and zoom across the data of the raster catalog, the ORACLE ORA-21500 error occurs.

Cause

According to Oracle documentation, the ORA-21500 error is a generic error number for OCI environment (client-side) internal errors indicating the OCI environment has encountered an exceptional condition. Therefore, using raster catalogs that contain both an SDO_GEORASTER and an SDO_GEOMETRY or ST_GEOMETRY column is not allowed at this time.

Workaround

If the intention is to store raster catalog data in an SDO_GEORASTER column, choose either a BLOB or a LONG RAW column to store the raster catalog's polygon footprints.

In the configuration keyword used to create the raster catalog, the following storage parameters should not be combined:

RASTER_STORAGE "SDO_GEORASTER"
GEOMETRY_STORAGE "SDO_GEOMETRY"

or

RASTER_STORAGE "SDO_GEORASTER"
GEOMETRY_STORAGE "ST_GEOMETRY"

Instead, the following storage parameter combinations should be used if the intention is to store the raster catalog data in an SDO_GEORASTER:

RASTER_STORAGE "SDO_GEORASTER"
GEOMETRY_STORAGE "SDELOB"

or

RASTER_STORAGE "SDO_GEORASTER"
GEOMETRY_STORAGE "SDEBINARY"

Article ID:000008775

Software:
  • Legacy Products

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

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