8 Replies Latest reply on Dec 1, 2011 9:38 PM by JeffJon

    Automation error FDM

    866553
      Hi all, I have FDM 11.1.2.1 and the Fm11X-G5-E adaptor.

      I have searched the forums because it seems this error have multiple causes and solutions but haven't been able to find anything like my case.

      I have two users: one has admin rights, the other one is intermediate-2 with permission to the location I have problems with.

      I'm doing the import through sql scripting and it works fine with both users, however on the next step (validate step) with the admin users it works like a charm but with the other user it shows an automation error, more detailed it says the problems ocurrs on the upsOBJDMw.clsValidationMgrClass.fValidate ( ) method.

      Browsing the forums I saw things like Excel not being on the FDM server, the adapter not correctly configured, some IIS restarting, so I checked everything just in case.

      There was one thing however that caught my eye and it was the mentioning of AftValidate scripting, I do have it but it only says

      '------------------------------------------------------------------
      If lngProcState = 12 Then
      RES.PlngActionType = 2
      RES.PstrActionValue = "The validation process found some unmapped members" & vbcrlf & ", please check with the administrator"
      End If
      End Sub


      That's it, and more important IT IS working with the admin user. I really dont understand what could be wrong so I'm asking for a little help and knowledge.

      Thanks for any answer that could help me with this issue
        • 1. Re: Automation error FDM
          LarryR
          It doesn't seem likely that the AftValidate script is causing the problem. The Validate phase is the first phase that communicates with the target system. That could be why this user gets through Import, but not Validate. Maybe a permissions issue in the target system? Has the problem user been properly provisioned for the target system? If so, can you attach the complete error message from the user log?
          • 2. Re: Automation error FDM
            866553
            Hi, thanks for your answer, I checked the user log but don't really understand what the problem is, at some point it says it couldnt connect with the adapter, I really think it has to do with the way it was provisioned. Could you give some more advice about this process ?? Thanks again

            -------------------------------------------------------------
            Error:
            Code............-2147196845
            Description.....
            {4762B852-EBB5-4C9D-BB18-EEBA93E6FEFD}ciscarga1-2147196845130/11/2011 09:57:26 a.m.GAVDVMSQL01CHsxServer.cpp146011.1.2.1.000.3082OpenApplication: DEVCONFIA-2147196845030/11/2011 09:57:26 a.m.GAVDVMSQL01CHsxClient.cpp241711.1.2.1.000.3082

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

            Identification:
            User............ciscarga
            Computer Name...GAVDVMSQL01

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


            ** Begin FDM Runtime Error Log Entry [2011-11-30 09:57:27] **
            -------------------------------------------------------------
            ERROR:
            Code............................................. 10054
            Description...................................... Adapter function [fConnect] failed.
            Procedure........................................ clsBlockProcessor.ActCheckIntersections
            Component........................................ upsWBlockProcessorDM
            Version.......................................... 1112
            Thread........................................... 11860

            IDENTIFICATION:
            User............................................. ciscarga
            Computer Name.................................... GAVDVMSQL01
            App Name......................................... TESTFDM
            Client App....................................... WebClient

            CONNECTION:
            Provider......................................... SQLOLEDB
            Data Server...................................... gavdvmsql01
            Database Name.................................... TESTFDM
            Trusted Connect.................................. False
            Connect Status.. Connection Open

            GLOBALS:
            Location......................................... F11804_F7_INV
            Location ID...................................... 923
            Location Seg..................................... 44
            Category......................................... CONTABLE
            Category ID...................................... 13
            Period........................................... sep - 2011
            Period ID........................................ 30/09/2011
            POV Local........................................ False
            Language......................................... 1033
            User Level....................................... 2
            All Partitions................................... False
            Is Auditor....................................... False


            ** Begin FDM Runtime Error Log Entry [2011-11-30 09:57:27] **
            -------------------------------------------------------------
            ERROR:
            Code............................................. 10054
            Description...................................... [Script failure caused error]: Adapter function [fConnect] failed.
            Procedure........................................ clsEventHandler.PobjAPI_BPCheckIntersections
            Component........................................ upsWObjEventHandlerDM
            Version.......................................... 1112
            Thread........................................... 11860

            IDENTIFICATION:
            User............................................. ciscarga
            Computer Name.................................... GAVDVMSQL01
            App Name......................................... TESTFDM
            Client App....................................... WebClient

            CONNECTION:
            Provider......................................... SQLOLEDB
            Data Server...................................... gavdvmsql01
            Database Name.................................... TESTFDM
            Trusted Connect.................................. False
            Connect Status.. Connection Open

            GLOBALS:
            Location......................................... F11804_F7_INV
            Location ID...................................... 923
            Location Seg..................................... 44
            Category......................................... CONTABLE
            Category ID...................................... 13
            Period........................................... sep - 2011
            Period ID........................................ 30/09/2011
            POV Local........................................ False
            Language......................................... 1033
            User Level....................................... 2
            All Partitions................................... False
            Is Auditor....................................... False


            ** Begin FDM Runtime Error Log Entry [2011-11-30 09:57:28] **
            -------------------------------------------------------------
            ERROR:
            Code............................................. 440
            Description...................................... Automation error
            Procedure........................................ clsValidationMgr.fValidate
            Component........................................ upsWObjectsDM
            Version.......................................... 1112
            Thread........................................... 11860

            IDENTIFICATION:
            User............................................. ciscarga
            Computer Name.................................... GAVDVMSQL01
            App Name......................................... TESTFDM
            Client App....................................... WebClient

            CONNECTION:
            Provider......................................... SQLOLEDB
            Data Server...................................... gavdvmsql01
            Database Name.................................... TESTFDM
            Trusted Connect.................................. False
            Connect Status.. Connection Open

            GLOBALS:
            Location......................................... F11804_F7_INV
            Location ID...................................... 923
            Location Seg..................................... 44
            Category......................................... CONTABLE
            Category ID...................................... 13
            Period........................................... sep - 2011
            Period ID........................................ 30/09/2011
            POV Local........................................ False
            Language......................................... 1033
            User Level....................................... 2
            All Partitions................................... False
            Is Auditor....................................... False
            • 3. Re: Automation error FDM
              TonyScalese
              This issue has been addressed a number of times in this forum. Please do a search of the forums for previous provided solutions.
              • 4. Re: Automation error FDM
                866553
                I dont want to seem lazy, as I stated on the first post I did check the forums to see if the problem had a solution, I did check each one but things didnt work out.

                What really got me lost is the fact that it works with the admin user, and not with the other user.

                I really did take the time to revise other posts but couldnt find an answer that is why I decided to start my own thread
                • 5. Re: Automation error FDM
                  JeffJon
                  Can you browse for a target value in the mapping table when logged in under the non-admin user?
                  • 6. Re: Automation error FDM
                    866553
                    Thanks for your help

                    Tryng to search for a target value gives me this error

                    Error:
                    Code............-2147196845
                    Description.....
                    {8C7C9883-3B9E-46B1-A1E9-05BB4E4F6F5A}ciscarga1-2147196845130/11/2011 03:43:08 p.m.GAVDVMSQL01CHsxServer.cpp146011.1.2.1.000.3082OpenApplication: DEVCONFIA-2147196845030/11/2011 03:43:08 p.m.GAVDVMSQL01CHsxClient.cpp241711.1.2.1.000.3082

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

                    Identification:
                    User............ciscarga
                    Computer Name...GAVDVMSQL01

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


                    ** Begin FDM Runtime Error Log Entry [2011-11-30 15:43:08] **
                    -------------------------------------------------------------
                    ERROR:
                    Code............................................. 10054
                    Description...................................... Adapter function [fConnect] failed.
                    Procedure........................................ clsBlockProcessor.DimensionList
                    Component........................................ upsWBlockProcessorDM
                    Version.......................................... 1112
                    Thread........................................... 12220

                    IDENTIFICATION:
                    User............................................. ciscarga
                    Computer Name.................................... GAVDVMSQL01
                    App Name......................................... TESTFDM
                    Client App....................................... WebClient

                    CONNECTION:
                    Provider......................................... SQLOLEDB
                    Data Server...................................... gavdvmsql01
                    Database Name.................................... TESTFDM
                    Trusted Connect.................................. False
                    Connect Status.. Connection Open

                    GLOBALS:
                    Location......................................... F11804_F7_INV
                    Location ID...................................... 923
                    Location Seg..................................... 44
                    Category......................................... CONTABLE
                    Category ID...................................... 13
                    Period........................................... sep - 2011
                    Period ID........................................ 30/09/2011
                    POV Local........................................ False
                    Language......................................... 1033
                    User Level....................................... 2
                    All Partitions................................... False
                    Is Auditor....................................... False


                    ** Begin FDM Runtime Error Log Entry [2011-11-30 15:43:08] **
                    -------------------------------------------------------------
                    ERROR:
                    Code............................................. -2146818234
                    Description...................................... Adapter function [fConnect] failed.
                    Procedure........................................ ObjScriptReturnMarshaler.GetDimensionList

                    IDENTIFICATION:
                    User............................................. ciscarga
                    Computer Name.................................... GAVDVMSQL01
                    App Name......................................... TESTFDM
                    Client App....................................... WebClient

                    CONNECTION:
                    Provider......................................... SQLOLEDB
                    Data Server...................................... gavdvmsql01
                    Database Name.................................... TESTFDM
                    Trusted Connect.................................. False
                    Connect Status.. Connection Open

                    GLOBALS:
                    Location......................................... F11804_F7_INV
                    Location ID...................................... 923
                    Location Seg..................................... 44
                    Category......................................... CONTABLE
                    Category ID...................................... 13
                    Period........................................... sep - 2011
                    Period ID........................................ 30/09/2011
                    POV Local........................................ False
                    Language......................................... 1033
                    User Level....................................... 2
                    All Partitions................................... False
                    Is Auditor....................................... False


                    So it seems the problem is the adapter, but why it doesnt connect properly ?? I havent read anything about an option where you say this user cannot use the adapter ...

                    I'm really lost :S
                    • 7. Re: Automation error FDM
                      877061
                      Be sure that your non-admin user is provisioned to the HFM application you use as the target system, e.g. with Intermediate-2 role in Hyperion shared Services
                      Kind regards,
                      Jeroen
                      • 8. Re: Automation error FDM
                        JeffJon
                        It's not the adapter, the error is being returned from HFM. If you can browse for a target value when logged into FDM as an administrator the user you are attempting to browse for the target accounts with in HFM does not have proper access to return back the list of accounts. I would check the users security class in HFM and security level and make sure they have proper access to the HFM Application.