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 NOVEMBER 15, 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

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
Cause
Solution
References


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.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.