Error "Cannot perform cube view operation. Essbase Error(1024015): Request [MdxReport] from user [xxxxx] was terminated by an admin user" When Exporting Data from Source
(Doc ID 2971692.1)
Last updated on SEPTEMBER 01, 2023
Applies to:
Oracle Enterprise Performance Management FreeForm Cloud Service - Version 22.02.63 and laterInformation in this document applies to any platform.
Symptoms
When exporting data from from source, the export takes many hours and failed with an error "Cannot perform cube view operation. Essbase Error(1024015): Request [MdxReport] from user [xxxxxx] was terminated by an admin user"
The process log shows the below MDX query taking lot time.
EXPORT INTO FILE "FDMEE-5634" OVERWRITE USING COLUMNDELIMITER ","
SELECT {[Period].[Apr]} ON COLUMNS,NON EMPTY {CROSSJOIN({Descendants([Product].[Product],[Product].Levels(0))},CROSSJOIN({Descendants([Account].[xxxxxxx],[Account].Levels(0))},CROSSJOIN({Descendants([Company].[Company],[Company].Levels(0))},CROSSJOIN({Descendants([Department].[Department],[Department].Levels(0))},CROSSJOIN({Descendants([Currency].[Currency],[Currency].Levels(0))},CROSSJOIN({Descendants([Scenario].[Scenario],[Scenario].Levels(0))},CROSSJOIN({Descendants([Country].[Country],[Country].Levels(0))},CROSSJOIN({Descendants([Sub Account].[Sub Account],[Sub Account].Levels(0))},CROSSJOIN({Descendants([Interco].[Interco],[Interco].Levels(0))},CROSSJOIN({Descendants([Year].[Year],[Year].Levels(0))},{Descendants([View].[View],[View].Levels(0))}))))))))))} ON ROWS FROM SYMTAX54.SYMTAX
After few hours, it may fail with the below error.
[Date] 03:00:15,438 ERROR [AIF]: Cannot perform cube view operation. Essbase Error(1024015): Request [MdxReport] from user [xxxxx] was terminated by an admin user
[Date] 03:00:15,453 INFO [AIF]: EssbaseService.extractData - END (false)
[Date] 03:00:15,463 DEBUG [AIF]: AIFUtil.callOdiServlet - END
[Date] 03:00:15,465 FATAL [AIF]: Error in CommData.extractDataFromSource
Traceback (most recent call last):
File "<string>", line 2862, in extractDataFromSource
RuntimeError: false
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 |