MAPVIEWER-01023: Unable To Find Entry In ALL_SDO_GEOM_METADATA Table For Theme: [BI_COUNTRY_THEME] (Doc ID 1609198.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Fusion Middleware MapViewer - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

Trying to display a map in OBIEE

Mapviewer log shows:

Dec 17, 2013 12:54:42 AM oracle.sdovis.ThemeTable getSrid
SEVERE: MAPVIEWER-01023: Unable to find entry in ALL_SDO_GEOM_METADATA table for theme: [BI_COUNTRY_THEME]
select SRID from ALL_SDO_GEOM_METADATA where TABLE_NAME=? and (COLUMN_NAME=? OR COLUMN_NAME=? or COLUMN_NAME=?) and OWNER=?
Dec 17, 2013 12:54:42 AM oracle.sdovis.ThemeTable getSrid
SEVERE: Exhausted Resultset
java.sql.SQLException: Exhausted Resultset
at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:1997)
at oracle.sdovis.ThemeTable.getSrid(ThemeTable.java:1990)


The user executing the map is not the owner of the base table for the theme

The user executing the map has a view based on the base table for the theme

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms