Quote Line Items and Ungroup Method, Error: There were more rows than could be returned. Please refine your query to bring back fewer rows (SBL-DAT-00500) (Doc ID 530979.1)

Last updated on OCTOBER 01, 2016

Applies to:

Siebel eConfigurator - Version 7.8.2 SIA [19213] and later
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise) and above
Observed Version: 7.8.2.3 [19221] ITA Engy/Oil
Database: Oracle 10.2.0.2
Application Server OS: Microsoft Windows 2003 Server SP1
Database Server OS: IBM AIX 5L 5.2

This document was previously published as Siebel SR 38-3305653901.
***Checked for relevance on 01/10/2016***

Symptoms

A customer was experiencing a problem when dealing with a huge number of quote items, each on them containing several components of customizable products.
Users encounter an error when invoking the "Ungroup" method from applet menu.
The error states that:

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

Given that they cannot simplify the involved query, they tried to implement the following suggestions:

1) At business component (BC) level set "Maximum Cursor Size" = -1
2) Within application cfg file (when testing with dedicated client) set: MaxCursorSize = -1

But, in spite of this, the user keeps on getting that error.

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