Wednesday, November 30, 2011

FDM Schema Update Utility Hangs Upon Login [ID 1225495.1]


FDM Schema Update Utility Hangs Upon Login [ID 1225495.1]

Modified 07-OCT-2010 Type PROBLEM Status PUBLISHED

In this Document
Symptoms
Cause
Solution


Applies to:

Hyperion Financial Data Quality Management - Version: 11.1.1.3.00 and later [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms

When attempting to login to the schema update utility to upgrade an FDM application the tool freezes. The login form is returned and the user enters the admin account information and clicks login and it is frozen. The utility has to be terminated via the windows task manager.

Cause

Currently the schema update utility is unable to authenticate users against Hyperion Shared Services. When the COMJNIBRIDGE.exe process is launched in the task manager and attempts to establish a connection with Shared Services, the process is hung in the task manager and does not receive a success response from HSS, causing the schema update utility to hang.

Cause Justification
The cause of the issue is justified by performing the following:

a) Launch the FDM Load Balance Config and edit the HSS Authentication Provider
b) Click the "Test connection" button
c) The Load Balance Config is frozen and the "Connection Successful" message is not returned.
d) Looking in the processes tab of the windows task manager shows comjnibridge.exe with 0% CPU stuck in the task manager

Solution

A) Start > run > DCOMCNFG
B) Expand COMPUTERS > My Computer > DCOM Config
C) Locate the COMJNIBRIDGE item, right-click and choose "properties"
D) Click on the "Identity" tab and update the FDM Service Account password and confirm
E) Open the windows task manager and locate the current comjnibridge.exe hung in the task manager and end the process
F) Re-run the schema update utility and login successfully and click "update" to update the application to the 11.1.1.3 level successfully.


Show Related Information Related


Products
  • Middleware > Enterprise Performance Management > Financial Data Quality Management > Hyperion Financial Data Quality Management

Back to topBack to top

FDM Task Manager Configuration Returns "Service Login Failure" [ID 1331947.1]


FDM Task Manager Configuration Returns "Service Login Failure" [ID 1331947.1]

Modified 23-JUN-2011 Type HOWTO Status PUBLISHED

In this Document
Goal
Solution


Applies to:

Hyperion Financial Data Quality Management - Version: 11.1.2.1.000 and later [Release: 11.1 and later ]
Information in this document applies to any platform.

Goal

When configurating the FDM Task Manager I receive a message "Service Login Failure".

What would cause this?

Solution

The fdm service account does not have the "Logon As a Service" local security policy granted to it.

To grant the account this policy you can do this in one of two ways:

a) Choose Start > Control Panel > Administrative Tools > Local Security Policy
b) Expand Local Policies > User Rights Assignment
c) Locate the "Log on as a service item an double-click to open
d) Add the service account to the setting and click OK
e) Reset the FDM Load Balance Config

The second method is:

a) Start > run > services.msc
b) Locate the "hyperion financial data quality management task manager service" service
c) Right-click and choose "Properties". Click on the "logon" tab
d) Enter and confirm the password for the service account and click "Apply"

You will receive a message that the account has been granted the logon as a service role. Click OK

Oracle Hyperion Enterprise Performance Management 11.1.2.x Product Information Center - Installation


Oracle Hyperion Enterprise Performance Management 11.1.2.x Product Information Center - Installation [ID 1248594.1]

Modified 13-JUN-2011 Type REFERENCE Status PUBLISHED

In this Document
Purpose
Scope
Oracle Hyperion Enterprise Performance Management 11.1.2.x Product Information Center - Installation


Applies to:

Middleware > Enterprise Performance Management
Information in this document applies to any platform.

Purpose

This document provides installation information for Oracle Hyperion Enterprise Performance Management 11.1.2.x in respect to the Oracle Hyperion Enterprise Performance Management 11.1.2.x Product Information Center Note 1247194.1

Scope

This document is a reference document to support Oracle Hyperion Enterprise Performance Management 11.1.2.x Product Information Center.

Oracle Hyperion Enterprise Performance Management 11.1.2.x Product Information Center - Installation

Lifecycle: Installation



