Knowledgebase: HFM
Hyperion Financial Management Application Creation Fails With ORA-12520 Errors
Posted by Priya Doyle on 02 December 2010 08:34 AM

Hyperion Financial Management Application Creation Fails With ORA-12520 Errors

 Modified 22-APR-2010 

Applies to:

Hyperion Financial Management - Version: 9.3.1.0.00 to 11.1.2.0.00 - Release: 9.3 to 11.1
Hyperion Financial Management - Version: 9.3.1.0.00 to 11.1.2.0.00   [Release: 9.3 to 11.1]
Information in this document applies to any platform.

Symptoms

An Enterprise Performance Management Architect (EPMA) type Hyperion Financial Management (HFM) application could not be deployed. The EPMA job library displays the following messages for the attempted deployment job:

An unknown error has occurred in the HsvDataSourceImpl object. 
Status : Aborted 
Progress : 100%

Review of the attachment job message shows details similar to the following: 

Error Reference number: {C9D47FDF-3014-4E71-B740-956C6C8ED009} 
Num: 0x80004005;Type: 1;DTime: mm/dd/yyy hh:mm:ss AM/PM; Svr: <server_name>;File:HFMADOConnection.cpp;Line: 260;Ver: 11.1.1.2.0.2207;DStr: ORA-12520: TNS:listener could not find available handler for requested type of Server; 
Num: 0x80004005;Type: 0;DTime: mm/dd/yyy hh:mm:ss AM/PM;Svr: <server_name>;File: CHsxSQLConnectionPool.cpp;Line: 375;Ver: 11.1.1.2.0.2207; 
Num: 0x80004005;Type: 0;DTime: mm/dd/yyy hh:mm:ss AM/PM;Svr: <server_name>;File: CHvDSSQL.cpp;Line: 261;Ver: 11.1.1.2.0.2207; 
Num: 0x80041a01;Type: 1;DTime: mm/dd/yyy hh:mm:ss AM/PM;Svr: <server_name>;File: CHsvDataSourceImpl.cpp;Line: 402;Ver: 11.1.1.2.0.2207; 
Num: 0x8000ffff;Type: 0;DTime: mm/dd/yyy hh:mm:ss AM/PM;Svr: <server_name>;File: CHsvDataSourceimpl.cpp;Line: 415;Ver: 11.1.1.2.0.2207;


Cause

The Oracle instance initialization parameters have not been optimized for the expected number of database connections that will come from HFM application servers.

Solution

Oracle instance must have the appropriate values configured for the SESSIONS and PROCESSES initialization parameters.
 
Details for determining appropriate values can be found in the Database Information For Financial Management section of the EPM Installation and Configuration Guide as well as in the HFM Performance Tuning Guide

References

NOTE:1083460.1 - Hyperion Financial Management (HFM) Performance Tuning Guide, Fusion Edition


(1 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: