Getting Error--"There Were More Rows Than Could Be Returned. Please Refine Your Query"
(Doc ID 1337389.1)
Last updated on NOVEMBER 15, 2017
Applies to:Siebel ERM - Version 18.104.22.168  and later
Information in this document applies to any platform.
***Checked for relevance on 06 Oct 2014***
The Customer is trying to update 5,00,000 records in production when we run a Business Service. The Business Service will query on the Product Defect Business Component and it will process all the records to update a field.Nearly 5,00,000 records fetched in the query.It works fine till 10,000 records but when it processess 10001 record it gives below error:
"There were more rows than could be returned. Please refine your query to bring back fewer rows."
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|