5 Replies Latest reply on Nov 18, 2010 10:46 PM by Erich Ranz

    API error on load into the target system: Error 5 – Permission Denied

    Erich Ranz
      Hello FDM crew,

      I'm working with the API and have stumbled on an error I cannot seem to fix. I'm just walking through the code in the guide and everything has worked fine up until the load of the data into the target system (i.e. I built the form, can login and connect, can change locations, can import, can validate, and can create the load file). When executing the load into the target system, I get the following error below.

      When I debug, the varOptMethodValue is listed at 0 - Replace. Any ideas as to what's happening? I'm the admin and have tested to ensure all this works when done manually through the front end of FDM. Thanks a bunch!

      Error 5 – Permission Denied: varOptMethodValue at line 80
              'Execute the LOAD into the target system
              '****************************************************************************
              'Get the default Load options from Integration Block
              objLP.mInitializeParameters(GobjAS.PobjAPI)
              'Execute the Load - ERROR HAPPENS ON THIS LINE
              objSR = GobjAS.PobjBlockProc.ActLoad(GobjAS.PobjAPI.POVMgr.PPOVLocation, _
              GobjAS.PobjAPI.POVMgr.PPOVCategory, _
              GobjAS.PobjAPI.POVMgr.PPOVPeriod, _
              GobjAS.PobjAPI.POVMgr.PPOVPeriod, _
              strFilePath, objLP) 
              'Set the POV Status Indicators
              mDisplayPOVStatus(Me.txtWorkflowStatus, _
              Me.txtLockStatus, _
              Me.txtLogicStatus, _
              Me.txtMapStatus)
      Note: this is the code from page 40 in the api object guide.

      Below is from the error log:

      ERROR:
      Code............ 70
      Description..... Permission denied: 'varOptMethodValue' At Line: 80
      Procedure....... clsBlockProcessor.ActLoad
      Component....... upsWBlockProcessorDM
      Version......... 930
      Thread.......... 4412

      IDENTIFICATION:
      User............ Henson12
      Computer Name... SUPERCOMP029
      App Name........ DEVTESTMAIN
      Client App...... WebClient

      CONNECTION:
      Provider........ SQLOLEDB
      Data Server..... SUPERCOMP030
      Database Name... WLTESTMAINDEV
      Trusted Connect. False
      Connect Status.. Connection Open

      GLOBALS:
      Location........ USA1
      Location ID..... 776
      Location Seg.... 21
      Category........ Actual
      Category ID..... 13
      Period.......... Aug - 2010
      Period ID....... 8/31/2010
      POV Local....... False
      Language........ 1
      User Level...... 1
      All Partitons... True
      Is Auditor...... False