My Oracle Support Banner

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 JUNE 16, 2022

Applies to:

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


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

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

 Associated stack trace:

intradoc.common.ServiceException: !csSearchUnableToReturnResults
3:getSearchResults,**no captured values**
at intradoc.server.SearchManager.retrieveSearchInfoAsBinder(
at intradoc.server.SearchService.retrieveSearchInfo(
at intradoc.server.SearchService.doLocalSearch(
at intradoc.server.SearchService.getSearchResults(
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
at java.lang.reflect.Method.invoke(

 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 ( / 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



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

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