News
Hyperion Planning Mandatory Patch 11.1.2.1.000
This Patch Set Exception (PSE) is mandatory for customers who are upgrading to Oracle Hyperion Planning 11.1.2.1.000 from a prior release. Please read article for further information.
Hyperion Enterprise Performance Management Mandatory Patch 11.1.2.1.101
This Patch Set Update (PSU) is mandatory for customers who are currently on or planning to upgrade to Oracle Hyperion Enterprise Performance Management Architect (EPMA) 11.1.2.1.000. Please read article for further information.
Hyperion Data Relationship Management recommended version is 11.1.2.1.101
Oracle recommends customers install this patch set update instead of installing the base 11.1.2.1.000 release of Data Relationship Management as this version addresses many of the defects listed in the known issues section of the 11.1.2.1.000 release. This DRM 11.1.2.1.101 release is a full install. Please refer to the patch readme for system requirements, dependencies, and installation instructions.
Documents
Start Here: EPM System Release 11.1.2.1 Pre-Installation
This links to the EPM System Release 11.1.2.1 Installation Start Here, which provides a pre-installation checklist, prerequisites, architecture diagrams, default port requirements, and other information to help you plan for your installation.
Supported System Configurations/Certification Matrix
This links to the EPM System Certification Matrix, which provides details on system requirements and release compatibility.
EPM System Release 11.1.2.1 Installation Readme
This links to the EPM System Release 11.1.2 Installation and Configuration Readme, which provides late-breaking information about EPM System 11.1.2.1 installations.
EPM System Release 11.1.2.1 Installation Instructions
This links to the EPM System Release 11.1.2.1 Installation and Configuration Guide, which provide detailed instructions to install and configure EPM System components (includes upgrade steps).
EPM System Release 11.1.2.1 Installation Troubleshooting
This links to the EPM System Release 11.1.2.1 Installation and Configuration Troubleshooting Guide, which contains troubleshooting tips and methods to troubleshoot problems.
Component Architecture for 11.1.2.1 EPM System Components
The Installation Start Here includes architecture diagrams for each EPM system component. See the "EPM System Architecture" chapter.

Communication Flows for 11.1.2.1 EPM System Components
This spreadsheet provides communication flows, protocols, and default ports for EPM System components.

EPM Data Models Release 11.1.2.1
The schemas of EPM system databases are documented and are available in a zip file posted on the EPM/BI Whitepaper Library (“EPM Data Models Release 11.1.2.1”). Please consult EPM System Application and Repository Databases Access Policy noted above to understand what is allowed and not allowed with regard to direct database access.

EPM System Compact Deployment for Release 11.1.2.1
A whitepaper describing how to deploy all EPM System Web applications to one WebLogic managed server, called “Compact Deployment.” Compact deployment significantly reduces the required memory at start up time and reduces the time it takes to start up all services. Note that this is supported only in Development environments and on 64-bit machines.

Unique Instance Name Is Required
This link to explain the requirement for having unique instance names when configuring a new install of EPM 11.1.2.1.

What Inventories Are Available in EPM 11.1.2.1?
This link will help Identify the location of software inventories associated with EPM 11.1.2.1 .

Configuration Problem in "Set up Shared Services and Registry Database Connection" in EPM 11.1.2.1
This link provides a solution for "Error 404" After Configuration "Set up Shared Services and Registry Database Connection" in EPM 11.1.2.1.

Rerunning a Configurator Task in Oracle Hyperion EPM 11.1.2.1
This link provides a solution for how to re-run a Configurator Task in EPM 11.1.2.1.







Show Related Information Related


Products
  • Middleware > Enterprise Performance Management >
Errors
ERROR 404

Back to topBack to top

Using Remote Diagnostic Agent (RDA) to Troubleshoot Oracle Hyperion EPM 11.1.2.1


Using Remote Diagnostic Agent (RDA) to Troubleshoot Oracle Hyperion EPM 11.1.2.1 [ID 1304885.1]

Modified 01-AUG-2011 Type HOWTO Status PUBLISHED

In this Document
Goal
Solution
References


Applies to:

Hyperion BI+ - Version: 11.1.2.1.000 and later [Release: 11.1 and later ]
Information in this document applies to any platform.

Goal

Provide brief instructions on how to run RDA 4.23 in Oracle Hyperion Enterprise Performance Management (EPM) 11.1.2.1 for various Hyperion products.

Solution

EPM 11.1.2.1 comes bundled with a current version (4.23) under \Oracle\Middleware\EPMSystem11R1\rda.

To use this tool:
1. First ensure that Perl 5.005 or later is available by typing the following from the command line:

perl -v

