Search - Standard Search using DATABASE.METADATA shows the condition operator twice and gives error : "Unable to retrieve search results. Parsing error in query" (Doc ID 1986513.1)

Last updated on SEPTEMBER 18, 2023

Applies to:

Symptoms

After upgrade from 10g to 11g 11.1.1.8

Seeing the search operator 'MATCHES' occur twice in the drop down list for standard search.

When  searching on a content ID you get an error like :

"Content Server Request Failed"

Unable to retrieve search results. Parsing error at character 27 in query: "( UPPER(dDocName) LIKE UPPER('My content') AND dDocName IS NOT NULL )".

Excerpt from csSearchUnableToReturnResults.log:

Event generated by user 'weblogic' at host 'localhost:16200'. Error occurred while processing. Unable to return results. Encountered an exception while executing a query. [ Details ]
An error has occurred. The stack trace below shows more information.

!csUserEventMessage,weblogic,localhost:16200!$!csSearchUnableToReturnResults!csJdbcGenericError
intradoc.common.ServiceException: !csSearchUnableToReturnResults
*ScriptStack GET_SEARCH_RESULTS
3:getSearchResults,**no captured values**
       at intradoc.server.SearchManager.retrieveSearchInfoAsBinder(SearchManager.java:297)
       at intradoc.server.SearchService.retrieveSearchInfo(SearchService.java:2004)
       at intradoc.server.SearchService.doLocalSearch(SearchService.java:1472)
       at intradoc.server.SearchService.getSearchResults(SearchService.java:706)
       ... and more

Caused by: intradoc.data.DataException: !csJdbcGenericError
       at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2680)
       at intradoc.jdbc.JdbcWorkspace.createResultSetSQL(JdbcWorkspace.java:915)
       ... and more

Changes

 Environment was upgraded from 10g.

Cause

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