Hyperion Financial Management (HFM) Performance Deteriorates for Consolidation, Load and Update Activity

(Doc ID 2408794.1)

Last updated on JUNE 08, 2018

Applies to:

Hyperion Financial Management - Version and later
Information in this document applies to any platform.
HFM creates a pool of connections at startup and maintains this pool for as long as the application is kept running. The number initial pool connections is configurable but the default is 40 connections per application per server. If more than one HFM application has been defined in the EPM System Registry, an additional pool of connections is required to handle application integrity. This additional pool is known internally as the Cluster Controller pool and is not configurable.

At no time should any HFM connection be reset, even when idle.


Error Messages found in System Messages and HFM ODL logs:

Exert from xfm.odl.<APPLICATION_NAME>.log:

[YYYY-MM-DDTHH:MM:SS.] [XFM] [ERROR:1] [EPMHFM-07441] [XFM] [ecid: ] [File: ..\..\SharedSourceCode\AccessorClusterController.cpp] [Line: 821] [userId: ] [Msg arguments: ] [appName: <APPNAME>] [pid: 13676] [tid: 2368] [host: <HOST>] [nwaddr: ] [errorCode: 800402D5] [srcException: XfmExc] [errType: 0] [dbUpdate: 0] [] Database connection failure [[]]
[YYYY-MM-DDTHH:MM:SS.] [XFM] [TRACE:1] [EPMHFM-07441] [XFM] [ecid: ] [File: XfmODBC.cpp] [Line: 442] [userId: ] [Msg arguments: ] [appName: <APPNAME>] [pid: 13676] [tid: 15512] [host: <HOST>] [nwaddr: ] [errorCode: 800402D5] [srcException: NotSpec] [errType: 1] [dbUpdate: 2] [] Database connection failure [[Stale DB connection found!! Replaced with new DB connection.]]
[YYYY-MM-DDTHH:MM:SS.] [XFM] [ERROR:1] [EPMHFM-07392] [XFM] [ecid: ] [File: XfmODBC.cpp] [Line: 168] [userId: ] [Msg arguments: ] [appName: <APPNAME>] [pid: 13676] [tid: 2368] [host: <HOST>] [nwaddr: ] [errorCode: 800402B5] [srcException: NotSpec] [errType: 0] [dbUpdate: 2] [] An unknown error occurred in an ODBC object. [[The handle indicated by HandleType and Handle was not a valid handle]]
[YYYY-MM-DDTHH:MM:SS.] [XFM] [ERROR:1] [EPMHFM-00000] [XFM] [ecid: ] [File: AccessorClusterController.cpp] [Line: 435] [userId: ] [Msg arguments: ] [appName: <APPNAME>] [pid: 13676] [tid: 15512] [host: <HOST>] [nwaddr: ] [errorCode: 80004005] [srcException: NotSpec] [errType: 1] [dbUpdate: 1] [] [[Failed to added lock into the DB. It's possible that the same thread can ask for the same lock twice.SERVERNAME=<HOST>;THREADID=;LOCKTYPE=;LOCKID=;SCENARIO=;YEAR=;ENTITY=;PARENT=;VALUE=;WRITER=;READERIMPACTING=]]




Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms