Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A


Hi Experts,

Our BI Prod System is throwing the dump for "TSV_TNEW_PAGE_ALLOC_FAILED" error.

I have extended the parameters couple of times based on sap notes.

Please find the current parameter values set in our BI Prod system

em/global_area_MB = 250

ztta/roll_extension 4000000000

ztta/roll_first 1

ztta/roll_area 6500000

em/initial_size_MB 8192

abap/heap_area_total 6000000000

abap/heap_area_dia 3000000000

abap/heap_area_nondia 3000000000

We have 32GB RAM and 64 GB Paging space.

I'm attaching the details of "how to currect the error" from the ST22 dump below,

The amount of storage space (in bytes) filled at termination time was:

Roll area...................... 6221152

Extended memory (EM)........... 6000468352

Assigned memory (HEAP)......... 3000777840

Short area..................... " "

Paging area.................... 16384

Maximum address space.......... 4294967295

Please let me know, with my current memory availability, can I increase the parameter further and what should be parameter values.

Or Please let me know, how can I rectify this error.



Former Member
Former Member replied

Hi Shanahas,

Before you change the memory parameters, I would like to highlight some points which can help you making your decision :

1) If you are getting memory dump for a specific program, then firstly involve any developer to tune the records selection criteria from the tables. Often, it has been seen that the data selected from the tables in BW systems is quite high which is stored in runtime memory and uses SAP memory in the sequence of ext. and then heap.

2) If there is no chance to tune the program, then you have to change the memory parameters.

3) You need to consider the memory consumed by oracle and SAP both on the server and memory settings should fit into physicam RAM.

4) For eg. Database consumes 15 GB (SGA + PGA), so 17 GB can be used by SAP in this scenario.

With the above facts, it makes more relevant to ask you some questions :

a) Are you using Windows/Unix and 32bit/64bit OS ?

It is required to set the paramter ztta/roll_extension because the behavior of memory allocations changes accordingly

b) How much memory is allocated to your database software.

c) If you increase ext. memory for a WP, it is required to be calculated like how many WPs do you have and what can the total em size of your SAP

I hope I am not confusing you. Let me know if you have further queries.



0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question