This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 


  << Previous Topic | Next Topic >>Return to Index  

Parallel ASO Load - Multiple Buffers

February 20 2013 at 1:57 PM
No score for this post
DanP 
from IP address 108.5.149.202

 
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.

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
AuthorReply
Dean Haraguchi

50.11.131.67

Move your semicolon

No score for this post
February 20 2013, 2:09 PM 

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

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
DanP

108.5.149.202

OK I tried That (just in case you were not joking)

No score for this post
February 20 2013, 2:19 PM 

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

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
TimG

168.65.231.228

Re: OK I tried That (just in case you were not joking)

No score for this post
February 20 2013, 2:27 PM 

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

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
DanP

108.5.149.202

Yes I did that already

No score for this post
February 20 2013, 2:33 PM 

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

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
TimG

168.65.231.228

Re: Yes I did that already

No score for this post
February 20 2013, 2:39 PM 

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.

 
Scoring disabled. You must be logged in to score posts.Respond to this message   



205.228.53.11

Re: Parallel ASO Load - Multiple Buffers

No score for this post
February 20 2013, 2:44 PM 


Try

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

 
Scoring disabled. You must be logged in to score posts.Respond to this message   



205.228.53.11

Re: Parallel ASO Load - Multiple Buffers

No score for this post
February 20 2013, 2:50 PM 

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.

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
DanP

108.5.149.202

Tried That too but did it again to make sure

No score for this post
February 20 2013, 3:02 PM 

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?).

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
DanP

108.5.149.202

Ran a Query database List load_buffers to prove they exist

No score for this post
February 20 2013, 3:08 PM 

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

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
TimG

168.65.231.228

Re: Ran a Query database List load_buffers to prove they exist

No score for this post
February 20 2013, 4:29 PM 

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?

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
DanP

108.5.149.202

Works in EAS Editor

No score for this post
February 20 2013, 4:46 PM 

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

So the mystery continues.

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
DanP

108.5.149.202

Solved - You will not believe!

No score for this post
February 20 2013, 5:37 PM 

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

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
TimG

168.65.231.228

Re: Solved - You will not believe!

No score for this post
February 20 2013, 5:48 PM 

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.

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
Current Topic - Parallel ASO Load - Multiple Buffers
  << Previous Topic | Next Topic >>Return to Index  
 Copyright © 1999-2014 Network54. All rights reserved.   Terms of Use   Privacy Statement  

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.