My Oracle Support Banner

WebCenter Content data retrieval exception when retrieving a large number of records (results sets >12K) (Doc ID 2378830.1)

Last updated on MARCH 26, 2018

Applies to:

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

Symptoms

WebCenter Content data retrieval via RIDC - exception when retrieving large number of records.

The following exception is raised when using RIDC to access records from Webcenter Content for large result sets (>12K).

After a successful query, the RIDC statement: DataBinder responseBinder = serviceResponse.getResponseAsBinder(); is called iteratively to retrieve 2000 records at a time.

After 6 calls (~12K records), the next call fails with the following exception:

intradoc.common.ServiceException: !csJdbcGenericError
  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.GeneratedMethodAccessor145.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:639)
  at intradoc.server.Service.doCode(Service.java:594)
  at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1693)
...

Smaller result sets (<12K) work fine without error.

Performing the same query via the Webcenter Content interface also proceeds without error.

Changes

 

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.