Error creating Cube

Reply
New Contributor
Posts: 4

Error creating Cube

Hi,

I've a DI studio job with a user written code to create a Cube. It was working fine until a few days ago when it started raising the following error:

ERROR:  Failed to alloc mem for in-mem arrays when mapping fact keys to dim keys

ERROR: The fact keys cannot be mapped during the loading of star schema.

I've search for quite some time but didn't find anything that could explain this error.

Any suggestions?

Thanks

Super User
Posts: 5,424

Re: Error creating Cube

Posted in reply to CarlosSantos

Sounds like a memory problem.

First try to rule out that you have too little memory allocated/available during the cube creation.

Run your code using options fullstimer;

What is you memsize and sortsize settings?

During the job execution, monitor memory consumptions in the appropriate OS tool.

If you can't figure out by then, contact SAS tech support and have them explain what is causing the error message.

Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 150 views
  • 0 likes
  • 2 in conversation