4 Replies Latest reply on Nov 10, 2011 3:24 AM by user13029084

    440 Automation error with script in "AftFileImport"

    user13029084
      Hi experts,
      I know there're some threads talking about this error,but I still need some help with my problem. If anyone knows the reason or have the same experience please share your solutions,thanks a lot!!!

      My Error log as blow:
      ** Begin FDM Runtime Error Log Entry [2011-10-25 18:03:26] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. 440
      Description...................................... Automation error
      Procedure........................................ clsImpProcessMgr.fLoadAndProcessFile
      Component........................................ upsWObjectsDM
      Version.......................................... 1112
      Thread........................................... 13556

      IDENTIFICATION:
      User............................................. fdmadmin
      Computer Name.................................... FIACTHFMTD
      App Name......................................... FDMAP
      Client App....................................... WebClient

      CONNECTION:
      Provider......................................... SQLOLEDB
      Data Server...................................... fiacthfmtd
      Database Name.................................... FDMAP
      Trusted Connect.................................. False
      Connect Status.. Connection Open

      GLOBALS:
      Location......................................... ABCD
      Location ID...................................... 758
      Location Seg..................................... 10
      Category......................................... IFRS PA_2
      Category ID...................................... 17
      Period........................................... Aug - 2011
      Period ID........................................ 2011/8/31
      POV Local........................................ False
      Language......................................... 1033
      User Level....................................... 1
      All Partitions................................... True
      Is Auditor....................................... False

      This error occured after I add a script on Event "AftFileImport", I wrote some check scripts in Import and pass the result to "AftFileImport". But it shows some error at the line have "API.Import.ImpProcessMgr.State.dstDataWindow"
      .Did I use the wrong way to call this API? (purpose:If any error occured, stop import the file)
      My script as below:
      Sub AftFileImport(strLoc, strCat, strPer, strFile, lngRecs)
      '------------------------------------------------------------------
      'Oracle Hyperion FDM EVENT Script:
      '
      'Created By:      fdmadmin
      'Date Created:      2011-10-24 17:50:51
      '
      'Purpose:
      '
      '------------------------------------------------------------------

      Dim checkPeriod, errPeriod, errYear, errCat

      errYear = RES.PvarTemp1

      errPeriod = RES.PvarTemp2

      errCat = RES.PvarTemp3

      checkResult = RES.PvarTemp5

      If checkResult = "OK" Then
           
      Else
           
      RES.PlngActionType = 6                    
      RES.PstrActionValue = "Source Data Year : " & Left(errYear,4) & " " & "Source Data Period : "& Left(errPeriod,3) & " " & "Source Data Cat : "& errCat

      API.Import.ImpProcessMgr.State.dstDataWindow = False

      End If

      End Sub


      ============================================
      Thanks!!

      WL

      Edited by: user13029084 on 2011/10/25 下午 7:07