8 Replies Latest reply on Jan 17, 2019 4:38 PM by Chris Badenhorst

    HFM Data Extract Fails when exporting to Database

    Chris Badenhorst

      Hi

       

      We are trying to export metadata and data from our HFM application to an Oracle database. I've successfully created the DSN and when clicking on 'Test Connection', it is Successful.

       

      However, when running the data extract, we get an error:

      Processing status change: (-2147220797)

      12/5/2018 9:08:25 AM : Status : Processing completed with errors

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

       

      Below is an extract of the xfm.odl  log:

       

      [errorCode: 800402B5] [srcException: NotSpec]
      [errType: 1] [dbUpdate: 2] [11.1.2.4.207.5298] An unknown error occurred in an
      ODBC object. [[1 record: SQLSTATE = 08001; NATIVE ERROR = 0; MSG =
      [DataDirect][ODBC Oracle Wire Protocol driver]Connection refused. Verify Host
      Name and Port Number.]]

      [errorCode: 800402B5] [srcException: NotSpec]
      [errType: 1] [dbUpdate: 2] [11.1.2.4.207.5298] An unknown error occurred in an
      ODBC object. [[1 record: SQLSTATE = 08001; NATIVE ERROR = 0; MSG =
      [DataDirect][ODBC Oracle Wire Protocol driver]Connection refused. Verify Host
      Name and Port Number.2 record: SQLSTATE = 08001; NATIVE ERROR = -1; MSG =
      [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-12203: unable to
      connect to destination]]

      [errorCode: 800402C3] [srcException: XfmExc] [errType:
      1] [dbUpdate: 1] [11.1.2.4.207.5298] An error occurred in creating an ODBC
      connection. [[08001]]

      [errorCode: 800402C3] [srcException: XfmExc] [errType:
      1] [dbUpdate: 1] [11.1.2.4.207.5298] An error occurred in creating an ODBC
      connection. [[Failed to create DB connection.]]

      [errorCode:
      800402B5] [srcException: NotSpec] [errType: 1] [dbUpdate: 2]
      [11.1.2.4.207.5298] An unknown error occurred in an ODBC object. [[1 record:
      SQLSTATE = HY000; NATIVE ERROR = 0; MSG = [DataDirect][ODBC Oracle Wire
      Protocol driver]Cannot open TNS Names file.]]

      [errorCode:
      800402C3] [srcException: XfmExc] [errType: 1] [dbUpdate: 1] [11.1.2.4.207.5298]
      An error occurred in creating an ODBC connection. [[HY000]]

       

      Our HFM version is 11.1.2.4.206.5291 Our DB is MS SQL. We have confirmed that all IPs and Ports are open on the firewalls.

       

      Any suggestions of what the cause might be?

       

      Thank you.

       

      Chris.