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 FEBRUARY 09, 2024
Applies to:
Hyperion Financial Management - Version 11.1.2.4.200 and laterInformation 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:
- Database connection failure
- An unknown error occurred in an ODBC object
- Stale DB connection found!! Replaced with new DB connection
- An unknown error has occurred in the HsvClusterController object
- Failed to added lock into the DB. It's possible that the same thread can ask for the same lock twice
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]]
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! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |