topic Re: Data Limitation in Spool in Application Development and Automation Discussions

Data Limitation in Spool

Former Member — Fri, 06 Jan 2012 11:49:46 GMT

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

Re: Data Limitation in Spool

Former Member — Fri, 06 Jan 2012 12:28:09 GMT

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

Re: Data Limitation in Spool

Former Member — Fri, 06 Jan 2012 12:40:18 GMT

Hi,

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

Re: Data Limitation in Spool

Former Member — Mon, 09 Jan 2012 03:50:44 GMT

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

Re: Data Limitation in Spool

Former Member — Mon, 09 Jan 2012 06:19:43 GMT

Hi ,

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

Regards,

Shardul P Jitkar

Re: Data Limitation in Spool

Former Member — Mon, 09 Jan 2012 16:20:19 GMT

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