This discussion is archived
11 Replies Latest reply: Jan 25, 2012 2:19 AM by SH RSS

FDM Error Connecting with HFM

724287 Newbie
Currently Being Moderated
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 Oracle ACE
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Thanks a lot. It resolved the issue.

    Regards
    -Samar-
  • 6. Re: FDM Error Connecting with HFM
    JeffJon Expert
    Currently Being Moderated
    Please mark the question as answered. Thank You :)
  • 7. Re: FDM Error Connecting with HFM
    776129 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    Please start a new thread for this post

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points