My Oracle Support Banner

QueryPage Method on the EAI Siebel Adapter Fails With "There were more rows than could be returned. Please refine your query to bring back fewer rows (SBL-DAT-00500)" (Doc ID 1059092.1)

Last updated on AUGUST 05, 2020

Applies to:

Siebel CRM - Version 8.0 [20405] and later
Information in this document applies to any platform.

Symptoms

Publish functionality uses the QueryPage method on the EAI Siebel Adapter to retrieve data from the Siebel database. Pagesize is set to 25. On a particular day there were more than 18000 records to retrieve. When QueryPage reached page 6 it failed with an error.

Error:
-------
(adptutils.cpp (5614)) SBL-EAI-04376: Method 'NextRecord' of business component 'Personal Address' (integration component 'Personal Address') returned the following error:
"There were more rows than could be returned. Please refine your query to bring back fewer rows(SBL-DAT-00500)"


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.