12 Replies Latest reply on Apr 21, 2016 2:43 PM by 2983392

    Search results are getting displayed in Web UI but not from DIS

    2983392

      Hi,

       

      We are trying to execute the Search from DIS (In DIS, right click -> Search),then its not displaying any result in DIS, it says search complete and no results. Whereas it works fine in Web UI.

       

      Its giving the error:

      !csDbUnableToExecuteCallableQuery,CotsSearchQuery!$ORA-20000: Oracle Text error:


      Kindly advice us here.


      Thanks in advance!!

       

      Message was edited by: 2983392

        • 1. Re: Search results are getting displayed in DIS but not in Web UI
          amey g

          Hello,

           

          Are you sure search is working in /cs application and not in DIS..

           

          Please check MOS Doc ID (1332348.1)

           

          Ensure the new metadata data field shows up properly and is set to be searchable:

           

          1. Launch the Administration > Admin Applets > Configuration Manager Applet

          2. Ensure the 'Update Database Design' button is grayed out and the field 'XFILINGDATE' exists

          3. Select the metadata field XFILINGDATE on the 'Information Fields' tab and validate the settings

                A. Ensure that 'Searchable' field is set to 'Yes'. If this fields is not set to be Yes it will not work in the sort options.

                B. If this field should be indexed click 'Edit...' and check the box 'Enable for Search Index'

                C. Launch the Administration > Admin Applets > Repository manager > Indexer tab

                D. Start the Full Collection Rebuild cycle

                (Note: With OTS you can perform a fast rebuild or a complete rebuild.  The complete rebuild can take a while depending on how much content is in the system.)

          4. Test searching on the field 'XFILINGDATE'.

           

           

          Please enable search* and systemdatabase full verbose trace and collect the logs from system audit information.


          Thanks,

          Amey

          • 2. Re: Search results are getting displayed in DIS but not in Web UI
            Srinath Menon-Oracle

            Its giving the error:

            !csDbUnableToExecuteCallableQuery,CotsSearchQuery!$ORA-20000: Oracle Text error:

            Does this error show up in content server logs when the search is done from DIS ? In that case please provide the following details :

             

            1. DIS Client  version - copy it from Client - About

             

            2. Content server version - copy it from administration - configuration information - version .

             

            3. Add requestaudit,search*,task*.system*  + full verbose and update .

             

            Clear the server output and then run the same search .

             

            Refresh server output and copy the logs to a text file , upload it here .

            • 3. Re: Re: Search results are getting displayed in DIS but not in Web UI
              2983392

              Hi Srinath,

               

              Thanks for reply, please find attached details as requested..

               

              This issue exists only when we search from DIS, in native ui search work fine with it provides correct results.

               

              Content Server error:

              Error4/17/16 7:12 AMEvent generated by user 'extrpo' at host 'ver-icanet-dms.ica.ia-hc.net'. Error occurred while processing. Unable to return results. [ Details]
              An error has occurred. The stack trace below shows more information. !csUserEventMessage,extrpo,ver-icanet-dms.ica.ia-hc.net!$!csSearchUnableToReturnResults intradoc.common.ServiceException: !csSearchUnableToReturnResults *ScriptStack GET_SEARCH_RESULTS 3:getSearchResults,**no captured values** at intradoc.server.SearchManager.retrieveSearchInfoAsBinder(SearchManager.java:297) at intradoc.server.SearchService.retrieveSearchInfo(SearchService.java:2004) at intradoc.server.SearchService.doLocalSearch(SearchService.java:1472) at intradoc.server.SearchService.getSearchResults(SearchService.java:706) at sun.reflect.GeneratedMethodAccessor1383.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) 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:639) at intradoc.server.Service.doCode(Service.java:594) at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1693) at intradoc.server.Service.doAction(Service.java:566) at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1483) at intradoc.server.Service.doActions(Service.java:561) at intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1415) at intradoc.server.Service.executeActions(Service.java:547) at intradoc.server.ServiceRequestImplementor.doRequest(ServiceRequestImplementor.java:751) at intradoc.server.Service.doRequest(Service.java:1976) 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.GeneratedMethodAccessor286.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) 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:1696) at idcservlet.IdcFilter.doFilter(IdcFilter.java:457) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119) at java.security.AccessController.doPrivileged(Native Method) 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 oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119) at java.security.AccessController.doPrivileged(Native Method) 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 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) 

               

               

              System Audit Info:

              >requestaudit/6 04.17 07:11:25.935     IdcServer-3484 GET_USERS_DOCPROFILES [dUser=extrpo][IsJava=1] 0.01913600042462349(secs)
              >requestaudit/6 04.17 07:11:26.254     IdcServer-3485 GET_DOC_PAGE [Page=CAPTURE_QUERY_PAGE][dUser=extrpo] 0.16233499348163605(secs)
              >requestaudit/6 04.17 07:11:27.277     IdcServer-3498 GET_PERSONALIZED_JAVASCRIPT [dUser=extrpo] 0.0446540005505085(secs)
              >requestaudit/6 04.17 07:11:44.323     IdcServer-3511 WEBDAV_PROPFIND [dUser=extrpo][dSecurityGroup=S1] 0.6090620160102844(secs)
              >requestaudit/6 04.17 07:11:44.973     IdcServer-3512 WEBDAV_OPTIONS [dUser=extrpo] 0.011269000358879566(secs)
              >searchquery/7 04.17 07:11:45.129     IdcServer-3513 Query by extrpo from ver-icanet-dms.ica.ia-hc.net
              >searchquery/6 04.17 07:11:45.133     IdcServer-3513 preparedQueryText: dDocType <matches> `ICA_GEN_1`  <AND>  xParentFolders <contains> `21F879B572B607A1913987123FD5A570 FLD_ROOT` <AND> zxClbraUserList <contains> ``
              >searchquery/6 04.17 07:11:45.134     IdcServer-3513 Setting substr to other operator conv flag: 'dDocType <matches> `ICA_GEN_1`  <AND>  xParentFolders <contains> `21F879B572B607A1913987123FD5A570 FLD_ROOT` <AND> zxClbraUserList <contains> ``'
              >searchqueryparse/6    04.17 07:11:45.134     IdcServer-3513 Into parse of UniversalSearchQuery for: dDocType <matches> `ICA_GEN_1`  <AND>  xParentFolders <contains> `21F879B572B607A1913987123FD5A570 FLD_ROOT` <AND> zxClbraUserList <contains> ``
              >searchqueryparse/6    04.17 07:11:45.134     IdcServer-3513 Into parseQueryEx of UniversalSearchQueryParser for queryArr : dDocType <matches> `ICA_GEN_1`  <AND>  xParentFolders <contains> `21F879B572B607A1913987123FD5A570 FLD_ROOT` <AND> zxClbraUserList <contains> ``
              >searchquery/6 04.17 07:11:45.134     IdcServer-3513 Parsing universal query: 'dDocType <matches> `ICA_GEN_1`  <AND>  xParentFolders <contains> `21F879B572B607A1913987123FD5A570 FLD_ROOT` <AND> zxClbraUserList <contains> ``'
              >searchquery/6 04.17 07:11:45.134     IdcServer-3513 Processing callback on query value 'ICA_GEN_1'
              >searchqueryparse/6    04.17 07:11:45.134     IdcServer-3513 Into appendClauseElement CommonSearchConfig with operator : equals value : ICA_GEN_1
              >searchqueryparse/6    04.17 07:11:45.134     IdcServer-3513 Processing actions list size : 1 on the input value : ICA_GEN_1 with searchengine ORACLETEXTSEARCH
              >searchqueryparse/6    04.17 07:11:45.134     IdcServer-3513 Processing action number : 0 : escape on the input value : ICA_GEN_1 with searchengine ORACLETEXTSEARCH
              >searchqueryparse/6    04.17 07:11:45.134     IdcServer-3513 Processed escape with '' resulting in value :ICA_GEN_1
              >searchqueryparse/6    04.17 07:11:45.134     IdcServer-3513 Processed escape with _ resulting in value :ICA_GEN_1
              >searchqueryparse/6    04.17 07:11:45.135     IdcServer-3513 Processed escape with \- resulting in value :ICA_GEN_1
              >searchqueryparse/6    04.17 07:11:45.135     IdcServer-3513 Processed escape with \_ resulting in value :ICA\_GEN\_1
              >searchqueryparse/6    04.17 07:11:45.135     IdcServer-3513 Processed escape with \, resulting in value :ICA\_GEN\_1
              >searchqueryparse/6    04.17 07:11:45.135     IdcServer-3513 Processed escape with \= resulting in value :ICA\_GEN\_1
              >searchqueryparse/6    04.17 07:11:45.135     IdcServer-3513 Into appendClauseElement CommonSearchConfig with operator : and value : 
              >searchquery/6 04.17 07:11:45.135     IdcServer-3513 Processing callback on query value '21F879B572B607A1913987123FD5A570 FLD_ROOT'
              >searchqueryparse/6    04.17 07:11:45.135     IdcServer-3513 Into appendClauseElement CommonSearchConfig with operator : hasAsWord value : 21F879B572B607A1913987123FD5A570 FLD_ROOT
              >searchqueryparse/6    04.17 07:11:45.135     IdcServer-3513 Processing actions list size : 1 on the input value : 21F879B572B607A1913987123FD5A570 FLD_ROOT with searchengine ORACLETEXTSEARCH
              >searchqueryparse/6    04.17 07:11:45.135     IdcServer-3513 Processing action number : 0 : escape on the input value : 21F879B572B607A1913987123FD5A570 FLD_ROOT with searchengine ORACLETEXTSEARCH
              >searchqueryparse/6    04.17 07:11:45.135     IdcServer-3513 Processed escape with '' resulting in value :21F879B572B607A1913987123FD5A570 FLD_ROOT
              >searchqueryparse/6    04.17 07:11:45.135     IdcServer-3513 Processed escape with _ resulting in value :21F879B572B607A1913987123FD5A570 FLD_ROOT
              >searchqueryparse/6    04.17 07:11:45.135     IdcServer-3513 Processed escape with \- resulting in value :21F879B572B607A1913987123FD5A570 FLD_ROOT
              >searchqueryparse/6    04.17 07:11:45.136     IdcServer-3513 Processed escape with \_ resulting in value :21F879B572B607A1913987123FD5A570 FLD\_ROOT
              >searchqueryparse/6    04.17 07:11:45.136     IdcServer-3513 Processed escape with \, resulting in value :21F879B572B607A1913987123FD5A570 FLD\_ROOT
              >searchqueryparse/6    04.17 07:11:45.136     IdcServer-3513 Processed escape with \= resulting in value :21F879B572B607A1913987123FD5A570 FLD\_ROOT
              >searchqueryparse/6    04.17 07:11:45.136     IdcServer-3513 Into appendClauseElement CommonSearchConfig with operator : and value : 
              >searchquery/6 04.17 07:11:45.136     IdcServer-3513 Processing callback on query value 'idcnull'
              >searchqueryparse/6    04.17 07:11:45.136     IdcServer-3513 Into appendClauseElement CommonSearchConfig with operator : hasAsWord value : idcnull
              >searchqueryparse/6    04.17 07:11:45.136     IdcServer-3513 Processing actions list size : 1 on the input value : idcnull with searchengine ORACLETEXTSEARCH
              >searchqueryparse/6    04.17 07:11:45.136     IdcServer-3513 Processing action number : 0 : escape on the input value : idcnull with searchengine ORACLETEXTSEARCH
              >searchqueryparse/6    04.17 07:11:45.136     IdcServer-3513 Processed escape with '' resulting in value :idcnull
              >searchqueryparse/6    04.17 07:11:45.136     IdcServer-3513 Processed escape with _ resulting in value :idcnull
              >searchqueryparse/6    04.17 07:11:45.136     IdcServer-3513 Processed escape with \- resulting in value :idcnull
              >searchqueryparse/6    04.17 07:11:45.136     IdcServer-3513 Processed escape with \_ resulting in value :idcnull
              >searchqueryparse/6    04.17 07:11:45.137     IdcServer-3513 Processed escape with \, resulting in value :idcnull
              >searchqueryparse/6    04.17 07:11:45.137     IdcServer-3513 Processed escape with \= resulting in value :idcnull
              >searchquery/6 04.17 07:11:45.137     IdcServer-3513 Converted native query: ' ((ICA\_GEN\_1) WITHIN dDocType)   and   ((21F879B572B607A1913987123FD5A570 FLD\_ROOT) WITHIN xParentFolders)   and   ((idcnull) WITHIN zxClbraUserList) '
              >searchquery/7 04.17 07:11:45.137     IdcServer-3513 assigning connection
              >searchquery/6 04.17 07:11:45.137     IdcServer-3513 !csMonitorActiveDbConnections,1
              >searchquery/6 04.17 07:11:45.137     IdcServer-3513 Connection is added to active connections with key of '[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)''.
              >searchquery/6 04.17 07:11:45.137     IdcServer-3513 query(live): (((((ICA\_GEN\_1) WITHIN dDocType)   and   ((21F879B572B607A1913987123FD5A570 FLD\_ROOT) WITHIN xParentFolders)   and   ((idcnull) WITHIN zxClbraUserList)))) [1,20000] sort(dInDate Desc)
              >search/7      04.17 07:11:45.146     IdcServer-3513        !csDbUnableToExecuteCallableQuery,CotsSearchQuery!$ORA-20000: Oracle Text error:
               search/7      04.17 07:11:45.146     IdcServer-3513 DRG-50857: oracle error in ctx_query.result_set
               search/7      04.17 07:11:45.146     IdcServer-3513 ORA-20000: Oracle Text error:
               search/7      04.17 07:11:45.146     IdcServer-3513 DRG-13607: end_hit_num is not specified or out of valid range 1..16000
               search/7      04.17 07:11:45.146     IdcServer-3513 
               search/7      04.17 07:11:45.146     IdcServer-3513 ORA-06512: at "CTXSYS.DRUE"\, line 160
               search/7      04.17 07:11:45.146     IdcServer-3513 ORA-06512: at "CTXSYS.CTX_QUERY"\, line 800
               search/7      04.17 07:11:45.146     IdcServer-3513 ORA-06512: at "DMS07_OCS_2.CONTENT_SEARCH"\, line 125
               search/7      04.17 07:11:45.146     IdcServer-3513 ORA-06512: at "DMS07_OCS_2.CONTENT_SEARCH"\, line 320
               search/7      04.17 07:11:45.146     IdcServer-3513 ORA-06512: at line 1
               search/7      04.17 07:11:45.146     IdcServer-3513 exception backtrace:intradoc.data.DataException: !csDbUnableToExecuteCallableQuery,CotsSearchQuery!$ORA-20000: Oracle Text error:
               search/7      04.17 07:11:45.146     IdcServer-3513 DRG-50857: oracle error in ctx_query.result_set
               search/7      04.17 07:11:45.146     IdcServer-3513 ORA-20000: Oracle Text error:
               search/7      04.17 07:11:45.146     IdcServer-3513 DRG-13607: end_hit_num is not specified or out of valid range 1..16000
               search/7      04.17 07:11:45.146     IdcServer-3513 
               search/7      04.17 07:11:45.146     IdcServer-3513 ORA-06512: at "CTXSYS.DRUE"\, line 160
               search/7      04.17 07:11:45.146     IdcServer-3513 ORA-06512: at "CTXSYS.CTX_QUERY"\, line 800
               search/7      04.17 07:11:45.146     IdcServer-3513 ORA-06512: at "DMS07_OCS_2.CONTENT_SEARCH"\, line 125
               search/7      04.17 07:11:45.146     IdcServer-3513 ORA-06512: at "DMS07_OCS_2.CONTENT_SEARCH"\, line 320
               search/7      04.17 07:11:45.146     IdcServer-3513 ORA-06512: at line 1
               search/7      04.17 07:11:45.146     IdcServer-3513 
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2680)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.jdbc.JdbcWorkspace.executeCallable(JdbcWorkspace.java:609)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.search.OracleTextSearchImplementor.doQuery(OracleTextSearchImplementor.java:221)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.search.CommonSearchConnection.doQuery(CommonSearchConnection.java:158)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.SearchManager.retrieveSearchInfoAsBinder(SearchManager.java:224)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.SearchService.retrieveSearchInfo(SearchService.java:2004)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.SearchService.doLocalSearch(SearchService.java:1472)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.SearchService.getSearchResults(SearchService.java:706)
               search/7      04.17 07:11:45.146     IdcServer-3513         at sun.reflect.GeneratedMethodAccessor1383.invoke(Unknown Source)
               search/7      04.17 07:11:45.146     IdcServer-3513         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
               search/7      04.17 07:11:45.146     IdcServer-3513         at java.lang.reflect.Method.invoke(Method.java:606)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:86)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.common.ClassHelperUtils.executeMethodEx(ClassHelperUtils.java:310)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.common.ClassHelperUtils.executeMethod(ClassHelperUtils.java:295)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.Service.doCodeEx(Service.java:639)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.Service.doCode(Service.java:594)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1693)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.Service.doAction(Service.java:566)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1483)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.Service.doActions(Service.java:561)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1415)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.Service.executeActions(Service.java:547)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.ServiceRequestImplementor.doRequest(ServiceRequestImplementor.java:751)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.Service.doRequest(Service.java:1976)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.ServiceManager.processCommand(ServiceManager.java:486)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.IdcServerThread.processRequest(IdcServerThread.java:265)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.idcwls.IdcServletRequestUtils.doRequest(IdcServletRequestUtils.java:1355)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.idcwls.IdcServletRequestUtils.processFilterEvent(IdcServletRequestUtils.java:1732)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.idcwls.IdcIntegrateWrapper.processFilterEvent(IdcIntegrateWrapper.java:223)
               search/7      04.17 07:11:45.146     IdcServer-3513         at sun.reflect.GeneratedMethodAccessor286.invoke(Unknown Source)
               search/7      04.17 07:11:45.146     IdcServer-3513         ... 35 more
              >search/6      04.17 07:11:45.147     IdcServer-3513 Masking status message '!csDbUnableToExecuteCallableQuery,CotsSearchQuery!$ORA-20000: Oracle Text error:
               search/6      04.17 07:11:45.147     IdcServer-3513 DRG-50857: oracle error in ctx_query.result_set
               search/6      04.17 07:11:45.147     IdcServer-3513 ORA-20000: Oracle Text error:
               search/6      04.17 07:11:45.147     IdcServer-3513 DRG-13607: end_hit_num is not specified or out of valid range 1..16000
               search/6      04.17 07:11:45.147     IdcServer-3513 
               search/6      04.17 07:11:45.147     IdcServer-3513 ORA-06512: at "CTXSYS.DRUE"\, line 160
               search/6      04.17 07:11:45.147     IdcServer-3513 ORA-06512: at "CTXSYS.CTX_QUERY"\, line 800
               search/6      04.17 07:11:45.147     IdcServer-3513 ORA-06512: at "DMS07_OCS_2.CONTENT_SEARCH"\, line 125
               search/6      04.17 07:11:45.147     IdcServer-3513 ORA-06512: at "DMS07_OCS_2.CONTENT_SEARCH"\, line 320
               search/6      04.17 07:11:45.147     IdcServer-3513 ORA-06512: at line 1
               
              >searchquery/6 04.17 07:11:45.147     IdcServer-3513 !csMonitorActiveDbConnections,0
              >searchquery/6 04.17 07:11:45.147     IdcServer-3513 Connection is removed from active connections with key of '[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)''.
              >searchquery/6 04.17 07:11:45.147     IdcServer-3513 release pool connection
              >services/3    04.17 07:11:45.148     IdcServer-3513 !csUserEventMessage,extrpo,ver-icanet-dms.ica.ia-hc.net!$ intradoc.common.ServiceException: !csSearchUnableToReturnResults
               services/3    04.17 07:11:45.148     IdcServer-3513 *ScriptStack GET_SEARCH_RESULTS
               services/3    04.17 07:11:45.148     IdcServer-3513 3:getSearchResults,**no captured values**
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.SearchManager.retrieveSearchInfoAsBinder(SearchManager.java:297)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.SearchService.retrieveSearchInfo(SearchService.java:2004)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.SearchService.doLocalSearch(SearchService.java:1472)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.SearchService.getSearchResults(SearchService.java:706)
               services/3    04.17 07:11:45.148     IdcServer-3513         at sun.reflect.GeneratedMethodAccessor1383.invoke(Unknown Source)
               services/3    04.17 07:11:45.148     IdcServer-3513         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
               services/3    04.17 07:11:45.148     IdcServer-3513         at java.lang.reflect.Method.invoke(Method.java:606)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:86)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.common.ClassHelperUtils.executeMethodEx(ClassHelperUtils.java:310)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.common.ClassHelperUtils.executeMethod(ClassHelperUtils.java:295)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.Service.doCodeEx(Service.java:639)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.Service.doCode(Service.java:594)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1693)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.Service.doAction(Service.java:566)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1483)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.Service.doActions(Service.java:561)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1415)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.Service.executeActions(Service.java:547)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.ServiceRequestImplementor.doRequest(ServiceRequestImplementor.java:751)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.Service.doRequest(Service.java:1976)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.ServiceManager.processCommand(ServiceManager.java:486)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.IdcServerThread.processRequest(IdcServerThread.java:265)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.idcwls.IdcServletRequestUtils.doRequest(IdcServletRequestUtils.java:1355)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.idcwls.IdcServletRequestUtils.processFilterEvent(IdcServletRequestUtils.java:1732)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.idcwls.IdcIntegrateWrapper.processFilterEvent(IdcIntegrateWrapper.java:223)
               services/3    04.17 07:11:45.148     IdcServer-3513         at sun.reflect.GeneratedMethodAccessor286.invoke(Unknown Source)
               services/3    04.17 07:11:45.148     IdcServer-3513         ... 35 more
              >requestaudit/6 04.17 07:11:45.186     IdcServer-3513 GET_SEARCH_RESULTS [dUser=extrpo][QueryText= ((ICA\_GEN\_1) WITHIN dDocType)   and   ((21F879B572B607A1913987123FD5A570 FLD\_ROOT) WITHIN xParentFolders)   and   ((idcnull) WITHIN zxClbraUserList) ][StatusCode=-1][StatusMessage=Unable to retrieve search results. Error occurred while processing. Unable to return results.][IsJava=1] 0.0833360031247139(secs)

              >requestaudit/6       04.17 07:11:46.052    IdcServer-3514        WEBDAV_PROPFIND [dUser=extrpo][dSecurityGroup=S1] 0.5484910011291504(secs)

              Content Server Error:

                  

              Error

              4/17/16   7:12 AM

              Event generated by user 'extrpo' at host 'ver-icanet-dms.ica.ia-hc.net'. Error   occurred while processing. Unable to return results. [ Details ]

              An error   has occurred. The stack trace below shows more information.

               

              !csUserEventMessage,extrpo,ver-icanet-dms.ica.ia-hc.net!$!csSearchUnableToReturnResults

              intradoc.common.ServiceException:   !csSearchUnableToReturnResults

              *ScriptStack   GET_SEARCH_RESULTS

              3:getSearchResults,**no   captured values**

                      at   intradoc.server.SearchManager.retrieveSearchInfoAsBinder(SearchManager.java:297)

                      at   intradoc.server.SearchService.retrieveSearchInfo(SearchService.java:2004)

                      at   intradoc.server.SearchService.doLocalSearch(SearchService.java:1472)

                      at   intradoc.server.SearchService.getSearchResults(SearchService.java:706)

                      at   sun.reflect.GeneratedMethodAccessor1383.invoke(Unknown Source)

                      at   sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                      at   java.lang.reflect.Method.invoke(Method.java:606)

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

                      at   intradoc.server.Service.doCode(Service.java:594)

                      at   intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1693)

                      at intradoc.server.Service.doAction(Service.java:566)

                      at   intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1483)

                      at   intradoc.server.Service.doActions(Service.java:561)

                      at   intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1415)

                      at   intradoc.server.Service.executeActions(Service.java:547)

                      at   intradoc.server.ServiceRequestImplementor.doRequest(ServiceRequestImplementor.java:751)

                      at   intradoc.server.Service.doRequest(Service.java:1976)

                      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.GeneratedMethodAccessor286.invoke(Unknown   Source)

                      at   sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                      at   java.lang.reflect.Method.invoke(Method.java:606)

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

                      at   idcservlet.IdcFilter.doFilter(IdcFilter.java:457)

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

                      at   oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)

                      at   java.security.AccessController.doPrivileged(Native Method)

                      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   oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)

                      at   java.security.AccessController.doPrivileged(Native Method)

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

               
               
              System Audit Information:
              >requestaudit/6 04.17 07:11:08.239     IdcServer-3479 CLEAR_SERVER_OUTPUT [dUser=extrpo] 0.08147300034761429(secs)
              >requestaudit/6 04.17 07:11:08.478     IdcServer-3480 GET_SERVER_OUTPUT [dUser=extrpo] 0.024132000282406807(secs)
              >requestaudit/6 04.17 07:11:12.470     IdcServer-3481 WEBDAV_PROPFIND [dUser=extrpo][dSecurityGroup=S1] 0.6157360076904297(secs)
              >requestaudit/6 04.17 07:11:25.484     IdcServer-3482 WEBDAV_PROPFIND [dUser=extrpo] 2.4882659912109375(secs)
              >requestaudit/6 04.17 07:11:25.745     IdcServer-3483 DESKTOP_GET_DOC_CONFIG_INFO [dID=0][dUser=extrpo][IsJava=1] 0.03607400134205818(secs)
              >requestaudit/6 04.17 07:11:25.935     IdcServer-3484 GET_USERS_DOCPROFILES [dUser=extrpo][IsJava=1] 0.01913600042462349(secs)
              >requestaudit/6 04.17 07:11:26.254     IdcServer-3485 GET_DOC_PAGE [Page=CAPTURE_QUERY_PAGE][dUser=extrpo] 0.16233499348163605(secs)
              >requestaudit/6 04.17 07:11:27.277     IdcServer-3498 GET_PERSONALIZED_JAVASCRIPT [dUser=extrpo] 0.0446540005505085(secs)
              >requestaudit/6 04.17 07:11:44.323     IdcServer-3511 WEBDAV_PROPFIND [dUser=extrpo][dSecurityGroup=S1] 0.6090620160102844(secs)
              >requestaudit/6 04.17 07:11:44.973     IdcServer-3512 WEBDAV_OPTIONS [dUser=extrpo] 0.011269000358879566(secs)
              >searchquery/7 04.17 07:11:45.129     IdcServer-3513 Query by extrpo from ver-icanet-dms.ica.ia-hc.net
              >searchquery/6 04.17 07:11:45.133     IdcServer-3513 preparedQueryText: dDocType <matches> `ICA_GEN_1`  <AND>  xParentFolders <contains> `21F879B572B607A1913987123FD5A570 FLD_ROOT` <AND> zxClbraUserList <contains> ``
              >searchquery/6 04.17 07:11:45.134     IdcServer-3513 Setting substr to other operator conv flag: 'dDocType <matches> `ICA_GEN_1`  <AND>  xParentFolders <contains> `21F879B572B607A1913987123FD5A570 FLD_ROOT` <AND> zxClbraUserList <contains> ``'
              >searchqueryparse/6    04.17 07:11:45.134     IdcServer-3513 Into parse of UniversalSearchQuery for: dDocType <matches> `ICA_GEN_1`  <AND>  xParentFolders <contains> `21F879B572B607A1913987123FD5A570 FLD_ROOT` <AND> zxClbraUserList <contains> ``
              >searchqueryparse/6    04.17 07:11:45.134     IdcServer-3513 Into parseQueryEx of UniversalSearchQueryParser for queryArr : dDocType <matches> `ICA_GEN_1`  <AND>  xParentFolders <contains> `21F879B572B607A1913987123FD5A570 FLD_ROOT` <AND> zxClbraUserList <contains> ``
              >searchquery/6 04.17 07:11:45.134     IdcServer-3513 Parsing universal query: 'dDocType <matches> `ICA_GEN_1`  <AND>  xParentFolders <contains> `21F879B572B607A1913987123FD5A570 FLD_ROOT` <AND> zxClbraUserList <contains> ``'
              >searchquery/6 04.17 07:11:45.134     IdcServer-3513 Processing callback on query value 'ICA_GEN_1'
              >searchqueryparse/6    04.17 07:11:45.134     IdcServer-3513 Into appendClauseElement CommonSearchConfig with operator : equals value : ICA_GEN_1
              >searchqueryparse/6    04.17 07:11:45.134     IdcServer-3513 Processing actions list size : 1 on the input value : ICA_GEN_1 with searchengine ORACLETEXTSEARCH
              >searchqueryparse/6    04.17 07:11:45.134     IdcServer-3513 Processing action number : 0 : escape on the input value : ICA_GEN_1 with searchengine ORACLETEXTSEARCH
              >searchqueryparse/6    04.17 07:11:45.134     IdcServer-3513 Processed escape with '' resulting in value :ICA_GEN_1
              >searchqueryparse/6    04.17 07:11:45.134     IdcServer-3513 Processed escape with _ resulting in value :ICA_GEN_1
              >searchqueryparse/6    04.17 07:11:45.135     IdcServer-3513 Processed escape with \- resulting in value :ICA_GEN_1
              >searchqueryparse/6    04.17 07:11:45.135     IdcServer-3513 Processed escape with \_ resulting in value :ICA\_GEN\_1
              >searchqueryparse/6    04.17 07:11:45.135     IdcServer-3513 Processed escape with \, resulting in value :ICA\_GEN\_1
              >searchqueryparse/6    04.17 07:11:45.135     IdcServer-3513 Processed escape with \= resulting in value :ICA\_GEN\_1
              >searchqueryparse/6    04.17 07:11:45.135     IdcServer-3513 Into appendClauseElement CommonSearchConfig with operator : and value : 
              >searchquery/6 04.17 07:11:45.135     IdcServer-3513 Processing callback on query value '21F879B572B607A1913987123FD5A570 FLD_ROOT'
              >searchqueryparse/6    04.17 07:11:45.135     IdcServer-3513 Into appendClauseElement CommonSearchConfig with operator : hasAsWord value : 21F879B572B607A1913987123FD5A570 FLD_ROOT
              >searchqueryparse/6    04.17 07:11:45.135     IdcServer-3513 Processing actions list size : 1 on the input value : 21F879B572B607A1913987123FD5A570 FLD_ROOT with searchengine ORACLETEXTSEARCH
              >searchqueryparse/6    04.17 07:11:45.135     IdcServer-3513 Processing action number : 0 : escape on the input value : 21F879B572B607A1913987123FD5A570 FLD_ROOT with searchengine ORACLETEXTSEARCH
              >searchqueryparse/6    04.17 07:11:45.135     IdcServer-3513 Processed escape with '' resulting in value :21F879B572B607A1913987123FD5A570 FLD_ROOT
              >searchqueryparse/6    04.17 07:11:45.135     IdcServer-3513 Processed escape with _ resulting in value :21F879B572B607A1913987123FD5A570 FLD_ROOT
              >searchqueryparse/6    04.17 07:11:45.135     IdcServer-3513 Processed escape with \- resulting in value :21F879B572B607A1913987123FD5A570 FLD_ROOT
              >searchqueryparse/6    04.17 07:11:45.136     IdcServer-3513 Processed escape with \_ resulting in value :21F879B572B607A1913987123FD5A570 FLD\_ROOT
              >searchqueryparse/6    04.17 07:11:45.136     IdcServer-3513 Processed escape with \, resulting in value :21F879B572B607A1913987123FD5A570 FLD\_ROOT
              >searchqueryparse/6    04.17 07:11:45.136     IdcServer-3513 Processed escape with \= resulting in value :21F879B572B607A1913987123FD5A570 FLD\_ROOT
              >searchqueryparse/6    04.17 07:11:45.136     IdcServer-3513 Into appendClauseElement CommonSearchConfig with operator : and value : 
              >searchquery/6 04.17 07:11:45.136     IdcServer-3513 Processing callback on query value 'idcnull'
              >searchqueryparse/6    04.17 07:11:45.136     IdcServer-3513 Into appendClauseElement CommonSearchConfig with operator : hasAsWord value : idcnull
              >searchqueryparse/6    04.17 07:11:45.136     IdcServer-3513 Processing actions list size : 1 on the input value : idcnull with searchengine ORACLETEXTSEARCH
              >searchqueryparse/6    04.17 07:11:45.136     IdcServer-3513 Processing action number : 0 : escape on the input value : idcnull with searchengine ORACLETEXTSEARCH
              >searchqueryparse/6    04.17 07:11:45.136     IdcServer-3513 Processed escape with '' resulting in value :idcnull
              >searchqueryparse/6    04.17 07:11:45.136     IdcServer-3513 Processed escape with _ resulting in value :idcnull
              >searchqueryparse/6    04.17 07:11:45.136     IdcServer-3513 Processed escape with \- resulting in value :idcnull
              >searchqueryparse/6    04.17 07:11:45.136     IdcServer-3513 Processed escape with \_ resulting in value :idcnull
              >searchqueryparse/6    04.17 07:11:45.137     IdcServer-3513 Processed escape with \, resulting in value :idcnull
              >searchqueryparse/6    04.17 07:11:45.137     IdcServer-3513 Processed escape with \= resulting in value :idcnull
              >searchquery/6 04.17 07:11:45.137     IdcServer-3513 Converted native query: ' ((ICA\_GEN\_1) WITHIN dDocType)   and   ((21F879B572B607A1913987123FD5A570 FLD\_ROOT) WITHIN xParentFolders)   and   ((idcnull) WITHIN zxClbraUserList) '
              >searchquery/7 04.17 07:11:45.137     IdcServer-3513 assigning connection
              >searchquery/6 04.17 07:11:45.137     IdcServer-3513 !csMonitorActiveDbConnections,1
              >searchquery/6 04.17 07:11:45.137     IdcServer-3513 Connection is added to active connections with key of '[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)''.
              >searchquery/6 04.17 07:11:45.137     IdcServer-3513 query(live): (((((ICA\_GEN\_1) WITHIN dDocType)   and   ((21F879B572B607A1913987123FD5A570 FLD\_ROOT) WITHIN xParentFolders)   and   ((idcnull) WITHIN zxClbraUserList)))) [1,20000] sort(dInDate Desc)
              >search/7      04.17 07:11:45.146     IdcServer-3513        !csDbUnableToExecuteCallableQuery,CotsSearchQuery!$ORA-20000: Oracle Text error:
               search/7      04.17 07:11:45.146     IdcServer-3513 DRG-50857: oracle error in ctx_query.result_set
               search/7      04.17 07:11:45.146     IdcServer-3513 ORA-20000: Oracle Text error:
               search/7      04.17 07:11:45.146     IdcServer-3513 DRG-13607: end_hit_num is not specified or out of valid range 1..16000
               search/7      04.17 07:11:45.146     IdcServer-3513 
               search/7      04.17 07:11:45.146     IdcServer-3513 ORA-06512: at "CTXSYS.DRUE"\, line 160
               search/7      04.17 07:11:45.146     IdcServer-3513 ORA-06512: at "CTXSYS.CTX_QUERY"\, line 800
               search/7      04.17 07:11:45.146     IdcServer-3513 ORA-06512: at "DMS07_OCS_2.CONTENT_SEARCH"\, line 125
               search/7      04.17 07:11:45.146     IdcServer-3513 ORA-06512: at "DMS07_OCS_2.CONTENT_SEARCH"\, line 320
               search/7      04.17 07:11:45.146     IdcServer-3513 ORA-06512: at line 1
               search/7      04.17 07:11:45.146     IdcServer-3513  exception backtrace:intradoc.data.DataException: !csDbUnableToExecuteCallableQuery,CotsSearchQuery!$ORA-20000: Oracle Text error:
               search/7      04.17 07:11:45.146     IdcServer-3513 DRG-50857: oracle error in ctx_query.result_set
               search/7      04.17 07:11:45.146     IdcServer-3513 ORA-20000: Oracle Text error:
               search/7      04.17 07:11:45.146     IdcServer-3513 DRG-13607: end_hit_num is not specified or out of valid range 1..16000
               search/7      04.17 07:11:45.146     IdcServer-3513 
               search/7      04.17 07:11:45.146     IdcServer-3513 ORA-06512: at "CTXSYS.DRUE"\, line 160
               search/7      04.17 07:11:45.146     IdcServer-3513 ORA-06512: at "CTXSYS.CTX_QUERY"\, line 800
               search/7      04.17 07:11:45.146     IdcServer-3513 ORA-06512: at "DMS07_OCS_2.CONTENT_SEARCH"\, line 125
               search/7      04.17 07:11:45.146     IdcServer-3513 ORA-06512: at "DMS07_OCS_2.CONTENT_SEARCH"\, line 320
               search/7      04.17 07:11:45.146     IdcServer-3513 ORA-06512: at line 1
               search/7      04.17 07:11:45.146     IdcServer-3513 
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2680)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.jdbc.JdbcWorkspace.executeCallable(JdbcWorkspace.java:609)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.search.OracleTextSearchImplementor.doQuery(OracleTextSearchImplementor.java:221)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.search.CommonSearchConnection.doQuery(CommonSearchConnection.java:158)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.SearchManager.retrieveSearchInfoAsBinder(SearchManager.java:224)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.SearchService.retrieveSearchInfo(SearchService.java:2004)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.SearchService.doLocalSearch(SearchService.java:1472)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.SearchService.getSearchResults(SearchService.java:706)
               search/7      04.17 07:11:45.146     IdcServer-3513         at sun.reflect.GeneratedMethodAccessor1383.invoke(Unknown Source)
               search/7      04.17 07:11:45.146     IdcServer-3513         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
               search/7      04.17 07:11:45.146     IdcServer-3513         at java.lang.reflect.Method.invoke(Method.java:606)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:86)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.common.ClassHelperUtils.executeMethodEx(ClassHelperUtils.java:310)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.common.ClassHelperUtils.executeMethod(ClassHelperUtils.java:295)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.Service.doCodeEx(Service.java:639)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.Service.doCode(Service.java:594)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1693)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.Service.doAction(Service.java:566)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1483)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.Service.doActions(Service.java:561)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1415)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.Service.executeActions(Service.java:547)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.ServiceRequestImplementor.doRequest(ServiceRequestImplementor.java:751)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.Service.doRequest(Service.java:1976)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.ServiceManager.processCommand(ServiceManager.java:486)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.server.IdcServerThread.processRequest(IdcServerThread.java:265)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.idcwls.IdcServletRequestUtils.doRequest(IdcServletRequestUtils.java:1355)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.idcwls.IdcServletRequestUtils.processFilterEvent(IdcServletRequestUtils.java:1732)
               search/7      04.17 07:11:45.146     IdcServer-3513         at intradoc.idcwls.IdcIntegrateWrapper.processFilterEvent(IdcIntegrateWrapper.java:223)
               search/7      04.17 07:11:45.146     IdcServer-3513         at sun.reflect.GeneratedMethodAccessor286.invoke(Unknown Source)
               search/7      04.17 07:11:45.146     IdcServer-3513         ... 35 more
              >search/6      04.17 07:11:45.147     IdcServer-3513 Masking status message '!csDbUnableToExecuteCallableQuery,CotsSearchQuery!$ORA-20000: Oracle Text error:
               search/6      04.17 07:11:45.147     IdcServer-3513 DRG-50857: oracle error in ctx_query.result_set
               search/6      04.17 07:11:45.147     IdcServer-3513 ORA-20000: Oracle Text error:
               search/6      04.17 07:11:45.147     IdcServer-3513 DRG-13607: end_hit_num is not specified or out of valid range 1..16000
               search/6      04.17 07:11:45.147     IdcServer-3513 
               search/6      04.17 07:11:45.147     IdcServer-3513 ORA-06512: at "CTXSYS.DRUE"\, line 160
               search/6      04.17 07:11:45.147     IdcServer-3513 ORA-06512: at "CTXSYS.CTX_QUERY"\, line 800
               search/6      04.17 07:11:45.147     IdcServer-3513 ORA-06512: at "DMS07_OCS_2.CONTENT_SEARCH"\, line 125
               search/6      04.17 07:11:45.147     IdcServer-3513 ORA-06512: at "DMS07_OCS_2.CONTENT_SEARCH"\, line 320
               search/6      04.17 07:11:45.147     IdcServer-3513 ORA-06512: at line 1
               
              >searchquery/6 04.17 07:11:45.147     IdcServer-3513 !csMonitorActiveDbConnections,0
              >searchquery/6 04.17 07:11:45.147     IdcServer-3513 Connection is removed from active connections with key of '[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)''.
              >searchquery/6 04.17 07:11:45.147     IdcServer-3513 release pool connection
              >services/3    04.17 07:11:45.148     IdcServer-3513 !csUserEventMessage,extrpo,ver-icanet-dms.ica.ia-hc.net!$ intradoc.common.ServiceException: !csSearchUnableToReturnResults
               services/3    04.17 07:11:45.148     IdcServer-3513 *ScriptStack GET_SEARCH_RESULTS
               services/3    04.17 07:11:45.148     IdcServer-3513 3:getSearchResults,**no captured values**
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.SearchManager.retrieveSearchInfoAsBinder(SearchManager.java:297)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.SearchService.retrieveSearchInfo(SearchService.java:2004)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.SearchService.doLocalSearch(SearchService.java:1472)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.SearchService.getSearchResults(SearchService.java:706)
               services/3    04.17 07:11:45.148     IdcServer-3513         at sun.reflect.GeneratedMethodAccessor1383.invoke(Unknown Source)
               services/3    04.17 07:11:45.148     IdcServer-3513         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
               services/3    04.17 07:11:45.148     IdcServer-3513         at java.lang.reflect.Method.invoke(Method.java:606)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:86)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.common.ClassHelperUtils.executeMethodEx(ClassHelperUtils.java:310)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.common.ClassHelperUtils.executeMethod(ClassHelperUtils.java:295)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.Service.doCodeEx(Service.java:639)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.Service.doCode(Service.java:594)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1693)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.Service.doAction(Service.java:566)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1483)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.Service.doActions(Service.java:561)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1415)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.Service.executeActions(Service.java:547)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.ServiceRequestImplementor.doRequest(ServiceRequestImplementor.java:751)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.Service.doRequest(Service.java:1976)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.ServiceManager.processCommand(ServiceManager.java:486)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.server.IdcServerThread.processRequest(IdcServerThread.java:265)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.idcwls.IdcServletRequestUtils.doRequest(IdcServletRequestUtils.java:1355)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.idcwls.IdcServletRequestUtils.processFilterEvent(IdcServletRequestUtils.java:1732)
               services/3    04.17 07:11:45.148     IdcServer-3513         at intradoc.idcwls.IdcIntegrateWrapper.processFilterEvent(IdcIntegrateWrapper.java:223)
               services/3    04.17 07:11:45.148     IdcServer-3513         at sun.reflect.GeneratedMethodAccessor286.invoke(Unknown Source)
               services/3    04.17 07:11:45.148     IdcServer-3513         ... 35 more
              >requestaudit/6 04.17 07:11:45.186     IdcServer-3513 GET_SEARCH_RESULTS [dUser=extrpo][QueryText= ((ICA\_GEN\_1) WITHIN dDocType)   and   ((21F879B572B607A1913987123FD5A570 FLD\_ROOT) WITHIN xParentFolders)   and   ((idcnull) WITHIN zxClbraUserList) ][StatusCode=-1][StatusMessage=Unable to retrieve search results. Error occurred while processing. Unable to return results.][IsJava=1] 0.0833360031247139(secs)
              >requestaudit/6 04.17 07:11:46.052     IdcServer-3514 WEBDAV_PROPFIND [dUser=extrpo][dSecurityGroup=S1] 0.5484910011291504(secs)

               

              • 4. Re: Re: Search results are getting displayed in DIS but not in Web UI
                2983392

                Hi Amey,

                 

                Yes, verified new metadata field 'hasUAL' and it is set to searchable.

                we have performed Full collection rebuild 2 weeks back,

                Search with this metadata works fine in Native UI, it provides correct results.

                When performed search from DIS, search form displays correctly but when we click on search results were not returned to DIS.

                 

                System Audit and content server error I have attached,

                Please let us know your inputs

                 

                Thanks,

                • 5. Re: Search results are getting displayed in Web UI but not from DIS
                  Srinath Menon-Oracle

                  search/7      04.17 07:11:45.146     IdcServer-3513 DRG-13607: end_hit_num is not specified or out of valid range 1..16000

                  The core reason for this error is that OracleText engine can list out total results <= 16000 and if the result set has more values this error shows up .

                  This is an expected behavior since the db side has it capped at 16000 .

                   

                  Secondly, are you using the same search query from DIS and Web ui and seeing this error ?

                   

                  I would suggest you to download the latest DIS client from My content server -my downloads and install it and then test .

                  • 6. Re: Search results are getting displayed in Web UI but not from DIS
                    2983392

                    Thanks for your reply.

                     

                    Yes, we are using the same query for DIS and Web UI. We are seeing this error in DIS UAT envt(we have recently introduced a new metadata in UAT envt) whereas, we do not get this error in Production envt.

                    For example: We have a folder, when we did Search from Web UI we got 3 results whereas in DIS its not displaying any result.

                     

                    Could you please suggest what can be done here.

                    • 7. Re: Search results are getting displayed in Web UI but not from DIS
                      Srinath Menon-Oracle
                      We are seeing this error in DIS UAT envt(we have recently introduced a new metadata in UAT envt)

                      Not sure if a new metadata can show this error but in that case you can try to run the Fast rebuild and then test.

                      • 8. Re: Search results are getting displayed in Web UI but not from DIS
                        2983392

                        We have done the Fast rebuild, still it is not working

                        • 9. Re: Search results are getting displayed in Web UI but not from DIS
                          Srinath Menon-Oracle

                          Can we have a web conference to check the exact set of steps that is causing the issue ?

                           

                          My e-mail address is in the profile information .

                          • 10. Re: Search results are getting displayed in Web UI but not from DIS
                            2983392

                            Thank you so much Srinath.

                             

                            I am not able to find your mail id. Could you please tell us your free time and mail ID. We will show our error to you through webex.

                             

                            Thanks alot !!!

                            • 11. Re: Search results are getting displayed in Web UI but not from DIS
                              Srinath Menon-Oracle

                              The issue was related to MaxResults variable which was set in this environment to 20000 , where as the ots maximum is 16000. This variable is passed along with the search query (from DIS), hence the issue shows up from DIS.