My Oracle Support Banner

Hyperion Financial Management (HFM) Performance Slow and Tasks Fail or Abort with Errors in System Messages: "Database connection failure" "Stale DB connection found!! Replaced with new DB connection." "Wait time expired. Block" (Doc ID 2408794.1)

Last updated on JUNE 18, 2021

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: ] [tid: ] [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: ] [tid: ] [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: ] [tid: ] [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: ] [tid: ] [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=]]

[YYYY-MM-DDTHH:MM:SS.] [XFM] [WARNING:1] [EPMHFM-00000] [XFM] [ecid: ] [File: CXfmClusterController.cpp] [Line: 1367] [userId: ] [Msg arguments: ] [appName: <APPNAME>] [pid: ] [tid: 15876] [host: <HOST>] [nwaddr: [] [errorCode: 0] [srcException: NotSpec] [errType: 1] [dbUpdate: 1] []  [[Wait time expired. Block records deleted]]





To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.