Search Index Auto Update or Rebuild Causes "DRG-10700: PREFERENCE DOES NOT EXIST: CTXSYS.DEFAULT_WORDLIST" (Doc ID 972396.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle WebCenter Content - Version 10.1.3.3.0 to 10.1.3.5.0 [Release 10gR3]
Information in this document applies to any platform.

Symptoms

At the onset of the indexer update scheduled transaction (runs approximately every 5 minutes), or a forced index rebuild via the Repository Manager admin applet, Oracle Database reports the below error to Content Server:

Indexing aborted. Unable to delete collection directories. Cannot create table or index 'IdcText1' Unable to execute SQL statement 'CREATE INDEX FT_IdcText1 ON IdcText1 (otsMeta) INDEXTYPE IS CTXSYS.CONTEXT Filter By dCreateDate,dInDate,dOutDate PARAMETERS('DATASTORE IdcStore_ots1 LEXER IdcLexer_ots1
SECTION GROUP section_group_ots1 MEMORY 20M
SYNC(MANUAL) ')'. ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10700: preference does not exist: CTXSYS.DEFAULT_WORDLIST
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 365

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