OracleTextSearch – fix limit of 2048 results

I’ve seen the following error pop up a lot while searching within WebCenter Content.

!csUserEventMessage,boset,10.0.110.59:16200!$!csJdbcGenericError
intradoc.common.ServiceException: !csJdbcGenericError
*ScriptStack GET_SEARCH_RESULTS
3:getSearchResults,dID=
        at intradoc.server.SearchManager.retrieveSearchInfoAsBinder(SearchManager.java:297)
        at intradoc.server.SearchService.retrieveSearchInfo(SearchService.java:1990)
        at intradoc.server.SearchService.doLocalSearch(SearchService.java:1458)
        at intradoc.server.SearchService.getSearchResults(SearchService.java:697)
        at sun.reflect.GeneratedMethodAccessor671.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at intradoc.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:86)
        at intradoc.common.ClassHelperUtils.executeMethodEx(ClassHelperUtils.java:310)
        at intradoc.common.ClassHelperUtils.executeMethod(ClassHelperUtils.java:295)
        at intradoc.server.Service.doCodeEx(Service.java:637)
        at intradoc.server.Service.doCode(Service.java:592)
        at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1693)
        at intradoc.server.Service.doAction(Service.java:564)
        at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1483)
        at intradoc.server.Service.doActions(Service.java:559)
        at intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1415)
        at intradoc.server.Service.executeActions(Service.java:545)
        at intradoc.server.ServiceRequestImplementor.doRequest(ServiceRequestImplementor.java:751)
        at intradoc.server.Service.doRequest(Service.java:1974)
        at intradoc.server.ServiceManager.processCommand(ServiceManager.java:486)
        at intradoc.server.IdcServerThread.processRequest(IdcServerThread.java:265)
        at intradoc.idcwls.IdcServletRequestUtils.doRequest(IdcServletRequestUtils.java:1355)
        at intradoc.idcwls.IdcServletRequestUtils.processFilterEvent(IdcServletRequestUtils.java:1748)
        at intradoc.idcwls.IdcIntegrateWrapper.processFilterEvent(IdcIntegrateWrapper.java:223)
        at sun.reflect.GeneratedMethodAccessor555.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at idcservlet.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:87)
        at idcservlet.common.ClassHelperUtils.executeMethodEx(ClassHelperUtils.java:305)
        at idcservlet.common.ClassHelperUtils.executeMethodWithArgs(ClassHelperUtils.java:278)
        at idcservlet.ServletUtils.executeContentServerIntegrateMethodOnConfig(ServletUtils.java:1680)
        at idcservlet.IdcFilter.doFilter(IdcFilter.java:457)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
        at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
        at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
        at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
        at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
        at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at oracle.security.wls.filter.SSOSessionSynchronizationFilter.doFilter(SSOSessionSynchronizationFilter.java:418)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
        at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
        at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
        at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
        at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
        at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748)
        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)
        at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
        at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
        at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)
        at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)
        at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491)
        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
        at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

This is a very generic error. To better troubleshoot, we can turn on search* and systemdatabase tracing which reveals the following:

(!csDbUnableToExecuteCallableQuery,CotsSearchQuery!$ORA-20000: Oracle Text error:
DRG-50857: oracle error in ctx_query.result_set
ORA-20000: Oracle Text error:
DRG-13607: end_hit_num is not specified or out of valid range 1..2048

ORA-06512: at "CTXSYS.DRUE"\, line 160
ORA-06512: at "CTXSYS.CTX_QUERY"\, line 791
ORA-06512: at "SCCS_APP.CONTENT_SEARCH"\, line 116
ORA-06512: at line 1
)-exception stack
intradoc.data.DataException: !csDbUnableToExecuteCallableQuery,CotsSearchQuery!$ORA-20000: Oracle Text error:
DRG-50857: oracle error in ctx_query.result_set
ORA-20000: Oracle Text error:
DRG-13607: end_hit_num is not specified or out of valid range 1..2048

ORA-06512: at "CTXSYS.DRUE"\, line 160
ORA-06512: at "CTXSYS.CTX_QUERY"\, line 791
ORA-06512: at "SCCS_APP.CONTENT_SEARCH"\, line 116
ORA-06512: at line 1

OracleTextSearch previously had a limit of 2048 results. This is a database issue and thus requires a database patch. To fix this issue, download and apply patch 12582138. Note that Oracle Database 11.2.0.4 or higher has the patch included.

See these Oracle Support notes for more information:

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz