Trsv_page_allocation_failed error: need solution programatically

[Former Member]

Hi experts,

We are reading MARC table with 42 million data.we are reading the table for 10000 times .It is giving error like TRSV PAGE ALLOCATION FAILED . The error is coming from SAP internal tables ( not for the tables declared in program). As per basis team, we can not increase the memory.

How to deal with the situation programmatically?

how can i refresh the buffer or memory?

Thanks,

Jo

Edited by: jowar saha on Jul 25, 2011 3:32 PM

[Former Member]

the cause for the problem is obviously your program, I guess you read to much data.

So post your code.

[Former Member]

I think you are running out of allocated roll area and extended memory considering the number of records you are trying to read. Read the data in chunks , process them , refresh the internal tables and then read the next chunk.

Also check if you really want to read so many entries from database or if you can restrict the count in your select query . Few things to consider here : see if you have to create a secondary index here to better database selection performance at the cost of database growth , but will reduce the network load.

[yuri_ziryukin]

Dear Jowar,

please read this post:

Kind regards,

Yuri

[Former Member]

Hi,

May i know how actually you are fetching the data from MARC table?

Are there any where clause used like for plant or something like that? if not try to add a where clause in it.

Can you post your code here? for better undertanding..

Thanks,

Venkatesh.

[lcpaiva]

You can try to use option PACKAGE on SELECT to treat data in blocks from MARC, instead to populate entire table. It also can be done using CURSOR.