2 Replies Latest reply on Jan 30, 2012 5:03 AM by rajneesh sharma

    GL Center is a required field!  Check file definition format in file header

    rajneesh sharma
      Hi

      I am new in Hyperion FDM. I am trying to load a txt file using multiload feature of FDM. I have created a VBScript to load data. When i run the script it finishes without error but doesnt load any data. I get the following errors in the log file

      ** Begin FDM Runtime Error Log Entry [2012-01-29 16:20:07] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. 2621
      Description...................................... GL Center is a required field! Check file definition format in file header (Lines 1-6)!
      File=10_SAMPLE_Actuals_JAN - 2011_RM.txt
      Procedure........................................ clsMPLoader.fStructGetText
      Component........................................ upsWMPLoaderDM
      Version.......................................... 1111
      Thread........................................... 3212

      IDENTIFICATION:
      User............................................. admin
      Computer Name.................................... RAJNEESH
      App Name......................................... testfdm1
      Client App....................................... WorkBench

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

      GLOBALS:
      Location......................................... SAMPLE
      Location ID...................................... 748
      Location Seg..................................... 2
      Category......................................... ACTUALS
      Category ID...................................... 12
      Period........................................... Jan - 2012
      Period ID........................................ 1/31/2012
      POV Local........................................ False
      Language......................................... 1033
      User Level....................................... 1
      All Partitions................................... True
      Is Auditor....................................... False

      Here is the contents and format of the text file that I am trying to load

      SAMPLE
      ACTUALS
      Jan - 2012
      1
      R,M
      a,v,e,v
      a1,version1,e1,100
      a2,version1,e1,100
      a3,version1,e1,100

      Obviously there is something wrong in the txt file above. Can anybody let me know whats wrong I am doing. I also see following error in the tbatchcontents database table after the VBScript finishes running

      10_SAMPLE_ACTUALS_JAN - 2011_RM.TXT_CHECK-IN-FAILED (CODE=2621)

      Need your help. Thanks.

      Edited by: rajneesh sharma on Jan 29, 2012 2:02 PM