My Oracle Support Banner

WebCenter Content (WCC) FullText Search Fails with Database Search; "CTX_USER_INDEX_ERRORS" (DRG-11207, DRG-50857, etc.) (Doc ID 1134146.1)

Last updated on FEBRUARY 01, 2019

Applies to:

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

Symptoms

Content not fulltext indexed.


CTX_USER_INDEX_ERRORS view (and table) shows:

execute:  select * from <ucm-schema>.ctx_user_index_errors;

ERR_INDEX_NAME: IdcColl2
ERR_TEXT: DRG-11207: user filter command exited with status 1
Another presentation of this problem shows the following errors, particularly when zone fields are being used.
execute:  select * from ctx_user_index_errors

DDOCNAME_REVISIONS_ZFT 2/20/2012 10:45:03 AM ON COMMIT SYNC DRG-50857: oracle error in dreii0fsh
ORA-20000: Oracle Text error:
DRG-50857: oracle error in driopt.lock_opt_rebuild
ORA-01460: unimplemented or unreasonable conversion requested
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.DRVDML", line 837
ORA-06512: at line 1

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
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.