Sunday Aug 23, 2015

New Knowledge Article: Troubleshooting Oracle Hyperion Essbase Crashes and Hangs

The following new My Oracle Support Knowledge Article is available:

Troubleshooting Oracle Hyperion Essbase Crashes and Hangs
Doc ID 2028052.2

This article provides a series of step through processes, to assist and guide in investigating an Essbase crash or hang issue.

Along with getting started and investigating a crash or hang, the article contains details on common crash and hang symptoms, log and configuration file locations, along with additional references.

Oracle highly recommends you always apply the latest Bundle Patch Set available for your release. This will help to rule out any resolved Bugs as a potential cause.

For more information on the latest Essbase Patch releases refer to the document:

Available Patch Sets and Patch Set Updates for Oracle Hyperion Essbase
Doc ID 1396084.1

To assist in locating these articles for all future updates, they can be easily bookmarked.

To Bookmark - click on the star to the left of the title.

Once bookmarked the star will become yellow, and the article can be quickly accessed from the "Favorites" drop down menu.

Questions specific to Essbase ...

For questions specific to Hyperion Essbase ...

The My Oracle Support Community "Hyperion Essbase" is the ideal first stop to seek & find product specific answers:

Hyperion Essbase

Sunday Feb 15, 2015

OBIEE 11g: Troubleshooting Crash Issues

(In via Debbie)

We are pleased to advise the following NEW Knowledge Document for Oracle Business Intelligence Enterprise Edition (OBIEE)  which is now available in My Oracle Support:

OBIEE 11g: Troubleshooting Crash Issues
Doc ID 1964727.2

This Knowledge Document guides you through a series of steps to assist in investigating a crash in an OBIEE 11g environment.

Along with the Overview and Getting Started sections, details are provided for Investigating a Crash and Common Crash Symptoms. If an issue is not resolved, the important information to provide within a Service Request are also outlined.

Where more information is required, the References section provides links to related documents, and a useful list of the Log & Configuration File Locations.

Additional Information:

If encountering Stuck Threads or Hang Issues, refer to our previous Blog post:

OBIEE 11g: Troubleshooting Stuck Threads or Hangs

Before proceeding to troubleshoot any issues Oracle highly recommends the latest Bundle Patch Set available be installed. For more information on the latest releases please refer to the following Knowledge Document:

OBIEE 11g: Required and Recommended Bundle Patches and Patch Sets
Doc ID 1488475.1

Questions specific to OBIEE ...

For questions or an issue that you can not identify - visit the OBIEE Community as a first step on your way to a solution: :

My Oracle Support Community

Monday Oct 21, 2013

EPM troubleshooting Utilities

(in via Maurice)

Are you keeping up-to-date with the latest troubleshooting utilities introduced from EPM These are typically not described in product documentation, so you might miss references to them. The following five utilities may be run from the command line.

(1) Deployment Report was introduced with EPM (11 April 2012).
It details logical web addresses, web servers, application ports, database connections, user directories, database repositories configured for the EPM system, data directories used by EPM system products, instance directories, FMW homes, deployment distory, et cetera.
It also helps to keep you honest about whether you made changes to the system and at what times! Download Shared Services patch 13530721 to get the backported functionality in EPM

Run it from
/Oracle/Middleware/user_projects/epmsystem1/bin/ report deployment
(on Unix/Linux)
\Oracle\Middleware\user_projects\epmsystem1\bin\epmsys_registry.bat report deployment (on Microsoft Windows).
The output is saved under

(2) Log Analysis has received more "press".
It was released with EPM and helps the user to slice and dice EPM logs. It has many parameters which are documented when run without parameters, when run with the -h parameter, or in the 'Readme' file. It has also been released as a standalone utility for EPM and earlier versions. (Sign in to  My Oracle Support, click the 'Patches & Updates' tab, enter the patch number 17425397, and click the Search button.
Download the appropriate platform-specific zip file, unzip, and read the 'Readme' file.
Note that you must provide a proper value to a JAVA_HOME environment variable [pointer to the mother directory of the Java /bin subdirectory] in the loganalysis.bat | .sh file and use the -d parameter when running standalone.)

Run it from
/Oracle/Middleware/user_projects/epmsystem1/bin/ -h (on Unix/Linux)
\Oracle\Middleware\user_projects\epmsystem1\bin\loganalysis.bat -h (on Microsoft Windows).
The output is saved under the

(3) The Registry Cleanup command may be used (without fear!) to clean up various corruptions which can  affect the Hyperion (database-based) Repository.

Run it from
/Oracle/Middleware/user_projects/epmsystem1/bin/ (on Unix/Linux)
\Oracle\Middleware\user_projects\epmsystem1\bin\registry-cleanup.bat (on Microsoft Windows).
The actions are described on the command line.

(4) The Remove Instance Command is only used if there are two or more instances configured on one computer and one of those should be deleted.

Run it from
/Oracle/Middleware/user_projects/epmsystem1/bin/ (on Unix/Linux)
\Oracle\Middleware\user_projects\epmsystem1\bin\remove-instance.bat (on Microsoft Windows).

(5) The Reset Configuration Tool was introduced with EPM
It nullifies Shared Services Hyperion Registry settings so that a service may be reconfigured. You may locate the values to substitute for <product> or <task> by scanning registry.html (generated by running epmsys_registry.bat | .sh).
Find productNAME in INSTANCE_TASKS_CONFIGURATION and SYSTEM_TASKS_CONFIGURATION nodes and identify tasks by property pairs that have values of 'Configurated' or 'Pending'.

Run it from
/Oracle/Middleware/user_projects/epmsystem1/bin/ -product <product> -task <task> (on Unix/Linux)
\Oracle\Middleware\user_projects\epmsystem1\bin\resetConfigTask.bat -product <product> -task <task> (on Microsoft Windows).

Thanks to Maurice for this collection of utilities.


This blog talks about the latest news and upcoming events initiated by the EPM/BI Proactive Support Team.
Lia, Torben, Paul, Julie


« October 2015