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:

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

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