Wednesday, 10 July 2013

What is spool overflow ( SPAD, RZ20 & SNRO )



Spool request that got generated are stored in a temporary sequential file called Temse.
The default size of Temse is 32,000 and it can be increased till 2 billion. However, defining very high value can effect the database performance. Due to limited storage capacity of Temse, when this file got full, this throws an SAP spool overflow error.

If this happens, customers could not print from SAP. you may encounter some error log or dumps like

  • ERROR IN SPOOL call : SPOOL OVERFLOW
  • SPOOL_INTERNAL_ERROR
  • System internal error in the spool system
How to troubleshoot spool overflow ?

To resolve this spool issue, some of the old spools can be deleted from the sap system. 
Goto transaction SPAD. 
From the initial screen, navigate to Administration -> Clean_up_spool
 Once you click this, Spool Administration : Delete old spool requests screen will be displayed.
In that screen, you will be prompted to choose requests for deletion like

  • Old spool requests older than the maximum set age
  • Requests already printed
  • All spool requests
and enter value for minimum age (in days) text box.




 Once you click this, Spool Administration : Delete old spool requests screen will be displayed.
In that screen, you will be prompted to choose requests for deletion like

  • Old spool requests older than the maximum set age
  • Requests already printed
  • All spool requests
and enter value for minimum age (in days) text box.




Select the check boxes as per the requirement (eg:  delete all requests already printed and minimum age in days equal to 30 days) and execute to delete old spool requests, which will clear Temse and will resolve spool over flow issue.
How to avoid spool overflow issue ?

  • These reports RSPO0041 and RSPO0043 should be scheduled as background jobs with proper variants on a periodic basis which avoids spool overflow issue.

  • You can try to increase the spool numbers from default 32000 to a bit higher value but please note donot set this too high as it may impact database performance

  • Proactive monitoring check can be made in RZ20 transaction to see how much is the fill level of spool numbers.
          How to check spool numbers ?

          To check spool numbers : Goto RZ20 transaction, navigate to SAP CCMS Monitor Templates -> Spool System.







Here you can check the status of spool servers and the used numbers percentage of spool numbers. If you find that used numbers is greater than 80%, you can manually run above mentioned reports or delete old spool requests from SPAD tcode as mentioned earlier.


How to set the spool number in SAP ?

Using Transaction SNRO (Number range object maintenance) and object SPO_NUM, you can set the spool number in an SAP system.










Once you provide object as SPO_NUM, click on change icon. It displays another screen. In that screen, click on Number Ranges push button. It displays another screen "Number range for spooler numbers". Click on change icon here and set the value of spooler(from number and to number). Please note that a change request may be generated here based on the client settings(if automatic recording of changes is set in SCC4 transaction of the client)

No comments:

Post a Comment