My Oracle Support Banner

How To Search WCC Metadata Fields As SDATA Sections (Doc ID 2149284.1)

Last updated on JANUARY 15, 2019

Applies to:

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

Goal

When doing searches an error maybe generated:

systemdatabase/6 05.05 13:20:36.206 IdcServer-57543 !csDbUnableToExecuteCallableQuery,CotsSearchQuery!$ORA-20000: Oracle Text error:
systemdatabase/6 05.05 13:20:36.206 IdcServer-57543 DRG-50857: oracle error in ctx_query.result_set
systemdatabase/6 05.05 13:20:36.206 IdcServer-57543 ORA-20000: Oracle Text error:
systemdatabase/6 05.05 13:20:36.206 IdcServer-57543 DRG-51030: wildcard query expansion resulted in too many terms
systemdatabase/6 05.05 13:20:36.206 IdcServer-57543
systemdatabase/6 05.05 13:20:36.206 IdcServer-57543 ORA-06512: at "CTXSYS.DRUE"\, line 160
systemdatabase/6 05.05 13:20:36.206 IdcServer-57543 ORA-06512: at "CTXSYS.CTX_QUERY"\, line 800
systemdatabase/6 05.05 13:20:36.206 IdcServer-57543 ORA-06512: at "STELLENT.CONTENT_SEARCH"\, line 123
systemdatabase/6 05.05 13:20:36.206 IdcServer-57543 ORA-06512: at line 1

  

This more typically occurs due to large amounts of Content Server accounts or long account sub strings.

The resolution for the error when due to the dDocAccount is covered in <Note 1940525.1>.

However, this error may occur when doing wildcard searches on other metadata fields.  This KM note covers how to set the fields to be SDATA sections and how to search for them as SDATA sections.

Solution

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
Goal
Solution
 A. To set the metadata field to be an SDATA section
 B. To search the field as an SDATA section
References


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