-
Title
Post stopped with ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine. -
Description
Post stopped and in the event_log you see error messages similar to this one:
09/04/07 17:44 Notice: ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine.ORA-13236: internal error in R-tree processing: [insertion-failure].ORA-29400: data cartridge error.ORA-01013: user requested cancel of current operation.ORA-06512: at "MDSYS.SDO_INDEX_METHOD_9I", line 319.ORA-06512: at "MDSYS.SDO_IDX", line 17.ORA-06512: at "MDSYS.SDO_INDEX_METHOD_9I", line 368. [sp_opst(osp)/85272]
09/04/07 17:44 Error: Unexpected Oracle error: ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine.ORA-13236: internal error in R-tree processing: [insertion-failure].ORA-29400: data cartridge error.ORA-01013: user requested cancel of current operation.ORA-06512: at "MDSYS.SDO_INDEX_METHOD_9I", line 319.ORA-06512: at "MDSYS.SDO_IDX", line 17.ORA-06512: at "MDSYS.SDO_INDEX_METHOD_9I", line 368. (object name: "SCHEMA"."TABLENAME") [sp_opst (for o.SID1-o.SID2 queue ei088sg4)/85272]
09/04/07 17:44 Process exited sp_opst (for o.SID1-o.SID2 queue ei088sg4) [pid = 85272] - exit(1) -
Cause
You're using Oracle Spatial and some of the indexes are unusable.
-
Resolution
Drop and recreate the indexes of the table in the error message (object name: "SCHEMA"."TABLENAME") .
-
Additional Information
This is not a SharePlex issue but a problem in the underlying Oracle database.