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)
Last updated on OCTOBER 01, 2016
Applies to:Siebel eConfigurator - Version 7.8.2 SIA  and later
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise) and above
Observed Version: 18.104.22.168  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***
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms