We are currently unable to export data from our production 11.1.2.4.206 HFM to a MS SQL Database. This process works fine in the development environment. The database connection information is the same in both environments and test connection works in both environments. There are no firewall configurations blocking ports. Has anyone faced this issue or have a suggestion? Is there anything that needs to be set up besides the database in Configure DSN?
Below is an excerpt from the xfm.odi:
[2019-06-06T09:52:34.314260-05:00] [XFM] [ERROR:1] [EPMHFM-07392] [XFM] [ecid: 00iuJw_jxfKFw00Fzzw0w000037C003c18] [File: XfmODBC.cpp] [Line: 203] [userId: ] [Msg arguments: ] [appName: SCPROD1] [pid: 11316] [tid: 14532] [host: ICTHYP2] [nwaddr: 10.1.3.152:0;] [errorCode: 800402B5] [srcException: NotSpec] [errType: 1] [dbUpdate: 2] [11.1.2.4.206.5284] An unknown error occurred in an ODBC object. [[1 record: SQLSTATE = 28000; NATIVE ERROR = 18456; MSG = [DataDirect][ODBC SQL Server Wire Protocol driver][SQL Server]Login failed for user 'Hyperion'.]]
[2019-06-06T09:52:34.314260-05:00] [XFM] [ERROR:1] [EPMHFM-07406] [XFM] [ecid: 00iuJw_jxfKFw00Fzzw0w000037C003c18] [File: XfmODBC.cpp] [Line: 615] [userId: ] [Msg arguments: ] [appName: SCPROD1] [pid: 11316] [tid: 14532] [host: ICTHYP2] [nwaddr: 10.1.3.152:0;] [errorCode: 800402C3] [srcException: XfmExc] [errType: 1] [dbUpdate: 1] [11.1.2.4.206.5284] An error occurred in creating an ODBC connection. [[28000]]
[2019-06-06T09:52:34.329892-05:00] [XFM] [ERROR:1] [EPMHFM-07406] [XFM] [ecid: 00iuJw_jxfKFw00Fzzw0w000037C003c18] [File: XfmODBC.cpp] [Line: 700] [userId: ] [Msg arguments: ] [appName: SCPROD1] [pid: 11316] [tid: 14532] [host: ICTHYP2] [nwaddr: 10.1.3.152:0;] [errorCode: 800402C3] [srcException: XfmExc] [errType: 1] [dbUpdate: 1] [11.1.2.4.206.5284] An error occurred in creating an ODBC connection. [[Failed to create DB connection.]]
[2019-06-06T09:52:34.329892-05:00] [XFM] [ERROR:1] [EPMHFM-07406] [XFM] [ecid: 00iuJw_jxfKFw00Fzzw0w000037C003c18] [File: CSQLConnectionPool.cpp] [Line: 142] [userId: ] [Msg arguments: ] [appName: SCPROD1] [pid: 11316] [tid: 14532] [host: ICTHYP2] [nwaddr: 10.1.3.152:0;] [errorCode: 800402C3] [srcException: XfmExc] [errType: 0] [dbUpdate: 0] [11.1.2.4.206.5284] An error occurred in creating an ODBC connection. [[]]
[2019-06-06T09:52:34.329892-05:00] [XFM] [ERROR:1] [EPMHFM-07406] [XFM] [ecid: 00iuJw_jxfKFw00Fzzw0w000037C003c18] [File: CSQLConnectionPool.cpp] [Line: 932] [userId: ] [Msg arguments: ] [appName: SCPROD1] [pid: 11316] [tid: 14532] [host: ICTHYP2] [nwaddr: 10.1.3.152:0;] [errorCode: 800402C3] [srcException: XfmExc] [errType: 0] [dbUpdate: 0] [11.1.2.4.206.5284] An error occurred in creating an ODBC connection. [[]]
[2019-06-06T09:52:34.329892-05:00] [XFM] [ERROR:1] [EPMHFM-07406] [XFM] [ecid: 00iuJw_jxfKFw00Fzzw0w000037C003c18] [File: EAProcessing.cpp] [Line: 1907] [userId: ] [Msg arguments: ] [appName: SCPROD1] [pid: 11316] [tid: 14532] [host: ICTHYP2] [nwaddr: 10.1.3.152:0;] [errorCode: 800402C3] [srcException: XfmExc] [errType: 0] [dbUpdate: 1] [11.1.2.4.206.5284] An error occurred in creating an ODBC connection. [[]]
[2019-06-06T09:52:34.329892-05:00] [XFM] [ERROR:1] [EPMHFM-07406] [XFM] [ecid: 00iuJw_jxfKFw00Fzzw0w000037C003c18] [File: CXfmData.cpp] [Line: 20594] [userId: ] [Msg arguments: ] [appName: SCPROD1] [pid: 11316] [tid: 14532] [host: ICTHYP2] [nwaddr: 10.1.3.152:0;] [errorCode: 800402C3] [srcException: XfmExc] [errType: 0] [dbUpdate: 0] [11.1.2.4.206.5284] An error occurred in creating an ODBC connection. [[]]
[2019-06-06T09:52:34.329892-05:00] [XFM] [ERROR:1] [EPMHFM-07406] [XFM] [ecid: 00iuJw_jxfKFw00Fzzw0w000037C003c18] [File: ..\Handlers\loadExtract\DataExtractHelper.cpp] [Line: 382] [userId: ] [Msg arguments: ] [appName: SCPROD1] [pid: 11316] [tid: 14532] [host: ICTHYP2] [nwaddr: 10.1.3.152:0;] [errorCode: 800402C3] [srcException: XfmExc] [errType: 0] [dbUpdate: 0] [11.1.2.4.206.5284] An error occurred in creating an ODBC connection. [[]]
[2019-06-06T09:52:34.329892-05:00] [XFM] [ERROR:1] [EPMHFM-00000] [XFM] [ecid: 00iuJw_jxfKFw00Fzzw0w000037C003c18] [File: DataExtractHelper.cpp] [Line: 665] [userId: ] [Msg arguments: ] [appName: SCPROD1] [pid: 11316] [tid: 14532] [host: ICTHYP2] [nwaddr: 10.1.3.152:0;] [errorCode: 80004005] [srcException: NotSpec] [errType: 1] [dbUpdate: 1] [11.1.2.4.206.5284] [[Data extract completed with errors for Application SCPROD1 using prefix HFMALL. Error code is: -2147220797]]