Unable to launch Essbase Administration Services (EAS) console

Author: Sanjay Purohit

Audience:  Hyperion Solution Architects and Hyperion Database Administrator

Recently I came across an error with EAS console. Few of our users were not able to launch EAS console with their desktop PC.  I tested on my machine and everything was working as expected so I knew there is something wrong with their machine.

Issue  

EAS console JNLP files are unable to associate with Java Web Start on local machine.

SOLUTION

Most of the Java version comes with Java Web Start Launcher and automatically associates with JNLP files.  But in some case depending on your local PC setting; the JNLP files are unable to associated with Java Web Start (javaws.exe) and cannot launch console.  You need to associate to javaws.exe file with JNLP.

Go to control panel>All Control Panel Items>Default Programs.

 And select the file under Java directory

You should be able to launch EAS console now.

Similar postings

 http://www.ehow.com/how_5035559_open-file-extension-jnlp.html

http://satishkoosam.blogspot.com/2013/02/eas-jre-issue.html

Default Log Location of Hyperion EPM Components

                                                          Author:-Sanjay Purohit 
Audience:-Hyperion Solution Architect, Technical Lead and Hyperion Administrator

Planning application is giving an error message and I am unable to refresh an application. My HFR reports are not working. I just found one article taking about the MIDDLEWARE_HOME and log locations. I don’t understand this language. Why it is happening with my application. Where do I go and see the details message about the error. I get these kind of questions from our clients and I always try to help them over the phone.  All of those questions made me to write this blog. This blog can be very useful for starter. I will also try to provide you Oracle doc URLs for details on each log. I am going to describe the Hyperion terminology and default log location of commonly used Hyperion family products. We will start with Hyperion terminology.

·         MIDDLEWARE_HOME:- is defined during the installation of components and refers the location of middleware components such as WebLogic, HTTP Server, used Java environments. One server can have more than one EPM_ORACLE_HOME its really depends on server configuration. The default location is MIDDLEWARE_HOME. The default location Oracle\Middleware.

·         EPM_ORACLE_HOME:- contains the support files of EPM system. This resides under the MIDDLEWARE_HOME. The default location is Oracle\Middleware\EPMsystem11R1

·         EPM_ORACLE_INSTANCE:- This location is defined during the Hyperion configuration. Most of the EPM/Hyperion components requires deployment location. The default location is Oracle\Middleware\user_projects\epmsystem1.  Users can modify this location during the configuration.

·         WEBLOGIC_DOMAIN_HOME:- most of the EPM components runs on WebLogic. This directory contains server domain for each deployed components. The default name is EPMSystem.

Now we will discusses about the default log location of Hyperion (11.1.2.x) related components. We can differentiates EPM logs in four categories:-

·         EPM Installation Logs

·         EPM Configuration Logs

·         WebLogic Managed Services Logs

·         Application Logs

 Node Manager Start Location

/Oracle/Middleware/wlserver_10.3/server/bin

Opmn  Start Location
Oracle/Middleware/EPMSystem11R1/opmn/bin

EPM Install/Uninstall logs: - This location contains the EPM installation logs. Any error during installation may be seen here.  The default locating is

Oracle/Middleware/EPMSystem11R1/diagnostics/logs/install

Running Uninstaller Location (In case you need to re-install components)

/u02/Oracle/Middleware/EPMSystem11R1/uninstall

EPM Configuration Logs: - The default log location

Oracle/Middleware/user_projects/epmsystem1/diagnostics/logs/config

Running Configurator:-

Oracle/Middleware/EPMSystem11R1/common/config/11.1.2.0

Shared Services Config Schema:-
Oracle/Middleware/user_projects/config/foundation/11.1.2.0

RMI Port

Oracle/Middleware/EPMSystem11R1/common/RMI/11.1.2.0
Oracle/Middleware/user_projects/epmsystem1/RMI

Outline Export from Workspace Location:-

Oracle/Middleware/user_projects/epmsystem1/tmp

LCM Log Location:-

Oracle/Middleware/user_projects/epmsystem1/diagnostics/logs

Patch log location:-

Oracle/Middleware/EPMSystem11R1/cfgtoollogs/opatch/

Diagnostic Logs

Essbase Server Related Logs:-Essbase maintain two logs types of logs to record the server and application related activities. The Location is

Oracle/Middleware/user_projects/epmsystem1/diagnostics/logs/essbase/essbase

Essbase Application Related Logs:-This log keeps the application specific activity logs.

