Search this blog for other interesting articles

Tuesday 14 June 2011

what is spool overflow ? How to troubleshoot spool overflow issue ?

This article answers the following queries :

  • What is spool overflow ?
  • How to troubleshoot spool overflow ?
  • How to delete old spool requests ?
  • How to avoid spool overflow issue ?
  • How to check spool numbers?
  • How to set the spool number in SAP ?
  • How to define storage location (Temse) of spool requests ?


----------------------------------------------------------------------------------------

What is spool overflow ? :

Spool request that got generated are stored in a temporary sequential file called Temse. Please note that these are stored in Temse because these are not stored permanently. The size of the Temse is limited by the parameter definition.
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. If you check in SM21 and ST22 transactions, 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.








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.

Apart from this there are others ways of resolving spool overflow issue. They are

1) Run the report RSPO0041 from SE38 transaction to delete old spool requests








2) Run the report RSPO0043 from SE38 transaction, which checks the Temse/spool consistency and reorganizes the spool







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)

How to define storage location (Temse) of spool requests ?

Every Temse object contains a header in TST01 table and the actual object. This can be either stored in table TST03 or in file system. You can set a parameter rspo/store_location in RZ10 to define whether to store Temse objects  TST03 table or in filesystem.

If value G is set to this parameter, it will be stored in filesystem and if it is db it is stored in TST03 table.








63 comments:

Anonymous said...

Hello Durga Prasad,

I am visiting this blog for the first time and I must say its mind blowing. Thanks for sharing the articles.


Hope you contribute more for OUR growth.

DurgaPrasad said...

Hi friend..thanks a lot for your sweet comments :-)

sandeep said...

hi
durgaprasad
your explanation is osam..thaxs lot..

DurgaPrasad said...

Thanks Sandeep for your nice comment

Anonymous said...

Really Goood coverage. Thanks for sharing..

Anonymous said...

really very good..
really awesome experience
TNX DurgaPrasad

Shakeel said...

HI DurgaPrasad,
your collection in basis is anonymous.
Request you to please upload netweaver and new dimention product doc related to basis

Saumya Sap Basis said...

Good article .

raj said...

HI Durga Prasad,

Its awesome.

DurgaPrasad said...

Thanks a lot Raj

Gangadhar said...

Hi, Durga this is really great

Gangadhar said...

Hi, Durga this is really great

Kumar said...

Thanks a lot Durga..

Anonymous said...

Hi durpgaprasad
if you have any document regarding how we can disable sap reference img

Anonymous said...

It is very benefit for me.Thanks a lot Durgaprasad.

Anonymous said...

HI Durga,

Thanks for your document on the spool issues as we are aware many poeple are not that much experts in Spool and sure it hepls a lot to any one.

DurgaPrasad said...

Thanks frnd for your nice comments

Anonymous said...

Thanks for your document with screenshots

Regards
Venkat

Anonymous said...

Thanks for the info, to add a follow on question, I have old temse files that i can't seem to delete. i have run the spool deletes based on the days, I have run the HR temse delete too,but I still see temse objects from 2 years ago. Is there a way to find and delete them. I have tried basically all the RSPO___ programs with no luck.

Archana Vijay said...

It was mind blowing and i got a idea on how to start troubleshooting with spool..Thanks for the document.

Archana Vijay said...

Thanks for the very good document.It was very clear in understanding.

Regards,
Archana Vijay

Anonymous said...

Nice article

but would like to add that for clearing of spool requests,
we have now newer report called RSPO1041 instead of RSPO0041.

frum

Shiva said...

Hi DurgaPrasad,
Excellent Job.

Thank you

JITENDRA KUMAR RAJ said...

Please share step by step Implementation of ECC6.0 n post configuration.

manishd_2000 said...

Hi DurgaPrased,

Regarding the above post, can you please tell me how to change the size of the number of jobs from 32000 to something greater as you have mentioned up.

Thanks.

M

DurgaPrasad said...

Hi Manishd,

Please refer below section in the blog above.

How to set the spool number in SAP ?

In this section, i have explained how to change parameter using SNRO transaction code

Anonymous said...

i mailed u a question please let me know the answer durga garu,,, regarding ewa in 7.1. please reply me

Anonymous said...

Thank you Durga for very informative blog. Could you please explain how to setup printer server in sap system.
Thanks again
Syed

Anonymous said...

Ultimate Mindblowing.

:)

Anonymous said...

Good very good blog

prasad said...

Hi Durga prasad,

This blog is very very helpful for me and can you please post the system specific monitoring and troubleshooting issues like(SCM,SRM,BI/BW,PI/XI,CRM,Portal)

suppose i will take BI/BW system
In BW system specific reports run in btc mode ,status will check in sm37 but which stage the report is failed?
we can go for a Tr---RSPC

Anonymous said...

first time i visited this blog i had an interview by seeing this blog makes me comfortable really awesome...thanx Durgaprasad

Beegle boy said...

Excellent document..!

DurgaPrasad said...

Am touched with this comment..Am happy that my blog is helping people like you..This type of feedback motivates me to spend more time on blog from my busy schedule !

DurgaPrasad said...

Thanks Beegle boy

DurgaPrasad said...

Certainly ...will post more prasad

DurgaPrasad said...

Thanks..will do in a separate article

DurgaPrasad said...

Hi Jitendra, yes will do in a separate article

DurgaPrasad said...

Thanks Shiva

DurgaPrasad said...

Yes..Thanks for sharing this

DurgaPrasad said...

Welcome Archana

DurgaPrasad said...

Hi frnd, While running RSPO**** programs, please make sure, you provide "Minimum age in days" value accurately as per your requirement and run.

varun said...

it's excellent

DurgaPrasad said...

Thanks Varun

Anonymous said...

thanks sir its tremendous

Unknown said...

hello sir ....i must say your blog is very useful for job seekers,i was not as good in sap for some time back..but thanks to u to made me as good as others..god bless u..thks again for such a wonderful blog.

vijay said...

TEMSE size is in mb's or kb's?

Anonymous said...

Very useful !

Manju said...

Hi Guru Prasada

Can you please roll in and roll out and also wait time and response time :ST03n t-code..workload analysis

Manju said...

Hi Durga Prasad,

Can you please tell me about ST03n workload analysis

Regarding:Roll in ,Roll out ,wait time ,response time

venkat said...

Hi Durga Prasad,

Can you Please tell us the Interview questions for above 3+ Years of experience.

Thanks in Advance.

Unknown said...

awesome explanation by durgaprasad

Unknown said...

Really helpfull..thank you very much :)

Anonymous said...

excellent. good work


-krishna

Rakesh.M said...

Hi Durga,

It's really WIKIPEDIA blog for SAP Basis freshers and even experience people. All most all topics are covered and explanation is superb.

DurgaPrasad said...

Thanks much Rakesh

Unknown said...

Dear Durga,

seriously i loved it. thank you for sharing a wonderful blog.

Kiran...

praveen said...

Hi Durga prasad,

This blog is very very helpful for me and i learned sap basis course now i want to attend interviews which type of questions they will ask as experienced.

Anonymous said...

very good post.

Anonymous said...

I have been harassed by spool full lately, and this has become my answer. Thanks a lot for this knowlegde

Anonymous said...

what is the difference between RSPO0041&RSPO1041

sapMAN said...

Wonderful Article Mr. Prasad. The lucid way of writing makes us understand with such ease. Thanks!!

Unknown said...

Hi sir..
Your blogs are easy to learn...

Search this blog for other interesting articles

Please subscribe & activate link received to your email id to receive latest articles

Enter your email address:

Delivered by FeedBurner