Make sure that the following environment variables are set correctly:
ARBORPATH
(PC and UNIX)PATH
(PC and UNIX)LD_LIBRARY_PATH
(UNIX only) If Analytic Services is installed in the default location, set the variables as follows:
PATH=C:\ESSBASE\BIN
ARBORPATH=C:\ESSBASE
ARBORMSGPATH=C:\ESSBASE\BIN
path=/home/hyperion/essbase/bin
ARBORPATH=/home/hyperion/essbase
LD_LIBRARY_PATH=$ARBORPATH/bin:$ARBORPATH/dlls:$ARBORPATH/api/lib
arbormsgpath=/home/hyperion/essbase/binFor other environment variables, see the Analytic Services Installation
Guide.
Check to see if the database is corrupt.
To fix a corrupt database, try the following:
If the database is still corrupt:
$ARBORPATH/app/applicationName/databaseName/databaseName.esm$ARBORPATH/app/applicationName/databaseName/databaseName.ind$ARBORPATH/app/applicationName/databaseName/databaseName.tct$ARBORPATH/app/applicationName/databaseName/essXXXXX.ind$ARBORPATH/app/applicationName/databaseName/essXXXXX.pag$ARBORPATH/app/applicationName/databaseName/databaseName.esn$ARBORPATH/app/applicationName/databaseName/databaseName.inn$ARBORPATH/app/applicationName/databaseName/databaseName.otm$ARBORPATH/app/applicationName/databaseName/databaseName.otn$ARBORPATH/app/applicationName/databaseName/databaseName.tcu$ARBORPATH/app/applicationName/databaseName/essXXXXX.inn$ARBORPATH/app/applicationName/databaseName/essXXXXX.pan$ARBORPATH/app/applicationName/databaseName/essXXXXX.tmpIf you are on a UNIX computer using the Korn shell, check the user limit
profile using the ulimit -a command. If you are using another
shell, check the flags for the limit command by typing man
limit or man ulimit.
ulimit -d unlimited
command. ulimit
-v unlimited command.ulimit -n 1024 command. If possible, set the file descriptor
limit to unlimited..profile
or .cshrc file.Increasing the values for NETDELAY and NETRETRYCOUNT can solve network problems. To set NETDELAY and NETRETRYCOUNT:
$ARBORPATH/bin/essbase.cfg
file on the server computer and client computer in the $ARBORPATH\bin
directory, create one using a text editor.$ARBORPATH/bin/essbase.cfg
file on the server computer and the client computer, set NETDELAY
to at least 800.$ARBORPATH/bin/essbase.cfg
file on the server computer and the client computer, set NETRETRYCOUNT
to at least 1000.If you cannot stop Analytic Server using the standard method, consult the following list:
ps -ef |grep ESS
kill -9 process idAfter you end the server task, follow the procedures for an abnormal
shutdown.
Users lock objects while performing some operations on them. If an object that you need is locked, try the following solutions, in order.
The Analytic Services Agent must be assigned the correct operating system privileges to run, regardless of the privileges of the user who starts the Agent.
$ARBORPATH/bin directory,
type ls -l ESSBASE. The file should have the following read,
write, and execute privileges:159749 -rwxr-xr-x 1 essbase staff 730168 Aug 31 05:06 ESSBASE
$ARBORPATH\bin directory,
select essbase.exe, right click, and select Properties to open
the essbase.exe dialog box.Administrator.