topic Re: Memory Overflow Problem in Application Development and Automation Discussions

Memory Overflow Problem

Former Member — Fri, 19 May 2006 08:51:53 GMT

Hi,

I have created a Spool List with 70.000 Pages for General

Ledger in 3.0 F Old SAP System. The Spool List can be seen

in SP01. In Spool settings I give 70.000 Pages and System

makes a Dump with TSV_TNEW_PAGE_ALLOC_FAILED.

I try also to print directly. Also not possible. it makes

also Dump. I know, that is not possible in 3.0F to give

a Page Range from as Example Page 1 to 1000 in the

Settings.You can give only the End Page in the Old System.

Thanks for your Replies in Advance.

Bye

Beserithan Malabakan

Re: Memory Overflow Problem

franois_henrotte — Fri, 19 May 2006 12:34:10 GMT

You should try to print it in smaller parts

anyway I don't see clearly how helpful such a huge spool can be... do you really intend to print it ???

Re: Memory Overflow Problem

andreas_mann3 — Fri, 19 May 2006 12:46:29 GMT

Hi,

please transfer your data in a flat file

<i>70000 pages or 4.2 mio. items in a spool

...

(:- my admins would <b>not</b> love me</i>

Grace &

have a nice weekend

Andreas

Re: Memory Overflow Problem

Former Member — Fri, 19 May 2006 14:11:13 GMT

Yes I know they are many Pages. But Finance Government wants to see the Ledger in Paperform. there is no other way. I cant also print in smaller Parts in Old system 3.0F

.I need any other Suggestions urgently.

Thanks!

Bye

Re: Memory Overflow Problem

Former Member — Fri, 19 May 2006 14:23:13 GMT

Can you execute the program in ranges[by restricting the selection paramters/select options] and create multipal spool requests and then print one by one.

Regards

Aman

Re: Memory Overflow Problem

Former Member — Fri, 19 May 2006 15:36:27 GMT

Hello.

Have a look an FM RSPO_RETURN_ABAP_SPOOLJOB. This enables you to retrieve a given range of lines into an internal table. I would suggest downloading each portion generated with this FM to the application server using the ABAP statements OPEN DATASET and TRANSFER ...

Re: Memory Overflow Problem

Former Member — Sun, 21 May 2006 06:34:01 GMT

Hallo Mike,

This can solve the Problem. I will try it on Monday.

Thanks for the helpfull Answer. have a nice Weekend!!!

Bye Bye

Re: Memory Overflow Problem

Former Member — Mon, 22 May 2006 10:20:01 GMT

Hi,

In 4.6 C The Function Module RSPO_RETURN_ABAP_SPOOLJOB

is avaliable. But not in 3.0 F

Beserithan Malabakan

Re: Memory Overflow Problem

Former Member — Mon, 22 May 2006 11:03:53 GMT

Hello,

I too have faced a similar issue (in 3.1i) where the records that were required to be written to Spool was 7 Billion records.

The First point was handled by using the PACKAGE SIZE in the SELECT STATEMENT (around 100000 records were selected for every loop).

The Second point was handled by using the GET_PRINT_PARAMETERS to generate the Multiple spools. So, multiple spools will be created each with 100000 records init. In this was i avoided the SPOOL I/O error.

If the above relates to your issue let me know and i can send you the Code.

Regards,

- Sravan

Re: Memory Overflow Problem

Former Member — Mon, 22 May 2006 17:04:23 GMT

Hallo Sravan,

pls send me Coding to malabakan@web.de

Thanks!

Bye Bye

Re: Memory Overflow Problem

franois_henrotte — Wed, 24 May 2006 12:25:16 GMT

In current release, you can output contents of a spool to a file. Check if you can already do it in 3.0F

Go to SP01, check the checkbox in front of your spool

Then go to menu: Spool request / Forward / output as text