7 Replies Latest reply: Dec 20, 2012 6:36 AM by GeorgeAbraham RSS

    Error: File not found: esbapin

    783124
      When attempting to add a new mapping row in Activites | Maps and selecting Target | "Browse for Target Value..." the following error message is displayed, and no target Essbase members are displayed.

      Essentially, I have done the following in Workbench:
      - Created a new FDM app
      - Imported the Essbase adapter (ES11X-G4-H)
      - Registered the adapter
      - Added a new machine profile
      - Set the various dimensions (the drop-down lists appear to be "seeing" the Essbase dimensions

      Then in Web FDM I have tried the above. Using FDM and Essbase versions of 11.1.2.1. There is a similar post at https://kr.forums.oracle.com/forums/thread.jspa?threadID=1027575 but this did not solve the issue.

      The log is as follows (server names etc obscured). Any ideas?


      ** Begin Oracle Hyperion FDM Adapter for Essbase Runtime Error Log Entry [2012-03-26-16:43:28] **
      -------------------------------------------------------------
      Error:
      Code..............53
      Description.......File not found: esbapin
      Procedure.........clsHPConnection.fConnect
      Component.........upsES11XG4H
      Version...........100
      Thread............22228

      Identification:
      User..............xxxxxxx
      Computer Name.....xxxxxxx

      Essbase Connection:
      App Name..........FDMApp
      DB Name...........FDMApp
      Server Name.......xxxxxxx
      Connect Status.... No Connection Open


      ** Begin FDM Runtime Error Log Entry [2012-03-26 16:43:28] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. 53
      Description...................................... File not found: esbapin
      At Line: 124
      Procedure........................................ clsBlockProcessor.ActConnect
      Component........................................ upsWBlockProcessorDM
      Version.......................................... 1112
      Thread........................................... 17732

      IDENTIFICATION:
      User............................................. xxxxxxx
      Computer Name.................................... xxxxxxx
      App Name......................................... FDMApp
      Client App....................................... WebClient

      CONNECTION:
      Provider......................................... SQLOLEDB
      Data Server...................................... xxxxxxx
      Database Name.................................... FDMApp
      Trusted Connect.................................. False
      Connect Status.. Connection Open

      GLOBALS:
      Location......................................... FDMApp
      Location ID...................................... 749
      Location Seg..................................... 3
      Category......................................... WLCat
      Category ID...................................... 12
      Period........................................... Jan - 2012
      Period ID........................................ 31/01/2012
      POV Local........................................ False
      Language......................................... 1033
      User Level....................................... 1
      All Partitions................................... True
      Is Auditor....................................... False


      ** Begin FDM Runtime Error Log Entry [2012-03-26 16:43:28] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. 53
      Description...................................... File not found: esbapin
      At Line: 124
      Procedure........................................ clsBlockProcessor.DimensionList
      Component........................................ upsWBlockProcessorDM
      Version.......................................... 1112
      Thread........................................... 17732

      IDENTIFICATION:
      User............................................. xxxxxxx
      Computer Name.................................... xxxxxxx
      App Name......................................... FDMApp
      Client App....................................... WebClient

      CONNECTION:
      Provider......................................... SQLOLEDB
      Data Server...................................... xxxxxxx
      Database Name.................................... FDMApp
      Trusted Connect.................................. False
      Connect Status.. Connection Open

      GLOBALS:
      Location......................................... FDMApp
      Location ID...................................... 749
      Location Seg..................................... 3
      Category......................................... WLCat
      Category ID...................................... 12
      Period........................................... Jan - 2012
      Period ID........................................ 31/01/2012
      POV Local........................................ False
      Language......................................... 1033
      User Level....................................... 1
      All Partitions................................... True
      Is Auditor....................................... False


      ** Begin FDM Runtime Error Log Entry [2012-03-26 16:43:29] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. 1
      Description...................................... File not found: esbapin
      At Line: 124 [Inner Except]: [Stack Trace]: at upsWBlockProcessorDM.clsBlockProcessorClass.DimensionList(String strDimName, Int32 lngDimType, Int32 lngMarshalType, Boolean blnListAllMembers)
      at Hyperion.FDM.ObjScriptReturnMarshaler.GetDimensionList(String strDimensionName, Int32 lngDimensionType, clsAppServerDM objAS, Page objPage, Boolean OnlyFromSession)
      Procedure........................................ ObjScriptReturnMarshaler.GetDimensionList

      IDENTIFICATION:
      User............................................. xxxxxxx
      Computer Name.................................... xxxxxxx
      App Name......................................... FDMApp
      Client App....................................... WebClient

      CONNECTION:
      Provider......................................... SQLOLEDB
      Data Server...................................... xxxxxxx
      Database Name.................................... FDMApp
      Trusted Connect.................................. False
      Connect Status.. Connection Open

      GLOBALS:
      Location......................................... FDMApp
      Location ID...................................... 749
      Location Seg..................................... 3
      Category......................................... WLCat
      Category ID...................................... 12
      Period........................................... Jan - 2012
      Period ID........................................ 31/01/2012
      POV Local........................................ False
      Language......................................... 1033
      User Level....................................... 1
      All Partitions................................... True
      Is Auditor....................................... False
        • 1. Re: Error: File not found: esbapin
          SH
          This error is usually because the adapter has not been registered in the correct directory and/or the correct paths have not been setup in FDM Server Environment variables. All the steps required are listed in the Essbase Adapter readme which can be downloaded from

          http://docs.oracle.com/cd/E17236_01/nav/portal_6.htm
          • 2. Re: Error: File not found: esbapin
            783124
            It appears that the environment variables did need some tweaking, however a different error is now being displayed instead (at exactly the same point) so things are still not right. Do you please have any further suggestions?

            "Essbase API Procedure: [EsbInit] Threw code: 1030803 - .
            At Line: 124"

            The error log is as follows:

            ** Begin Oracle Hyperion FDM Adapter for Essbase Runtime Error Log Entry [2012-03-27-14:01:02] **
            -------------------------------------------------------------
            Error:
            Code..............10404
            Description.......Essbase API Procedure: [EsbInit] Threw code: 1030803 - .
            Procedure.........clsHPConnection.fConnect
            Component.........upsES11XG4H
            Version...........100
            Thread............14636

            Identification:
            User..............xxxxxxx
            Computer Name.....xxxxxxx

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


            ** Begin FDM Runtime Error Log Entry [2012-03-27 14:01:03] **
            -------------------------------------------------------------
            ERROR:
            Code............................................. 10404
            Description...................................... Essbase API Procedure: [EsbInit] Threw code: 1030803 - .
            At Line: 124
            Procedure........................................ clsBlockProcessor.ActConnect
            Component........................................ upsWBlockProcessorDM
            Version.......................................... 1112
            Thread........................................... 14192

            IDENTIFICATION:
            User............................................. xxxxxxx
            Computer Name.................................... xxxxxxx
            App Name......................................... xxxxxxx
            Client App....................................... WebClient

            CONNECTION:
            Provider......................................... SQLOLEDB
            Data Server...................................... xxxxxxx
            Database Name.................................... xxxxxxx
            Trusted Connect.................................. False
            Connect Status.. Connection Open

            GLOBALS:
            Location......................................... Sample
            Location ID...................................... 748
            Location Seg..................................... 2
            Category......................................... WLCat
            Category ID...................................... 12
            Period........................................... Jan - 2012
            Period ID........................................ 31/01/2012
            POV Local........................................ False
            Language......................................... 1033
            User Level....................................... 1
            All Partitions................................... True
            Is Auditor....................................... False


            ** Begin FDM Runtime Error Log Entry [2012-03-27 14:01:03] **
            -------------------------------------------------------------
            ERROR:
            Code............................................. 10404
            Description...................................... Essbase API Procedure: [EsbInit] Threw code: 1030803 - .
            At Line: 124
            Procedure........................................ clsBlockProcessor.DimensionList
            Component........................................ upsWBlockProcessorDM
            Version.......................................... 1112
            Thread........................................... 14192

            IDENTIFICATION:
            User............................................. xxxxxxx
            Computer Name.................................... xxxxxxx
            App Name......................................... xxxxxxx
            Client App....................................... WebClient

            CONNECTION:
            Provider......................................... SQLOLEDB
            Data Server...................................... xxxxxxx
            Database Name.................................... xxxxxxx
            Trusted Connect.................................. False
            Connect Status.. Connection Open

            GLOBALS:
            Location......................................... Sample
            Location ID...................................... 748
            Location Seg..................................... 2
            Category......................................... WLCat
            Category ID...................................... 12
            Period........................................... Jan - 2012
            Period ID........................................ 31/01/2012
            POV Local........................................ False
            Language......................................... 1033
            User Level....................................... 1
            All Partitions................................... True
            Is Auditor....................................... False


            ** Begin FDM Runtime Error Log Entry [2012-03-27 14:01:03] **
            -------------------------------------------------------------
            ERROR:
            Code............................................. -2146817884
            Description...................................... Essbase API Procedure: [EsbInit] Threw code: 1030803 - .
            At Line: 124
            Procedure........................................ ObjScriptReturnMarshaler.GetDimensionList

            IDENTIFICATION:
            User............................................. xxxxxxx
            Computer Name.................................... xxxxxxx
            App Name......................................... xxxxxxx
            Client App....................................... WebClient

            CONNECTION:
            Provider......................................... SQLOLEDB
            Data Server...................................... xxxxxxx
            Database Name.................................... xxxxxxx
            Trusted Connect.................................. False
            Connect Status.. Connection Open

            GLOBALS:
            Location......................................... Sample
            Location ID...................................... 748
            Location Seg..................................... 2
            Category......................................... WLCat
            Category ID...................................... 12
            Period........................................... Jan - 2012
            Period ID........................................ 31/01/2012
            POV Local........................................ False
            Language......................................... 1033
            User Level....................................... 1
            All Partitions................................... True
            Is Auditor....................................... False
            • 3. Re: Error: File not found: esbapin
              GeorgeAbraham
              Can you confirm that you have installed the Essbase client in the server where FDM is installed ?
              • 4. Re: Error: File not found: esbapin
                JeffJon
                Refer to KM document:

                FDM: How To Register The Essbase Adapter and Troubleshoot Common Issues in 11.1.2.1 (Doc ID 1345340.1)
                • 5. Re: Error: File not found: esbapin
                  783124
                  Many thanks for your suggestions. I am still waiting for feedback from the system admin here, but will get back as soon as I have more information.
                  • 6. Re: Error: File not found: esbapin
                    Otein
                    Hi,

                    The first message error about esbapin file can be solved following the instructions about system variables in the Adapter Readme. For this to work essbase client has to be installed on the server (windows msi file in hyperion 11.1.2.2)

                    The second error should be solved with the right dimension configuration for the adapter in FDM Workbench, you need to activate or deactivate the dimensions accordingly to your dimensions schema.

                    A third possible error about user not been able to login can be solved configuring the login method in the adapter configuration in FDM Workbench. It can be unified or global, for global the user credentials are needed.


                    Tested on Hyperion 11.1.2.2

                    Regards
                    • 7. Re: Error: File not found: esbapin
                      GeorgeAbraham
                      Seen this error while dealing with Essbase integration in version 9.3 using FDM. The reason then was the Essbase client was missing.