Thursday, July 20, 2017

Windows Services Creation for Hyperion Admin and SOA Services

Once we install Hyperion on Windows,Admin and SOA services run on command prompt. when we lock the system,automatically command line will be closed it cause Admin and SOA services to stop abruptly. To over come this,we have option to run Admin and SOA services as Windows services.

Note : Stop Admin and SOA services. If there is any depend services are running,Please stop those services as well.


Consider,


Domain_home : D:\Oracle\Middleware\user_projects\domains\EPMSystem


WL_HOME : D:\Oracle\Middleware\wlserver_10.3\server\bin

Admin services Creation :
  • Navigate to Domain_home\bin
  • Copy setDomainEnv.cmd, and name the copied file as setSvcDomainEnv.cmd
  • Open setSvcDomainEnv.cmd in a text editor
  • Search for PROTOCOL_HANDLERS and comment it out as below,














  • Remove the PROTOCOL_HANDLERS settings in EXTRA_JAVA_PROPERTIES

  • After removing PROTOCOL_HANDLERS,it should be like below,






















  • Navigate to WL_HOME,
  • Copy installSvc.cmd to installSvc.bak to have a backup
  • Open installSvc.cmd in a text editor.
  • Comment out commEnv.cmd. Add .Set Domain home and call setSvcDomainEnv.cmd instead as shown below,

  • Copy the PROTOCOL_HANDLERS settings from setDomainEnv.cmd to this file, put it after the call of setSvcDomainEnv.cmd as below,


  • For troubleshooting / debugging purposes it is helpful to redirect standard out and error to a text file. Although most information is captured in the AdminServer server log files, you will not see all standard out and error when the server is started via a MS Windows Service (unlike when you start an AdminServer in console modefrom the command prompt using startWebLogic.cmd). To redirect standard out to a text file, backup and edit installSvc.cmd file and change the line at the bottom of the file so it includes the -log parameter. For example:




  • Note: You may also want to change the service name from beasvc to Oracle so that all of your Oracle services are ordered together in the services screen, for example: -svcname:"Oracle %DOMAIN_NAME%_%SERVER_NAME
  • Create Boot.Properties 
  • Configure the boot.properties to create an encrypted method to automatically pass the admin username and password 
  • DOMAIN_HOME\servers\AdminServer\Security
  • Note: the above credentials are the same as the one provided when the AdminServer is started from Command line. Do not use or leave the brackets [ ] in the file. They are only used to show what should be entered.
    As soon as you start the Admin Server the username and password values in this file will be encrypted
  • Create setup_adminsvc.bat file under WL_HOME\bin and run as Administrator to create Admin services as windows services.


















you can see Admin services created on services.msc screen. And you can notice boot.properties is encrypted.if there is any change in epm_admin password,then we need to stop services and make changes here.


SOA Services Creation :
  • Create Boot.Properties (as like while creating Admin services above) for SOA under security folder(sample path given below),
  • DOMAIN_HOME\servers\soa_server1\Security
  • we need to add Protocol handler in installSvc.cmd file.Edit the first set CMDLINE command to add the protocol handlers settings for SOA server.
-Djava.protocol.handler.pkgs=\"%PROTOCOL_HANDLERS%\"
  • After we add protocol handler looks as below,

  • Add log path to capture logs in new path. And make sure SOA services startup should be depend on Admin services and save the file.















  • Create setup_soasvc.cmd file under WL_HOME as below,


















  • we have successfully created Admin and SOA services.























Monday, July 10, 2017

Hyperion 11.1.2.x Default Log path

This blog describes about the Hyperion terminology and default log location of commonly used Hyperion products.

·         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)

       /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 


FDMEE Related Logs URL

EPM System Product Logging Matrix URL

Using EPM System Configurator URL

EPM System Configurator and System logs URL

Essbase Diagnostic logs URL

EPM System Product Logging Matrix URL

Planning logs URL

FDMEE logs URL


Node Manager



Oracle Support Article

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


HPCM logs

hpcm.log :  Profitability and Cost Management generates an application, server-side log file that collects applicationspecific messages that are sent from the application or server.

Default location : 

C:\oracle\Middleware\user_projects\domains\EPMSystem\servers\Profitability0\logs.

SharedServices_Security_Client.log : A Shared Services Client-side log file provides details regarding the Profitability and Cost Management handshake with Common Security Services. 

Default location : 
\Middleware\user_projects\domains\EPMSystem\servers\Profitability0\logs.

Other Locations :
























EPM Infrastructure Tips and Issues PDF located at :