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  and later
Information in this document applies to any platform.
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.
(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)"
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