Analytics Software

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