2 Replies Latest reply on May 11, 2012 8:48 AM by SH_INT

    FDM Export failed. Essbase API Procedure: [EsbInit] Threw code: 1030803

    783124
      We installed the Oracle SQL Developer client tools on our FDM server yesterday. Beforehand, we were successfully able to export FDM data to Essbase fine. However, since the installation we now receive the following error and cannot export data from FDM to Essbase. This may be a red herring, but it is the only config change we are aware of which may have caused this issue:


      FDM Web Client Error:
      Error: Export failed.
      Detail: Essbase API Procedure: [EsbInit] Threw code: 1030803 - .
      At Line: 124


      We have looked again at the system environment variables, specifically the Path variable settings, and have re-ordered the values to put the 32-bit client first. We have tried several variations on this, however it has not resolved the issue. Does anyone please have any ideas? Further details given below:


      Environment variables:
      EPM_ORACLE_HOME=D:\Oracle\Middleware\EPMSystem11R1
      ESSBASEPATH=D:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0
      ESSLANG=English_UnitedStates.Latin1@Binary
      HYPERION_HOME=D:\Oracle\Middleware\EPMSystem11R1
      Path=D:\Oracle\Middleware\EPMSystem11R1\bin-32;D:\Oracle\Middleware\EPMSystem11R1\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;D:\Oracle\Middleware\EPMSystem11R1\common\ODBC-64\Merant\6.0\Drivers;D:\Oracle\Middleware\EPMSystem11R1\products\Essbase\eas\console\bin;D:\Oracle\Middleware\EPMSystem11R1\common\JRE\Sun\1.6.0\bin;D:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0\bin;D:\Oracle\Middleware\EPMSystem11R1\products\Essbase\EssbaseClient-32\bin;C:\oracle\product\11.2.0\client_1\bin;c:\oracle\product\11.2.0\client_64\bin


      FDM Web Client Error Log:
      ** Begin Oracle Hyperion FDM Adapter for Essbase Runtime Error Log Entry [2012-05-11-09:09:19] **
      -------------------------------------------------------------
      Error:
      Code..............10404
      Description.......Essbase API Procedure: [EsbInit] Threw code: 1030803 - .
      Procedure.........clsHPConnection.fConnect
      Component.........upsES11XG4H
      Version...........100
      Thread............4132

      Identification:
      User..............*******
      Computer Name.....*******

      Essbase Connection:
      App Name..........Monthly
      DB Name...........Monthly
      Server Name.......*******
      Connect Status.... No Connection Open


      ** Begin FDM Runtime Error Log Entry [2012-05-11 09:09:20] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. 10404
      Description...................................... Essbase API Procedure: [EsbInit] Threw code: 1030803 - .
      At Line: 124
      Procedure........................................ clsBlockProcessor.ActConnect
      Component........................................ upsWBlockProcessorDM
      Version.......................................... 1112
      Thread........................................... 4076

      IDENTIFICATION:
      User............................................. *******
      Computer Name.................................... *******
      App Name......................................... FDMMONTHLY
      Client App....................................... WebClient

      CONNECTION:
      Provider......................................... ORAOLEDB.ORACLE
      Data Server......................................
      Database Name.................................... *******
      Trusted Connect.................................. False
      Connect Status.. Connection Open

      GLOBALS:
      Location......................................... CODA_TB
      Location ID...................................... 748
      Location Seg..................................... 2
      Category......................................... WLCURRENTYEAR
      Category ID...................................... 14
      Period........................................... PERIOD00
      Period ID........................................ 02/07/2011
      POV Local........................................ False
      Language......................................... 1033
      User Level....................................... 1
      All Partitions................................... True
      Is Auditor....................................... False


      ** Begin FDM Runtime Error Log Entry [2012-05-11 09:09:20] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. 10404
      Description...................................... Essbase API Procedure: [EsbInit] Threw code: 1030803 - .
      At Line: 124
      Procedure........................................ clsBlockProcessor.ActExport
      Component........................................ upsWBlockProcessorDM
      Version.......................................... 1112
      Thread........................................... 4076

      IDENTIFICATION:
      User............................................. *******
      Computer Name.................................... *******
      App Name......................................... FDMMONTHLY
      Client App....................................... WebClient

      CONNECTION:
      Provider......................................... ORAOLEDB.ORACLE
      Data Server......................................
      Database Name.................................... *******
      Trusted Connect.................................. False
      Connect Status.. Connection Open

      GLOBALS:
      Location......................................... CODA_TB
      Location ID...................................... 748
      Location Seg..................................... 2
      Category......................................... WLCURRENTYEAR
      Category ID...................................... 14
      Period........................................... PERIOD00
      Period ID........................................ 02/07/2011
      POV Local........................................ False
      Language......................................... 1033
      User Level....................................... 1
      All Partitions................................... True
      Is Auditor....................................... False
        • 1. Re: FDM Export failed. Essbase API Procedure: [EsbInit] Threw code: 1030803
          783124
          We have re-ordered the "Path" system environment variable values to the following, and rebooted the server. The client values are all listed first now. Re-ordering the values previously (without a reboot) did not appear to fix the issue, even after closing the FDM web client session and re-opening. Perhaps restarting IIS might have also had the same effect as a reboot?

          D:\Oracle\Middleware\EPMSystem11R1\bin-32;
          D:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0\bin;
          D:\Oracle\Middleware\EPMSystem11R1\products\Essbase\EssbaseClient-32\bin;
          D:\Oracle\Middleware\EPMSystem11R1\bin;
          C:\Windows\system32;
          C:\Windows;
          C:\Windows\System32\Wbem;
          C:\Windows\System32\WindowsPowerShell\v1.0\;
          D:\Oracle\Middleware\EPMSystem11R1\common\ODBC-64\Merant\6.0\Drivers;
          D:\Oracle\Middleware\EPMSystem11R1\products\Essbase\eas\console\bin;
          D:\Oracle\Middleware\EPMSystem11R1\common\JRE\Sun\1.6.0\bin;
          C:\oracle\product\11.2.0\client_1\bin;
          c:\oracle\product\11.2.0\client_64\bin
          • 2. Re: FDM Export failed. Essbase API Procedure: [EsbInit] Threw code: 1030803
            SH_INT
            Your definately looking in the right place that error is almost always down to pathing issues. Unfortunately for you, resolution of this error in my experience is hit and miss, you can follow all the guidelines on path formation and ordering but it still doesn't resolve the error.