Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

An error occurred in creating an ODBC connection

rajneesh sharmaJan 15 2017 — edited Jan 17 2017

Hello

I am trying to export data to an oracle database schema in HFM 11.1.2.4 data extract option. But I am getting these errors

Processing status change: (-2147220797)

1/16/2017 2:33:13 AM : Status : Processing completed with errors

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

I have below 2 data sources defined in Consolidation Administration -> Configure DSN and both are test connecting to database successfully

hfm_star_schema

hfmtns

The HFM application overall is working fine.

Any idea. Thanks.

This post has been answered by Vikram VK on Jan 16 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 14 2017

Added on Jan 15 2017

#business-intelligence-applications, #financial-consolidation, #performance-management-applications

4 comments

1,057 views