Increase size of ABAP/Program Buffer? (cannot extend internal table)

[Former Member]

Hi experts

I often run into the following short dump when executing a load in BW which fill a lot data into an internal table in the startroutine:

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.

ABAP/Program Buffer status

When I look at the buffer monitor in RZ20 (-->CCMS monitor sets --> SAP CCMS Monitor Templates --> Buffers) is get the following:

Buffers

xxx_xxx_04

Program

DirectoryUsed 14 % , Green 12.03.2008 , 10:04:37

SpaceUsed 100 % , Red 12.03.2008 , 10:04:37

HitRatio 100 % , Green 12.03.2008 , 10:04:37

Swap 3.6 /min, Green 12.03.2008 , 10:04:37

There is allocate size for the ABAP buffer is 700.000KB, currently are 2.257KB free and we have 3.948 swaps.

Question:

I am therefore wondering if it might help to extend the size of the "ABAP Buffer" (also know as the "Program Buffer")?

Thanks in advance, kind regards,

Torben

[Former Member]

That would be overkill. Try using a SELECT with PACKAGE SIZE.

Rob

[Former Member]

Hi Rob

Thanks for you reply.

What do you mean by SELECT with Package Size (For all entries or?)?

By the way I forgot to tell that over BW system is quite big (75 multiproviders, 266 InfoCubes and of course even much more ODS's). Do you still think that we should not change the buffer size?

Kind regards,

Torben

[Former Member]

A basis solution would affect all programs; using a PACKAGE SIZE affects only the program you are working on, so I would look at that first. PACKAGE SIZE allows you to process a database SELECT in chunks:

SELECT * FROM db_tab
       INTO TABLE lt_tab
       PACKAGE SIZE 50000
* Process these records
endselect.

Press F1 on SELECT for more information. It's an addition to the INTO.

Rob

[Former Member]

Dear Torben Pedersen,

Did you increase program buffer? pls help me!

Contact to me quanglv"et"pythis.com

Skype ID: quanglv124

YM : harypotervn

Pls tell me detail solution!

Thank you very much!

[Former Member]

Hi Quang

We have not changed the parameter yet (because of a unicode project), but I did instead optimize the ABAP code which was working great. We will have to change the parameter though since the problem have re-occured after the unicode (executing ABAP consumes around 25% more of memory after a unicode conversion).

Please let me know if you have further questions.

KR

Torben

[Former Member]

Hi Torben Pedersen,

I having e serious error.

Runtime Errors CALL_FUNCTION_NOT_FOUND

Except. CX_SY_DYN_CALL_ILLEGAL_FUNC

Date and Time 15.05.2008 15:01:02

Short dump has not been completely stored (too big)

Spaceused is 100%. I think buffer too small that we have to increase it.

Please help me how to set parameter ABAP buffer!

Thank you very much!

Regards,

QuangLV

[Former Member]

Hi

For me it does not sound like a buffer problem, it sounds like the function (ex program or FM) called does not exist....

KR

Torben