Registry Optimizations
Setting the JVMOption for Embedded Connection Type
If you are experiencing difficulties using the "embedded" Connection Type mode in Oracle Hyperion Profitability and Cost Management to connect to Oracle Essbase (especially in distributed configurations), you must set the environment variable ESS_ES_HOME
as a JVMOption
in order for Profitability and Cost Management to point to any local folder which contains two empty folders called bin
and data
.
-
If APS is installed on the system, set
ESS_ES_HOME
to the same value as theAPS_HOME
environment variable. (APS_HOME
should have the required folder structure.) -
If APS is not installed, set
ESS_ES_HOME
to any folder which contains emptybin
anddata
folders
Note:
No changes are required if you are using the "APS" Connection Type mode.
To set the JVMOption
for the Embedded Connection Type:
-
Stop the Profitability and Cost Management server.
-
Edit the Windows registry for
HKEY_LOCAL_MACHINE\SOFTWARE\Hyperion Solutions\Profitability0\HyS9HyS9PftWeb
. -
Add a
JVMOptionX
(whereX
is the next integer, based on the existing number ofJVMOptions
). For example, if the currentJVMOptionCount
is set to decimal 17, then addJVMOption18
. -
Set the string value for the new
JVMOptionX
to-DESS_ES_HOME=<folder-name>
, wherefolder name
is the name of the folder that contains the empty bin and data folders. -
Increment the
JVMOptionCount
to the next integer. For example, ifJVMOption18
is added, then setJVMOptionCount
to decimal 18. -
Start the Profitability and Cost Management server.
Setting for a High Rate of Network Connections for Windows
To improve the ability of the Windows operating system to deal with a high rate of network connections:
-
From the Windows Registry, navigate to:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\TCPIP\Parameters
-
Add or modify the following registry entries:
-
TcpTimedWaitDelay
- Set this to a low value (for example, 30) for the sockets to be released quickly. This DWORD value ranges between 30-300. -
MaxUserPort
- Set this to a high value (for example, 33000) to increase the total number of sockets that can be connected to the port. This is a DWORD value.
CAUTION: Before modifying these parameters, refer to the Microsoft Windows operating system documentation for more details.
-
-
Reboot the system for the changes to take effect.