No storage space available for extending an internal table.

[Former Member]

Hi!

I have a job that terminate with this error: 'TSV_TNEW_PAGE_ALLOC_FAILED'

No storage space available for extending an internal table.

I talk with one basis and he tell me that I can increase the memory values to resolve the problem, but I don't know if its correct that. Because I see the code of the program and I see select all and other things that may be cab cause the error. May be if I repair the code I can fix the dump error.

What do you think?

This is the code that I see and the internal table that causes this error are: TBUFF.

Thanks!

     SELECT * FROM PCL2                                  "QICK11K094643
             WHERE RELID EQ BUFFER_DIR-RELID
             AND SRTFD EQ BUFFER_DIR-SRTFD
*            AND SRTF2 EQ AUX_SRTF2.                 (del) QICK11K094643
             ORDER BY PRIMARY KEY.                        "QICK11K094643
        TBUFF = PCL2.
        TBUFF-SGART = SAVE-SGART.
        APPEND TBUFF.                                     "QICK11K094643
        IF TBUFF-SRTF2 EQ 0.                              "QICK11K094643
          TBUFF-TABIX = SY-TABIX.                         "QICK11K094643
        ENDIF. "TBUFF-SRTF2 EQ 0.                         "QICK11K094643
      ENDSELECT. "* FROM PCL2                             "QICK11K094643

[Former Member]

Try using PACKAGE SIZE on your select. You can press F1 on SELECT to see how to use this.

Rob

[Former Member]

If I choose to increase the memory variables the system can be inconsistence?

[Former Member]

I would let the basis people determine the system variables and concentrate on getting the program to use less resources.

Rob

[Former Member]

Hi GURUS,

I am facing no storage space available for extending to internal table....

Generally when we get the problem,,,and how to resolve it,,,,,but in my case when i am writing data into unix file in background it is occuring this dump....so pls could any body help me in this..........and how to debug the background job.

DATA : BEGIN OF gt_gl_header OCCURS 2000,

ap_header(5000),

END OF gt_gl_header.

DATA : BEGIN OF gt_gl_item OCCURS 2000,

ap_header(5000),

END OF gt_gl_item.

above are my internal tables where i am putting final data and writhing to output file from this header to header and item to item file.......i dont think, is it right way to define final internal tables,,,,,,,it has 156000 records or 300 thousends or data .

eagerly waiting for solution from you .

Krisna