My Oracle Support Banner

Siebel 18.10 - Maximum Cursor Size Parameter Is Being Ignored For Action BC (Doc ID 2525229.1)

Last updated on APRIL 02, 2023

Applies to:

Siebel CRM - Version 18.10 and later
Information in this document applies to any platform.

Symptoms

The BC level parameter Maximum Cursor Size does not seems to work. It has been set at 15000, but the application fails with error after fetching 10,000 records.

ERROR
-----------------------
SBL-DAT-00500: There were more rows than could be returned. Please refine your query to bring back fewer rows


STEPS
-----------------------
1) Executing a script from Business service Simulator add over 15,000 records to Action business component.
2. After all records have been created, go to Home Page 

Alert : SBL-DAT-00500: There were more rows than could be returned. Please refine your query to bring back fewer rows

3) Now set the Maximum Cursor Size at the action BC to 20,000.

Still the error can be seen at the home page. 


 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.