Indexing Aborted. Unable To Execute Callable Query 'CoracleTextExchangeShadowIndex'
Last updated on JANUARY 26, 2017
Applies to:
Oracle WebCenter Content - Version 11.1.1.6.0 and laterInformation 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