If not, you may need to download a binary copy of rda and add a value to RDA_ENG in the configuration file \engine\rda.cfg; Please refer to DOC ID 330363.1 (FAQ #6) for further information.

2. Navigate via the command line to \Oracle\Middleware\EPMSystem11R1\rda

3. Type the following:

rda.cmd -V > version.txt

4. Type 'notepad version.txt' and confirm that the first line has 'RDA 4.23' or later

5. If it is not version 4.23 or later, in http://support.oracle.com go to DOC ID 314422.1 and click on the "Download RDA" hyperlink, following instructions to download the appropriate version of the application. Delete the existing \Oracle\Middleware\ohs\rda directory. Then extract the downloaded file to any convenient place...such as \Oracle\Middleware\ohs (it will create a directory called 'rda').

6. Navigate via the command line to that 'rda' directory and type rda.cmd -V > version.txt and confirm output as elaborated in step (4) above.

7. Command lines (with an example of SQR Production Reporting and Interactive Reporting [PR HIRs] as module names; Essbase as profile name):
Type on Command Line
Explanation
rda.cmd -Q PR HIR
rda.cmd -Qp Essbase
-Q will alert you to most of the questions that will be posed by RDA to facilitate its collection of information. Collect those details before running the modules.
rda.cmd -M PR HIR
This will describe (man page) what information will be collected by these modules.
rda.cmd -S PR HIR -p Essbase

This will collect instructions and values to be entered into the setup.cfg file for modules PR and HIR and profile Essbase. Only two files and one TMP directory will be written to the output directory.
rda.cmd -vnSCRP PR HIR
This will configure (de nouveaux) the setup.cfg file and then run the data collection mechanism, compressing data to (by default) be placed in the ..\output\ directory.
rda.cmd
This will execute the instructions previously entered into the setup.cfg file (rda.cmd run with -S parameter). Note that this is a two step process, and after this step starts a large number of files with extensions *.txt, *.fil, and *.toc will first be written. At the end files with *.htm extensions will be written.
rda.cmd -x profiles
This will provide a cross reference between the available profile names and the (programmer's) module names which are executed under each profile.
rda.cmd -L tools
rda.cmd -T epm
In recent versions, this 'tool' will run validate scripts and return a report listing each validation result. You should only run this after having previously run the EPM module. In addition at the bottom of the validate reporting page you may click on a hyperlink to access a zip file containing logs generated on the server.


Modules (rda.cmd -L modules) which would be particularly interesting to Oracle Hyperion users would be:

Module Abbreviation
Module Application Name
BI
Oracle Business Intelligence Enterprise Edition
BIPL
Oracle Business Intelligence Publisher
CCR
Oracle Configuration Manager
EPM
Oracle Hyperion Enterprise Performance Management
EPMA
Oracle Hyperion Enterprise Performance Architect
ESS
Oracle Hyperion Essbase
FCM
Oracle Hyperion Financial Close Management
HDRM
Oracle Hyperion Data Relationship Management
HFM
Oracle Hyperion Financial Management
HFR
Oracle Hyperion Financial Reports
HIR
Oracle Hyperion Interactive Reporting
HPL
Oracle Hyperion Planning
HPSV
Oracle Hyperion Planning SmartView
HSS
Oracle Hyperion Shared Services
HSV
Oracle Hyperion Smart View
PR
Oracle Hyperion SQR Production Reporting

There are also a few profiles (sets of modules: rda.cmd -L profiles) available which could be useful when troubleshooting Oracle Hyperion products:
Profile Abbreviation
Profile Descriptive Name
EPMA_FullRun
Oracle Enterprise Performance Management Architect problems
Essbase
Oracle Essbase problems
FCM_FullRun
Oracle Hyperion Financial Close Management problems
FinancialReporting
Oracle Hyperion Financial Reporting problems
FM11g_Bi
Business Intelligence Enterrpise Edition 11g problems
FM11g_WlsBi
Business Intelligence Enterprise Edition 11g with WLS
HFM_FullRun
Oracle Hyperion Financial Management problems
Hyperion_DRM
Oracle Hyperion Data Relationship Management problems

When setting up a profile or module a number of questions are asked, some typical value assignments include (Although the default install on Microsoft Windows would be to "C:\Oracle\Middleware\", the user may chose a different install home):

ORACLE_HOME=C:\app\\product\11.2.0\dbhome_1
JAVA_HOME=C:\Oracle\Middleware\jdk160_21
EPM_ORACLE_INSTANCE=C:\Oracle\Middleware\user_projects\epmsystem1
EPM_ORACLE_INSTANCE_ROOT=C:\Oracle\Middleware\user_projects
domain home directory=C:\Oracle\Middleware\user_projects\domains

In the \rda\setup.cfg file ensure the following are set to acceptable values:
CMD_ZIP='C:\Oracle\Middleware\ohs\bin\zip.exe'
RPT_GROUP= {some name in single quotes}
RPT_DIRECTORY= {some path in single quotes}

Utilities for Troubleshooting Oracle Hyperion Enterprise Performance Management 11.1.2.0 or 11.1.2.1 [ID 1303200.1]


Utilities for Troubleshooting Oracle Hyperion Enterprise Performance Management 11.1.2.0 or 11.1.2.1 [ID 1303200.1]

Modified 11-AUG-2011 Type HOWTO Status PUBLISHED

In this Document
Goal
Solution
References


Applies to:

Hyperion Essbase - Version: 11.1.2.1.000 and later [Release: 11.1 and later ]
Hyperion BI+ - Version: 11.1.2.0.00 to 11.1.2.1.000 [Release: 11.1 to 11.1]
Hyperion Planning - Version: 11.1.2.0.00 to 11.1.2.1.000 [Release: 11.1 to 11.1]
Hyperion Financial Management - Version: 11.1.2.0.00 to 11.1.2.1.000 [Release: 11.1 to 11.1]
Hyperion BI+ - Version: 11.1.2.0.00 to 11.1.2.1.000 [Release: 11.1 to 11.1]
Information in this document applies to any platform.
(1) \Oracle\Middleware\user_projects\epmsystem1\bin\ziplogs.bat|.sh
(2) \Oracle\Middleware\ohs\ccr\bin\
(3) \Oracle\Middleware\ohs\rda\rda.cmd
(4) \Oracle\Middleware\user_projects\epmsystem1\bin\epmsys_registry.bat|.sh
(5) \Oracle\Middleware\user_projects\epmsystem1\bin\validate.bat

Goal

This article aims to help users use various troubleshooting tools to validate or troubleshoot an installation of Oracle EPM 11.1.2.0. or 11.1.2.1

Solution

(1) A new troubleshooting tool introduced in Oracle EPM 11.1.2.1 is \Oracle\Middleware\user_projects\epmsystem1\bin\ziplogs.bat|.sh file. The output of this is generated in \Oracle\Middleware\user_projects\epmsystem1\diagnostics\ziplogs\EPM_logs__11.1.2.1.0.zip

(2) Oracle Configuration Manager (OCM) is an advanced tool which collects and evaluates settings from configuration files (but not Hyperion Registry) and stores them in a central database administered by Oracle. It was first introduced into EPM in version 11.1.2.0

(3) Remote Desktop Assistant (RDA) collects and zips up a large amount of information concerning the software and hardware environments of Oracle products. If Perl 5.1 or later is installed on the computer and accessible from the command line (test: perl -version), then run: \Oracle\Middleware\ohs\rda\rda.cmd from the command line to access the RDA tool. Alternately, precompiled RDA executables are available for several platforms.

(4) Configuration settings have been moved from configuration files to a database repository associated with Shared Services. These may be extracted to an HTML formatted file by running \Oracle\Middleware\user_projects\epmsystem1\bin\epmsys_registry.bat|.sh without parameters from the command line. The output is generated to file \Oracle\Middleware\user_projects\epmsystem1\diagnostics\reports\registry.html The username/login/jdbc URL for the Hyperion/HSS registry are kept in \Oracle\Middleware\user_projects\epmsystem1\config\foundation\11.1.2.0\reg.properties file.

(5) A much enhanced validation tool is available in \Oracle\Middleware\user_projects\epmsystem1\bin\validate.bat. In EPM 11.1.2.1 the output files are of the form \Oracle\Middleware\user_projects\epmsystem1\diagnostics\reports\instance_report_20YYMMDD_######.html (where YY is the year, MM is the month, DD is the day, and ###### is a unique integer). It also runs the tool under (1) and gives the output of that tool.

(6) Individual log files may be found in subdirectories under (those 'starred' are not collected by ziplogs):
\Oracle\Middleware\user_projects\domains\EPMSystem\servers\\logs *
\Oracle\Middleware\logs *
\Oracle\Middleware\wlserver_10.3 *
\Oracle\Middleware\user_projects\epmsystem1\tmp *
\Oracle\Middleware\ohs\cfgtoollogs\opatch *
\Oracle\Middleware\EPMSystem11R1\diagnostics\logs
\Oracle\Middleware\user_projects\epmsystem1\diagnostics\logs\
\Program Files\Oracle\Inventory\logs
C:\Users\\Oracle\oradiag_\diag\
C:\Users\\.oracle\logs\

(7) Some debug tools (*) can be activated if under http://:19000/workspace/index.jsp > Navigate > Administration > Workspace Server Settings > Client Debug Enabled: is set to Yes (then click 'OK' button, close all browser windows, and restart browser).
* http://hostname:19000/workspace/debug/configInfo.jsp
* http://hostname:19000/workspace/debug/userInfo.jsp
* http://hostname:19000/workspace/debug/userGroupQuery.jsp


Other tools are available at these URLs (largely derived from validate.bat output). A non-Error response indicates that the web service of each particular application is active.:
http://hostname:19000/workspace/status
http://hostname:19000/workspace/BPMContext
http://hostname:8600/mappingtool/faces/info.jspx
http://hostname:10080/easconsole/console.html
http://hostname:16000/WebAnalysis
http://hostname:6373/oracle-epm-fm-webservices/ApplicationService
http://hostname:8300/HyperionPlanning/
http://hostname:13080/aps/APS
http://hostname:8200/hr/status.jsp
http://hostname:19091/awb/conf/AwbConfig.xml
http://hostname:8500/calcmgr/index.htm

References


Show Related Information Related


Products
  • Middleware > Enterprise Performance Management > Essbase > Hyperion Essbase
  • Middleware > Business Intelligence > Hyperion Query & Reporting > Hyperion BI+
  • Middleware > Enterprise Performance Management > Planning > Hyperion Planning
  • Middleware > Enterprise Performance Management > Financial Management > Hyperion Financial Management
  • Middleware > Business Intelligence > Hyperion Query & Reporting > Hyperion BI+
Keywords
CONFIGURATION; CONFIGURATION FILE; DEBUGGING; DIAGNOSTICS; ENTERPRISE PERFORMANCE MANAGEMENT; LOG FILE; PERFORMANCE MANAGEMENT; PERL; RDA; TROUBLESHOOT

Back to topBack to top

Platform Desupport Notice Affecting EPM System Releases Beginning with Release 11.1.2 [ID 1072511.1]


Platform Desupport Notice Affecting EPM System Releases Beginning with Release 11.1.2 [ID 1072511.1]

Modified 05-NOV-2010 Type ANNOUNCEMENT Status PUBLISHED

In this Document
What is being announced?


Applies to:

Oracle Crystal Ball - Version: 11.1.1.0.00 to 11.1.1.3.00 - Release: 11.1 to 11.1
Hyperion Data Integration Management - Version: 11.1.1.0.00 to 11.1.1.1.00 [Release: 11.1 to 11.1]
Hyperion Strategic Finance - Version: 11.1.1.1.00 to 11.1.1.3.00 [Release: 11.1 to 11.1]
Hyperion Data Relationship Management - Version: 11.1.1.0.00 to 11.1.1.3.00 [Release: 11.1 to 11.1]
Hyperion Financial Data Quality Management - Version: 11.1.1.0.00 to 11.1.1.3.00 [Release: 11.1 to 11.1]
Information in this document applies to any platform.

What is being announced?

The following platform components will no longer be supported by Oracle Hyperion Enterprise Performance Management System subsequent to release 11.1.1.x. (Note: Not all individual Oracle Hyperion Enterprise Performance Management System release 11.1.1.x products are supported all platforms. For specific details, please refer to the applicable Certification Matrix.). Please refer to the Products section below for a full list of the affected Products.

SERVER OPERATING SYSTEMS
POWER AIX 5.2
PA-RISC HP-UX 11i (11.23)
Itanium-2 Windows 2003 SP1, Server Enterprise Edition for Itanium-based Systems

DATABASES (Repositories and Data Sources)
Oracle Database 10.1
IBM DB2 8.2 through 9.2
Microsoft SQL Server 2000

DATABASES (Data Sources only)
IBM DB2 7x for z/OS
Teradata (ODBC) V2R6.0.x
Teradata (ODBC) V2R5.1.x

WEB APPLICATION SERVERS
Oracle WebLogic Server 9.2
Oracle Application Server (all releases)
IBM WebSphere Application Server and IBM HTTP Server will not supported with the next release.

IDENTITY MANAGEMENT
Oracle Directory Services
- Oracle Virtual Directory 10.1.4.0.1
Access Management
- Oracle Access Manager 10.1.4.0.1
Oracle Identity Manager 10.1.4.0.1 and higher
Microsoft Active Directory 2000
IBM Tivoli Directory Server 6.1
Sun ONE LDAP 5.2

OTHER CLIENT SOFTWARE
Internet Explorer 6
Firefox 2


Show Related Information Related


Products
  • Middleware > Enterprise Performance Management > Financial Data Quality Management > Hyperion Financial Data Quality Management
  • Middleware > Enterprise Performance Management > Profitability > Hyperion Profitability
  • Middleware > Enterprise Performance Management > Essbase > Hyperion Essbase
  • Middleware > Enterprise Performance Management > Financial Management > Hyperion Financial Management
  • Middleware > Enterprise Performance Management > Planning > Hyperion Planning
  • Middleware > Business Intelligence > Hyperion Query & Reporting > Hyperion BI+
  • Middleware > Enterprise Performance Management > Performance Scorecard > Hyperion Performance Scorecard
  • Middleware > Enterprise Performance Management > Crystal Ball > Oracle Crystal Ball
  • Middleware > Enterprise Performance Management > Integration Management > Hyperion Data Integration Management
  • Middleware > Enterprise Performance Management > Strategic Finance > Hyperion Strategic Finance
  • Middleware > Enterprise Performance Management > Relationship Management > Hyperion Data Relationship Management
Keywords
CERTIFICATION MATRIX

Back to topBack to top

Error: "Error 404" After Configuration "Set up Shared Services and Registry Database Connection" in EPM 11.1.2.1 [ID 1303661.1]


Error: "Error 404" After Configuration "Set up Shared Services and Registry Database Connection" in EPM 11.1.2.1 [ID 1303661.1]

Modified 20-APR-2011 Type PROBLEM Status PUBLISHED

In this Document
Symptoms
Cause
Solution


Applies to:

Hyperion BI+ - Version: 11.1.2.1.000 and later [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms

When the Shared Services URL (http://:19000/interop) is accessed, an Error-404 error will appear.

A run of netstat would not show port 28080 (for Shared Services would not stay up due to lack of relational database repository).

Cause

When 'Next' is clicked after the 'Set up Shared Services and Registry Database Connection...' page is configured, the EPM System Configurator tool immediately attempts to write HSS_COMPONENT_* and CSS_* tables (and ESS_CLUSTER_SERVER_MAPPING) to the relational database schema described on that page.
However when the 'Back' button is clicked on the following page and new connectivity information is entered on the 'Set up Shared Services and Registry Database Connection...' page, the newly configured database will lack those tables. Without those repository database tables Shared Services will not run.

Solution

Workaround:

(1) Delete the Hyperion Shared Services database repository tables ('old' Shared Services repository tables are not reused from 9.2.1 or 9.3.3 or 11.1.1.3 in any case...their data is extracted and reimported).

(2) Delete \Oracle\Middleware\user_projects\epmsystem1\config\foundation\11.1.2.0\reg.properties
or
create a new instance name, (to some name other than the default, 'epmsystem1') such as \Oracle\Middleware\user_projects\epmsystem2

(3) Rerun EPM System Configurator 11.1.2.1

Show Related Information Related


Products
  • Middleware > Business Intelligence > Hyperion Query & Reporting > Hyperion BI+
Keywords
BACK BUTTON; CONFIGURATOR; CONFIGURE; CONFIGURE DATABASE; FOUNDATION; REPOSITORY; SERVICES; SHARED SERVICES
Errors
ERROR 404; 404 ERROR

Back to topBack to top

Tuesday, November 29, 2011

Concurrent Processing - How to Find Database Session & Process Associated with a Concurrent Program Which is Currently Running.


Concurrent Processing - How to Find Database Session & Process Associated with a Concurrent Program Which is Currently Running. [ID 735119.1]

Modified 15-APR-2011 Type HOWTO Status PUBLISHED

In this Document
Goal
Solution


Applies to:

Oracle Application Object Library - Version: 11.5.9 to 12.0.6 - Release: 11.5.10 to 12
Oracle Concurrent Processing - Version: 11.5.10.0 to 12.0.6 [Release: 11.5.10 to 12]
Information in this document applies to any platform.

Goal

1. How to find database session and process associated with a concurrent program which is currently running.

2. How to cancel a concurrent request from database side.

Solution

A concurrent program can be canceled either from "Submit Request Submission" form or from database side also. In case of custom concurrent programs, sometimes concurrent program do not release database session and process even though it has canceled from "Submit Request Submission" form. Active database process can be seen in running status. In those cases there is a need to manually kill those process to release CPU memory.

1. Take the "request_id" of a Concurrent Program which is currently running or which is to be canceled from the database side.

2. Connect to SQLPLUS as APPS User :

SQL> SELECT ses.sid,
ses.serial#
FROM v$session ses,
v$process pro
WHERE ses.paddr = pro.addr
AND pro.spid IN (SELECT oracle_process_id
FROM fnd_concurrent_requests
WHERE request_id = &request_id);

Note : oracle_process_id is Unix PID and request_id is running concurrent program's request ID. If "sid" and "serial#" value is returning then it means that process is running at database level. When canceling a request from the "Submit Request Submission" form, then it should release associated database process and session but it doesn't mean that it will kill database process immediately. Database process will take their own time to validate concurrent program execution process that has been canceled and then it will kill database process. So ideally when canceling a request from "Submit Request Submission", wait for some time and then check associated database process.

3. Connect to SQLPLUS as the SYSTEM user:

SQL> ALTER SYSTEM KILL SESSION 'sid,serial#';

Note the "sid" and "serial#" value returned from step 1.


Show Related Information Related


Products
  • Oracle E-Business Suite > Applications Technology > Application Object Library > Oracle Application Object Library
  • Oracle E-Business Suite > Applications Technology > Application Object Library > Oracle Concurrent Processing
Keywords
FND_CONCURRENT_REQUESTS; KILL SESSION; SESSION; SID; V$PROCESS; V$SESSION

Back to topBack to top

How to Start and Stop Financial Management (HFM) Server Windows Processes [ID 989574.1]


How to Start and Stop Financial Management (HFM) Server Windows Processes [ID 989574.1]

Modified 08-FEB-2011 Type REFERENCE Status PUBLISHED

In this Document
Purpose
Scope
How to Start and Stop Financial Management (HFM) Server Windows Processes
What are the main Windows processes of an HFM application server?
What happens when I start the HFM Windows Service?
What happens when I stop the HFM Windows Service?
Why should I use the HFM Windows Service?
When should I not use the HFM Windows Service?
Allowing HFM to start and stop as needed.
Why do I see multiple HsvDataSource.exe processes on an HFM application server?
When does the HsvDataSource.exe process stop itself?
Why might the HsvDataSource.exe not stop by itself?
What is the CASSecurity.exe process?
In what order should the HFM processes be stopped?


Applies to:

Hyperion Financial Management - Version: 1.0.0.0.00 to 11.1.2.0.00 - Release: 1.0 to 11.1
Information in this document applies to any platform.

Purpose

This document describes the starting and stopping of the main Windows processes that are seen in the Windows Task Manager of a HFM application server.

Scope

This document is intended for use by Hyperion Financial Management administrators with a good understanding of the Windows Task Manager, in particular the Processes tab.

How to Start and Stop Financial Management (HFM) Server Windows Processes

What are the main Windows processes of an HFM application server?

The main Windows processes of a HFM application server are HsxService.exe, HsxServer.exe, CASSecurity.exe and HsvDatasource.exe.

What happens when I start the HFM Windows Service?

Oracle's Hyperion Financial Management can be started by starting the Windows Service "Hyperion Financial Management - Management Service". When this service is started, a process called HsxService.exe will become visible in the Windows Task Manager, and will remain running until the Windows Service is stopped. The HsxServer.exe, CASSecurity.exe and HsvDataSource.exe processes are also started.

What happens when I stop the HFM Windows Service?

When the Hyperion Financial Management Windows service is stopped, the HsxService.exe process will be stopped along with the HsvDataSource.exe, CASSecurity.exe and HsxServer.exe processes.

Why should I use the HFM Windows Service?

Oracle typically recommends that customers use the Windows Service approach only when their individual applications within their HFM database are known to take several minutes to start up. By starting the Windows Service, the application server will pre-launch each application, which will then be "active" and already started when the first user attempts to connect to the application. In this way, the user will not experience any "delay" while logging in, due to application startup time.

Applications may take longer to start up when their metadata dimensions are very large, when an application server or database is under heavy load, or when the rules file of the application contains a slow performing "NoInput" rules section. This section may take longer to execute if it contains many loop statements through many different metadata Point of View (POV) members. Care should be taken when designing metadata and NoInput rules routines to reduce the start up time of an individual application.

When should I not use the HFM Windows Service?

A potential disadvantage of using the Windows Service approach is that all applications are started, regardless of the true requirement and usage of the end users. If there are many applications that exist in the HFM database, unnecessary memory and CPU cycles may be used launching applications which are not needed by the end users. For this reason, Oracle recommends that customers not keep unused HFM applications in production environment HFM databases, or to not use the HFM Windows Service approach if there are known unused HFM applications in the database.

Allowing HFM to start and stop as needed.

If the HFM Windows Service is not being used as above, Financial Management will start itself when end users attempt to log on to an HFM application. When any end user connects to HFM for the first time on a particular application server, the process HsxServer.exe will be started. This process builds connections to the HFM database repository, authenticates the user connecting, and returns a list of available HFM applications within the database. There will only be one HsxServer.exe process on each application server. If the end user who connected to the HFM application server then proceeds to select an HFM application name to open, the HsxServer.exe process will then launch the HsvDataSource.exe Windows process to start that application. The HsxServer.exe process will remain running until there are no users logged on to that application server and all HsvDataSource.exe processes have also stopped.

Why do I see multiple HsvDataSource.exe processes on an HFM application server?

Hyperion Financial Management opens one HsvDataSource.exe (HSVDAT~1.EXE) process on the HFM server per active application. Connections are application specific. If multiple applications are opened, multiple HsvDataSource.exe processes will be launched.

When an application is opened, a database connection pool is created between the application process and the relational database (SQL Server / Oracle / DB2 etc). However, connections are not released on an application basis - they are released on an application server basis. All connections are not released until the application server has no Financial Management users accessing any application.

When does the HsvDataSource.exe process stop itself?

When an application server determines that all users of a particular application on that application server have correctly logged off or timed out (e.g. web time out), then it sends a signal to the HsvDataSource.exe process running that application to stop itself.

When all HsvDataSource.exe processes on a particular application server have stopped themselves, then the HsxServer.exe and CASSecurity.exe processes will also be stopped. After a short delay, under normal circumstances, all HFM processes will stop themselves. Only when all HFM processes on all HFM application servers have been stopped is it safe to make changes to the relational database for example, copying applications, taking or restoring backups of the database or powering down the database. Changes to the database should NOT be made while any HsvDataSource.exe process is seen running in the Windows Task Manager.

Why might the HsvDataSource.exe not stop by itself?

If end users log off incorrectly, their sessions may not have stopped. Hyperion Reports, Financial Reporting, Web Analysis, Financial Data Quality Management, Shared Services task flows or other modules may be holding open connections to Financial Management applications. All other Hyperion processes and services which may be connecting to Financial Management should be stopped first. Financial Management administrators may like to use the "Users on System" module of Financial Management to stop end user connections. When Financial Management decides that all connections have stopped, it should proceed to shut itself down automatically.

What is the CASSecurity.exe process?

Another Windows process is CASSecurity.exe. This is a process that manages the interface between Financial Management and Hyperion Shared Services modules. It handles some of the authorization and authentication processes of HFM, as well as security related features while the application is running. Important Note: Any change in the Shared Services external provider configuration REQUIRES the CASSecurity.exe process to be recycled in order gain access to the provider changes. Follow the "In what order should the HFM processes be stopped" section.

In what order should the HFM processes be stopped?

If Financial Management appears to have frozen / crashed it may be necessary to stop the processes. Processes should be stopped in the following order:

  1. The Hyperion Financial Management Windows Service (HsxService.exe) should be stopped via the Windows Services if it seen to be running.
  2. The HsvDataSource.exe for each application should be shut down. Ideally it should be observed that the HsvDataSource.exe is using 00% CPU in the Windows Task Manager before it is stopped using "End Process". Care should be taken when stopping running processes.
  3. Any CASSecurity.exe process which is still running in the Windows Task Manager should be stopped using "End Process"
  4. If any HsxServer.exe process is still running, it should be stopped using "End Process"

    CAUTION: In a multi-server environment where multiple application servers are connecting to the same relational database, the process of stopping HFM should be repeated on ALL HFM application servers before attempting to restart any HFM processes or "bring up" the applications once again. It is not recommended to stop and start any one server independently but instead to stop the whole environment and then bring it back up.