on 03-09-2010 9:00 AM
Hi Gurus,
Recently we've been receiving a bunch of TSV_TNEW_PAGE_ALLOC_FAILED abap dumps.
The dump will always mention "No storage space available for extending table "IT_XXXXX"." XXXXX are various numbers.
This is a server memory issue, NOT a DB space issue. An internal table is a table that resides in server memory.
Also i noticed in ST02, Free Space & Free Directory for NAMETAB (NTAB) Table definition is RED and 0.00. Could this be related to the abap dump???
I'm trying to pinpoint which parameter to increase the value, I rounded it down to:-
abap/heap_area_total
abap/heap_area_dia
abap/heap_area_nondia ...
em/initial_size_MB
ztta/roll_extension
Would this solve this problem???
Dear All
This memory related error gets because its hitting upper limits of memory for sinlgle user,
Roll area...................... 6178768
Extended memory (EM)........... 2001260211
Assigned memory (HEAP)......... 10096240
Short area..................... 16079
Paging area.................... 262144
Maximum address space.......... "-1"
You need to change heap area dia to 2GB and abap heap area non dia to a high value depending on RAM and heap area
total also
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can try incresing the heap memory for Non-diag to 4 or 6 gb , roll_extension to 4 gb and em_global to 20% more to existing.
The BTC takes the memory intially from roll after that Heap memory if that exhausted it will go for roll_extension .
http://help.sap.com/saphelp_nw04/helpdata/en/34/d9c8b9c23c11d188b40000e83539c3/content.htm
Thanks,
Subhash.G
Hi,
This seems to be problem in the Shared memory. please refer Note 1166259 - Problems with shared memory in marketing applications for the solution
Regards
D.Mukunthan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
most possible the issue with abap program please check abap program
or check paging memory in you server
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Keat,
In my experience , 9 out of 10 times this dump has been seen due to some Z* (customer program) not being correctly written and hence not optimally utilizing the memory of the system.
The below issue which you are facing; is this due to a standard SAP program or a Z* program. Please confirm this.
Also, more often than not, the SAP parameter values would be fine. You can get this checked again, though.
But i guess, The program should be tuned accordingly.
Because, Its difficult to understand why would this program consume 2 GB of memory ?
Good Luck.
Hari Kishan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Keat,
Can you let us know the exact situation when you are getting this dump and also the system details. In my experience this dump you see freaquently in BW system in production support after over a period of time, as the data grow's and accordingly user request for the data grows. In that case you need to do memory tuning. But also as Alivier recommonded its better to look for the provision where you can reduce the selection criterea or some time's there could be a problem with program that you are using then u have to reach out programmer.
If this memory demand is from SAP standard programs, then give the complete senario of the problem. Like what you are trying to run and the steps you are following for that. So that its easy to narrow down the problem and to find the cause.
Also if you decided to change the memory parameters, then dont forget to run the 'sappfpar' to check your profile.
Thanks & Regards,
N.Amarnath
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi all,
These are the related parameters currently set in the system.
ztta/roll_area = 6500000
ztta/roll_extension = 2000000000
abap/heap_area_total = 2000000000
abap/heap_area_dia = 10000000
abap/heap_area_nondia = 1073741824
em/initial_size_MB = 6144
here is a sample storage usage at termination time of the abap dump.
Roll area...................... 6178768
Extended memory (EM)........... 2001260211
Assigned memory (HEAP)......... 10096240
Short area..................... 16079
Paging area.................... 262144
Maximum address space.......... "-1"
As you can see, the usage of the Extended memory (EM) of the batch jobs have exceeded the specified value of 2000000000.
This is the reason why the batch jobs got terminated with error message "No storage space available for extending table "IT_XXXXXX"."
We can't do much here as we're not allowed to increase the value of parameter ztta/roll_extension further.
Are you check your JOB work's fine or not? As mr.Olivier say usually is are badly writen code ....
About memory configuration .... --->> You not say how much memory you have on your BOX, are DB on same host, any other application are used? Try to give as this information, or we need buy magic ball ? Regards.
here is a sample storage usage at termination time of the abap dump.
Roll area...................... 6178768
Extended memory (EM)........... 2001260211
Assigned memory (HEAP)......... 10096240
Short area..................... 16079
Paging area.................... 262144
Maximum address space.......... "-1"
Hi KeatSeong,
Based on the values from your ABAP dump, I can definitely say this is a BAD program. At the time of termination, Extended memory is fully utilized upto 2GB which is allowed per process as per ztta/roll_extension.
Please ask ABAPer to check the ABAP code where the program terminates .... many times if there is a nested query where first query results in internal table and that becomes source for another query , the issue is previous query generated a NULL internal table and that triggers a full table read of the next query on a huge table and that becomes this ERROR.
A simple, IF InternalTable not NULL, condition may resolve this issue, if the symptoms I mentioned are correct in your case.
Thanks
Yatin
Hello,
If this dump is about a background job, why it uses less heap and more of the EM.
As per your parameters:
ztta/roll_extension = 2000000000
abap/heap_area_total = 2000000000
abap/heap_area_dia = 10000000
abap/heap_area_nondia = 1073741824
em/initial_size_MB = 6144
Your non_dia heap is set to 1GB, its only after using this 1GB would the background process look for Extended memory. Most probably this dump is not of a background process.
Also, I see that your total extended memory is just 6GB how much memory does your server have? Make good use of the available server memory by setting up large chunks of EM, if you increase the initia_size_MB to say 8GB or 12GB you can increase ztta/roll_extension to accommdate those programs that are dumping.
However the first priority is to talk to developers on improving the code rather than increasing parameters.
Regards,
Siddhesh
Hi,
>This is a server memory issue,
In my experience, 9 times out of 10, it is either a badly written program or an unappropriate (too big) variant used.
This kind of short dump is designed to protect your system from too much memory consumption.
It is much better to dump one program than to crash the whole system.
Don't change the system paramters before checking the variant and the program. You are not supposed to load tens of millions lines in an internal table. You can check the number of lines in the short dump.
Regards,
Olivier
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
An internal table is a table that resides in server memory
This is correct but is limited to the parameters you have listed, as you do not not multiple users blowing your server memory away.
I'm trying to pinpoint which parameter to increase the value, I rounded it down to:-
abap/heap_area_total
abap/heap_area_dia
abap/heap_area_nondia ...
em/initial_size_MB
ztta/roll_extension
Waht are your valuse for these..?
and can you paste the full dump..
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.