Error With Refresh of P6 Database: ORA-13249: SRID 8307 WKT Does Not Exist In MDSYS.CS_SRS Table (Doc ID 2963557.1)

Last updated on JULY 27, 2023

Applies to:

Symptoms

When refreshing a P6 database from Production to test and importing into a test Oracle instance, the following error appears for both the ndx_rsrcloc_geo_location and ndx_location_geo_location indexes:

ERROR

ORA-13249: SRID 8307 WKT does not exist in MDSYS.CS_SRS table

Error starting at line : 7 in command -
CREATE INDEX ndx_rsrcloc_geo_location ON rsrcloc (geo_location) INDEXTYPE IS mdsys.spatial_index
Error report -
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13249: internal error in Spatial index: [mdidxrbd]
ORA-13249: SRID 8307 WKT does not exist in MDSYS.CS_SRS table
ORA-13249: Stmt-Execute Failure: SELECT /*+ RESULT_CACHE */ MDSYS.sdo_cs.disambiguate_proj_name(srid, wktext) FROM MDSYS.sdo_cs_srs WHERE srid = :1
ORA-29400: data cartridge error
ORA-04063: package body "MDSYS.SDO_CS" has errors
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10
29855. 00000 - "error occurred in the execution of ODCIINDEXCREATE routine"
*Cause: Failed to successfully execute the ODCIIndexCreate routine.
*Action: Check to see if the routine has been coded correctly.

Error starting at line : 9 in command -
CREATE INDEX ndx_location_geo_location ON location (geo_location) INDEXTYPE IS mdsys.spatial_index
Error report -
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13249: internal error in Spatial index: [mdidxrbd]
ORA-13249: SRID 8307 WKT does not exist in MDSYS.CS_SRS table
ORA-13249: Stmt-Execute Failure: SELECT /*+ RESULT_CACHE */ MDSYS.sdo_cs.disambiguate_proj_name(srid, wktext) FROM MDSYS.sdo_cs_srs WHERE srid = :1
ORA-29400: data cartridge error
ORA-04063: package body "MDSYS.SDO_CS" has errors
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10
29855. 00000 - "error occurred in the execution of ODCIINDEXCREATE routine"
*Cause: Failed to successfully execute the ODCIIndexCreate routine.
*Action: Check

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.