Run time error - TSV_TNEW_PAGE_ALLOC_FAILED

[Former Member]

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

like

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

[Former Member]

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...

[RichHeilman]

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

[ThomasZloch]

> 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