Cube Refresh Command Line Utility Performance Issues

This section enables you to fix Cube refresh command line utility performance drops and timeouts issues.

Issue:

Running the CubeRefresh.sh utility may take significantly longer than expected or fail with intermittent timeout or connection errors, while cube refreshes initiated from the Planning web interface complete successfully. This behavior can occur when the command-line utility does not explicitly disable Outline Edit Server Mode, resulting in unnecessary processing overhead and excessive Oracle Essbase logging.

Solution:

Configure the Planning environment to explicitly disable Outline Edit Server Mode for command-line cube refresh operations.

• Edit the setHPenv.sh script and add the following setting:
• export ESSOTLEDITSERVERMODE="false"
• Save the changes and rerun the CubeRefresh.sh utility.

After this configuration, command-line cube refreshes complete with expected performance, and timeout or connection-related failures caused by the excessive processing no longer occur.