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 27, 2018

Applies to:

Hyperion Financial Management - Version 11.1.2.4.200 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.

Symptoms

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] [11.1.2.4.206.5284] 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] [11.1.2.4.206.5284] 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] [11.1.2.4.206.5284] 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] [11.1.2.4.206.5284] [[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] [11.1.2.4.206.5284]  [[Wait time expired. Block records deleted]]

 

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.