topic Run time error - TSV_TNEW_PAGE_ALLOC_FAILED in Application Development and Automation Discussions

Run time error - TSV_TNEW_PAGE_ALLOC_FAILED

Former Member — Tue, 12 Aug 2008 15:18:55 GMT

Hi,

When I execute a report I am getting run time error as TSV_TNEW_PAGE_ALLOC_FAILED.

Short text

No more storage space available for extending an internal table.

What happened?

You attempted to extend an internal table, but the required space was

not available.

Error analysis

The internal table "\PROGRAM=ZZFO_MKTG_INFO_RPT\DATA=IT_VBELN[]" couldnot be

further extended. To enable

error handling, the table had to be delete before this log was writt

As a result, the table is displayed further down or, if you branch t

the ABAP Debugger, with 0 rows.

At the time of the termination, the following data was determined fo

the relevant internal table:

Memory location: "Session memory"

Row width: 2308

Number of rows: 1456124

Allocated rows: 1456124

Newly requested rows: 4 (in 1 blocks)

Can any one suggest how to rectify this error?

I tried to change the data declaration of the internal table

DATA : IT_VBELN TYPE STANDARD TABLE OF TYPE_IT_VBELN.

But I doubt if it will work.

Some of my friends suggested to contact Basis team.

Can any one suggest how to proceed with?

Regards,

Rajesh

Re: Run time error - TSV_TNEW_PAGE_ALLOC_FAILED

Former Member — Tue, 12 Aug 2008 15:21:19 GMT

you need to do some performance tuning... before selecting data by using for all entries check whether internal table is empty or not...

if first select try using all keys.. if not possible try creating secondary index and use it...

Re: Run time error - TSV_TNEW_PAGE_ALLOC_FAILED

RichHeilman — Tue, 12 Aug 2008 15:23:21 GMT

You are running out of memory!!! You need to free up some memory in your program. I would suggest debugging your program in the productive system, and seeing what internal tables are the largest. And if at any point in time during the program execution, there is not need for that data any longer, you should FREE it. This allows that memory to be reused.

Free itab.

Regards,

Rich Heilman

Re: Run time error - TSV_TNEW_PAGE_ALLOC_FAILED

ThomasZloch — Tue, 12 Aug 2008 15:27:49 GMT

> Row width: 2308

> Number of rows: 1456124

That's more than 3GB of internal memory!

> Some of my friends suggested to contact Basis team.

No. Your program needs a makeover i.e. block processing: read a chunk of x records, process, clear tables, read next chunk etc.

Thomas