Need to use ForwardOnly query In EAI Siebel Adapter operation on child IC
Last updated on APRIL 30, 2018
Applies to:Siebel CRM - Version 6.0.1  and later
Information in this document applies to any platform.
The error: "SBL-DAT-00500 There were more rows than could be returned. Please refine your query to bring back fewer rows" was reported by EAI Siebel Adapter Upsert operation even when input SiebelMessage included only ONE child Integration Component instance.
The "MaxCursorSize" and "PrefetchSize" Data Source parameters were with default values. The "Maximum Cursor Size" and "PreFetch Size" properties of the Business Component (on which the Integration Component was based) were not defined.
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