Last updated on MARCH 02, 2017
Applies to:Hyperion Financial Management - Version 184.108.40.206.000 and later
Information in this document applies to any platform.
- This is a new installation and the first time extracting data to database using HFM 220.127.116.11.000 through 18.104.22.168.203.
- Recently applied HFM 22.214.171.124.204 to prior release that previously worked.
- User is unable to exact data to database.
- The following error occurs in the in extract result log:
"Data extract completed with errors for Application MYAPP using prefix MYAPP. Error code is: -2147220797 : (-2147220797) (An error occurred in creating an ODBC connection.)"
- When you use Oracle Service Name in the in HFM Consolidation Administration DSN entry the Connection Testing is failing with the below error message:
"Listener refused the connection with following error: ORA-12505, TNS: listener does not currently know of SID given in connect descriptor"
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms