2 Replies Latest reply: Sep 16, 2011 4:23 AM by user638056 RSS

    Migrating V9.3.3 FDM application to Version 11.1.2.1

    user638056
      All,
      I am hoping someone might be able to assist me in getting my FDM application migrated successfully - I currently use FDM to map to a HFM application
      So far I have gotten to the stage where the application schema has been updated, the scripts were manually updated (as per config manual pg51 - http://download.oracle.com/docs/cd/E17236_01/epm.1112/fdm_config_11121.pdf), I synchronised my v9 adpapter to the V11 one and reassigned it in the Workbench client.

      When I then logged into the applicatoin through the FDM Workspace, my control tables were not valid (the categories and the periods) - I was able to connect to my HFM application and corrected both tables manually.
      My first question is how can I migrated these tables without having to manually edit them ?

      Then once they were manually edited a tested and import and it worked fine, then tried to validate and got an Automation error along with an [fConnect] error. I will upload the error log below as recommended by the Forum guidelines

      I have configured the FDM Apdater COM admin account correctly and checked the integration settings were ok...

      Any ideas would be grateful - I have logged the call also directly on My Oracle support but they don't seem to grasp my description of the issues here - they are focusing on referring to pages in manuals and I can't find any manual reference to reassigning and synchronising adapters in the manuals....

      Regards

      Caitriona

      Error Log


      ** Begin fdmFM11XG5E Runtime Error Log Entry [2011-09-08-14:39:23] **
      -------------------------------------------------------------
      Error:
      Code............-2147220966
      Description.....
      {C034448C-86F3-45D4-BA2C-EF25B25CBDAA}1-214722096609/8/2011 2:39:23 PMEU-HUB-M326CHsxClient.cpp241711.1.2.1.000.3082Unknown Error

      Procedure.......clsFMAdapter.fConnect
      Component.......D:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\SharedComponents\Adapters\FM11X-G5-E_1005\AdapterComponents\fdmFM11xG5E\fdmFM11XG5E.dll
      Version.........145

      Identification:
      User............cambrose
      Computer Name...EU-HUB-M326

      FINANCIAL MANAGEMENT Connection:
      App Name........
      Cluster Name....
      Domain............
      Connect Status.... No Connection Open


      ** Begin FDM Runtime Error Log Entry [2011-09-08 14:39:23] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. 10054
      Description...................................... Adapter function [fConnect] failed.
      Procedure........................................ clsBlockProcessor.ActCheckIntersections
      Component........................................ upsWBlockProcessorDM
      Version.......................................... 1112
      Thread........................................... 5988

      IDENTIFICATION:
      User............................................. cambrose
      Computer Name.................................... EU-HUB-M326
      App Name......................................... SKG
      Client App....................................... WebClient

      CONNECTION:
      Provider......................................... SQLOLEDB
      Data Server...................................... eu-hub-c325,2866
      Database Name.................................... SKG
      Trusted Connect.................................. False
      Connect Status.. Connection Open

      GLOBALS:
      Location......................................... SK_Espana
      Location ID...................................... 787
      Location Seg..................................... 30
      Category......................................... Actual
      Category ID...................................... 13
      Period........................................... Aug - 2011
      Period ID........................................ 8/31/2011
      POV Local........................................ False
      Language......................................... 1033
      User Level....................................... 1
      All Partitions................................... False
      Is Auditor....................................... False


      ** Begin FDM Runtime Error Log Entry [2011-09-08 14:39:23] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. 10054
      Description...................................... [Script failure caused error]: Adapter function [fConnect] failed.
      Procedure........................................ clsEventHandler.PobjAPI_BPCheckIntersections
      Component........................................ upsWObjEventHandlerDM
      Version.......................................... 1112
      Thread........................................... 5988

      IDENTIFICATION:
      User............................................. cambrose
      Computer Name.................................... EU-HUB-M326
      App Name......................................... SKG
      Client App....................................... WebClient

      CONNECTION:
      Provider......................................... SQLOLEDB
      Data Server...................................... eu-hub-c325,2866
      Database Name.................................... SKG
      Trusted Connect.................................. False
      Connect Status.. Connection Open

      GLOBALS:
      Location......................................... SK_Espana
      Location ID...................................... 787
      Location Seg..................................... 30
      Category......................................... Actual
      Category ID...................................... 13
      Period........................................... Aug - 2011
      Period ID........................................ 8/31/2011
      POV Local........................................ False
      Language......................................... 1033
      User Level....................................... 1
      All Partitions................................... False
      Is Auditor....................................... False


      ** Begin FDM Runtime Error Log Entry [2011-09-08 14:39:23] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. 440
      Description...................................... Automation error
      Procedure........................................ clsValidationMgr.fValidate
      Component........................................ upsWObjectsDM
      Version.......................................... 1112
      Thread........................................... 5988

      IDENTIFICATION:
      User............................................. cambrose
      Computer Name.................................... EU-HUB-M326
      App Name......................................... SKG
      Client App....................................... WebClient

      CONNECTION:
      Provider......................................... SQLOLEDB
      Data Server...................................... eu-hub-c325,2866
      Database Name.................................... SKG
      Trusted Connect.................................. False
      Connect Status.. Connection Open

      GLOBALS:
      Location......................................... SK_Espana
      Location ID...................................... 787
      Location Seg..................................... 30
      Category......................................... Actual
      Category ID...................................... 13
      Period........................................... Aug - 2011
      Period ID........................................ 8/31/2011
      POV Local........................................ False
      Language......................................... 1033
      User Level....................................... 1
      All Partitions................................... False
      Is Auditor....................................... False