Hyperion Financial Management (HFM) Errors Running Data Extract To Database: "EPMHFM-07406" "An Error Occurred In Creating An ODBC Connection." "Failed to create DB connection"
(Doc ID 2743606.1)
Last updated on JULY 08, 2024
Applies to:
Hyperion Financial Management - Version 11.2.3.0.000 and laterInformation in this document applies to any platform.
Symptoms
When running Data Extract to Oracle database, 2 errors appear in logs prior to data extract starting:
[XFM] [ERROR:1] [EPMHFM-07406] [XFM] [ecid: ] [File: c:\repos\hfm-build\source\commonservercomponents\xfmcommon\xfmodbc.cpp] [Line: 856] [userId: ] [Msg arguments: ] [appName: <APPNAME>] [pid: ] [tid: ] [host: <HOST>] [nwaddr:] [errorCode: 800402C3] [srcException: 1] [errType: 1] [dbUpdate: 1] [11.2.3.0.000.7450] An error occurred in creating an ODBC connection. [[08001]]
[XFM] [ERROR:1] [EPMHFM-07406] [XFM] [ecid: e3601f5a-95ef-4247-b014-1249b4e7744a-00000002] [File: c:\repos\hfm-build\source\commonservercomponents\xfmcommon\xfmodbc.cpp] [Line: 945] [userId: ] [Msg arguments: ] [appName: <APPNAME>] [pid: ] [tid: ] [host: <HOST>] [nwaddr: 10.2.116.69:0;] [errorCode: 800402C3] [srcException: 1] [errType: 1] [dbUpdate: 1] [11.2.3.0.000.7450] An error occurred in creating an ODBC connection. [[Failed to create DB connection.]]
[XFM] [TRACE:1] [EPMHFM-00000] [XFM] [ecid: ] [File: dataextracthelper.cpp] [Line: 1148] [userId: ] [Msg arguments: ] [appName: <APPNAME>] [pid: ] [tid: ] [host: <HOST>] [nwaddr: ] [errorCode: 0] [srcException: 0] [errType: 1] [dbUpdate: 1] [11.2.3.0.000.7450] [[Extended Analytics export started for application <APPNAME> and Label <LABEL>]]
[XFM] [ERROR:1] [EPMHFM-07406] [XFM] [ecid: e3601f5a-95ef-4247-b014-1249b4e7744a-00000002] [File: c:\repos\hfm-build\source\commonservercomponents\xfmcommon\xfmodbc.cpp] [Line: 945] [userId: ] [Msg arguments: ] [appName: <APPNAME>] [pid: ] [tid: ] [host: <HOST>] [nwaddr: 10.2.116.69:0;] [errorCode: 800402C3] [srcException: 1] [errType: 1] [dbUpdate: 1] [11.2.3.0.000.7450] An error occurred in creating an ODBC connection. [[Failed to create DB connection.]]
[XFM] [TRACE:1] [EPMHFM-00000] [XFM] [ecid: ] [File: dataextracthelper.cpp] [Line: 1148] [userId: ] [Msg arguments: ] [appName: <APPNAME>] [pid: ] [tid: ] [host: <HOST>] [nwaddr: ] [errorCode: 0] [srcException: 0] [errType: 1] [dbUpdate: 1] [11.2.3.0.000.7450] [[Extended Analytics export started for application <APPNAME> and Label <LABEL>]]
Changes
HFM DSN using Oracle Service name not SID
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 |
| Changes |
| Cause |
| Solution |
| References |