Indexing Aborted. Unable To Execute Callable Query 'CoracleTextExchangeShadowIndex'

(Doc ID 2167699.1)

Last updated on JANUARY 26, 2017

Applies to:

Oracle WebCenter Content - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

Symptoms

A fast index rebuild aborted just prior to completion. The following error was found in the Content Server online logs (Administration -> Log Files -> Content Server Logs).

Error<DATETIME> Indexing aborted. Unable to execute callable query 'CoracleTextExchangeShadowIndex'. ORA-20000: Oracle Text error:
DRG-50857: oracle error in drvrio.alter_swap_shadow
ORA-29858: error occurred in the execution of ODCIINDEXALTER routine
ORA-20000: Oracle Text error:
DRG-13509: error while swapping shadow index
User-Defined Exception
DRG-50857: oracle error in drvxtab.swap_index_temp_tables
ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DDL", line 1737
ORA-06512: at line 1
java.sql.SQLException: ORA-20000: Oracle Text error:
DRG-50857: oracle error in drvrio.alter_swap_shadow
ORA-29858: error occurred in the execution of ODCIINDEXALTER routine
ORA-20000: Oracle Text error:
DRG-13509: error while swapping shadow index
User-Defined Exception
DRG-50857: oracle error in drvxtab.swap_index_temp_tables
ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DDL", line 1737
ORA-06512: at line 1. [ Details ]

Changes

The solution in the following KM note was executed to resolve another issue.

CTX_DDL.RECREATE_INDEX_ONLINE Raises DRG-50857 ORA-14097 DRG-13509 (Doc ID 1903909.1)

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