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

Last updated on MARCH 02, 2017

Applies to:

Siebel ERM - Version 7.8.2.3 [19221] and later
Information in this document applies to any platform.
***Checked for relevance on 06 Oct 2014***

Symptoms


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."

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms