cancel
Showing results for 
Search instead for 
Did you mean: 

TSV_TNEW_PAGE_ALLOC_FAILED/ Table NAST/ program SAPLV70A

former_member196664
Participant
0 Kudos

Hi All,

I am getting dump in ECC production system which runs on windows 2003/sql2005 on 64 bit platflorm. Kernel -700-patch347. We have set all parameters as below. Do we need to increase physical memory or any other parameter? Batch jobs failing with memory related dumps TSV_TNEW_PAGE_ALLOC_FAILED. The program causing is SAPLV70A. Affected table is NAST. Please help ASAP. Distributed system with CI +App server has 16+16 GB RAM. In CI

Physical main memory (RAM) 16378

PHYS_MEMSIZE 16378

em/initial_size_MB 20,000 

em/blocksize_KB 4096

em/max_size_MB 100000

ztta/roll_area 6500000 

em/address_space_MB 4096

ztta/roll_first 1 

ztta/roll_extension 2000000000

abap/heap_area_dia 2000000000 

abap/heap_area_nondia 0

abap/heap_area_total 17173577728 

rdisp/ROLL_MAXFS 32768

rdisp/ROLL_SHM 32768

rdisp/PG_MAXFS 262144

rdisp/PG_SHM 16384

em/global_area_MB 512

From ST22

Error analysis
    The internal table "\PROGRAM=SD70AV2A\DATA=MSGS[]" could not be further
     extended. To enable
    error handling, the table had to be delete before this log was written.
    As a result, the table is displayed further down or, if you branch to
    the ABAP Debugger, with 0 rows.

    At the time of the termination, the following data was determined for
    the relevant internal table:

    Memory location: "Session memory"
    Row width: 2208
    Number of rows: 1748948
    Allocated rows: 1748948
    Newly requested rows: 4 (in 1 blocks)

How to correct the error
    The amount of storage space (in bytes) filled at termination time was:

    Roll area...................... 6221152
    Extended memory (EM)........... 2002743520
    Assigned memory (HEAP)......... 1932740608
    Short area..................... " "
    Paging area.................... 24576
    Maximum address space.......... " "

    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" " "
    "SAPLV70A" or "LV70AU03"
    "WFMC_MESSAGES_SELECT_ALL_FALSE"

Please help ASAP.

Thanks,

Kavitha

Accepted Solutions (1)

Accepted Solutions (1)

Former Member

Hi

how many records has your nast?

Let me know

a

former_member196664
Participant
0 Kudos

Hi Andrea,

NAST has more than 22 million records.

former_member196664
Participant
0 Kudos

Hi Andrea,

Is there way to optimize the table performance or program fix available? Pls help.

Former Member
0 Kudos

Hi Kavitha

you are in a kind of grey area. The table is really big but it could be a temp bottleneck (if in parallel there are other things that are affecting all night runs) or a not good statement in the program you use

Can you give me more info regarding program and variant you use?

Are Note 1629669 or KBA 1580605 applicable for you? What sp level have you in your system?

Is something that happens always or sometimes?

Even if i don't like to change parameter to allow management of big tables, have you seen Matteo Stocco 's recommendation?

Let me know and i'll help you

a

former_member196664
Participant
0 Kudos

Hi Andrea,

Note 1629669 is already applied. KBA1580605, I think is not applicable. Program runs every 10 minutes. It causing issue during day time as well. It sometimes caused issue before but now it became adequate and everyday dumping affecting business. Program has 4 steps. 3&4 has issues.

1  RSNAST00             ABAP                  ZADR       BATCH  EN

2  RSNAST00             ABAP                  YADR       BATCH  EN

3  SD70AV2A             ABAP                  ZADR_3     BATCH EN

4  SD70AV2A             ABAP                  YADR_4     BATCH EN

I replied to Matteo's response, however, my messages and replies are being moderated and taking so long to get posted. It is ECC 6.0 SPS17. Please help ASAP.

Thanks,

Kavitha.

former_member196664
Participant
0 Kudos

Hi Andrea,

Just for additional information. 4th step was running with variant processing mode 3. Just now we changed to processing mode 4 to test the performance.

Former Member
0 Kudos

Hi Kavitha

sounds like a plan!

Meanwhile i'm checking if there is anything we can do for performances, did you never create custom index against nast?

Can you trace one of the nasty steps and let me know what's the longest statement?

Let me know how is going

a

former_member196664
Participant
0 Kudos

Hi Andrea,

We rebuilt index on table NAST and that did not work. Our issue is resolved now, as we reduced the number of entries in table NAST only for YADR variant. We reduced around 2 million records and also changed processing mode to 4, which creates less entries compared to processing mode 3 in NAST.

Thank you so much for the time.

Kavitha Rajan.

Former Member
0 Kudos

Has been a pleasure

Come back to me if you need

a

former_member196664
Participant
0 Kudos

Sure, Thank you so much.

Answers (2)

Answers (2)

Former Member
0 Kudos

Try to increase these parameter:

abap/heap_area_dia 2000000000  --> 4000000000

abap/heap_area_nondia 0 --> 4000000000

abap/heap_area_total 17173577728 --> 4000000000

Restart your AS after the modification to activate it.

Regards

Matteo

former_member196664
Participant
0 Kudos

Hi Matteo,

We have parameter values based on  Note 146289 - Parameter Recommendations for 64-Bit SAP Kernel and Note 88416 - Zero administration memory management for the ABAP server. Pls advise increasing to above values cause issue? Is there any OSS Note? Pls help.

Thanks,

Kavitha.

Former Member
0 Kudos

Some time the parameter of notes Note 146289 - Parameter Recommendations for 64-Bit SAP Kernel and Note 88416 - Zero administration memory management are not sufficient.

In my experience the parameter that I suggested you don't create any issue.

A suggestion should be to change the parameter, execute the job that you need, and after that retur to the original value.

former_member196664
Participant
0 Kudos

Hi Matteo.

I will definitely try this and get back. Since it is production and users work all round the clock, I will wait for downtime to get approved.

Thanks,

Kavitha Rajan.

Former Member
0 Kudos

Ok, let us know.

A corrections to the parameter...

If you put abap/heap_area_nondia 0 the value of this parameter by default is equal to abap/heap_area_total so, I suggest you to let abap/heap_area_nondia 0.

If it works please mark the question as answered.

Bye

former_member196664
Participant
0 Kudos

Hi Matteo,

Sure will do. Thank you so much. Right now, we have changed the processing mode and testing. Next, I will try on the parameters.

Thanks,

Kavitha.

former_member188883
Active Contributor
0 Kudos

Hi Kavitha,

Could you check below SAP note.

Note 654901 - Short dump occurs when updating the message language

Hope this helps.

Regards,

Deepak Kori

former_member196664
Participant
0 Kudos

Hi Deepak,

This is not applicable to our system as it is for old version. Pls let me know if there is any other Note available.

Thanks,

kavitha