5 Replies Latest reply on Aug 18, 2011 5:31 PM by 851939

    Invalid procedure call or argument when import with integration script

    851939
      Hi

      I am using FDM 11.1.2.1

      I would like to use import script in my import format.

      I have just created the import integration script below (as you can see, I am not very ambitious for this beginning...) in the Expression field of my import format :

      Function Test(strLoc, lngCatKey, dblPerKey, strWorkTableName)
      '------------------------------------------------------------------
      'Oracle Hyperion FDM Integration Import Script:
      '
      'Created By:     admin
      'Date Created:     8/18/2011 6:14:48 PM
      '
      'Purpose:
      '
      '------------------------------------------------------------------

      RES.PlngActionType = 2
      RES.PstrActionValue = "coucou"

      Test = True

      End Function


      When I run the script in the script editor, that is ok.

      but when I run the "import" in FDM client, I have the following error :


      ** Begin FDM Runtime Error Log Entry [2011-08-18 18:37:17] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. 5
      Description...................................... Invalid procedure call or argument
      Procedure........................................ clsImpProcessMgr.fLoadAndProcessFile
      Component........................................ upsWObjectsDM
      Version.......................................... 1112
      Thread........................................... 7704

      IDENTIFICATION:
      User............................................. admin
      Computer Name.................................... S92S08983
      App Name......................................... FDMTEST
      Client App....................................... WebClient

      CONNECTION:
      Provider......................................... ORAOLEDB.ORACLE
      Data Server......................................
      Database Name.................................... HYP11DEV
      Trusted Connect.................................. False
      Connect Status.. Connection Open

      GLOBALS:
      Location......................................... ERPIEBS
      Location ID...................................... 749
      Location Seg..................................... 3
      Category......................................... ACTUAL
      Category ID...................................... 12
      Period........................................... août - 2011
      Period ID........................................ 8/31/2011
      POV Local........................................ False
      Language......................................... 1033
      User Level....................................... 1
      All Partitions................................... True
      Is Auditor....................................... False

      Any idea?

      Thanks in advance

      Fanny