My Oracle Support Banner

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

Last updated on DECEMBER 15, 2017

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

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
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.