TSV_TNEW_PAGE_ALLOC_FAILED, No more storage space available for extending an internal table.

[former_member280828]

Hi Everyone,

Hope all are doing fine.

Guys i am getting some memory dumps whenever my HCM Consultant is running a retro payroll.

The dumps are as follows.

How to correct the error

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

    Roll area...................... 6238112

    Extended memory (EM)........... 4001259000

    Assigned memory (HEAP)......... 2000720624

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

    Paging area.................... 679936

    Maximum address space.......... 18446604152724142095

    If the error occures in a non-modified SAP program, you may be able to

    find an interim solution in an SAP Note.

    If you have access to SAP Notes, carry out a search with the following

    keywords:

    "TSV_TNEW_PAGE_ALLOC_FAILED" " "

    "SAPMS380" or "MS380F10"

    "EXTRACT_STRINGS_FROM_SNAP"

    If you cannot solve the problem yourself and want to send an error

    notification to SAP, include the following information:

    1. The description of the current problem (short dump)

       To save the description, choose "System->List->Save->Local File

    (Unconverted)".

    2. Corresponding system log

       Display the system log by calling transaction SM21.

       Restrict the time interval to 10 minutes before and five minutes

    after the short dump. Then choose "System->List->Save->Local File

    (Unconverted)".

    3. If the problem occurs in a problem of your own or a modified SAP

    program: The source code of the program

       In the editor, choose "Utilities->More

    Utilities->Upload/Download->Download".

    4. Details about the conditions under which the error occurred or which

    actions and input led to the error.

My Systems Memory Parameters are as follows.

ztta/roll_area        6500352    Byte Roll area per workprocess (total)

ztta/roll_first       1024       Byte First amount of roll area used in a dialog WP

ztta/short_area       3200000    Byte Short area per workprocess

rdisp/ROLL_SHM        131072     8 kB Part of roll file in shared memory

rdisp/PG_SHM          65536      8 kB Part of paging file in shared memory

rdisp/PG_LOCAL        150        8 kB Paging buffer per workprocess

em/initial_size_MB    7960       MB   Initial size of extended memory

em/blocksize_KB       4096       kB   Size of one extended memory block

em/address_space_MB   4096       MB   Address space reserved for ext. mem. (NT only)

ztta/roll_extension   4000317440 Byte Max. extended mem. per session (external mode)

abap/heap_area_dia    2000683008 Byte Max. heap memory for dialog workprocesses

abap/heap_area_nondia 2000683008 Byte Max. heap memory for non-dialog workprocesses

abap/heap_area_total  2000683008 Byte Max. usable heap memory

abap/heaplimit        40894464   Byte Workprocess restart limit of heap memory

abap/use_paging       0               Paging for flat tables used (1) or not (0)

Please advice me is there any parameter that i can increase so that the process can work smoothly ???

My Servers memory is 32 GB on RHEL 6.

[former_member280828 · Accepted solution]

Hey Guys,

First of all thanks all of you for taking out a precious time from your life to help me in this issue.

I have gained knowlegde from all of your answers and this issue is resolved now.

I told my consultant to limit their query for fetching a report and it worked.

Thanks everybody for their help.

Regards,

Musa

[raquel_gomez]

Hi!

Glad to read issue was solved. As you may already know, the TSV_TNEW_PAGE_ALLOC_FAILED mainly appears when a single work process has taken all its quota for Extended Memory and Heap Memory and has no more memory to allocate.

In the attached dump, 6GB were consumed by the work process, 4GB EM and 2GB HM:

    Extended memory (EM)........... 4001259000

    Assigned memory (HEAP)......... 2000720624

Defined quotas are ztta/roll_extension_(non)dia for EM, and abap/heap_area_(non)dia for HM.
In case you face this dump again, deeper explanation can be found on Note:

2180736 - TSV_TNEW_PAGE_ALLOC_FAILED

Regards,
Raquel

[tamil_arasan]

Hi RBK,

Glad to know that your issue has been resolved. Usually, Functional/ABAP team will come directly to BASIS team for this kind of issue immediately and we should not directly go for parameter optimization for the memory dumps. We should request them to fine tune their code or we need to ask them to reduce the data selection range.

Cheers,

Pradeep. 

[former_member280828]

Hey Pradeep,

Yeah dude you are right we should do this way only

Regards,

Musa.

[tamil_arasan]

Hi,

If possible, please request your team to reduce the data processing limit. For example, if they are running a report to retrieve the data for 1000000 records, Please ask them to reduce to 50000 and run another time remaining 50000 records. If this is not possible, please check the SAP note  941735 - SAP memory management system for 64-bit Linux systems this may help you.

Also post the SAP system and kernel details  as parameters recommendations based on SAP kernel release.

Thanks and regards,

Pradeep

[former_member182675]

Hi

I think the best way to solve this problem is first to check if you can improve the query, check the table check index etc..

And if this notoptionor the problem so I willrecomendedto you yo check memory parameter

abap/heaplimit,Try first to increase from RSMEMORY

If you need more help

Feel free

Regards

Naor

[Former Member]

Hello,

Try to check if you can limit the selection criteria and execute the report again. Improper selection criteria unnecessarily utilises more memory.

Thanks,

Sowmya

[former_member280828]

Hey Sowmya,

Yeah your suggestion is great ill surely tell my consultant to limit the selection creteria and check if still issue persist ill reply back here.

Regards,

Musaddik.

[Former Member]

Hi,

Your process has consumed to the maximum level of memory allocation allotted to a process.

i.e. 6 GB which is enough for a process.

You can try increasing heap memory by 1 GB to see if the process completes successfully. Though you should force the users reducing the selection criteria.

If you want to increase the memory you can do this on temporary basis using RSMEMORY report to avoid system restart.

Regards,

Prithviraj.

[feng_shi]

hi,

Assigned memory (HEAP)......... 2000720624

abap/heap_area_dia    2000683008 Byte Max. heap memory for dialog workprocesses
abap/heap_area_nondia 2000683008 Byte Max. heap memory for non-dialog workprocesses
abap/heap_area_total  2000683008 Byte Max. usable heap memory

The heap memory is used up.

just increase(for example, doulble or triple ) heap memory by following parameters,

then the issue will be avoided.

abap/heap_area_dia

abap/heap_area_nondia

abap/heap_area_total

Thanks and best regards,

Shi

[former_member280828]

Hey Feng Shi,

Hope you are doing great man ??

Can i increase these parameters that you are suggesting ??

Because i have 32 GB RAM on my server

Regards,

Musa