11 Replies Latest reply: Jan 25, 2012 4:19 AM by SH RSS

    FDM Error Connecting with HFM

    724287
      Hi,

      We are using FDM 11.1.2, the FM 11x G5D Adapter.

      When trying to browse to a target value in mappings and when trying to export a file we are getting 'Error at Line 45' Errors.
      Below is a copy of the FDM Error Log. If anyone has any ideas please share.

      ** Begin FDM Runtime Error Log Entry [2010-10-14 10:55:29] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. -2147467259
      Description......................................
      At Line: 45
      Procedure........................................ clsBlockProcessor.ActConnect
      Component........................................ upsWBlockProcessorDM
      Version.......................................... 1112
      Thread........................................... 7620

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

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

      GLOBALS:
      Location......................................... HISTORICAL-LOAD
      Location ID...................................... 751
      Location Seg..................................... 4
      Category......................................... ACTUALS
      Category ID...................................... 12
      Period........................................... Feb - 2010
      Period ID........................................ 2/28/2010
      POV Local........................................ False
      Language......................................... 1033
      User Level....................................... 1
      All Partitions................................... True
      Is Auditor....................................... False


      ** Begin FDM Runtime Error Log Entry [2010-10-14 10:55:30] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. -2147467259
      Description......................................
      At Line: 45
      Procedure........................................ clsBlockProcessor.DimensionList
      Component........................................ upsWBlockProcessorDM
      Version.......................................... 1112
      Thread........................................... 7620

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

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

      GLOBALS:
      Location......................................... HISTORICAL-LOAD
      Location ID...................................... 751
      Location Seg..................................... 4
      Category......................................... ACTUALS
      Category ID...................................... 12
      Period........................................... Feb - 2010
      Period ID........................................ 2/28/2010
      POV Local........................................ False
      Language......................................... 1033
      User Level....................................... 1
      All Partitions................................... True
      Is Auditor....................................... False


      ** Begin FDM Runtime Error Log Entry [2010-10-14 10:55:30] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. -2147467259
      Description......................................
      At Line: 45
      Procedure........................................ ObjScriptReturnMarshaler.GetDimensionList

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

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

      GLOBALS:
      Location......................................... HISTORICAL-LOAD
      Location ID...................................... 751
      Location Seg..................................... 4
      Category......................................... ACTUALS
      Category ID...................................... 12
      Period........................................... Feb - 2010
      Period ID........................................ 2/28/2010
      POV Local........................................ False
      Language......................................... 1033
      User Level....................................... 1
      All Partitions................................... True
      Is Auditor....................................... False
        • 1. Re: FDM Error Connecting with HFM
          TonyScalese
          This issues has been addressed a number of times on this forum and also in various KM articles on support.oracle.com. Have you tried searching the forum?
          • 2. Re: FDM Error Connecting with HFM
            JeffJon
            The adapter needs to be configured with the FDM Service account. Login to the workbench, right-click on the adapter and choose "configure". Provide the service account username/password/domain. This should resolve the issue. As Tony mentioned this has been addressed numerous times in the forum and also in the Knowledge Base on my oracle support. Please search for "FDM Error at line 45" in the Knowledge Base to locate the article.
            • 3. Re: FDM Error Connecting with HFM
              540301
              Hi ,

              I also have similar issue and when I am trying to configure the adapter from workbench by right clicking on Adpater and Configure I am getting the following error.

              429 - ActiveX component can't create object: 'fdmAdapterCOMadminLocalized.clsConfig' - for FM11x-G5-C
              429 - ActiveX component can't create object: 'upsHE6xG4E.clsHypeWindow' - for HE6x-G4-E

              Plese advise.

              --Samar-                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
              • 4. Re: FDM Error Connecting with HFM
                JeffJon
                The adapter has not been registered. The "AdapterComponents" folder included with the FM11xG5C.zip file needs to be placed in the Hyperion\products\financialdataquality\sharedcomponents folder and the adapter then needs to be registered from this location using File > Register Adapter in the workbench. Browse to the adapter components folder > FM11xG5C > upsFM11xG5c.dll and choose "open".

                For the Enterprise Adapter the upsHE6xG4E.exe file needs to be placed in the shared components folder and registered as well.

                All of the steps necessary are listed in the corresponding adapter readme files available on the Oracle Technology Network under Documentation.
                • 5. Re: FDM Error Connecting with HFM
                  540301
                  Thanks a lot. It resolved the issue.

                  Regards
                  -Samar-
                  • 6. Re: FDM Error Connecting with HFM
                    JeffJon
                    Please mark the question as answered. Thank You :)
                    • 7. Re: FDM Error Connecting with HFM
                      776129
                      Yes, this post proved to be helpful for me and my error is solved, now i am able to connect to my Target Application.

                      Thanks.
                      • 8. Re: FDM Error Connecting with HFM
                        user13490301
                        Hi Experts,

                        I am getting the same error, but error code is different. i am using FDM 11.1.2, the FM 11x G5D Adapter. i am able to import and validate but while exporting from FDM. I am getting below error:






                        ** Begin FDM Runtime Error Log Entry [2011-08-30 12:48:00] **
                        -------------------------------------------------------------
                        ERROR:
                        Code............................................. -2147024894
                        Description......................................
                        At Line: 45
                        Procedure........................................ clsBlockProcessor.ActExport
                        Component........................................ upsWBlockProcessorDM
                        Version.......................................... 1112
                        Thread........................................... 264

                        IDENTIFICATION:
                        User............................................. admin
                        Computer Name.................................... EPMAPP02-D
                        App Name......................................... BMHCFDMHFM
                        Client App....................................... WebClient

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

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


                        Please help me.

                        Regards,

                        Sudhir Sinha
                        • 9. Re: FDM Error Connecting with HFM
                          user13490301
                          Hi Experts,

                          I am getting the same error, but error code is different. i am using FDM 11.1.2, the FM 11x G5D Adapter. i am able to import and validate but while exporting from FDM. I am getting below error:






                          ** Begin FDM Runtime Error Log Entry [2011-08-30 12:48:00] **
                          -------------------------------------------------------------
                          ERROR:
                          Code............................................. -2147024894
                          Description......................................
                          At Line: 45
                          Procedure........................................ clsBlockProcessor.ActExport
                          Component........................................ upsWBlockProcessorDM
                          Version.......................................... 1112
                          Thread........................................... 264

                          IDENTIFICATION:
                          User............................................. admin
                          Computer Name.................................... EPMAPP02-D
                          App Name......................................... BMHCFDMHFM
                          Client App....................................... WebClient

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

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


                          Please help me. i have also perform the step ----> Login to the workbench, right-click on the adapter and choose "configure". Provide the service account username/password/domain. Still it didn't fix the issue

                          Regards,

                          Sudhir Sinha
                          • 10. Re: FDM Error Connecting with HFM
                            896901
                            Hi All,
                            One of my users is getting the error below while exporting a mapping file to Excel, which he was able to do it before. I am assuming this shouldn't be related to registration of the adapter as user was able to take an export before.

                            ** Begin FDM Runtime Error Log Entry [2012-01-24-14:21:33] **
                            -------------------------------------------------------------
                            ERROR:
                            Code............................................. 429
                            Description...................................... ActiveX component can't create object
                            Procedure........................................ clsUtility.mRecordsetToExcel
                            Component........................................ upsWDataWindowDM
                            Version.......................................... 1111
                            Thread........................................... 15876

                            IDENTIFICATION:
                            User............................................. xxxxx
                            Computer Name.................................... xxxxx
                            App Name......................................... FDMAPP
                            Client App....................................... WebClient

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

                            GLOBALS:
                            Location......................................... HFM
                            Location ID...................................... 769
                            Location Seg..................................... 23
                            Category......................................... Actual
                            Category ID...................................... 13
                            Period........................................... Dec - 2010
                            Period ID........................................ 12/31/2010
                            POV Local........................................ False
                            Language......................................... 1033
                            User Level....................................... 1
                            All Partitions................................... True
                            Is Auditor....................................... False


                            ** Begin FDM Runtime Error Log Entry [2012-01-24-14:21:52] **
                            -------------------------------------------------------------
                            ERROR:
                            Code............................................. 429
                            Description...................................... ActiveX component can't create object
                            Procedure........................................ clsUtility.mRecordsetToExcel
                            Component........................................ upsWDataWindowDM
                            Version.......................................... 1111
                            Thread........................................... 14044

                            IDENTIFICATION:
                            User............................................. xxxxxx
                            Computer Name....................................xxxxxx
                            App Name......................................... FDMAPP
                            Client App....................................... WebClient

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

                            GLOBALS:
                            Location......................................... HFM
                            Location ID...................................... 769
                            Location Seg..................................... 23
                            Category......................................... Actual
                            Category ID...................................... 13
                            Period........................................... Dec - 2010
                            Period ID........................................ 12/31/2010
                            POV Local........................................ False
                            Language......................................... 1033
                            User Level....................................... 1
                            All Partitions................................... True
                            Is Auditor....................................... False




                            Please help.

                            Edited by: 893898 on Jan 24, 2012 5:47 PM
                            • 11. Re: FDM Error Connecting with HFM
                              SH
                              Please start a new thread for this post