Searches Fail when ACLs are Configured (Doc ID 1546887.1)

Last updated on AUGUST 30, 2017

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

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