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!

HFM datasource error

pr144Jun 7 2017 — edited Aug 19 2017

I can register but can't open a HFM application...I see this error in the xfm.odl.TESTAPP-1

(I applied the latest patches)

[2017-06-06T19:08:58.866141-04:00] [XFM] [ERROR:1] [EPMHFM-07392] [XFM] [ecid: XDS.0000.0000.0000.0001] [File: XfmODBC.cpp] [Line: 203] [userId: ] [appName: TESTAPP] [pid: 3040] [tid: 3676] [host: hfm_server] [nwaddr: 179.22.147.224:0;] [errorCode: 800402B5] [srcException: NotSpec] [errType: 1] [dbUpdate: 2] [11.1.2.4.204.5264] An unknown error occurred in an ODBC object. [[1 record: SQLSTATE = HY000; NATIVE ERROR = 0; MSG = [DataDirect][ODBC SQL Server Wire Protocol driver]Insufficient information to connect to the data source.]]

[2017-06-06T19:08:58.881742-04:00] [XFM] [ERROR:1] [EPMHFM-07406] [XFM] [ecid: XDS.0000.0000.0000.0001] [File: XfmODBC.cpp] [Line: 615] [userId: ] [appName: TESTAPP] [pid: 3040] [tid: 3676] [host: hfm_server] [nwaddr: 179.22.147.224:0;] [errorCode: 800402C3] [srcException: XfmExc] [errType: 1] [dbUpdate: 1] [11.1.2.4.204.5264] An error occurred in creating an ODBC connection. [[HY000]]

[2017-06-06T19:08:58.881742-04:00] [XFM] [ERROR:1] [EPMHFM-07406] [XFM] [ecid: XDS.0000.0000.0000.0001] [File: XfmODBC.cpp] [Line: 700] [userId: ] [appName: TESTAPP] [pid: 3040] [tid: 3676] [host: hfm_server] [nwaddr: 179.22.147.224:0;] [errorCode: 800402C3] [srcException: XfmExc] [errType: 1] [dbUpdate: 1] [11.1.2.4.204.5264] An error occurred in creating an ODBC connection. [[Failed to create DB connection.]]

[2017-06-06T19:08:58.881742-04:00] [XFM] [TRACE:1] [EPMHFM-00000] [XFM] [ecid: ] [File: XFMDataSource.cpp] [Line: 499] [userId: ] [appName: TESTAPP] [pid: 3040] [tid: 3676] [host: hfm_server] [nwaddr: 179.22.147.224:0;] [errorCode: 0] [srcException: NotSpec] [errType: 1] [dbUpdate: 2] [11.1.2.4.204.5264] [[XDS: XFMDataSource process exiting with unknown exception ...]]

[2017-06-06T19:08:58.881742-04:00] [XFM] [TRACE:1] [EPMHFM-00000] [XFM] [ecid: ] [File: XFMDataSource.cpp] [Line: 508] [userId: ] [appName: TESTAPP] [pid: 3040] [tid: 3676] [host: hfm_server] [nwaddr: 179.22.147.224:0;] [errorCode: 0] [srcException: NotSpec] [errType: 1] [dbUpdate: 2] [11.1.2.4.204.5264] [[XDS: XFMDataSource process exiting now ...]]

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 16 2017

Added on Jun 7 2017

#business-intelligence-applications, #epm-system-infrastructure, #performance-management-applications

8 comments

1,524 views