Data Limitation in Spool

[Former Member]

Hello,

I am trying to run a program in background, due to which large amount of data gets printed as a spool request in SP01. We are unaware about the amount of data in production, so just want to understand if there is a spool limitaion in storing the data. Is this limitation based on

If complete data is not stored in the spool request, is it possible to extract complete data out of spool?

Thanks & Regards

Rohit

[Former Member]

how many pages are you expecting? till the memory runs out of space you can store data in spool

[Former Member]

Hi,

I think there is no limit is spool but while downloading limitation may be there.

[Former Member]

Hello,

Thanks for your response. How can we make sure that user is able to download complete data in spool request? We are using SAP 4.6C and i understand, if we try to export data from SP01, it may give dump. But is there any limitation if we use Function Modules such as 'CONVERT_ABAPSPOOLJOB_2_PDF' or 'CONVERT_OTFSPOOLJOB_2_PDF' or any other similar Function Modules.

Thanks & Regards,

Rohit

[Former Member]

Hi ,

I had once used FM 'CONVERT_ABAPSPOOLJOB_2_PDF' , it has a limitation of 99 pages.

Regards,

Shardul P Jitkar

[Former Member]

Hi Rohit,

Not sure if this would help, but had I been you, I would rather generate the output in a file format in the Application Server and not in a Spool. The problem with huge spool is massive at times. If the Spool memory overflows in the system, it can cause an outage situation in the Production Server where all Background Jobs would start failing until Basis Team clears the spool memory.

Also, Spool has limited lifetime in any system as housekeeping jobs clear old spools from the system, wheer as a flat file has longer existence and can also be backed up if need be.

Large Spool with not so efficient system monitoring can be a serious problem at times.

Regards,

Subhrangsu