EPM troubleshooting Utilities

(in via Maurice)

"
Are you keeping up-to-date with the latest troubleshooting utilities introduced from EPM 11.1.2.2? 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.1.2.2 (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 11.1.2.1.

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


(2) Log Analysis has received more "press".
It was released with EPM 11.1.2.3 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 11.1.2.3 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/loganalysis.sh -h (on Unix/Linux)
\Oracle\Middleware\user_projects\epmsystem1\bin\loganalysis.bat -h (on Microsoft Windows).
The output is saved under the
\Oracle\Middleware\user_projects\epmsystem1\diagnostics\reports\
subdirectory.


(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/registry-cleanup.sh (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/remove-instance.sh (on Unix/Linux)
\Oracle\Middleware\user_projects\epmsystem1\bin\remove-instance.bat (on Microsoft Windows).


(5) The Reset Configuration Tool was introduced with EPM 11.1.2.2.
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/resetConfigTask.sh -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.


Comments:

According to an Oracle blog "ECID allows an administrator to track the end-to-end flow of a particular request across the product stack". I would love to know which EPM products support ECID tracing - can I find the log entries for a user launching a Financial Reporting report and goind all the way down to the HFM data source if I use the Log Analysis tool?

Posted by Henri Vilminko on October 21, 2013 at 08:55 AM CEST #

Individual tracking of the Execution Context ID (ECID) is only assured for Hyperion applications 11.1.2.3 (and later). Hence, even if you had the backported Log Analysis utility, the implementation of ECID in earlier versions is likely to be problematic.

The log messages of Financial Reporting 11.1.2.3 are lacking MESSAGE_ID and hence are somewhat difficult to locate. Similarly the HFM MESSAGE_IDs are in a few inconsistent formats (EPMHFM- HFM-).

But you may look in the logs:
\Middleware\user_projects\domains\EPMSystem\servers\EPMServer0\logs\FRLogging.log
\Oracle\Middleware\user_projects\domains\EPMSystem\servers\FinancialReporting0\logs\*
\Oracle\Middleware\user_projects\epmsystem1\diagnostics\logs\services\
\Oracle\Middleware\user_projects\epmsystem1\diagnostics\logs\hfm
\Oracle\Middleware\user_projects\epmsystem1\diagnostics\logs\services\HyS9FRReports*
\Oracle\Middleware\user_projects\epmsystem1\diagnostics\logs\services\HyS9FinancialManagementWeb*

If you do locate an ECID in either the Financial Reporting or HFM log files, you should be able to track between the servers. An example of what such a search would entail would be:

loganalysis.bat -ecid "0000Jz3swL5Bh4FpN0DCie1Hr26n000002"

You do not have to add other parameters as the ECID is unique and should be considered even if it is not of type ERROR.

Cheers,

Maurice

Posted by Maurice Bauhahn on October 29, 2013 at 02:44 PM CET #

Post a Comment:
  • HTML Syntax: NOT allowed
About


This blog talks about the latest news and upcoming events initiated by the EPM/BI Proactive Support Team.

Authors:

italia.nowodworska@oracle.com
paul.anderson@oracle.com





Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
3
5
6
9
12
13
15
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today