My Oracle Support Banner

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:

Oracle WebCenter Content - Version and later
Information in this document applies to any platform.
Environment was upgrade from 10g.


After upgrade from 10g to 11g

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.

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(
       ... and more

Caused by: !csJdbcGenericError
       at intradoc.jdbc.JdbcWorkspace.handleSQLException(
       at intradoc.jdbc.JdbcWorkspace.createResultSetSQL(
       ... and more


 Environment was upgraded from 10g.


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.