My Oracle Support Banner

Need to use ForwardOnly query In EAI Siebel Adapter operation on child IC (Doc ID 951812.1)

Last updated on DECEMBER 04, 2020

Applies to:

Siebel CRM - Version 6.0.1 [2848] 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.


To view full details, 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 a vibrant support community of peers and Oracle experts.