"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 laterInformation 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
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
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 |