Oracle/Middleware/user_projects/epmsystem1/diagnostics/logs/essbase/essbase/app/(name of application)    

Essbase OPMN logs:-

Oracle/Middleware/user_projects/epmsystem1/diagnostics/logs/OPMN/opmn

Oracle HTTP Server (OHS):-This location contain OHS access and console logs.

Oracle/Middleware/user_projects/epmsystem1/httpConfig/ohs/diagnostics/logs/OHS/ohs_component

·         access_log and access_log.number:- WebLogic-generated log files for a managed server

·         console~OHS~1.log:- Oracle HTTP Server-generated log file, console output

·         ohs_component.log:- Oracle HTTP Server-generated log file

Common Location for All Diagnostic Logs:-This location contains all the installed components start and stop related logs.   

The default location on UNIX Server is:-

Oracle/Middleware/user_projects/epmsystem1/diagnostics/logs/starter

The default log location on Windows Server is:-

Oracle\Middleware\user_projects\epmsystem1\diagnostics\logs\services

      Domain Log Location for Each Deployed Components

Planning Logs:-

C: /MIDDLEWARE_HOME/user_projects/domains/EPMSystem/servers/Planning0/logs   

Planning0.log:-Records Planning Web Application activity

Planning_ADF.log:-Oracle Application Development Framework information

Planning_WebApp.log:-Logs generated for Planning Server interactions

Planning_ADF.log–AD:- (Oracle Application Development Framework) information

Foundation Services Logs:-

Oracle/Middleware/user_projects/domains/EPMSystem/servers/FoundationServices0/logs      FoundationServices0.log–Server and security activity

Framework.log:- EPM System common user interface framework error and informational messages.

SharedServices_Admin.log:-Applications Groups management activity.

SharedServices_Audit.log:-Audit server errors while reading/writing audit information to the database.

SharedServices_Audit_Client.log:-information about the audit client.

SharedServices_CMSClient.log:-Metadata Service client activity.

SharedServices_Hub.log:-Shared Services listener and initialization activity.

SharedServices_LCM.log:-Lifecycle Management activity when it is run from Workspace.

SharedServices_Registry.log:-Shared Services Registry activity.

SharedServices_Security.log:-User management, authentication, and provisioning.

 SharedServices_TaskFlow.log:-Information about Taskflows.

Workspace.log:-EPM Workspace error and informational messages.

Financial Data Quality of Management Enterprise Edition (FDMEE) log:-

Oracle/Middleware/user_projects/domains/EPMSystem/servers/ErpIntegrator0/logs

MIDDLEWARE_HOME/user_projects/domains/EPMSystem/servers/ErpIntegrator0/logs  

ErpIntegrator0.log:- FDMEE application server log

aif-CalcManager.log:- Logs for Calculation Manager.

aif-HfmAdmDriver.log:- Logs for Financial Management ADM Driver.

aif-Planning_WebApp.log:- Logs for Planning Server interactions.

FDMEE Folder Creation Location:- 
Oracle/Middleware/user_projects/domains/EPMSystem

ODI Generated FDMEE logs:-

Oracle/Middleware/user_projects/domains/EPMSystem/servers/ErpIntegrator0/logs/oracledi

Calculation Manger Logs:-

Oracle/Middleware/user_projects/domains/EPMSystem/servers/CalcMgr0/logs

access.log:-What site was accessed inside the Web application (if access logging is enabled)

apsserver.log:-Communications between Calculation Manager.

CalcManager.log:-Calculation Manager Web-tier activities.

CalcMgr0.log:-All Calculation Manager Activities.

apsserver.log:-communications between Calculation Manager and Essbase.

Registry.log:-CM registry activity.

SharedServices_SecurityClient.log:-Logon activities and errors

I spend some time to collect most useful Oracle URLs. Below given URL should be enough to provide you details what you looking for.  

Foundation Services Logs URL

http://docs.oracle.com/cd/E17236_01/epm.1112/epm_install_troubleshooting_1112200/frameset.htm?ch03s12.html

FDMEE Related Logs URL

http://docs.oracle.com/cd/E40248_01/epm.1112/epm_troubleshooting/frameset.htm?ch03s16s02.html

EPM System Product Logging Matrix URL

http://docs.oracle.com/cd/E17236_01/epm.1112/epm_install_troubleshooting_1112200/frameset.htm?ch03s01.html

Using EPM System Configurator URL

