How to Optimize a Metadata Field for WebCenter Content (WCC) OracleTextSearch (OTS)? (Doc ID 1395572.1)

Last updated on MAY 16, 2017

Applies to:

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

Goal

How to Optimize a Metadata Field in OracleTextSearch (OTS)?

This was used to resolve the following issues/errors:
intradoc.common.ServiceException: !csOracleTextErrorExecutingQuery,(((({JSP} WITHIN dSecurityGroup)) or (({Operational} WITHIN dSecurityGroup)) or (({Public} WITHIN dSecurityGroup)) or (({WebContent} WITHIN dSecurityGroup))) and ((((ASSETS#HS#CN%) WITHIN dDocAccount)) or (((ASSETS#CM#RT#LIC%) WITHIN dDocAccount)) or (({idcnull} WITHIN dDocAccount)) or (((public%) WITHIN dDocAccount)) or (((CEDEM%) WITHIN dDocAccount)) or (((EHPLANDN%) WITHIN dDocAccount)) or (((EHSTRAT%) WITHIN dDocAccount)) or (((ORG#R%) WITHIN dDocAccount))))!csDbUnableToExecuteCallableQuery,CotsSearchQuery!$ORA-20000: Oracle Text error:
DRG-50857: oracle error in ctx_query.result_set
ORA-20000: Oracle Text error:
DRG-51030: wildcard query expansion resulted in too many terms

ORA-06512: at "CTXSYS.DRUE"\, line 160
ORA-06512: at "CTXSYS.CTX_QUERY"\, line 788
ORA-06512: at "UCM.CONTENT_SEARCH"\, line 123
ORA-06512: at line 1

at intradoc.server.SearchManager.handleSearchStatusMessage(SearchManager.java:315)
at intradoc.server.SearchService.retrieveSearchInfo(SearchService.java:1347)
at intradoc.server.SearchService.doLocalSearch(SearchService.java:1049)
at intradoc.server.SearchService.getSearchResults(SearchService.java:531)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
DRG-12245 SDATA operator not compatible with the sdata section

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