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 JANUARY 19, 2024
Applies to:
Siebel Tools - Version 7.5.3.5 SIA [16183] and laterIBM AIX on POWER Systems (64-bit)
Product Release: V7 (Enterprise)
Version: 7.5.3.5 [16183]
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
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 ...
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |