My Oracle Support Banner

"Oracle Error in CTX_Query.result_set" Error When Performing Search as Non-Admin User with Collaboration Manager (Doc ID 748558.1)

Last updated on MAY 22, 2020

Applies to:

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

This problem can occur on any platform.


On installing the Oracle Text Search component with Collaboration manager and doing a standard search as non admin user would lead to the following error:

Content Server Request
Unable to retrieve search results. Error generated when executing query
'(((({HR} WITHIN dSecurityGroup) or ({Public} WITHIN dSecurityGroup)) or (({Projects} Within dSecurityGroup)) and (((%&test(R%) WITHIN xClbraUserList) or ((%@XXXX(R%) WITHIN xClbraAliasList)))) and (({test} WITHIN dDocAccount) or ((XXXXX%) WITHIN dDEocAccount) or ((XXX%) WITHIN dDocAccount) or ((prj%) WITHIN dDocAccount)))'.
Unable to execute query 'XXXXXXX'.
ORA-20000: Oracle Text Error:
DRG-50857: oracle error in ctx_query.result_set
ORA-20000: Oracle Text Error:
DRG-50901: text query parser syntax error on line 1, column 333

ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSTS.CTX_QUERY". line 772
ORA-06512: at "UCMREP.CONTENT_SEARCH". line 116
ORA-06512: at line 1


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.