I am using the syntax as I see it in the DBAG and still getting an error:


IMPORT DATABASE $(APPname).$(DBname) DATA FROM LOAD_BUFFER WITH BUFFER_ID 901,902,903,904,905 ;


in MaxL I get this error:

MAXL> IMPORT DATABASE ALrgB1.AtrStdDm DATA FROM LOAD_BUFFER WITH BUFFER_ID ,902,
903,904,905 ;

essmsh error: Parse error near ,902,903,904,905


I have tried '901,902,903,904,905'

I have tried "901,902,903,904,905"

and putting spaces after the commas. Any ideas???



From the techref:
import database AsoSamp.Sample data from load_buffer with buffer_id 1, 2;
Commits the contents of multiple data load buffers (buffer_id 1 and buffer_id 2) to the AsoSamp.Sample database.


From the DBAG:
import database AsoSamp.Sample data from load_buffer with buffer_id 1, 2;
Commits the contents of multiple data load buffers (buffer_id 1 and buffer_id 2) to the AsoSamp.Sample database.

Try moving your ending semicolon to be immediately after the ending buffer number.

and it did not work:


MAXL> IMPORT DATABASE ALrgB1.AtrStdDm DATA FROM LOAD_BUFFER WITH BUFFER_ID ,902,
903,904,905;

essmsh error: Parse error near ,902,903,904,905;

essmsh timestamp: Wed Feb 20 14:17:48 2013

Have you tried it without the positional parameters - i.e. with the appname and dbname hard-coded?

No luck.

Also tried using 1,2... instead of 901,902

Tried with just 1 buffer and it worked so I know I am not nuts

I don't think this provides sufficient evidence either way, Dan. :-)

Let me go try on another 11.1.2.2 environment (different OS), will report back in a moment.

Try

IMPORT DATABASE $(APPname).$(DBname) DATA FROM LOAD_BUFFER WITH BUFFER_ID 901,902,903,904,905 add values;

By the way, if you are using 11.1.2.2, it was recently pointed out to me that you can now do this in a single statement/script using a load buffer block


import database 'App'.'DB' data connect as user identified by password
using multiple rules_file 'LD01', 'LD02', 'LD03', 'LD04', 'LD05', 'LD06', 'LD07', 'LD08'
to load_buffer_block starting with buffer_id 100
on error write to '/z/logs/LDALL.err';


No data commit is necessary it does it automatically.

IMPORT DATABASE ALrgB1.AtrStdDm DATA FROM LOAD_BUFFER WITH BUFFER_ID 901,902,903,904,905 add values;


MAXL> IMPORT DATABASE ALrgB1.AtrStdDm DATA FROM LOAD_BUFFER WITH BUFFER_ID ,902,
903,904,905 add values;

Your second post works with sql input but not with flat files (right?).

MAXL> query database ALrgB1.AtrStdDm list load_buffers;

buffer_id internal active resource_usage
aggregation_method ignore_missings ignore_zeros
+-------------------+-------------------+-------------------+-------------------
+-------------------+-------------------+-------------------
901 FALSE FALSE 0.2
AGGREGATE_SUM TRUE TRUE
904 FALSE FALSE 0.2
AGGREGATE_SUM TRUE TRUE
902 FALSE FALSE 0.2
AGGREGATE_SUM TRUE TRUE
903 FALSE FALSE 0.2
AGGREGATE_SUM TRUE TRUE
905 FALSE FALSE 0.2
AGGREGATE_SUM TRUE TRUE

OK/INFO - 1241044 - Records returned: [5].

essmsh timestamp: Wed Feb 20 15:06:21 2013

MAXL> IMPORT DATABASE ALrgB1.AtrStdDm DATA FROM LOAD_BUFFER WITH BUFFER_ID ,902,
903,904,905 add values;

essmsh error: Parse error near ,902,903,904,905

essmsh timestamp: Wed Feb 20 15:06:21 2013


essmsh timestamp: Wed Feb 20 15:06:21 2013

Dan, the following works OK when executed in the EAS MaxL editor, 11.1.2.2 running on AIX:

alter database ASOsamp.Sample initialize load_buffer with buffer_id 1 resource_usage 0.5;
alter database ASOsamp.Sample initialize load_buffer with buffer_id 2 resource_usage 0.5;
import database ASOsamp.Sample data from load_buffer with buffer_id 1, 2;

Have you tried running your commands from the EAS editor?

I vaguely remember getting MaxL parse errors when crossing operating systems (something to do with encoding) - are you running MaxL on Windows talking to a *nux server?

Well it works in the EAS Editor. Both EAS and Essbase are running on the same machine (my Laptop).

So the mystery continues.

I was calling with the -D decryption option and the decryption key.

When I removed it - everything was fine.

This Didn't work
%ESSBASEPATH%\bin\essmsh.exe -D %WorkingLoc%btest_%2.mxl 483451697,1516427083

This Did
%ESSBASEPATH%\bin\essmsh.exe %WorkingLoc%btest_%2.mxl

Sorry Dan, should have guessed encryption as I've seen it before, for example https://forums.oracle.com/forums/thread.jspa?threadID=2410571.

There are bugs in the Oracle Support database relating to this. For example, ID 871844.1 describes the same issue but with the statement:

import database 'xxx'.'xxx' data from load_buffer with buffer_id 1 add values create slice;

Supposedly fixed in 11.1.1.3 but evidently not for every case. If you have an Oracle Support account I'd log it.