http://docs.oracle.com/cd/E17236_01/epm.1112/epm_install/frameset.htm?ch05s10.html

EPM System Configurator and System logs URL

http://docs.oracle.com/cd/E17236_01/epm.1112/epm_install_troubleshooting_11121/frameset.htm?ch03s02s05.html

Essbase Diagnostic logs URL

http://docs.oracle.com/cd/E12825_01/epm.111/eashelp/frameset.htm?logsabot.htm

EPM System Product Logging Matrix URL

http://docs.oracle.com/cd/E17236_01/epm.1112/epm_install_troubleshooting_1112200/frameset.htm?ch03s01.html

Planning logs URL

http://docs.oracle.com/cd/E17236_01/epm.1112/epm_install_troubleshooting_1112200/frameset.htm?ch03s16s01.html

FDMEE logs URL

http://docs.oracle.com/cd/E17236_01/epm.1112/epm_install_troubleshooting_1112200/frameset.htm?ch03s16s01.html

Application Server, Webserver and EPM system process logs

http://docs.oracle.com/cd/E17236_01/epm.1112/epm_install_troubleshooting/frameset.htm?ch03s10.html

Using the Log Analysis Utility to Identify Problems

http://docs.oracle.com/cd/E40248_01/epm.1112/epm_troubleshooting/frameset.htm?ch03s01.html 

LCM logs URL

https://docs.oracle.com/cd/E17236_01/epm.1112/epm_lifecycle_management/frameset.htm?ch07s05s05.html

Node Manager

http://docs.oracle.com/cd/E23943_01/web.1111/e13740/starting_nodemgr.htm#NODEM214

http://www.oratraining.com/blog/2012/11/startup-shutdown-sequence-for-oracle-fusion-apps-components/

Oracle Support Article
FDMEE: Where Are The Logs For FDMEE (Doc ID 1640612.1)

The Process Flow of Decision Package/Budget Request with Oracle Hyperion Public Sector Planning and Budgeting

Author:-Sanjay Purohit
Audience:-Hyperion Solution Architect, Functional Lead and Hyperion Business User.

We already have discussed about Decision Package and Budget Request in-detail in my previous postings. Decision Packages are a way to present a fund request for a program or new initiative. I will not give you more overview of DP and BR but will show you how to create DP/BR.  The configuration process of DP and BR is complex enough and require deep knowledge of Hyperion Planning and Budgeting applications with business understanding.

Objective

The purpose of this article is to provide you a basic understanding of DP creation and promotion process. I cannot cover any business specific issue/case but will cover a general path of a DP and a BR. I will demonstrate you following steps:

·         Setting up a sample Planning Unit Hierarchy to use with DP

·         How to Create Decision Package.

·         How to promote decision package.

how To

I will take an example from one of my applications and create three users with the name of SanjayPlanning, SanjayReviewer and SanjayHead.  The SanajyPlanner is the first user who will create decision package and promote to his supervisor SanjayReviewer and then will promote to head of department SanjayHead. The entire promotion path is pretty simple.

I have setup a sample PUH for one department

Sanjay Planner will create a decision package on base level entity MA24000 and will promote to next level/user MA24X. The approval path should be MA2400>.MA24X> Total GL Entity

Now we will  start creating  a Decision Package.

The first screen will require Name of DP, Scenario, Version, Rank, Impact and entity. The Decision Packages Reviewers name is optional an can come from Master PUH

The second screen is attribute screen. We have setup attributes inside decision package attribute

The third screen is justification screen. Remember we had setup justification question in my previous posting. Here we just need to answer those questions.

 The last screen is summary screen. And users can see the entered details.

The next step is to create Budget Request (BR). The BR only can be created after DP.

The creation process of DP and BR is exact same. The first screen of BR also requires; Name of BR, Rank, Budget Impact, Owner Entity and Budget type.

We have not setup any attribute so we will skip this steps and move to justification screen. User needs to enter justification and view on the summary screen.

 The summary screen show the entered information

I have entered the value 200 in attached data form and now can be seen at DP/BR level

 The amount should look like below screen. And the entered amount can be seen.

The next is the approval process and you can see the current owner (Decision package creator) is SanjayPlanner. SanjayPlanner will promote to SanjayReviewer and SanjayHead will approve the DP

SanjayPlanner has promoted to SanjayReviewer and SanjayReviewer will promote to SanjayHead

Now I will login as sanjayhead and approve

Finally decision package is approved and can become the part of budget