Hyperion Planning : Security Refresh Takes an Hour or Longer with Trace Level Logging set for Planning Web App (Doc ID 2518170.1)

Last updated on SEPTEMBER 30, 2022

Applies to:

Symptoms

The security filter refresh takes an hour or longer instead of couple of minutes previously with no major changes in security or number of users

Changes

The Hyperion Planning logging level was set to TRACE:32

NOTE: The Planning logging level are set in the following file, example from Windows enviroment below

D:\Oracle\Middleware\user_projects\domains\EPMSystem\config\fmwconfig\servers\Planning0\logging.xml

The default level for epmhp-planning-handler is NOTIFICATION:1 as shown below. 

<logger name='oracle.EPMHSP' level='NOTIFICATION:1' useParentHandlers='false'>

<handler name='epmhp-planning-handler'/>

</logger>

The loggin level was set to TRACE:32 as shown below

<logger name='oracle.EPMHSP' level='TRACE:32' useParentHandlers='false'>

<handler name='epmhp-planning-handler'/>

</logger>

NOTE: The epmhp-planning-handler sets the logging level for Planning_WebApp.log

The default location for Planning logs is. However if there multiple Planning servers the Planning JVM server names are Planning0, Planning1 etc

\Oracle\Middleware\user_projects\domains\EPMSystem\servers\Planning0\logs\

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.