Quick Search For OTS Reserved Keywords Fails With DRG-50901 And "Unable to retrieve search results. Error occurred while processing" (Doc ID 1570588.1)

Last updated on MARCH 21, 2017

Applies to:

Oracle WebCenter Content - Version 11.1.1.7.0 to 11.1.1.7.0 [Release 11g]
Information in this document applies to any platform.

Symptoms

When (quick) searching for OTS reserved keywords (such as 'about','accum','and','bt','btg','bti','btp','equiv','fuzzy','haspath','inpath','mdata','minus','near','not','nt','ntg','nti','ntp','or','pt','rt','sqe','syn','tr','trsyn','tt','within'), the following error message is thrown in WCC 11.1.1.7:

Content Server Request Failed
Error Unable to retrieve search results. Error occurred while processing.
Unable to return results 

 Associated stack trace:

!csUserEventMessage,weblogic,<domain>.com:16200!$!csSearchUnableToReturnResults
intradoc.common.ServiceException: !csSearchUnableToReturnResults
*ScriptStack GET_SEARCH_RESULTS
3:getSearchResults,**no captured values**
at intradoc.server.SearchManager.retrieveSearchInfoAsBinder(SearchManager.java:295)
at intradoc.server.SearchService.retrieveSearchInfo(SearchService.java:1848)
at intradoc.server.SearchService.doLocalSearch(SearchService.java:1377)
at intradoc.server.SearchService.getSearchResults(SearchService.java:670)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
...

 Full verbose tracing for "systemdatabase" reveals the following error when the search is conducted:

!csDbUnableToExecuteCallableQuery,CotsSearchQuery!$ORA-20000: Oracle Text error:
DRG-50857: oracle error in ctx_query.result_set
ORA-20000: Oracle Text error:
DRG-50901: text query parser syntax error on line 1\, column 23

ORA-06512: at "CTXSYS.DRUE"\, line 160
ORA-06512: at "CTXSYS.CTX_QUERY"\, line 791
ORA-06512: at "DEV_OCS.CONTENT_SEARCH"\, line 125
ORA-06512: at "DEV_OCS.CONTENT_SEARCH"\, line 320
ORA-06512: at line 1

 In earlier versions (11.1.1.5 / 11.1.1.6) the same error was thrown but caught and the search is retried, escaping the reserved OTS keywords:

>systemdatabase/6 07.12 04:15:09.443 IdcServer-1114 Retrying search as reserved word/character search error code received

 

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