Hyperion Financial Management (HFM) Connection Issues "[DataDirect][ODBC Oracle Wire Protocol Driver][Oracle]ORA-03114: Not Connected" or "[ODBC SQL Server Wire Protocol driver]Unexpected Network Error. ErrNum = 10060]" (Doc ID 2113368.1)

Last updated on NOVEMBER 10, 2016

Applies to:

Hyperion Financial Management - Version 11.1.2.4.102 and later
Information in this document applies to any platform.

Symptoms

Network or database outage results in HFM not being able to re-establish connections, resulting in HFM application hang.  The following are examples of errors logged in the application's ODL log:

Oracle database

Num: 0x800402B5;Type: 1;DTime: YYYY-MM-DDTHH:MM:SS;Svr: MYSERVER;File: XfmODBC.cpp;Line: 193;Version: 11.1.2.4.102.5088;Dstr: 1 record: SQLSTATE = 08S01; NATIVE ERROR = -3114; MSG = [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-03114: not connected to ORACLE;

 MS SQL database

Line 20216: [YYYY-MM-DDTHH:MM:SS] [XFM] [ERROR:1] [EPMHFM-07392] [XFM] [ecid: ] [File: XfmODBC.cpp] [Line: 192] [userId: ] [appName: MYAPP] [pid: 5924] [tid: 8640] [host: MYSERVER] [nwaddr:;] [errorCode: 800402B5] [srcException: NotSpec] [errType: 1] [dbUpdate: 1] [11.1.2.4.100.5026] An unknown error occurred in an ODBC object. [[1 record: SQLSTATE = 08S01; NATIVE ERROR = 0; MSG = [DataDirect][ODBC SQL Server Wire Protocol driver]Unexpected Network Error. ErrNum = 10060]]

 

Cause

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 hundreds of Community platforms