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 MARCH 02, 2017

Applies to:

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

Symptoms


Environment:
-------------------
Product: Siebel CRM
Version: 8.0 [20405]
OS platform: Microsoft Windows (32-bit)
DB platform: Oracle Server - Enterprise Edition
Env: Development

Statement of Issue:
-----------------------------
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)"

Business Impact:
-------------------------
The publish functionality did not complete correctly. Resolving this behavior is critical as the code will be frozen shortly.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms