topic Re: Trsv_page_allocation_failed error: need solution programatically in Application Development and Automation Discussions

Trsv_page_allocation_failed error: need solution programatically

Former Member — Mon, 25 Jul 2011 13:29:02 GMT

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,

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

Re: Trsv_page_allocation_failed error: need solution programatically

Former Member — Mon, 25 Jul 2011 13:33:51 GMT

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

So post your code.

Re: Trsv_page_allocation_failed error: need solution programatically

Former Member — Mon, 25 Jul 2011 17:58:38 GMT

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.

Re: Trsv_page_allocation_failed error: need solution programatically

yuri_ziryukin — Tue, 26 Jul 2011 12:17:00 GMT

Dear Jowar,

please read this post:

Kind regards,

Yuri

Re: Trsv_page_allocation_failed error: need solution programatically

Former Member — Fri, 29 Jul 2011 16:02:39 GMT

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.

Re: Trsv_page_allocation_failed error: need solution programatically

lcpaiva — Tue, 02 Aug 2011 18:17:43 GMT

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.