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 laterOracle 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 |