7 Replies Latest reply: Apr 17, 2010 4:16 AM by 685893 RSS

    FDM 11.1.1.3 cannot connect to Essbase

    625044
      Hi All,

      I've tried everything but for some reason i can't get my FDM application to connect to Essbase.
      I have FDM 11.1.1.3 and Essbase 11.1.1.3, i've imported and registered the ES11x-G4-E adapter.
      In the workbench i'm able to browse for the target dimensions in the integration settings but within the web client when opening the control tables i see a message:
      Error: Unable to retrieve target System Data.

      When trying to add a new line to the mapping and browsing for a target member the following error appears:
      Error: Permission denied: 'CreateObject'
      At Line: 36
      Detail: InnerException1: Permission denied: 'CreateObject'
      At Line: 36

      I also have an issue when importing a file it shows:
      Error: An error occurred importing the file.
      Detail: Data access error.

      The error log then shows:
      ** Begin FDM Runtime Error Log Entry [2010-01-29-15:57:59] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. -2147217900
      Description...................................... Cannot bulk load because the file "C:\Hyperion\products\FinancialDataQuality\HPCM_Zorg\Inbox\tWadmin241233566557.tmp" could not be opened. Operating system error code 3(The system cannot find the path specified.).
      BULK INSERT HPCM_Zorg_FDM..tWadmin241233566557 FROM N'C:\Hyperion\products\FinancialDataQuality\HPCM_Zorg\Inbox\tWadmin241233566557.tmp' WITH (FORMATFILE = N'C:\Hyperion\products\FinancialDataQuality\HPCM_Zorg\Inbox\tWadmin241233566557.fmt',DATAFILETYPE = N'widechar',ROWS_PER_BATCH=2,TABLOCK)
      Procedure........................................ clsDataManipulation.fExecuteDML
      Component........................................ upsWDataWindowDM
      Version.......................................... 1111
      Thread........................................... 3356

      I already gave the hypdcom user (used to install fdm and service account for SQL) full access rights on the fdm folder.

      I'm really lost and hope some of you have a suggestion what to try next.

      Thanks!

      Marc
        • 1. Re: FDM 11.1.1.3 cannot connect to Essbase
          657263
          Marc,

          Unfortunately there isn't enough information to determine an issue for Essbase.
          Are you sure you installed the Essbase RTC and rebooted? (Note this is mentioned in the Essbae Adapter setup)
          I would suggest you clear your user error log, replicate the issue, and provide all the entries.

          Also on your topic about the importing of a file ....

          Per the EPM documentation it states that FDM Folder Path needs to be a UNC path name because SQL requires read access .... since you used a drive letter for your app path, and SQL is probably on another machine ... I do not see how SQL can gain the required access.

          Hopefully this helps....
          • 2. Re: FDM 11.1.1.3 cannot connect to Essbase
            625044
            Hi,

            Thanks for your quick response!
            Changing the folder location to a server location did indeed solve my import problem.

            Regarding the essbase connection i've deleted the log file, tried to add a control table and a row in the mapping but even though the information bar show error the log file stays blank.
            The admin.err file shows:

            ** Begin FDM Runtime Error Log Entry [2010-01-29-17:59:21] **
            -------------------------------------------------------------
            ERROR:
            Code............................................. 70
            Description...................................... Permission denied: 'CreateObject'
            At Line: 36
            Procedure........................................ clsBlockProcessor.ActConnect
            Component........................................ upsWBlockProcessorDM
            Version.......................................... 1111
            Thread........................................... 3944

            IDENTIFICATION:
            User............................................. admin
            Computer Name.................................... NL-S-LIM00005
            App Name......................................... HPCM_Zorg
            Client App....................................... WebClient

            CONNECTION:
            Provider......................................... SQLOLEDB
            Data Server...................................... nl-s-lim00001
            Database Name.................................... HPCM_Zorg_FDM
            Trusted Connect.................................. False
            Connect Status.. Connection Open

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


            ** Begin FDM Runtime Error Log Entry [2010-01-29-17:59:22] **
            -------------------------------------------------------------
            ERROR:
            Code............................................. 70
            Description...................................... Permission denied: 'CreateObject'
            At Line: 36
            Procedure........................................ clsBlockProcessor.DimensionList
            Component........................................ upsWBlockProcessorDM
            Version.......................................... 1111
            Thread........................................... 3944

            IDENTIFICATION:
            User............................................. admin
            Computer Name.................................... NL-S-LIM00005
            App Name......................................... HPCM_Zorg
            Client App....................................... WebClient

            CONNECTION:
            Provider......................................... SQLOLEDB
            Data Server...................................... nl-s-lim00001
            Database Name.................................... HPCM_Zorg_FDM
            Trusted Connect.................................. False
            Connect Status.. Connection Open

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


            ** Begin FDM Runtime Error Log Entry [2010-01-29-17:59:22] **
            -------------------------------------------------------------
            ERROR:
            Code............................................. 1
            Description...................................... Permission denied: 'CreateObject'
            At Line: 36 [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............................................. admin
            Computer Name.................................... NL-S-LIM00005
            App Name......................................... HPCM_Zorg
            Client App....................................... WebClient

            CONNECTION:
            Provider......................................... SQLOLEDB
            Data Server...................................... nl-s-lim00001
            Database Name.................................... HPCM_Zorg_FDM
            Trusted Connect.................................. False
            Connect Status.. Connection Open

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


            ** Begin FDM Runtime Error Log Entry [2010-01-29-17:59:30] **
            -------------------------------------------------------------
            ERROR:
            Code............................................. 70
            Description...................................... Permission denied: 'CreateObject'
            At Line: 36
            Procedure........................................ clsBlockProcessor.ActConnect
            Component........................................ upsWBlockProcessorDM
            Version.......................................... 1111
            Thread........................................... 1236

            IDENTIFICATION:
            User............................................. admin
            Computer Name.................................... NL-S-LIM00005
            App Name......................................... HPCM_Zorg
            Client App....................................... WebClient

            CONNECTION:
            Provider......................................... SQLOLEDB
            Data Server...................................... nl-s-lim00001
            Database Name.................................... HPCM_Zorg_FDM
            Trusted Connect.................................. False
            Connect Status.. Connection Open

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


            ** Begin FDM Runtime Error Log Entry [2010-01-29-17:59:30] **
            -------------------------------------------------------------
            ERROR:
            Code............................................. 70
            Description...................................... Permission denied: 'CreateObject'
            At Line: 36
            Procedure........................................ clsBlockProcessor.DimensionList
            Component........................................ upsWBlockProcessorDM
            Version.......................................... 1111
            Thread........................................... 1236

            IDENTIFICATION:
            User............................................. admin
            Computer Name.................................... NL-S-LIM00005
            App Name......................................... HPCM_Zorg
            Client App....................................... WebClient

            CONNECTION:
            Provider......................................... SQLOLEDB
            Data Server...................................... nl-s-lim00001
            Database Name.................................... HPCM_Zorg_FDM
            Trusted Connect.................................. False
            Connect Status.. Connection Open

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


            ** Begin FDM Runtime Error Log Entry [2010-01-29-17:59:30] **
            -------------------------------------------------------------
            ERROR:
            Code............................................. 1
            Description...................................... Permission denied: 'CreateObject'
            At Line: 36 [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............................................. admin
            Computer Name.................................... NL-S-LIM00005
            App Name......................................... HPCM_Zorg
            Client App....................................... WebClient

            CONNECTION:
            Provider......................................... SQLOLEDB
            Data Server...................................... nl-s-lim00001
            Database Name.................................... HPCM_Zorg_FDM
            Trusted Connect.................................. False
            Connect Status.. Connection Open

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


            I hope you have a clue..

            I have installed the Essbase client and rebooted and am able to connect.
            I login with admin which has access to Essbase.
            I have no credentials in the machine profile and use unified logon.
            I can browse for the dimensions from workspace but nog in the web browser.

            Thanks again!
            • 3. Re: FDM 11.1.1.3 cannot connect to Essbase
              729610
              Can you see the dimension list when you setup the ES11x adapter through the workbench client?

              Right click on the ES11x adapter and click configure:

              Checklist:
              1st. Check your machine profile (1st tab) make sure this user has access to the cube.
              2nd. Check the credentials you type in for the second tab. Check if that user is provisioned for the cube.
              3rd. Check the third tab and highlight the accounts dimension on the left hand side and within the drop down (the only one on the right) do you see all of your dimensionality?
              • 4. Re: FDM 11.1.1.3 cannot connect to Essbase
                625044
                Hi,

                The strange thing is that i do see the dimensionality but i cannot browse for a target value from the web.

                Since it's a test environment i've installed FDM on the Essbase server as well (it was now on the HFM server) and that solved the problem.

                But i still have no clue where it came from.

                Kind regards...
                • 5. Re: FDM 11.1.1.3 cannot connect to Essbase
                  694753
                  i would reccomend to check access rights in dcomcnfg
                  • 6. Re: FDM 11.1.1.3 cannot connect to Essbase
                    f amores - oracle
                    Probably it has to be with Enviroment Variables. Follow instructios within Essbase adapter Readme. you have to set them up both on FDM Server and machines running FDM Workbench Client.

                    Regards
                    • 7. Re: FDM 11.1.1.3 cannot connect to Essbase
                      685893
                      I am getting same error when I try to connect to HFM.What might be the reason?