topic Re: Memory Allocation Failure Dump. in Application Development and Automation Discussions

Memory Allocation Failure Dump.

Former Member — Thu, 20 Mar 2008 11:21:49 GMT

Hi Everybody,

I have a issue with my program. This is a report program where i added a select query as follows.

SELECT vbeln

posnr

erdat

matnr

werks

lfimg

FROM lips

INTO TABLE i_lips

FOR ALL ENTRIES IN i_mara

WHERE matnr = i_mara-matnr

AND bwart = c_653.

After the additon of this select querry i am getting a dump. The dump generally has the following defination

TSV_TNEW_PAGE_ALLOC_FAILED or TSV_TNEW_BLOCKS_NO_ROLL_MEMORY.

To avoid this i am freeing the internal table after fetching the data and doing my calculations. The dump occurs at a later part of the code. Even though freeing these internal table doesn't help me in any way.

Please advise. This is urgent.

Re: Memory Allocation Failure Dump.

Former Member — Thu, 20 Mar 2008 11:47:14 GMT

hi Amit,

Try using all the key fields of lips table in the where condition of your select statement to make the select faster..... else use any of the secondary indexes of lips table. Also make sure that the order of where conditon fields matches with the order of the fields in lips table.

Regards,

Santosh

Re: Memory Allocation Failure Dump.

Former Member — Thu, 20 Mar 2008 12:15:06 GMT

Hi Amit,

I don;t think your code has triggered the dump. LIPS is not a big table either. So please make sure you server/system is in good performance and try to restart the server and then test again.

Thanks,

Anil

Re: Memory Allocation Failure Dump.

Former Member — Thu, 20 Mar 2008 12:26:32 GMT

First put an initial check on the i_mara{} table.

Also you can sort i_mara and delete the duplicate material no

Check how manu records LIPS table have...then yiu might have to specify the package size in select statement.

Re: Memory Allocation Failure Dump.

Former Member — Thu, 05 Mar 2009 15:56:05 GMT

I found the issue. It was not associated with the select.