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

The amount of memory requested is no longer available for Internal table

Hi Guys,

Can someone help me on this error after tuning some Select statements to increase the performance of FI report?

Error:

No roll storage space of length 262080 available for internal storage.

-


What happened?

-


Each transaction requires some main memory space to process

application data. If the operating system cannot provide any more

space, the transaction is terminated.

-


Error analysis

-


The internal table "I_BSIS" could not be enlarged further.

You attempted to create a block table of length 262080 for the internal

table "I_BSIS". This happens whenever the OCCURS area of the internal table

is exceeded. The requested storage space was not available in the roll

area.

The amount of memory requested is no longer available.

Occurs value used is : 100000 & 1000.

Appreciate your response~

Thanks,

Hari.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 10:57 AM

    contect ur basis person he will solve ur problem(increase memory size)

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 10, 2007 at 11:03 AM

    1. You need to check on the select statement which is writing into the internal table. Since lot number of records are getting selected and written this is leading to this situation. To avoid you can split and send in packages.

    2. The rollback segment can be increased so some more space is got for writing into the internal table.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 11, 2007 at 07:07 AM

    you can use

    OPEN CURSOR WITH HOLD db_cursor FOR

    select * from BSIS...

    .....

    ....

    DO.

    FETCH NEXT CURSOR db_cursor

    INTO CORRESPONDING FIELDS OF TABLE buf_bsis

    PACKAGE SIZE g_package_size.

    .... (do processing here)

    ....

    ENDDO.

    this would help in overcoming the short dump.

    set the package size to 500.

    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.