Error Running Search And Setting OTSSortFields (Doc ID 2248386.1)

Last updated on MARCH 28, 2017

Applies to:

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

Symptoms

Error when running a search using OTSSortFields
Event generated by user 'bravoperma' at host 'cueaq01.city.a.ottawa.ca:16301'. Error
occurred while retrying the search query. Error occurred while processing. Unable to
return results. [ Details ]
An error has occurred. The stack trace below shows more information.
!csUserEventMessage,bravoperma,cueaq01.city.a.ottawa.ca:16301!$!csSearchRetryFailed!$!csSearchU
nableToReturnResults
intradoc.common.ServiceException:
*ScriptStack GET_SEARCH_RESULTS
3:getSearchResults,**no captured values**
       at recordsmanagement.RmaSearchService.getSearchResults(RmaSearchService.java:117)
       at sun.reflect.GeneratedMethodAccessor1432.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:643)
       at reportpublisher.RPServiceHandler.getSearchResults(RPServiceHandler.java:184)
       at sun.reflect.GeneratedMethodAccessor1431.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.executeMethodReportStatus(ClassHelperUtils.java:324)
       at intradoc.server.ServiceHandler.executeAction(ServiceHandler.java:79)
       at intradoc.server.Service.doCodeEx(Service.java:626)
       at intradoc.server.Service.doCode(Service.java:598)
       at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1762)
       at intradoc.server.Service.doAction(Service.java:570)
       at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1552)
       at intradoc.server.Service.doActions(Service.java:565)
       at
intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1484)
       at intradoc.server.Service.executeActions(Service.java:551)
       at intradoc.server.ServiceRequestImplementor.doRequest(ServiceRequestImplementor.java:760)
       at intradoc.server.Service.doRequest(Service.java:1999)
       at intradoc.server.ServiceManager.processCommand(ServiceManager.java:520)
       at intradoc.server.IdcServerThread.processRequest(IdcServerThread.java:359)
       at intradoc.idcwls.IdcServletRequestUtils.doRequest(IdcServletRequestUtils.java:1360)
       at intradoc.idcwls.IdcServletRequestUtils.processFilterEvent(IdcServletRequestUtils.java:1748)
       at intradoc.idcwls.IdcIntegrateWrapper.processFilterEvent(IdcIntegrateWrapper.java:223)
       at sun.reflect.GeneratedMethodAccessor173.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
       at java.lang.reflect.Method.invoke(Method.java:606)

 

Can also be reproduced via these steps after archive deletion of content:

  1. Add the variable OTSSortFields in the config.cfg file, configuration section OTSSortFields=dDocName,dDocTitle,dDocAuthor,dReleaseDate
  2. Restart content server
  3. Run search, it works
  4. Using archiver, delete records from the system (export)
  5. Run search, it works
  6. Rebuild the index (collection rebuild cycle)
  7. Run the search and it fails

 

 

 

 

Changes

 

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