Ora-20000 Error When Using OracleTextSearch and Searching With Multisort Component on Webcenter Content: Records (Doc ID 1373372.1)

Last updated on MAY 10, 2017

Applies to:

Oracle WebCenter Content - Version 10.1.3.3.1 to 10.1.3.5.0 [Release 10gR3]
Oracle WebCenter Content: Records - Version 10.1.3.3.1 to 10.1.3.5.0 [Release 10gR3]
Information in this document applies to any platform.

Symptoms

When using MultiSort on a system that is running Oracle Text Search with Webcenter Content: Records, the following error is displayed after picking the sort fields and clicking the Search button (the error below is generated when selecting Type as a sort field):

Content Server Request Failed
Unable to retrieve search results Error generated when executing query 'idccontenttrue'. Unable to execute callable query 'CotsSearchQuery'.
ORA-20000: Oracle Text error:
DRG-50857: oracle error in ctx_query.result_set
ORA-20000: Oracle Text error:
DRG-11131: Error from Oracle XML parser: LPX-00222: error received from SAX callback function
DRG-13600: Syntax error in the result set descriptor at hitlist
DRG-10837: section DDOCTYPE does not exist

ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_QUERY", line 800
ORA-06512: at "BIMSPADM.CONTENT_SEARCH", line 123
ORA-06512: at line 1

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