My Oracle Support Banner

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 JANUARY 21, 2021

Applies to:

Hyperion Financial Management - Version 11.2.3.0.000 and later
Information 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>]]



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


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