Validate Hyperion ESSBASE Database
Some time a corruption can be occured on Planning database for essbase application, the aim of this tuto is to show how to validate Essbase planning database when needed.
[oracle@hyperion essbaseserver1]$ pwd
/u01/EPM/Oracle/Middleware/user_projects/epmsystem1/EssbaseServer/essbaseserver1
[oracle@hyperion essbaseserver1]$ cd bin/
[oracle@hyperion bin]$ sh startEsscmd.sh
which: no startEsscmd.sh in (/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin)
Essbase Command Mode Interface 64-bit - Release 11.1.2 (ESB11.1.2.4.000B193)
Copyright (c) 1991, 2015, Oracle and/or its affiliates. All rights reserved.
U.S. Patent Number 5,359,724
U.S. Patent Number 6,317,750
:::[0]->login
Login:
Host Node >localhost
User >admin
Password >*********
[Wed Sep 26 19:41:02 2018]Local////Info(1051034)
Logging in user [admin@Native Directory]
Available Application Database:
PRODAPP ==> PRODPlan1
localhost:::admin[1]->select PRODAPP PRODPlan1
Select:
localhost:PRODAPP:PRODPlan1:admin[1]->validate
Validate:
Enter error log file name >./PRODPlan1_error2.log
Validate in progress (Hit <Esc> key to cancel).
[Wed Sep 26 19:41:27 2018]localhost/PRODAPP/PRODPlan1/admin/Info(1006078)
Invalid block header: Illegal block type -- Please restore from backup
[Wed Sep 26 19:41:27 2018]localhost/PRODAPP/PRODPlan1/admin/Info(1006078)
Invalid block header: Illegal block type -- Please restore from backup
[Wed Sep 26 19:41:27 2018]localhost/PRODAPP/PRODPlan1/admin/Info(1006078)
Invalid block header: Illegal block type -- Please restore from backup
[Wed Sep 26 19:41:27 2018]localhost/PRODAPP/PRODPlan1/admin/Error(1042013)
Network error [104]: Failed to receive data
[Wed Sep 26 19:41:27 2018]localhost/PRODAPP/PRODPlan1/admin/Error(1006032)
Invalid stored logical data block size [96].
Validate completed
sts = 1006032
Command Failed. Return Status = 1006032
localhost:PRODAPP:PRODPlan1:admin[1]->^C
[oracle@hyperion bin]$
Note: The file ./PRODPlan1_error2.log will give the errored combinations
