Essbase: Archive Database Fails after 15 minutes.
(Doc ID 2450608.1)
Last updated on MAY 18, 2022
Applies to:
Hyperion Essbase - Version 11.1.2.4.018 and laterInformation 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
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 |