2 Replies Latest reply: Nov 8, 2012 2:57 PM by macyankee86 RSS

    ActiveX component cant create object:upsES11XG4H.clsHypeWindow EB-FDM Error

    Renu
      I am new to FDM. I am trying to integrate Essbase Application with FDM for the very first time. I Configured Integration Settings, Followed by Associating Dimensions between App's. When i am trying to test my integration by going into FDM Web - Activities- Maps- on Target Dimension Column Selected Browse for Target Value to see my Members. Its giving me the Following Error. "ActiveX component cant create object:upsES11XG4H.clsHypeWindow EB" at line 36.

      I tried to look at logs and this is what i can gather.

      ** Begin FDM Runtime Error Log Entry [2011-12-22 15:26:48] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. 429
      Description...................................... ActiveX component can't create object: 'upsES11XG4H.clsHypeWindowEB'
      At Line: 36
      Procedure........................................ clsBlockProcessor.ActConnect
      Component........................................ upsWBlockProcessorDM
      Version.......................................... 1112
      Thread........................................... 19740

      IDENTIFICATION:
      User............................................. ADMIN
      Computer Name.................................... AL4HYP01
      App Name......................................... SampleFDM
      Client App....................................... WebClient

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

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


      ** Begin FDM Runtime Error Log Entry [2011-12-22 15:26:49] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. 429
      Description...................................... ActiveX component can't create object: 'upsES11XG4H.clsHypeWindowEB'
      At Line: 36
      Procedure........................................ clsBlockProcessor.DimensionList
      Component........................................ upsWBlockProcessorDM
      Version.......................................... 1112
      Thread........................................... 19740

      IDENTIFICATION:
      User............................................. ADMIN
      Computer Name.................................... AL4HYP01
      App Name......................................... SampleFDM
      Client App....................................... WebClient

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

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


      ** Begin FDM Runtime Error Log Entry [2011-12-22 15:26:49] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. -2146827859
      Description...................................... ActiveX component can't create object: 'upsES11XG4H.clsHypeWindowEB'
      At Line: 36
      Procedure........................................ ObjScriptReturnMarshaler.GetDimensionList

      IDENTIFICATION:
      User............................................. ADMIN
      Computer Name.................................... AL4HYP01
      App Name......................................... SampleFDM
      Client App....................................... WebClient

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

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


      Any Help is Appreciated.

      Thanks,
      Renu
        • 1. Re: ActiveX component cant create object:upsES11XG4H.clsHypeWindow EB-FDM Error
          macyankee86
          Renu-

          I am having the same issue. Did you ever find a resolution?

          thanks!

          Gordon
          • 2. Re: ActiveX component cant create object:upsES11XG4H.clsHypeWindow EB-FDM Error
            macyankee86
            I figured out the solution:

            Open the Adapter's CONNECT script.

            Search/look for the following code:
                      
                 '------------------------------------------------------------------------------
                 'Initialize UpStream HypeWindow Essbase COM object
                 '------------------------------------------------------------------------------
                 Set objHW = CreateObject("upsES11XG4H.clsHypeWindowEB")


            Change the version of the essbase adapter to the correct letter (for 11.1.2.2 it is J; 11.1.2.1 is H).

            Since we are running 11.1.2.2, I changed the code to the following:

                 '------------------------------------------------------------------------------
                 'Initialize UpStream HypeWindow Essbase COM object
                 '------------------------------------------------------------------------------
                 Set objHW = CreateObject("upsES11XG4J.clsHypeWindowEB")

            Re-try the mapping and it should connect without a problem.

            Good Luck!

            Gordon