Hyperion Essbase (MOSC)

MOSC Banner

Essbase Data load job Failed intermittently

edited Dec 22, 2017 4:01AM in Hyperion Essbase (MOSC) 1 commentAnswered

Hi All,

Our Load jobs scheduled via batch process in order to populate data into Essbase cubes Using ODI as Staging.The job failed intermittently during the execution of below maxl statement

MAXL> create or replace application 'OUTLOOKT' using aggregate_storage as 'OUTLOOK1' comment 'BACKUP';

while executing the same maxl script we are getting diff kind of error message for diff runs and the errors are listed below:

Error1:

essmsh error: Not logged in to Essbase

Error in creating temporary application OUTLOOKT from OUTLOOK1

Error2:

  ERROR - 1013268 - Cannot copy application [OUTLOOK1] while [DL522@CITILDAP] is performing [SpreadsheetOperation] on database [Pearldb].

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center