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/bin
For 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.tmp
If 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 id
After 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
.