Search Fails for External Users In WCC After Upgrade to 11.1.1.8.0
(Doc ID 1676468.1)
Last updated on JANUARY 02, 2024
Applies to:
Oracle WebCenter Content - Version 11.1.1.8.0 and laterInformation 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
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 |