The Essbase Studio Server startup file contains the commands necessary to start Essbase Studio Server.
During the configuration process , the EPM System Configurator writes information to the startup file about the computer on which Essbase Studio is installed so that Essbase Studio Server can start properly. Oracle recommends that you do not manually edit the startup file.
The start up file is installed by default in:
MIDDLEWARE_HOME/user_projects/epmsystem1/BPMS/bpms1/bin
The file is named startBPMS_bpms1_Server.bat on Windows; startBPMS_bpms1_Server.sh on UNIX.
An example of the startBPMS_bpms1_Server.bat file on a Windows 2003 operating system is shown below:
pushd "C:\Oracle\Middleware\user_projects\epmsystem1\bin" call setEnv.bat set JAVA_OPTIONS=-DESSBASE_STUDIO_INSTANCE="C:\Oracle\Middleware\user_projects \epmsystem1/BPMS\bpms1" -DsuppressAPSProductInfo=true set JAVA_HOME=C:\Oracle\Middleware\jdk160_11\jre call %EPM_ORACLE_HOME%/products/Essbase/EssbaseStudio/Server/startServer.bat
If you use Oracle for your catalog database or relational sources, and Essbase Studio Server is not able to open a physical connection to the Oracle RDBMS, you may have a time zone configuration issue.
To resolve a time zone configuration issue:
Locate the batch-file batch-file/shell-script that starts Essbase Studio Server.
On 11.1.1.x, the file is located at:
HYPERION_HOME/products/Essbase/EssbaseStudio/Server/startServer.bat|sh
On 11.1.2.1.x, the file is located at:
EPM_ORACLE_HOME/products/Essbase/EssbaseStudio/Server/startServer.bat|sh
On 11.1.2.2.x, the file is located at
MIDDLEWARE_HOME/user_projects/epmsystem1/BPMS/bpms1/bin/start_BPMS_bpms1_Server.bat|sh
Manually update the file to add the JVM parameter, user.timezone.
For example, the original entry may look like this:
%JAVA_HOME%\bin\java" -Xms128m -Xmx768m %JAVA_OPTIONS% -jar server.jar
After the update, the entry is:
%JAVA_HOME%\bin\java" -Xms128m -Xmx768m -Duser.timezone="2:00" %JAVA_OPTIONS% -jar server.jar