My Oracle Support Banner

OracleTextSearch Searches Fail When Parsing the Drill Down Fields in WebCenter Content Server (Doc ID 2260059.1)

Last updated on JULY 30, 2018

Applies to:

Oracle WebCenter Content - Version and later
Information in this document applies to any platform.


When the WebCenter Content Server is configured for OracleTextSearch, some searches work as expected but other searches will fail.

Such as attempting to do a blank quick search or a Search page full search, the search fails.

Or setting specific metadata field values searches fail but setting those same fields with different values work.

The user will get an error message displayed:

Content Server Request Failed - Unable to retrieve search results Error occurred while retrying the search query. Error occurred while processing. Unable to return results

The system audit trace will show an entries like:

systemdatabase/6 04.19 16:06:44.871 IdcServer-549 299 ms. Executing CallableStatement ({call content_search.search_with_resultsetinterface(?, ?,?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)})[Executed. First result is ResultSet:false]
search/6 04.19 16:06:44.875 IdcServer-549 Start parsing drill down fields with SAX...
search/7 04.19 16:06:44.875 IdcServer-549 The character reference must end with the ';' delimiter. exception backtrace:org.xml.sax.SAXParseException;
lineNumber: 1; columnNumber: 364; The character reference must end with the ';' delimiter.


Note that the failure occurred after the content_search.search_with_resultsetinterface callable statement was run.





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.