Application Development Software

Hi everyone,



I have an Oracle UCM installation of these characteristics:

UCM

Product version: 10.1.3.5.1 (110208)

Product compilation: 7.2.4.93

Original version: 7.1.0.2

Plattform: linux64



And the database:

Database type: Oracle

Database version: 11.1.0.7.0 ---Oracle Database 11g Enterprise Edition Release --- - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

Name of the search engine: ORACLETEXTSEARCH

Name of the index engine: ORACLETEXTSEARCH





The default result number is set to a 200 documents, but in the general configuration it is possible to change this parameter by the order:

“MaxResults=”





I want to see more than 200 documents every search, so that I have set “MaxResults=1500”, and precisely the system gives 1,500 documents,

but here is where the problems begin: because of UCM is not able to show more than 699 documents in the same page (up to 500 results per page there is no problem, above that value the problems start).







I think the problem is possible located with OracleTextSearch (some parameter or something):



When I show in the searchResult 694 result items in a result page in UCM (ResultCount=694) I have the response:

intradoc.common.ServiceException: !csOracleTextErrorExecutingQuery,idccontenttrue!csDbUnableToExecuteCallableQuery,CotsSearchQuery!$ORA-06502: PL/SQL: numerical or value error ORA-06512: at "ORAUCM.CONTENT_SEARCH"\, line 216 ORA-06512: at line 1.





There are these configuration's parameters in my system:

MaxResults=1500

MaxHitCount=500000



I would like not to have limits in the Search results.







Thanks.

PD: We thought the Core Update Bundle to UCM10gR35 will solve some of the bugs we have (if they can be called bugs) but it wouldn’t work.





Best regards