My Oracle Support Banner

Essbase: Archive Database Fails after 15 minutes. (Doc ID 2450608.1)

Last updated on SEPTEMBER 24, 2018

Applies to:

Hyperion Essbase - Version 11.1.2.4.018 and later
Information in this document applies to any platform.

Symptoms

Running the below Maxl statement to back up the database fails after 15 minutes.

MAXL> alter database AppName.DbName archive to file '/Oracle/Middleware/user_projects/Backup/AppName_DbName.arc';

 OK/INFO - 1051061 - Application AppName loaded - connection established.
 OK/INFO - 1054027 - Application [AppName] started with process id [8522].
 OK/INFO - 1054014 - Database DbName loaded.
 OK/INFO - 1051702 - Back up in progress for [AppName.DbName] 10 % complete.
 OK/INFO - 1051702 - Back up in progress for [AppName.DbName] 20 % complete.
 OK/INFO - 1051702 - Back up in progress for [AppName.DbName] 30 % complete.
 OK/INFO - 1051702 - Back up in progress for [AppName.DbName] 40 % complete.
 OK/INFO - 1051702 - Back up in progress for [AppName.DbName] 50 % complete.
 OK/INFO - 1051702 - Back up in progress for [AppName.DbName] 60 % complete.
 OK/INFO - 1051702 - Back up in progress for [AppName.DbName] 70 % complete.
 OK/INFO - 1051702 - Back up in progress for [AppName.DbName] 80 % complete.
 OK/INFO - 1051702 - Back up in progress for [AppName.DbName] 90 % complete.
 OK/INFO - 1051702 - Back up in progress for [AppName.DbName] 100 % complete.
  ERROR - 1054067 - Internal error.

The application log has the below entries, which shows the application was unloaded exactly after 15 minutes but the backup was still in progress and writing to the '/Oracle/Middleware/user_projects/Backup/AppName_DbName.arc' file.


AppName.log

[Day Mon dd 23:17:24 YYYY]Local/AppName///140151142381376/Info(1013205)
Received Command [Get Database State]

[Day Mon dd 23:17:24 YYYY]Local/AppName///140151142381376/Info(1013205)
Received Command [Archive Database]

[Day Mon dd 23:17:24 YYYY]Local/AppName///140151142381376/Info(1019020)
Writing Free Space Information For Database [DbName]

[Day Mon dd 23:41:23 YYYY]Local/AppName///140150780716800/Info(1013437)
Unloading AppName [AppName] after staying idle for 15 minutes

[Day Mon dd 23:41:23 YYYY]Local/AppName///140150780716800/Info(1013399)
Canceling current requests.

[Day Mon dd 23:41:26 YYYY]Local/AppName///140150780716800/Info(1013207)
RECEIVED SHUTDOWN COMMAND - SERVER TERMINATING

 

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


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