My Oracle Support Banner

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

Last updated on DECEMBER 18, 2023

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

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.