Help using Base SAS procedures

PROC OLAP aggregation error

Reply
Occasional Contributor
Posts: 6

PROC OLAP aggregation error

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?
Super User
Posts: 5,254

Re: PROC OLAP aggregation error

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
Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 393 views
  • 0 likes
  • 2 in conversation