Drg-51030 error shows up when Non-Admin users are searching on Webcenter Content server (Doc ID 1906007.1)

Last updated on OCTOBER 31, 2016

Applies to:

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

Symptoms

Webcenter Content Server is set up with Oracle Text Search indexing mechanism and accounts security is enabled.

When any non-admin user is trying to search in content server for any search query it is returning:


"Error occurred while processing. Unable to return results"

In the content server log it is generating following error :

>systemdatabase/6 05.27 11:52:46.850 IdcServer-127 1.12 ms. SELECT 1 FROM DUAL[Executed. Returned row(s): true]
>systemdatabase/6 05.27 11:52:46.850 IdcServer-127 !csDbUnableToExecuteCallableQuery,CotsSearchQuery!$ORA-20000: Oracle Text error:
 systemdatabase/6 05.27 11:52:46.850 IdcServer-127 DRG-50857: oracle error in ctx_query.result_set
 systemdatabase/6 05.27 11:52:46.850 IdcServer-127 ORA-20000: Oracle Text error:
 systemdatabase/6 05.27 11:52:46.850 IdcServer-127 DRG-51030: wildcard query expansion resulted in too many terms
 systemdatabase/6 05.27 11:52:46.850 IdcServer-127 
 systemdatabase/6 05.27 11:52:46.850 IdcServer-127 ORA-06512: at "CTXSYS.DRUE"\, line 160
 systemdatabase/6 05.27 11:52:46.850 IdcServer-127 ORA-06512: at "CTXSYS.CTX_QUERY"\, line 800
 systemdatabase/6 05.27 11:52:46.850 IdcServer-127 ORA-06512: at "WCCSIT_OCS.CONTENT_SEARCH"\, line 125
 systemdatabase/6 05.27 11:52:46.850 IdcServer-127 ORA-06512: at "WCCSIT_OCS.CONTENT_SEARCH"\, line 320
 systemdatabase/6 05.27 11:52:46.850 IdcServer-127 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