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 FEBRUARY 14, 2022
Applies to:
Siebel CRM - Version 8.0 [20405] and laterInformation 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 |