Indexing Aborted. Unable To Execute Callable Query 'CoracleTextExchangeShadowIndex'
(Doc ID 2167699.1)
Last updated on DECEMBER 18, 2023
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.
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |