1 Reply Latest reply on Feb 7, 2019 3:03 PM by jose.bedoya

    UCM 11.1.1.5 Error Searching 'ScriptStack GET_SEARCH_RESULTS'

    3739854

      we saw the case (Doc ID 1341076.1) that has the same error but our configuration is correct and no change has been made lately

       

       

      We have ORACLE WEBCENTER CONTENT 11.1.1.8.0-2013-07-11 17:07:21Z-r106802 (Versión Interna:7.3.5.185)

       

       

      The file config.cfg have the next configuration SearchIndexerEngineName=OracleTextSearch

       

       

      The Administration page > Configuration for (Instance Name). have the next configuration

      Motor de Búsqueda::ORACLETEXTSEARCH

      Nombre del Motor de Indexación:ORACLETEXTSEARCH

      Índice Activo:ots1

       

       

      We have the next two folders

      /u01/oracle/Oracle/Middleware/user_projects/domains/webcenter_domain/ucm/cs/search/ots1 (created today)

      /u01/oracle/Oracle/Middleware/user_projects/domains/webcenter_domain/ucm/cs/search/IdcColl1 (created on 11/07/2015)

       

       

      The error is the next

      Se ha producido un error. El rastreo de pila siguiente muestra más información.

      !csUserEventMessage,weblogic,10.0.0.136:16200!$!csJdbcGenericError

      intradoc.common.ServiceException: !csJdbcGenericError

      *ScriptStack GET_SEARCH_RESULTS

      3:getSearchResults,**no captured values**

              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.GeneratedMethodAccessor192.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:1732)

              at intradoc.idcwls.IdcIntegrateWrapper.processFilterEvent(IdcIntegrateWrapper.java:223)

              at sun.reflect.GeneratedMethodAccessor155.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.webdav.WebdavFilter.doFilter(WebdavFilter.java:174)

              at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

              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:56)

              at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)

              at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

              at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)

              at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)

              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:2273)

              at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)

              at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)

              at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)

              at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

        • 1. Re: UCM 11.1.1.5 Error Searching 'ScriptStack GET_SEARCH_RESULTS'
          jose.bedoya

          Hola, en estos casos es pereferible habilitar la auditoria del sistema. Esto se puede hacer por Administración > Información de Auditoría del Sistema.

           

          Habilita las siguientes opciones:

           

          Probablemente sea algún problema de base de datos, lo primero que hay que descartar son errores de base de datos, es fácil porque es solo buscar con el navegador texto que empiece con "ORA-" (Sin las comillas).

           

          Revisa también que no se hayan ejecutado reconstrucciones del índice o modificaciones de los campos optimizados.

           

          Si es posbile comparte la traza de auditoría.