PROC OLAP aggregation error

n01known — Thu, 16 Apr 2009 08:57:55 GMT

hi.
i try to build %cubename%, and i have receive such error:

NOTE: The cube already exists. The existing cube will be overwritten with the new cube.
NOTE: Intermediate aggregation created with 27815651 records.
NOTE: Processing of final NWAY completed.
ERROR: Index for aggregation "DEFAULT" could not be created.
No memory can be allocated
Incomplete index prohibits index use
Incomplete index prohibits index use
Incomplete index prohibits index use
ERROR: An SPDE aggregate table index cannot be created.
ERROR: Cube creation has failed due to a problem creating the fully summarized NWAY.
[....]
ERROR: Cube %cubename% cannot be created.

can you help me?

Re: PROC OLAP aggregation error

LinusH — Thu, 16 Apr 2009 11:15:41 GMT

You are short on memory, either on disk or in RAM.
Running PROC OPTIONS GROUP=(SORT MEMORY PERFORMANCE); RUN;
might give some clues. Also checking your disk status, both in saswork and cube location.

Browsing support.sas.com will give some useful tips, including this:

http://support.sas.com/kb/32/041.html

/Linus

topic Re: PROC OLAP aggregation error in SAS Procedures

PROC OLAP aggregation error

Re: PROC OLAP aggregation error