How To Search WCC Metadata Fields As SDATA Sections

(Doc ID 2149284.1)

Last updated on OCTOBER 16, 2017

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

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