Skip to Content
author's profile photo Former Member
Former Member

Tsv_tnew_blocks_no_roll_memory error while running a program in background

Hi All,

I have a report which if i run in background is giving me dump.I am getting tsv_tnew_blocks_no_roll_memory error.I checked in debugging and am pasting the code

where it is failing

  • Fetching delivery history

SELECT ebeln ebelp zekkn vgabe

gjahr belnr buzei bwart

budat menge xblnr lfbnr

FROM ekbe

INTO TABLE t_ekbe

FOR ALL ENTRIES IN t_eket

WHERE ebeln = t_eket-ebeln

AND ebelp = t_eket-ebelp

AND bwart IN r_bwart.

In the internal table t_eket there are 2400000 records.

Also there are many other hufe internal tables in the run time in program.

I think this error is bacause of memory allocation or lack of it.

So any solutions are most welcome.

I have tried using free itab.

Am verifying it now.

Please suggest.

Thanks in advance,

Saket.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 20, 2008 at 12:21 PM

    Is there a way to filter more data in T_EKET.

    2400000 in For all entries is too much for a select query.

    Regards,

    Mohaiyuddin

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 06:03 AM

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.