Hyperion Financial Management (HFM) Error When Extracting Data to Database: "Data extract completed with errors for Application MYAPP using prefix MYAPP. Error code is: -2147220797 : (-2147220797) (An error occurred in creating an ODBC connection." (Doc ID 1999126.1)

Last updated on MARCH 02, 2017

Applies to:

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

Symptoms

"Data extract completed with errors for Application MYAPP using prefix MYAPP. Error code is: -2147220797 : (-2147220797) (An error occurred in creating an ODBC connection.)"

 

"Listener refused the connection with following error: ORA-12505, TNS: listener does not currently know of SID given in connect descriptor"

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