My Oracle Support Banner

Extract Data From Fusion GL Failed With Error "Exceeds The Limit [1000000] Set By The QUERYRESULTLIMIT" (Doc ID 2751166.1)

Last updated on APRIL 14, 2024

Applies to:

Oracle Planning and Budgeting Cloud Service - Version N/A and later
Oracle Financial Consolidation and Close Cloud Service - Version N/A and later
Oracle Enterprise Planning and Budgeting Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

On : 21.01.28 version, PBCS

The following error displays while loading the data from the source Fusion Application to target the PBCS application through Data Management


ERROR from the Process log
=================

INFO [AIF]: ExtractBalanceData:Error::Cannot perform cube view operation. Essbase Error(1200766): The number of query result cells exceeds the limit [1000000] set by the QUERYRESULTLIMIT configuration setting

FATAL [AIF]: Error in CommData.extractDataFromSource
Traceback (most recent call last):
File "<string>", line 2905, in extractDataFromSource
File "<string>", line 408, in executeFusionService
Exception: java.lang.Exception: Ess request has completed with errors.

FATAL [AIF]: Error in Comm Extract Data
INFO [AIF]: FDMEE Process End, Process ID: 72688

Changes

 

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


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