UCM 11g with Oracle Text Search Failing to Return Results for Newly Added Metadata Field (Doc ID 1332348.1)

Last updated on JULY 05, 2017

Applies to:

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

Symptoms

In either the Search 'Expanded Form' or the 'Query Builder Form' click on Update Sort Fields at the bottom of the page and add a metadata field called 'Filing Date' to the Search Fields.
Run the search, an error message will appear:

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


1. Go to Administration > System Audit Information
2. In the Trace Sections information add 'systemdatabase'
3. Reproduce the error by running the query
4. Go back to the system Audit information and click on 'View Server Output'
5. This error is displayed:

systemdatabase/6 05.30 15:42:18.911 IdcServer-10083 !csDbUnableToExecuteCallableQuery,CotsSearchQuery!$ORA-20000: Oracle Text error:
systemdatabase/6 05.30 15:42:18.911 IdcServer-10083 DRG-50857: oracle error in ctx_query.result_set
systemdatabase/6 05.30 15:42:18.911 IdcServer-10083 ORA-20000: Oracle Text error:
systemdatabase/6 05.30 15:42:18.911 IdcServer-10083 DRG-11131: Error from Oracle XML parser: LPX-00222: error received from SAX callback function
systemdatabase/6 05.30 15:42:18.911 IdcServer-10083 DRG-13600: Syntax error in the result set descriptor
systemdatabase/6 05.30 15:42:18.911 IdcServer-10083 DRG-10837: section XFILINGDATE does not exist

Changes

New metadata field was added to the content server

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