Error SBL-DAT-00500 Occurring When Using ExecuteQuery2 Method With IgnoreMaxCursorSize Parameter Set To TRUE (Doc ID 2030981.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 8.1.1.5 SIA [21229] and later
Information in this document applies to any platform.

Symptoms

Version: 8.1.1.5

Issue: ExecuteQuery2 is not working as documented in Bookshelf

Error: SBL-DAT-00500 There were more rows that could be returned.

Steps:

1. Ensure you have more than 10000 Account records in the database.
2. Create a test business service with below script:

function Service_PreInvokeMethod (MethodName, Inputs, Outputs)
{
if(MethodName == "Test ExecuteQuery")
{
TheApplication().TraceOn("C:\\trace.txt", "Allocation", "All");
var boAccount = TheApplication().GetBusObject("Account");
var bcAccount = boAccount.GetBusComp("Account");
bcAccount.ClearToQuery();
bcAccount.ActivateField("Name");
bcAccount.SetViewMode(AllView);
bcAccount.SetSortSpec("Name");
bcAccount.ExecuteQuery2(ForwardBackward,"TRUE");
var VRecord = bcAccount.FirstRecord();
while(VRecord)
{
TheApplication().Trace("Account Name: " +bcAccount.GetFieldValue("Name"));
VRecord = bcAccount.NextRecord();
}
bcAccount=null;
boAccount=null;
TheApplication().TraceOff();
return(CancelOperation);
}
return (ContinueOperation);
}

3. run the BS in simulator

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