No more storage space available for extending an internal table.

[Former Member]

Hi All,

We are getting dump in one of our custom program "TSV_TNEW_PAGE_ALLOC_FAILED" . But some time the program finishes successfully and sometime it gives the dump.

We have below parameter in profile

ztta/roll_area = 6500352

ztta/roll_extension = 2000000000

abap/heap_area_total = 2000683008

abap/heap_area_dia= 2000683008

abap/heap_area_nondia=2000683008

em/initial_size_MB = 8192

and in the dump we are getting below message.

==========================================================================

How to correct the error

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

Roll area...................... 6201648

Extended memory (EM)........... 2002747344

Assigned memory (HEAP)......... 1997358272

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

Paging area.................... 24576

Maximum address space.......... 18446697159420952031

As i can see here the extended memory requirement is more.

I need to know which parameters i should update to avoid this dump.

Please help.

Regards

Deepak

[Former Member]

Hi,

Refer this SAP notes,

SAP Note 649327 - Analysis of memory consumption.

SAP Note 20527 - Runtime error TSV_TNEW_PAGE_ALLOC_FAILED

SAP Note 185185 - Application: Analysis of memory bottlenecks

SAP Note 369726 - TSV_TNEW_PAGE_ALLOC_FAILED "

Thanks and Regards,

Dhaya.G

[Former Member]

Hi,

Refer this ,

For ztta/roll_area:

==============

Unit: Bytes

Default value: 6500000 (6.5 MB)

Recommended value: UNIX: 6500000 (6.5 MB). 1000000 (1 MB) is the minimum size; under IBM AS/400 167731120 (16 MB); under Windows NT: 1000000 (1 MB).

Also,Check whether ztta/roll_area equal or larger than ztta/roll_first.

ztta/roll_extension,:

================

this specifies the amount in bytes of R/3 extended memory that a user context can allocate

Unit: Bytes

Default value: 250000000 (250 MB)

20971520 (20 MB) under AS/400

Recommended value: 20971520 (20 MB).

em/initial_size_MB: should be considerably larger than ztta/roll_extension

Abap/heap_area_total :

===================

Unit: Bytes

Default value: 800000000 (800 MB)

abap/heap_area_dia:

=================

Unit: Bytes

Default value: 80000000 (80 MB)

Recommended value: 2 GB

abap/heap_area_nondia:

====================

Unit: Bytes

Default value: 40000000 (40 MB)

Recommended value For the following platforms:

IBM AIX: 190000000 (190 mil. bytes)

Siemens-Nixdorf SINIX: 350000000 (350 mil. bytes)

HP-UX: 600000000 (600 mil. bytes)

Other platforms: 900000000 (900 mil. bytes)

em/initial_size_MB:

===============

Unit: 1 MB

Default value: 128 MB

Recommended value: 200 to 500 MB, approximately 5 MB for each R/3 user

Thanks and Regards,

Dhaya.G

[Former Member]

Hi Deepak,

This dump usually occurs in situations where the data selection is large. You could consider executing this program in the background. You may need to revise the memory related parameters only in situations where the dump occurs frequently in your system.

cheers!!

[Former Member]

Hi deepak.shinde,

Refer this forums it will help you,

