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 JULY 12, 2017

Applies to:

Siebel Tools - Version 7.5.3.5 SIA [16183] and later
IBM AIX on POWER Systems (64-bit)
Product Release: V7 (Enterprise)
Version: 7.5.3.5 [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.


Symptoms

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.ClearToQuery();
bcCampCon.SetViewMode(AllView);
bcCampCon.ActivateField("Source Code");
// bcCampCon.SetSearchExpr("([Source Code] IS NULL)"); //defect 20804 , r7.5,PD --start/end
bcCampCon.ExecuteQuery();
var isRecord = bcCampCon.FirstRecord();

while(isRecord)
{
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();
Inputs.SetProperty("CampConId",ContactId);
svc.InvokeMethod("GeneratePriorityCode",Inputs,Outputs);
} //defect 20804 , r7.5,PD --start/end

isRecord = bcCampCon.NextRecord();
}


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