Essbase Data load job Failed intermittently
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].