ORA-13199: Operation 83073857 does not Exist After Upgrade from 10g to 12c (Doc ID 1984529.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

SRID 3857 was not implemented in 10g so a custom coordinate set was created for this in 10g.

Now upgrading this database from 10g to 12c.

Deleted the corresponding entries for this SRID in 10g database before the upgrade, i.e. -

delete from MDSYS.SDO_COORD_OPS where target_srid=3857;
delete from MDSYS.SDO_COORD_OP_PATHS where SINGLE_OP_TARGET_ID=3857;
delete from mdsys.sdo_coord_ref_system where srid=3857;

After this delete the upgrade went fine.

But now encounter below errors when try to do some operation using this SRID:

SELECT MDSYS.SDO_CS.DETERMINE_CHAIN(NULL, NULL, 3857, 8307) FROM DUAL;

ORA-13199: Operation 83073857 does not exist.
ORA-06512: in "MDSYS.MD", Zeile 1723
ORA-06512: in "MDSYS.MDERR", Zeile 17
ORA-06512: in "MDSYS.TFM_PLAN", Zeile 51
ORA-06512: in "MDSYS.SDO_CS", Zeile 1058
ORA-06512: in "MDSYS.SDO_CS", Zeile 934

In a fresh 12c installation the command succeeds and gives

((3857; -1; 4326; -2; 8307; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ))

Checked and the entry for SRID 3857 does exist in the upgraded 12c database, i.e. -

SQL> select wktext from cs_srs where srid = 3857;

WKTEXT
--------------------------------------------------------------------------------
PROJCS["WGS 84 / Pseudo-Mercator", GEOGCS [ "WGS 84", DATUM ["World Geodetic Sys
tem 1984 (EPSG ID 6326)", SPHEROID ["WGS 84 (EPSG ID 7030)", 6378137.0, 298.2572
23563]], PRIMEM [ "Greenwich", 0.000000 ], UNIT ["Decimal Degree", 0.01745329251
99433]], PROJECTION ["Popular Visualisation Pseudo-Mercator"], PARAMETER ["Latit
ude_of_origin", 0.0], PARAMETER ["Central_Meridian", 0.0], PARAMETER ["False_Eas
ting", 0.0], PARAMETER ["False_Northing", 0.0], UNIT ["Meter", 1.0]]

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