Getting Error--"There Were More Rows Than Could Be Returned. Please Refine Your Query"
Last updated on NOVEMBER 15, 2017
Applies to:Siebel ERM - Version 22.214.171.124  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."
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms