Last updated on AUGUST 31, 2016
Applies to:Siebel Assignment Manager - Version 18.104.22.1685  and later
z*OBSOLETE: Microsoft Windows NT Terminal Server
Version: 22.214.171.1245 
Database: Oracle 8.1.7
Application Server OS: Microsoft Windows NT Server 4.0
Database Server OS: HP-UX 11.0
This document was previously published as Siebel SR 38-1228150911.
On Siebel recommendation, we had made an alternate Data Source for our Appointment Booking Engin component, and for that Data Source made the DSMaxFetchArraySize parameter to -1.
In the Appointment Booking Engine Component Parameters we have defined the Application DataSource to ServerDataSrcABS, which is the alternate Data Source having the DSMaxFetchArraySize parameter set to -1.
This should ensure that whenever the enivronment is recycler or ABS is reloaded, then we should not face a problem if the number of Activities in a service region returned are more than 10,000.
Now, we are facing a problem when the environment is recycled or the ABS is reloaded. In the log file we found that the error that its saying :
GenericLog GenericError 1 2004-03-20 10:07:21 There were more rows than could be returned. Please refine your query to bring back fewer rows
Execution Error 1 2004-03-20 10:07:27 [SLSC1012] There were more rows than could be returned. Please refine your query to bring back fewer rows
Execution Trace 3 2004-03-20 10:07:27 Service region '1-982-13' loaded.
Execution Trace 3 2004-03-20 10:07:27 Loading service region '1-982-15' ...
GenericLog GenericError 1 2004-03-20 10:08:22 There were more rows than could be returned. Please refine your query to bring back fewer rows
I am attaching some of the logs also for your perusal.
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