topic Re: Insufficient Memory in Metadata Server in SAS Procedures

Insufficient Memory in Metadata Server

senico — Wed, 25 Nov 2009 04:18:48 GMT

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

Re: Insufficient Memory in Metadata Server

milts — Wed, 25 Nov 2009 06:31:32 GMT

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

Re: Insufficient Memory in Metadata Server

senico — Wed, 25 Nov 2009 08:11:16 GMT

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

Re: Insufficient Memory in Metadata Server

DanielSantos — Wed, 25 Nov 2009 09:36:25 GMT

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.

Re: Insufficient Memory in Metadata Server

senico — Wed, 25 Nov 2009 10:09:11 GMT

Hi Daniel,

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

Is it insuffient?
Please advice.

Regards,
Senico

Re: Insufficient Memory in Metadata Server

senico — Wed, 25 Nov 2009 10:25:29 GMT

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

Re: Insufficient Memory in Metadata Server

DanielSantos — Wed, 25 Nov 2009 14:28:42 GMT

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_2003

Cheers from Portugal.

Daniel Santos @ www.cgd.pt