TSV_TNEW_PAGE_ALLOC_FAILED

[Former Member]

Hi,

When i am executing my query i am getting the below dump:

Runtime Errors         TSV_TNEW_PAGE_ALLOC_FAILED                                                  
Date and Time          11.12.2013 06:27:09                                                         
                                                                                                   

 

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.

What can you do?

Note which actions and input led to the error.

For further help in handling the problem, contact your SAP administrator

.

You can use the ABAP dump analysis transaction ST22 to view and manage

termination messages, in particular for long term reference.

Try to find out (e.g. by targetted data selection) whether the

transaction will run with less main memory.

If there is a temporary bottleneck, execute the transaction again.

If the error persists, ask your system administrator to check the

following profile parameters:

o  ztta/roll_area            (1.000.000 - 15.000.000)

Classic roll area per user and internal mode

usual amount of roll area per user and internal mode

o  ztta/roll_extension       (10.000.000 - 500.000.000)

Amount of memory per user in extended memory (EM)

o  abap/heap_area_total      (100.000.000 - 1.500.000.000)

Amount of memory (malloc) for all users of an application

server. If several background processes are running on

one server, temporary bottlenecks may occur.

Of course, the amount of memory (in bytes) must also be

available on the machine (main memory or file system swap).

Caution:

The operating system must be set up so that there is also

enough memory for each process. Usually, the maximum address

space is too small.

Ask your hardware manufacturer or your competence center

about this.

In this case, consult your hardware vendor

abap/heap_area_dia:        (10.000.000 - 1.000.000.000)

Restriction of memory allocated to the heap with malloc

for each dialog process.

Parameters for background processes:

abap/heap_area_nondia:        (10.000.000 - 1.000.000.000)

Restriction of memory allocated to the heap with malloc

for each background process.

Other memory-relevant parameters are:

em/initial_size_MB:         (35-1200)

Extended memory area from which all users of an

application server can satisfy their memory requirement.

But when i am removing one of the characteristics, it is executing fine. but with one characteristics it is creating problem. Please help.

Thanks,

Shefali

[RamanKorrapati · Accepted solution]

Hi Shefali.

Its memory issue. the character which you removed may have more combinations of data.

Better to execute your query with limited selections and check it. it will work.

or with help of basis team, try to run your bex query on separate app servers.

Ask basis team to increase the memory if possible.

Thanks

[Former Member · Accepted solution]

Thanks Raman for Quick response.

[Former Member · Accepted solution]

Hi Shefali,

you can also check query performance by rsrt and try to improve performance. Check if any object has exceptinal agreegation try to avoid it.