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 NOVEMBER 03, 2016

Applies to:

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

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

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