Skip to Content
0
Oct 22, 2007 at 12:40 PM

TSV_TNEW_PAGE_ALLOC_FAILED

128 Views

Hi All,

Currently i am working in Mobile Infrastructure and i have one memory issue,where the customer is trying to run the report MEREP_PURGE in the backround job and getting failed with the runtime error "TSV_TNEW_PAGE_ALLOC_FAILED ".

When i checked the dump i found out that the runtime error occurs while executing the select statement and found out that the select statement consumes more than 1.5 GB .The table contains more than 6 lacs records.

Interesting part is that he is trying to purge the data for one day which is containing this much of data.

Here is the select statement query.

*  Delete table 504 Outbox Data
* outbox data can be huge. So do in steps
    DO.
      select mandt direction mbl_id seqno rcd_cntr
        into table ldt_504
        up to gcf_packagesize rows
      from
           merep_504
      FOR ALL ENTRIES IN ldt_505
        where mbl_id    = ldt_505-mbl_id and
              seqno     = ldt_505-seqno and
              direction = ldt_505-direction.

FYI,

gcf_packagesize rows = 10000.

Can anyone tell me wheather is it possible to optimize the query or any memory parameters needs to be changed to handle this runtime error.

Thanks and Regards,

Rajan