"Unable to execute query 'CotsSearchQuery'" Error When Performing a Search in URM (Doc ID 947168.1)

Last updated on NOVEMBER 03, 2016

Applies to:

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

Symptoms

When attempting to perform a search on a URM system, the following error is thrown:

Content Request Failed
Error generated when executing query '((idccontenttrue NOT ({1} WITHIN xIsRecord and idccontenttrue NOT (xIsRecord IS NULL)))) and (((({Public} WITHIN dSecurityGroup)) and (({idcnull} WITHIN dDocAccount))))'.
Unable to execute query 'CotsSearchQuery'.

ORA-20000: Oracle Text error:
DRG-50857: oracle error in ctx_query.result_set
ORA-20000: Oracle Text error:
DRG-10837: section xIsRecord does not exist

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