[;

[;

You can refer this forums also,its of same scenario

[;

[;

Thanks and Regards,

Dhaya.G

Edited by: Dhayalinie Ganesh on Mar 7, 2012 5:22 AM

[Former Member]

Hi,

Thanks for reply. I have gone through some of the notes and sdn link also and the one which you have suggeted. But the program for which we are getting dump is getting finished succefully someday/time and some other day it is getting canceled.

So i am not very sure how to permanently resolve this problem. Please find below the output of "sappfpar check" Can you please suggested how i can find if there is any problem in parameter setting from below output? and if yes which i should change with what value.

Please help.

Thanks

===============================================================================

== Checking profile:

================================================================================

***WARNING: Unexpected parameter:

***WARNING: Unexpected parameter: icm/HTTP/esid_response_check =TRUE

***WARNING: Unexpected parameter: jstartup/vm/home =/usr/lib64/jvm/java-1.4.2_SR13_FP6_ibm

***ERROR: Size of shared memory pool 10 too small

================================================================

SOLUTIONS: (1) Locate shared memory segments outside of pool 10

with parameters like: ipc/shm_psize_<key> =0

SOLUTION: Increase size of shared memory pool 10

with parameter: ipc/shm_psize_10 =202000000

***ERROR: Size of shared memory pool 40 too small

================================================================

SOLUTIONS: (1) Locate shared memory segments outside of pool 40

with parameters like: ipc/shm_psize_<key> =0

SOLUTION: Increase size of shared memory pool 40

with parameter: ipc/shm_psize_40 =304000000

Shared memory disposition overview

================================================================

Shared memory pools

Key: 10 Pool

Size configured.....: 136000000 ( 129.7 MB)

Size min. estimated.: 198225520 ( 189.0 MB)

Advised Size........: 202000000 ( 192.6 MB)

Key: 40 Pool for database buffers

Size configured.....: 112000000 ( 106.8 MB)

Size min. estimated.: 300759040 ( 286.8 MB)

Advised Size........: 304000000 ( 289.9 MB)

Shared memories inside of pool 10

Key: 11 Size: 500000 ( 0.5 MB) Factory calender buffer

Key: 12 Size: 6000000 ( 5.7 MB) TemSe Char-Code convert Buf.

Key: 13 Size: 100500000 ( 95.8 MB) Alert Area

Key: 14 Size: 20000000 ( 19.1 MB) Presentation buffer

Key: 16 Size: 22400 ( 0.0 MB) Semaphore activity monitoring

Key: 17 Size: 21202352 ( 20.2 MB) Roll administration

Shared memories inside of pool 40

Key: 42 Size: 28352992 ( 27.0 MB) DB TTAB buffer

Key: 43 Size: 140214392 ( 133.7 MB) DB FTAB buffer

Key: 44 Size: 48054392 ( 45.8 MB) DB IREC buffer

Key: 45 Size: 10166392 ( 9.7 MB) DB short nametab buffer

Key: 46 Size: 20480 ( 0.0 MB) DB sync table

Key: 47 Size: 20481024 ( 19.5 MB) DB CUA buffer

Key: 48 Size: 500000 ( 0.5 MB) Number range buffer

Key: 49 Size: 2968344 ( 2.8 MB) Spool admin (SpoolWP+DiaWP)

Shared memories outside of pools

Key: 1 Size: 2500 ( 0.0 MB) System administration

Key: 2 Size: 60069580 ( 57.3 MB) Disp. administration tables

Key: 3 Size: 13714400 ( 13.1 MB) Disp. communication areas

Key: 4 Size: 518848 ( 0.5 MB) statistic area

Key: 6 Size: 532480000 ( 507.8 MB) ABAP program buffer

Key: 7 Size: 14838 ( 0.0 MB) Update task administration

Key: 8 Size: 268435556 ( 256.0 MB) Paging buffer

Key: 9 Size: 268435556 ( 256.0 MB) Roll buffer

Key: 18 Size: 7000100 ( 6.7 MB) Paging adminitration

Key: 19 Size: 200000000 ( 190.7 MB) Table-buffer

Key: 30 Size: 29696 ( 0.0 MB) Taskhandler runtime admin.

Key: 31 Size: 4206000 ( 4.0 MB) Dispatcher request queue

Key: 33 Size: 92160000 ( 87.9 MB) Table buffer, part.buffering

Key: 41 Size: 25010000 ( 23.9 MB) DB statistics buffer

Key: 51 Size: 3200000 ( 3.1 MB) Extended memory admin.

Key: 52 Size: 40000 ( 0.0 MB) Message Server buffer

Key: 54 Size: 102408192 ( 97.7 MB) Export/Import buffer

Key: 55 Size: 8192 ( 0.0 MB) Spool local printer+joblist

Key: 57 Size: 1048576 ( 1.0 MB) Profilparameter in shared mem

Key: 58 Size: 4096 ( 0.0 MB) Enqueue ID for reset

Key: 62 Size: 264241152 ( 252.0 MB) Memory pipes

Key: 63 Size: 409600 ( 0.4 MB) ICMAN shared memory

Key: 64 Size: 4202496 ( 4.0 MB) Online Text Repository Buf.

Key: 65 Size: 4202496 ( 4.0 MB) Export/Import Shared Memory

Key: 1002 Size: 400000 ( 0.4 MB) Performance monitoring V01.0

Key: 58900122 Size: 4096 ( 0.0 MB) SCSA area

Edited by: deepak.shinde on Mar 7, 2012 6:26 AM