My Oracle Support Banner

Searches Fail when ACLs are Configured (Doc ID 1546887.1)

Last updated on DECEMBER 18, 2023

Applies to:

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

Symptoms

When collaboration ACLs are configured on the Webcenter Content server, searches may fail.

The WCC page will display:

Error occurred while retrying the search query. Error occurred while processing. Unable to return results. Error occurred while processing. Unable to return results

The WCC Log will show:

!csSearchRetryFailed!csSearchUnableToReturnResults!csSearchUnableToReturnResults intradoc.common.ServiceException: !csSearchRetryFailed!csSearchUnableToReturnResults *ScriptStack GET_SEARCH_RESULTS 3:getSearchResults,**no captured values**

The WCC system audit trace will return:

>systemdatabase/6 04.18 11:12:31.769 [ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)' !csDbUnableToExecuteCallableQuery,CotsSearchQuery!$ORA-20000: Oracle Text error:
systemdatabase/6 04.18 11:12:31.769 [ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)' DRG-50857: oracle error in ctx_query.result_set
systemdatabase/6 04.18 11:12:31.769 [ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)' ORA-20000: Oracle Text error:
systemdatabase/6 04.18 11:12:31.769 [ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)' DRG-50901: text query parser syntax error on line 1\, column 627  
systemdatabase/6 04.18 11:12:31.769 [ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'
systemdatabase/6 04.18 11:12:31.769 [ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)' ORA-06512: at "CTXSYS.DRUE"\, line 160
systemdatabase/6 04.18 11:12:31.769 [ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)' ORA-06512: at "CTXSYS.CTX_QUERY"\, line 791
systemdatabase/6 04.18 11:12:31.769 [ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)' ORA-06512: at "WCC_OCS.CONTENT_SEARCH"\, line 125
systemdatabase/6 04.18 11:12:31.769 [ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)' ORA-06512: at "WCC_OCS.CONTENT_SEARCH"\, line 320
systemdatabase/6 04.18 11:12:31.769 [ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)' 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


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