6 Replies Latest reply on Jan 25, 2012 7:31 PM by JeffJon

    file structure for batch processing (no multi load)

    Onono
      HI all,

      has anyone a clou how the structure of the file should look like?
      The location name addressed in the file name does not appear
        • 1. Re: file structure for batch processing (no multi load)
          SH_INT
          The structure of the file is irrelevant for multiload the loacation it is targetted at needs to be configured with an import format to parse the file data appropriately. What is important is the naming convention of the multiload file as this contains all the information required to set the FDM POV information correctly and Load type/method. Details on this can be found in the FDM admin guide
          • 2. Re: file structure for batch processing (no multi load)
            Onono
            yes I read the admin guide :-)

            I used a filke that is usuallay rpocessed via manual import/validate/export workflow - renamed it - as it is descriped in admin aguide.

            like
            a_LOC_CAT_PER_RA.csv

            LOC=Location
            CAT=ACTUALS
            PER=Apr - 2030

            doesn work.
            The error file always contains an entry in reference to the default CONTROLSREVIEW Location
            • 3. Re: file structure for batch processing (no multi load)
              JeffJon
              can you paste the error log contents into the thread?
              ControlsReview is not a data load location, you may want to set the users default location to somethign other than controls review and also make sure that the user has access to all locations that is running the batch and is an administrator.
              • 4. Re: file structure for batch processing (no multi load)
                Onono
                Hu User :-)

                in fact you are right the default location is the ControlsReview (is selected when I log in) -
                but due to the file name structure I adress another - it might be one of n existing locations.
                After my mind this issue shouldn't be the default loaction - otherwise for any batch process I would have to change it :-)

                But I will check
                Thanks a lot for the moment.
                dou you ahve experience in batch processing
                • 5. Re: file structure for batch processing (no multi load)
                  Onono
                  here below the error message:




                  ** Begin FDM Runtime Error Log Entry [2012-01-20-16:49:36] **
                  -------------------------------------------------------------
                  ERROR:
                  Code............................................. 6
                  Description...................................... Overflow
                  Procedure........................................ clsBatchLoad.fFileCollectionCreateFromArray
                  Component........................................ upsWBatchLoaderDM
                  Version.......................................... 1111
                  Thread........................................... 4856

                  IDENTIFICATION:
                  User............................................. xxxx
                  Computer Name.................................... yyyyyy
                  App Name......................................... abcxyz
                  Client App....................................... WebClient

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

                  GLOBALS:
                  Location......................................... CONTROLSREVIEW
                  Location ID...................................... 730
                  Location Seg..................................... 1
                  Category......................................... ACTUALS
                  Category ID...................................... 12
                  Period........................................... Apr - 2030
                  Period ID........................................ 4/30/2030
                  POV Local........................................ False
                  Language......................................... 1033
                  User Level....................................... 1
                  All Partitions................................... True
                  Is Auditor....................................... False


                  ** Begin FDM Runtime Error Log Entry [2012-01-20-16:49:36] **
                  -------------------------------------------------------------
                  ERROR:
                  Code............................................. 6
                  Description...................................... Overflow
                  Procedure........................................ clsBatchLoader.mExecuteParallelBatchProcess
                  Component........................................ upsWBatchLoaderDM
                  Version.......................................... 1111
                  Thread........................................... 4856

                  IDENTIFICATION:
                  User............................................. xxxx
                  Computer Name.................................... yyyyyy
                  App Name......................................... abcxyz
                  Client App....................................... WebClient

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

                  GLOBALS:
                  Location......................................... CONTROLSREVIEW
                  Location ID...................................... 730
                  Location Seg..................................... 1
                  Category......................................... ACTUALS
                  Category ID...................................... 12
                  Period........................................... Apr - 2030
                  Period ID........................................ 4/30/2030
                  POV Local........................................ False
                  Language......................................... 1033
                  User Level....................................... 1
                  All Partitions................................... True
                  Is Auditor....................................... False
                  • 6. Re: file structure for batch processing (no multi load)
                    JeffJon
                    I would suggest opening a service request so support an take a look at the file you are attempting to load.