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 07, 2020
Applies to:Siebel Tools - Version 126.96.36.199 SIA  and later
IBM AIX on POWER Systems (64-bit)
Product Release: V7 (Enterprise)
Version: 188.8.131.52 
""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
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 ...
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