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

Last updated on SEPTEMBER 21, 2023

Applies to:

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.

Cause

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