Thursday, December 6, 2012

Locations of Major Configuration Information in EPM 11.1.2.1







Applies to:

Hyperion Essbase Administration Services - Version 11.1.2.1.000 and later
Hyperion Financial Management - Version 11.1.2.1.000 and later
Information in this document applies to any platform.
Access to Hyperion Registry configuration information is usually undertaken via epmsys_registry.bat|.sh or via Metadata in Hyperion Shared Services.


Purpose

This article points to the few remaining configuration files that are still used in Enterprise Performance Management 11.1.2.1.This is presumably not a complete list, however.

It is useful to relate findings in logs to configuration settings elsewhere in the products. It is also very helpful to increase the logging levels against specific servlets or servers by adjustments to the matching logging.xml files

Troubleshooting Steps

Oracle Hyperion Enterprise Performance Management 11.1.2.1
No.FilenameLocationDescription
1.reg.properties/Oracle/Middleware/user_projects/epmsystem1/config/foundation/11.1.2.0/jdbc.url, username accessing database repository
2.registry.xml\Oracle\MiddlewareProvides precise version of WebLogic application server.
3..product.properties\Oracle\Middleware\wlserver_10.3Hidden file contains: WLS_JAVA_HOME, MW_HOME, EPM_ORACLE_HOME, WLS_PRODUCT_VERSION, JAVA_MEM_ARGS
4.epmsys_registry.sh|.bat/Oracle/Middleware/user_projects/epmsystem1/binThis may be used to display or modify Hyperion registry settings. Run on its own it generates an HTML dump of the Hyperion registry in /Middleware/user_projects/epmsystem1/diagnostics/reports/registry.html
5.startconfigtool.bat
startconfigtool-manual.bat
\Oracle\Middleware\EPMSystem11R1\common\config\11.1.2.0Configuration Utility
6.Essbase.properties
datasources.xml, AnalyticProviderServices.properties, BPMS_bpms1_Server.properties. CalcMgr.properties, EisServer.properties, EpmaDataSync.properties, EpmaWebReports.properties, EssbaseAdminServices.properties, FinancialReporting.properties, FoundationServices.properties, ocm.properties, OHS.properties, Planning.properties, RaFrameworkAgent.properties, RaFramework.properties, RMI.properties
\Oracle\Middleware\user_projects\epmsystem1\aps\bin
\Oracle\Middleware\user_projects\epmsystem1\config\starter
Essbase configuration file; system.session.timeout, smartview properties
7.BpmServer.properties\Oracle\Middleware\user_projects\domains\EPMSystem\servers\FoundationServices0 or RaFramework0\tmp\servers\Foundation or RaFramework\ {etc}Temporary files indicating localization settings.
8.RMService8.properties\Oracle\Middleware\EPMSystem11R1\products\biplus\common\configCHECK_SERVICE_STARTUP for startup dependencies.
9.BPMA_Server_Config.xmlC:\Oracle\Middleware\EPMSystem11R1\products\Foundation\BPMA\AppServer\DimensionServer\ServerEngine\binDimensionServerPort
10.web.configC:\Oracle\Middleware\EPMSystem11R1\products\Foundation\BPMA\AppServer\DimensionServer\WebServiceDimensionServerPort
11.ADM.properties\Oracle\Middleware\EPMSystem11R1\common\ADM\11.1.2.0\libADM_RMI_PORT=8299 port number; MAX_PROPERTY_VALUE_LENGTH=4; LOAD_MDX_METADATA.
12.httpd.conf\Oracle\Middleware\user_projects\epmsystem1\httpConfig\ohs\config\OHS\ohs_componentOracle HTTP Server configuration: Aliases, ODL logging settings, timeout, Listen {port}, LoadModule, et cetera
13.mod_wl_ohs.conf, ssl.conf\Oracle\Middleware\user_projects\epmsystem1\httpConfig\ohs\config\OHS\ohs_componentLocationMatch, WLIOTimeoutSecs, Idempotent, WeblogicCluster, port; Listen, ProxyPreserveHost
14.logging.xml\Oracle\Middleware\user_projects\epmsystem1\config (\FoundationServices or ReportingAnalysis\Converter or ReportingAnalysis\MigrationUtility or \SDK or \syncCSSId or \validation)
\Oracle\Middleware\user_projects\epmsystem1\EssbaseServer\essbaseserver1\bin
\oracle\Middleware\user_projects\epmsystem1\BPMS\bpms1\bin
Oracle Diagnostic Logging is configured in \Oracle\Middleware\user_projects\epmsystem1\config\*\logging.xml files for servers
15.logging.xml\Oracle\Middleware\user_projects\domains\EPMSyem\config\fmwconfig\servers\WebAnalysis0 or \Oracle\Middleware\user_projects\domains\EPMSystem\config\fmwconfig\servers\(AdminServer or AdminServer\jboss or AdminServer\was\AnalyticProviderServices0 or EssbaseAdminServices0, FinancialReporting0, FMWebServices0, FoundationServices0 or Planning0 or RaFramework0 or WebAnalysis0)Oracle Diagnostic Logging Configuration files for servlets
16.web.config\Oracle\Middleware\EPMSystem11R1\products\FinancialManagement\Web\HFMOfficeProvider or HFMLCMService or HFMServices or HFMApplicationServiceappSettings, diagnostics
17.oraInst.locWindows: C:\Program Files\Oracle\Inventory\logs.

Unix: oraInst.loc file is generally in the /etc folder
 Central Inventory location is specified in theoraInst.loc
18.upgrade.properties/Oracle/Middleware/EPMSystem11R1/upgrades/raframework/upgrade.properties 
On Microsoft Windows, configuration information is kept in Windows Registry. HKEY_LOCAL_MACHINE\SOFTWARE\*Oracle Corporation, Hyperion Java Service or Hyperion Solutions,
HKEY_LOCAL_MACHINE\SYSTEM\ControlSet003\Services
The former CMC functionality shifted to the Hyperion Shared Services User Interface.

2 comments:

  1. This comment has been removed by a blog administrator.

    ReplyDelete
  2. This comment has been removed by a blog administrator.

    ReplyDelete