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 FEBRUARY 25, 2019

Applies to:

Oracle WebCenter Content - Version to [Release 10gR3]
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.