My Oracle Support Banner

SBL-DAT-00500: "There were more rows than could be returned. Please refine your query to bring back (Doc ID 533660.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Siebel Tools - Version SIA [16183] and later
IBM AIX on POWER Systems (64-bit)
Product Release: V7 (Enterprise)
Version: [16183]
""Checked for Relevance on 29-FEB-2016""
Database: IBM DB2 8.1 FixPack 3
Application Server OS: IBM AIX 5L 5.1
Database Server OS: IBM AIX 5L 5.1

This document was previously published as Siebel SR 38-1558305681.


There is an escript written on campaign Buscomp where it retrieves a record from campaign list contact and execute custom logic to generate unique code for every record for every contact. The code gets executed successfully for first 10k records and for 100001 records it error out saying

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

Cannot refine the query to return less then 10K records.

Above error was observed in the GUI which has more than 10K records. The script written on Campaign BC is follows and there is no way we can refine the query to limit less records ...

if ((FieldName == "Generate Priority Code")&& (FieldValue == "Y"))
var bcCampCon = this.BusObject().GetBusComp("Campaign List Contact");

bcCampCon.ActivateField("Source Code");
// bcCampCon.SetSearchExpr("([Source Code] IS NULL)"); //defect 20804 , r7.5,PD --start/end
var isRecord = bcCampCon.FirstRecord();

SourceCode = bcCampCon.GetFieldValue("Source Code");//defect 20804 , r7.5,PD --start
if(SourceCode.length !=8)
{ //defect 20804 , r7.5,PD --end
ContactId = bcCampCon.GetFieldValue("Id");
svc = TheApplication().GetService("IBM DBM Priority Code");
Inputs = TheApplication().NewPropertySet();
Outputs = TheApplication().NewPropertySet();
} //defect 20804 , r7.5,PD --start/end

isRecord = bcCampCon.NextRecord();


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

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