My Oracle Support Banner

TPW logs Report, 'ORA-29861: Domain Index Is Marked LOADING/FAILED/UNUSABLE' Due To 'ORA-13249: internal error in Spatial index' (Doc ID 2022969.1)

Last updated on APRIL 24, 2018

Applies to:

Oracle Real-Time Scheduler - Version 2.1.0 and later
Oracle Utilities Mobile Workforce Management - Version 2.1.0 and later
Information in this document applies to any platform.

Symptoms

We are seeing the below error in the TPW logs

04:59:27,053 [S1REGION7:SchedulerManager] ERROR (com.splwg.base.support.sql.PreparedStatementImpl) Error executing update for rawSQL:
 UPDATE M1_CREW_SHFT_SCHED SET M1_SHIFT_CLASS_FLG = 'M1RL', SHFT_SCH_STATUS_FLG = ?, M1_LOGON_GEO_LAT = ?, M1_LOGON_GEO_LONG = ?, M1_LOGOFF_GEO_LAT = ?, M1_LOGOFF_GEO_LONG = ?, M1_CAL_TRAL_TM = ?, M1_CAL_TRAL_DIST = ?, TOTAL_COST=?, M1_FROZEN_DTTM = null, WORK_DURATION = ?, VERSION = ? WHERE CREW_SHFT_ID = ? and VERSION = ?
with  'decimal' parameter named 'logonLongitude' to : '-0.244189' to indices: 3
with  'decimal' parameter named 'totalCost' to : '0' to indices: 8
with  'decimal' parameter named 'logoffLatitude' to : '12.345678' to indices: 4
with  'lookup' parameter named 'status' to : 'M1IN' to indices: 1
with  'integer' parameter named 'totalTravelTime' to : '0' to indices: 6
with  'decimal' parameter named 'logonLatitude' to : '12.345678' to indices: 2
with  'integer' parameter named 'workDuration' to : '0' to indices: 9
with  'integer' parameter named 'old_version' to : '2' to indices: 12
with  'entity-string id' parameter named 'shiftId' to : 'CrewShift_Id(00012345607354)' to indices: 11
with  'integer' parameter named 'totalTravelDistance' to : '0' to indices: 7
with  'integer' parameter named 'version' to : '3' to indices: 10
with  'decimal' parameter named 'logoffLongitude' to : '-0.123456' to indices: 5
java.sql.SQLException: ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
04:49:42,695 [DEFAULTWorker:0] INFO  (com.splwg.base.support.context.SimpleCacheManager) Registering cache 'PortalInfoRepository'
04:49:42,742 [DEFAULTWorker:0] INFO  (com.splwg.base.support.context.SimpleCacheManager) Registering cache 'FieldLabelRepository'
04:49:42,811 [DEFAULTWorker:0] INFO  (com.splwg.base.support.context.SimpleCacheManager) Registering cache 'CurrencyInfoRepository'
04:49:42,811 [DEFAULTWorker:0] INFO  (com.splwg.base.web.common.CurrencyRepository) Retrieving Currency Info
04:49:42,821 [DEFAULTWorker:0] INFO  (com.splwg.base.support.context.SimpleCacheManager) Registering cache 'FieldHasHelpTextRepository'
04:49:43,311 [DEFAULTWorker:0] WARN  (com.splwg.base.support.schema.validation.XMLStorageUnderGroupFinder)     !!! Unknown list mapping type for list /results
04:49:46,273 [DEFAULTWorker:0] WARN  (org.hibernate.engine.jdbc.spi.SqlExceptionHelper) SQL Error: 29861, SQLState: 99999
04:49:46,273 [DEFAULTWorker:0] ERROR (org.hibernate.engine.jdbc.spi.SqlExceptionHelper) ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
 

And, trying to run OraDBI.exe from the ORS/Install-Upgrade for a patch upgrade, BEFORE post installation results in this specific error string:

ERROR at line 1:
ORA-29858: error occurred in the execution of ODCIINDEXALTER routine
ORA-29400: data cartridge error

ORA-01403: no data found
ORA-13249: internal error in Spatial index: [mdidxrbd]
ORA-13203: failed to read USER_SDO_GEOM_METADATA view
ORA-13203: failed to read USER_SDO_GEOM_METADATA view
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 313

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.