"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 19, 2017

Applies to:

Oracle WebCenter Content - Version 10.1.3.3.2 to 10.1.3.5.0 [Release 10gR3]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

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

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