Memory Allocation Failure Dump.

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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