Memory Overflow Problem

[Former Member]

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

[franois_henrotte]

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 ???

[andreas_mann3]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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 ...

[Former Member]

Hallo Mike,

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

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

Bye Bye

[Former Member]

Hi,

In 4.6 C The Function Module RSPO_RETURN_ABAP_SPOOLJOB

is avaliable. But not in 3.0 F

Beserithan Malabakan

[Former Member]

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

[Former Member]

Hallo Sravan,

pls send me Coding to malabakan@web.de

Thanks!

Bye Bye

[franois_henrotte]

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