topic Re: Tsv_tnew_blocks_no_roll_memory error while running a program in background in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/tsv-tnew-blocks-no-roll-memory-error-while-running-a-program-in-background/m-p/4852745#M1134869 <HTML><HEAD></HEAD><BODY><P>Is there a way to filter more data in T_EKET.</P><P></P><P>2400000 in For all entries is too much for a select query.</P><P></P><P>Regards,</P><P>Mohaiyuddin</P></BODY></HTML> Thu, 20 Nov 2008 12:21:08 GMT Former Member 2008-11-20T12:21:08Z Tsv_tnew_blocks_no_roll_memory error while running a program in background https://community.sap.com/t5/application-development-and-automation-discussions/tsv-tnew-blocks-no-roll-memory-error-while-running-a-program-in-background/m-p/4852744#M1134868 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P> I have a report which if i run in background is giving me dump.I am getting tsv_tnew_blocks_no_roll_memory error.I checked in debugging and am pasting the code</P><P>where it is failing </P><P></P><UL><LI level="1" type="ul"><P> Fetching delivery history</P></LI></UL><P> SELECT ebeln ebelp zekkn vgabe</P><P> gjahr belnr buzei bwart</P><P> budat menge xblnr lfbnr</P><P> FROM ekbe</P><P> INTO TABLE t_ekbe</P><P> FOR ALL ENTRIES IN t_eket</P><P> WHERE ebeln = t_eket-ebeln</P><P> AND ebelp = t_eket-ebelp</P><P> AND bwart IN r_bwart.</P><P></P><P>In the internal table t_eket there are 2400000 records.</P><P>Also there are many other hufe internal tables in the run time in program.</P><P></P><P>I think this error is bacause of memory allocation or lack of it.</P><P>So any solutions are most welcome.</P><P>I have tried using free itab.</P><P>Am verifying it now.</P><P>Please suggest.</P><P></P><P>Thanks in advance,</P><P>Saket.</P></BODY></HTML> Thu, 20 Nov 2008 12:13:29 GMT https://community.sap.com/t5/application-development-and-automation-discussions/tsv-tnew-blocks-no-roll-memory-error-while-running-a-program-in-background/m-p/4852744#M1134868 Former Member 2008-11-20T12:13:29Z Re: Tsv_tnew_blocks_no_roll_memory error while running a program in background https://community.sap.com/t5/application-development-and-automation-discussions/tsv-tnew-blocks-no-roll-memory-error-while-running-a-program-in-background/m-p/4852745#M1134869 <HTML><HEAD></HEAD><BODY><P>Is there a way to filter more data in T_EKET.</P><P></P><P>2400000 in For all entries is too much for a select query.</P><P></P><P>Regards,</P><P>Mohaiyuddin</P></BODY></HTML> Thu, 20 Nov 2008 12:21:08 GMT https://community.sap.com/t5/application-development-and-automation-discussions/tsv-tnew-blocks-no-roll-memory-error-while-running-a-program-in-background/m-p/4852745#M1134869 Former Member 2008-11-20T12:21:08Z Re: Tsv_tnew_blocks_no_roll_memory error while running a program in background https://community.sap.com/t5/application-development-and-automation-discussions/tsv-tnew-blocks-no-roll-memory-error-while-running-a-program-in-background/m-p/4852746#M1134870 <HTML><HEAD></HEAD><BODY><P>Thanks</P></BODY></HTML> Thu, 18 Dec 2008 06:03:43 GMT https://community.sap.com/t5/application-development-and-automation-discussions/tsv-tnew-blocks-no-roll-memory-error-while-running-a-program-in-background/m-p/4852746#M1134870 Former Member 2008-12-18T06:03:43Z