My Oracle Support Banner

Unable to Retrieve Search Results Error when more than 16,000 Content Items are Returned in the Search Results (Doc ID 1924260.1)

Last updated on OCTOBER 10, 2017

Applies to:

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

Symptoms

In Universal Content Manager UCM) 11g, and error occurs when more than 16,000 content items are returned in the search results.

Once such a search is executed, pages 1 through 800 (20 items per page displayed) are returned in the search results, but when the next page is selected, (801,802..) the following error occurs:

"Content Server Request Failed
Error Unable to retrieve search results. Error occurred while processing. Unable to return results."

 Tracing will show something like this:

>systemdatabase/6 10.09 12:10:39.570 IdcServer-406631 !csDbUnableToExecuteCallableQuery,CotsSearchQuery!$ORA-20000: Oracle Text error:
systemdatabase/6 10.09 12:10:39.570 IdcServer-406631 DRG-50857: oracle error in ctx_query.result_set
systemdatabase/6 10.09 12:10:39.570 IdcServer-406631 ORA-20000: Oracle Text error:
systemdatabase/6 10.09 12:10:39.570 IdcServer-406631 DRG-13607: end_hit_num is not specified or out of valid range 1..16000
systemdatabase/6 10.09 12:10:39.570 IdcServer-406631
systemdatabase/6 10.09 12:10:39.570 IdcServer-406631 ORA-06512: at "CTXSYS.DRUE"\, line 160
systemdatabase/6 10.09 12:10:39.570 IdcServer-406631 ORA-06512: at "CTXSYS.CTX_QUERY"\, line 800
systemdatabase/6 10.09 12:10:39.570 IdcServer-406631 ORA-06512: at "STELLENT.CONTENT_SEARCH"\, line 123
systemdatabase/6 10.09 12:10:39.570 IdcServer-406631 ORA-06512: at line 1

>systemdatabase/6 10.09 12:10:39.571 IdcServer-406631 run: 1.53 ms. total 4.21 ms. [ORA-20000: Oracle Text error:
systemdatabase/6 10.09 12:10:39.571 IdcServer-406631 DRG-50857: oracle error in ctx_query.result_set
systemdatabase/6 10.09 12:10:39.571 IdcServer-406631 ORA-20000: Oracle Text error

 

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!


In this Document
Symptoms
Cause
Solution
References


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