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

Last updated on MAY 01, 2017

Applies to:

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

Symptoms

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.


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