Working with the Essbase Studio Server Startup File

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.

Example

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

For Oracle Users

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:

  1. 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
  2. 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
  3. Restart Essbase Studio.