Search Fails For External Users In WCC After Upgrade to 11.1.1.8.0 (Doc ID 1676468.1)

Last updated on AUGUST 07, 2017

Applies to:

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

Symptoms

Using WebCenter Content 11.1.1.8.0 with Oracle Text Search

After upgrading 2 independent WCC instances from 11.1.1.4 to WCC 11.1.1.8 MLR4, search performed by external users are failing.

If an admin user (weblogic for example) performs a search (quick, targeted, standard) the search works fine.
For the External Users (OID integrated with Weblogic), the search always fails. with the errors below.

>systemdatabase/6 04.24 13:14:36.219 IdcServer-273426 run: 5.32 ms. total 14 ms. [ORA-20000: Oracle Text error:
 systemdatabase/6 04.24 13:14:36.219 IdcServer-273426 DRG-50857: oracle error in ctx_query.result_set
 systemdatabase/6 04.24 13:14:36.219 IdcServer-273426 ORA-20000: Oracle Text error:
 systemdatabase/6 04.24 13:14:36.219 IdcServer-273426 DRG-51030: wildcard query expansion resulted in too many terms
 systemdatabase/6 04.24 13:14:36.219 IdcServer-273426
 systemdatabase/6 04.24 13:14:36.219 IdcServer-273426 ORA-06512: at "CTXSYS.DRUE", line 160
 systemdatabase/6 04.24 13:14:36.219 IdcServer-273426 ORA-06512: at "CTXSYS.CTX_QUERY", line 791
 systemdatabase/6 04.24 13:14:36.219 IdcServer-273426 ORA-06512: at "DEV_OCS.CONTENT_SEARCH", line 123
 systemdatabase/6 04.24 13:14:36.219 IdcServer-273426 ORA-06512: at line 1
 systemdatabase/6 04.24 13:14:36.219 IdcServer-273426 ]


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