6 Replies Latest reply on Jan 17, 2013 5:23 PM by Don'Tknow999-Oracle

    FDM 11.1.2.2 cannot connect to Essbase

    Don'Tknow999-Oracle
      I have installed FDM 11.1.2.2 and configured it successfully. However when I login into the workbench I am getting Connection failed under Target Dimension on the Dimension tab.


      Beow is what i am getting when i look into Tools -> View Error Log from from workbench

      ** Begin Oracle Hyperion FDM Adapter for Essbase Runtime Error Log Entry [2013-01-15-03:24:59] **
      -------------------------------------------------------------
      Error:
      Code..............53
      Description.......File not found: esbapin
      Procedure.........clsHPConnection.fConnect
      Component.........upsES11XG4J
      Version...........100
      Thread............1920

      Identification:
      User..............admin
      Computer Name.....AMIWSD04

      Essbase Connection:
      App Name..........AMIPLN
      DB Name...........AMIPLAN
      Server Name.......dblx509.mycmsc.com
      Connect Status.... No Connection Open


      ** Begin FDM Runtime Error Log Entry [2013-01-15 03:24:59] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. 53
      Description...................................... File not found: esbapin
      Procedure........................................ frmIntegrateES.tabMain_Click
      Component........................................ upsES11XG4J
      Version.......................................... 100
      Thread........................................... 1920

      IDENTIFICATION:
      User............................................. admin
      Computer Name.................................... AMIWSD04
      App Name......................................... FDMTEST
      Client App....................................... WorkBench

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

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

      Can someone kindly help me out
        • 1. Re: FDM 11.1.2.2 cannot connect to Essbase
          JeffJon
          Can you browse to Oracle\Middleware\EPMSystem11R1\Common

          Do you see a "EssbaseRTC" directory?
          • 2. Re: FDM 11.1.2.2 cannot connect to Essbase
            Don'Tknow999-Oracle
            Hi,
            Thanks for your reply.


            After i have installed Essbase 32 bit client i am able to see the Oracle\Middleware\EPMSystem11R1\Common and now i am getting a new error. When i try to login to workbench now i am getting the error as "security Authentication failure!-2007" This is the new error i am getting after i installed Essbase Client.

            Can anyone kindly help me out with this as this bit urgent for me.


            Regards,
            AS
            • 3. Re: FDM 11.1.2.2 cannot connect to Essbase
              JeffJon
              After installing the Essbase 32 bit client you should see Oracle\Middleware\EPMSystem11R1\Common\EssbaseRTC. The directory Oracle\Middleware\EPMSystem11R1\Common should be there by default when installing the EPM System Software.

              For the login error is the connection to shared services successful from the FDM Load Balance Configuration > Authentication providers > CSS Provider?
              If so, does the password contain a & in it?
              • 4. Re: FDM 11.1.2.2 cannot connect to Essbase
                Don'Tknow999-Oracle
                Hi,

                Thanks for your reply.

                After installing the Essbase 32 bit client you should see Oracle\Middleware\EPMSystem11R1\Common\EssbaseRTC I am able to see see Oracle\Middleware\EPMSystem11R1\Common\EssbaseRTC Folder.


                FDM Load Balance Configuration > Authentication providers > CSS Provider

                When i put my user id and password of shared services i click on Test Connection i am getting the below error. (I did not get this error while i did my FDM Configuration for the first time and i don't know why i am getting this error now)

                Can’t find the Class:com/hyperion/fdm/clients/Authentication

                Our Password does not contain '&'



                Can you kinldy help...

                Regards,
                AS

                Edited by: Don'tKnow999 on Jan 15, 2013 5:51 PM

                Edited by: Don'tKnow999 on Jan 15, 2013 6:24 PM
                • 5. Re: FDM 11.1.2.2 cannot connect to Essbase
                  JeffJon
                  It seems that something has removed the COM class files from the server.

                  I would suggest opening a service request with support for this.
                  • 6. Re: FDM 11.1.2.2 cannot connect to Essbase
                    Don'Tknow999-Oracle
                    Hi,

                    I have reinstalled FDM and now its working fine. Thanks for all your help. Kinldy let me know if anyone is facing the issues. i can help them as i have learned so many things in the process of FDM installation and configuration.


                    Regards,
                    AS