My Oracle Support Banner

Getting Error--"There Were More Rows Than Could Be Returned. Please Refine Your Query" (Doc ID 1337389.1)

Last updated on DECEMBER 24, 2019

Applies to:

Siebel ERM - Version [19221] 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.