7 Replies Latest reply: Jan 24, 2012 3:43 AM by Onono RSS

    BatchProcessing - Error: 6 Overflow

    887914
      Hello everyone,

      we're trying to use Batch Processing for Dataupload from textfiles to Essbase via FDM. We're encountering a problem as described below. Every hint or advice is appreciated. Thank you in advance.

      On an additional note: We noticed in the errorlog that allways this Location is use, which we defined as Default for the admin-user. It does not use the Location specified in the filename.

      Essbase: 11.1.2
      FDM: Version 11.1.2.1.00
      Adapter: ES11X-G4-H

      The textfile is located in the OpenBatch folder. It's named "a~LO_S47~IST~Jan-2011~RR.txt". LO_S47 being the appropriate Location. Loading the file via WebInterface clicking the four steps manually works fine. Using the Workbench BatchProcessing yields an error (see below).

      Batch Controls is set like this:
      Batch Type = Standard
      Process Level = Import
      Process Method = Serial
      File Name Delimiter = ~

      When I hit Execute the Batch Monitor gives the following output but no tree structure as I would expect.

      Initializing Batch...
      Processing Standard Files...
      Waiting for Batch Processes to Start (1)...
      Waiting for Batch Processes to Start (2)...
      and so on until
      One or more parallel processes failed to start, please see batch reports and error log...

      Error log:

      ** Begin FDM Runtime Error Log Entry [2011-09-13 15:17:48] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. 6
      Description...................................... Overflow
      Procedure........................................ clsBatchLoad.fFileCollectionCreateFromArray
      Component........................................ upsWBatchLoaderDM
      Version.......................................... 1112
      Thread........................................... 14740
      IDENTIFICATION:
      User............................................. admin
      Computer Name.................................... CompName
      App Name......................................... AppName
      Client App....................................... WebClient
      CONNECTION:
      Provider......................................... ORAOLEDB.ORACLE
      Data Server......................................
      Database Name.................................... FDQMDEV
      Trusted Connect.................................. False
      Connect Status.. Connection Open
      GLOBALS:
      Location......................................... LO_S47
      Location ID...................................... 761
      Location Seg..................................... 15
      Category......................................... IST
      Category ID...................................... 12
      Period........................................... Jan - 2011
      Period ID........................................ 1/31/2011
      POV Local........................................ False
      Language......................................... 1033
      User Level....................................... 1
      All Partitions................................... True
      Is Auditor....................................... False

      ** Begin FDM Runtime Error Log Entry [2011-09-13 15:17:48] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. 6
      Description...................................... Overflow
      Procedure........................................ clsBatchLoader.mExecuteParallelBatchProcess
      Component........................................ upsWBatchLoaderDM
      Version.......................................... 1112
      Thread........................................... 14740
      IDENTIFICATION:
      User............................................. admin
      Computer Name.................................... CompName
      App Name......................................... AppName
      Client App....................................... WebClient
      CONNECTION:
      Provider......................................... ORAOLEDB.ORACLE
      Data Server......................................
      Database Name.................................... FDQMDEV
      Trusted Connect.................................. False
      Connect Status.. Connection Open
      GLOBALS:
      Location......................................... LO_S47
      Location ID...................................... 761
      Location Seg..................................... 15
      Category......................................... IST
      Category ID...................................... 12
      Period........................................... Jan - 2011
      Period ID........................................ 1/31/2011
      POV Local........................................ False
      Language......................................... 1033
      User Level....................................... 1
      All Partitions................................... True
      Is Auditor....................................... False

      Cheers,
      Sandro
        • 1. Re: BatchProcessing - Error: 6 Overflow
          Robb Salzmann
          Hi Sandro,

          A couple of things,
          On an additional note: We noticed in the errorlog that allways this Location is use, which we defined as Default for the admin-user. It does not use the Location specified in the filename.
          Essbase: 11.1.2
          FDM: Version 11.1.2.1.00
          Adapter: ES11X-G4-H>
          What Location are you referring to here?

          The error indicates that indeed the process is using the location specified in the filename:

          ** Begin FDM Runtime Error Log Entry [2011-09-13 15:17:48] **
          ERROR:
          <snip>
          Connect Status.. Connection Open
          GLOBALS:
          Location......................................... LO_S47 <----

          Also, the error calls out an parallel process error, but you have your setting to serial. This is curious.

          Have you tried this using the underscore delimiter? (You'll need to rename your location)

          Also, make sure that the file isn't open in a text editor or excel, word etc somewhere.

          How many lines of data does the file contain?

          Regards,
          Robb Salzmann
          • 2. Re: BatchProcessing - Error: 6 Overflow
            888106
            ladies handbag
            http://www.accvv.com/louis-vuittonpochette-wallet-mini-lin-p-2177.html     fashion accessories designer
            http://www.accvv.com/louis-vuittonpopincourt-haut-p-2140.html     fashion bag
            http://www.accvv.com/louis-vuittonpopincourt-p-2139.html     fashion bags
            http://www.accvv.com/louis-vuittonportetresor-international-damier-azur-p-2027.html     fashion bags online
            http://www.accvv.com/louis-vuittonpouchette-cles-croisette-red-p-2074.html     fashion designer bag
            http://www.accvv.com/louis-vuittonpouchette-cles-croisette-white-p-2075.html     fashion designer bags
            http://www.accvv.com/louis-vuittonpouchette-orange-p-2196.html     fashion designer brands
            http://www.accvv.com/louis-vuittonpouchette-red-p-2197.html     fashion designer handbag
            http://www.accvv.com/louis-vuittonpriscilla-p-2226.html     fashion designer handbags
            http://www.accvv.com/louis-vuittonpriscilla-p-2226.html     fashion designer purses
            • 3. Re: BatchProcessing - Error: 6 Overflow
              887914
              Hi Robb,

              thanks for the input. I doublechecked that no process has the file opened when trying to import. The file has 1350 lines.

              Yes, the Location in the errorlog is the one stated in the filename, because we set this one as default. When I change the default location, the new default will be used.

              I tried using the Underscore-Delimiter changing the Locationname to "LOS47" and the Filename to "a_LOS47_IST_Jan-2011_RR.txt". It yields the same result as before.

              Cheers,
              Sandro
              • 4. Re: BatchProcessing - Error: 6 Overflow
                851939
                Hi

                Did you solve your problem?

                Because I have the same :-/

                Thanks

                Fanny
                • 5. Re: BatchProcessing - Error: 6 Overflow
                  Onono
                  unfortunately I have the same issue - isn't there anybody who can help us?

                  location name: 12345_FAST_ESS
                  category: ACTUALS
                  period: Apr - 2030

                  file name: a@12345_FAST_ESS@ACTUALS@Apr - 2030@RA.csv

                  A)
                  starting the batch processing via "workbench - bath process" I get always the error code 6 and a reference to the default location CONTROLSREVIEW in the error entry

                  B)
                  starting it via script within workbench (run button) I get a "file not found" error (error code 53)


                  in both cases I have no further ideas :-((((
                  • 6. Re: BatchProcessing - Error: 6 Overflow
                    beyerch2
                    While I don't have any great advice on this, I have one suggestion in troubleshooting this.

                    In regards to the 'File Not Found' error, use either FileMon or ProcMon

                    http://technet.microsoft.com/en-us/sysinternals/bb896642

                    To determine what exactly FDM is looking for. Filemon will show you all file access attempts and their result by process so you could use this to step through and figure out at least what file it is attempting to open. ProcMon will show you more than filemon including registry access attempts, etc.

                    I don't think this is a great help because answering the 'File Not Found' may lead you on a red herring chase; however, if you have absolutely not ideas, might be something to take a look at?
                    • 7. Re: BatchProcessing - Error: 6 Overflow
                      Onono
                      hmmm,

                      the txt file structrue should be the same - as it is used for manual workflow processing.

                      because I have seen, that for multi load (my case is single load - onyl one period) - in multi load case there is a special structure needed.
                      Means: Using ceratin Load Control Tags

                      Is that also for non-multiload necessary?

                      regards