My Oracle Support Banner

SBL-DAT-00500: "There were more rows than could be returned" error received when running a BS Method (Doc ID 524329.1)

Last updated on OCTOBER 03, 2018

Applies to:

Siebel Tools - Version 7.5.3.3 SIA [16172] and later
Oracle Solaris on SPARC (64-bit)
Product Release: V7 (Enterprise)
""Checked for Relevance on 10-June-2014""


Symptoms

Received the following error when running a Business Service Method from a Repeating Component Request in Production:

SBL-DAT-00500: "There were more rows than could be returned. Please refine your query to bring back fewer rows."

Checked SupportWeb and found similar posting (e.g. ALERT 951), however, this was due to the use of ForwardBackward ExecuteQuery method.

In this case, the ForwardOnly ExecuteQuery method is being used, which should not even utilise the DSMaxFetchArraySize parameter and therefore should not limit the number of records retrieved. This message is generated when attempting to fetch over 200,000 records to process by the Business Service method.

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.