Help using Base SAS procedures

Insufficient Memory in Metadata Server

Reply
Occasional Contributor
Posts: 6

Insufficient Memory in Metadata Server

Hi,

I am using SAS DI Studio 3.4 to create and modify SAS ETL job.
Now, when I connected to server and open one etl job,
i get the following error " Insufficient Memory".

I did set the memory configuration for Metadata server to MAX.
-memsize MAX

But, i still get the following error " Insufficient Memory".
So, I hope somebody can give out any idea to overcome this problem.

Regards,
Senico
Super Contributor
Posts: 326

Re: Insufficient Memory in Metadata Server

Hi Senico

Try modifying etlstudio.ini found at C:\Program Files\SAS\SASETLStudio\9.1

Modify CommandLineArgs and increase Xmxm

Hope this helps.

Regards,
Milton
Occasional Contributor
Posts: 6

Re: Insufficient Memory in Metadata Server

Hi Milton,
I did used your suggestion, but it does not work.
I think my client pc is ok. I guess the metadata server having problem.
For your information, when more than 2 developers connected at the metadata server, after a while, all the developers will face the Insufficient Memory problem. Currently, we did restart the metadata services to solve the problem. But, after a while we faced the same problem. So, please help me to solve this problem.
Thank you.

Regards,
Senico
Super Contributor
Posts: 474

Re: Insufficient Memory in Metadata Server

What is the hardware setup of your metadata server?

You see, metadata is all manipulated from memory at the server, so you should have at least a reasonable amount of RAM capable of holding all the metadata of your repositories.

We already had that problem on a 32bit Windows setup (witha 2Gb limitation), solution was to migrate the server to a 64bit Unix setup with 8Gb of RAM.

Cheers from Portugal.

Daniel Santos @ www.cgd.pt.
Occasional Contributor
Posts: 6

Re: Insufficient Memory in Metadata Server

Hi Daniel,

Our metadata server setup here as below:
Windows server 2003 32bit with 32G RAM.

Is it insuffient?
Please advice.

Regards,
Senico
Occasional Contributor
Posts: 6

Re: Insufficient Memory in Metadata Server

Hi Daniel,

For Window server 32bit with 32G RAM, is there any limitation of metadata size?
Currently, our metadata size is 5G.
Please advide.

Regards,
Senico
Super Contributor
Posts: 474

Re: Insufficient Memory in Metadata Server

That might be the problem.

Some 32 bit systems limit the addressing memory around 4GB.

And metadata server uses a single process to load the entire metadata into memory.

Check here the limit for your system here:
http://msdn.microsoft.com/en-us/library/aa366778(VS.85).aspx#physical_memory_limits_windows_server_2...

Cheers from Portugal.

Daniel Santos @ www.cgd.pt
Ask a Question
Discussion stats
  • 6 replies
  • 456 views
  • 0 likes
  • 3 in conversation