Hyperion Planning – Steps to Clear the EPM Oracle Instance Temporary Directories


This document is to provide information and recommendations on clearing the TMP and CACHE directories.

Each time an import or export occurs, Planning generates temporary files which are placed in the EPM Oracle Instance tmp directory. These files are not deleted, and over time, they can build up and affect performance. Oracle recommends that you periodically clear the EPM Oracle Instance tmp directory.

This is also recommended after upgrades and patches are applied.

Clearing the TMP directory may help resolve issues similar to the following:

  • Blank page while accessing Planning directly: (http://plan_server:8300/HyperionPlanning/)
  • Blank page while opening Planning Administration from within WorkSpace
  • “Internal Server Error” while opening Calculation Manager from within Workspace

 

Please follow the steps below to clear the temporary files and folders:

1. Shutdown EPM services.

2. On Foundation Server delete folders:
%MIDDLEWARE_HOME%\user_projects\domains\EPMSystem\servers\CalcMgr0\logs\cache
%MIDDLEWARE_HOME%\user_projects\domains\EPMSystem\servers\CalcMgr0\logs\tmp
%MIDDLEWARE_HOME%\user_projects\domains\EPMSystem\servers\Foundation0\logs\cache
%MIDDLEWARE_HOME%\user_projects\domains\EPMSystem\servers\Foundation0\logs\tmp

3. On Planning Server delete folders:
%MIDDLEWARE_HOME%\user_projects\domains\EPMSystem\servers\Planning0\logs\cache
%MIDDLEWARE_HOME%\user_projects\domains\EPMSystem\servers\Planning0\logs\tmp

Or
\Oracle\Middleware\User_projects\domains\EPMSystem\Servers\Planning0\Cache

\Oracle\Middleware\User_projects\domains\EPMSystem\Servers\Planning0\tmp
4. Restart EPM services.
5. Clear browser cache and retest.

Thanks,

~KKT~

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s