My Oracle Support Banner

Siebel ABS Fails With Error "There were more rows than could be returned. Please refine your query to bring back fewer rows" (Doc ID 537364.1)

Last updated on JULY 21, 2020

Applies to:

Siebel Assignment Manager - Version 7.0.4.305 [14190] and later
z*OBSOLETE: Microsoft Windows NT Terminal Server
Version: 7.0.4.305 [14190]

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.

Symptoms

On Siebel recommendation, 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  defined the Application DataSource to ServerDataSrcABS, which is the alternate Data Source having the DSMaxFetchArraySize parameter set to -1.

This ensures that whenever the environment is recycled or ABS is reloaded, should not face a problem if the number of Activities in a service region returned are more than 10,000.

Facing a problem when the environment is recycled or the ABS is reloaded. In the log file 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




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!


In this Document
Symptoms
Changes
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.