Question Re: Spool overflow in Technology Q&A

Spool overflow

Former Member — Wed, 23 May 2007 06:13:53 GMT

Hello,

I am getting the below Spool error

************************************************

Internal error in the spool system.

What happened?

The current ABAP program had to be terminated because the

ABAP processor detected an internal system error.

The current ABAP program "ZBDC_MAT_MASTER_HR" had to be terminated because the

ABAP

processor discovered an invalid system state.

What can you do?

Make a note of the actions and input which caused the error.

To resolve the problem, contact your SAP system administrator.

You can use transaction ST22 (ABAP Dump Analysis) to view and administer

termination messages, especially those beyond their normal deletion

date.

Error analysis

When calling the SAP spool system, an (unspecified) internal

error occurred.

More detailed description of error: "spool overflow "

Further information:

See below under "Spool error information".

How to correct the error

Probably the only way to eliminate the error is to correct the program.

You may able to find an interim solution to the problem

in the SAP note system. If you have access to the note system yourself,

use the following search criteria:

"SPOOL_INTERNAL_ERROR" C

"ZBDC_MAT_MASTER_HR" or "ZBDC_MAT_MASTER_HR"

"MESSAGES_DISPLAY"

Can you help me in finding out the solution

Appreciate your help.

Re: Spool overflow

Former Member — Wed, 23 May 2007 06:17:05 GMT

Hi:

Please check the OSS Note 16534 - Job terminates due to SPOOL_INTERNAL_ERROR.

Regards,

Bharath.

Re: Spool overflow

Former Member — Wed, 23 May 2007 06:18:50 GMT

Hi,

First, check if the table TSP01 is over than 32000 rows, if it is afirmative, your spool reach the limit.

You must schedulle the program RSPO0041 (or the new version with more parameters RSPO1041) like a background job (periodic).

and create a variant with the parameters. For example, leave last 10 days.

Please, see the followings notes too:

Note 48284 - Creating more than 32000 spool requests

Note 130978 - RSPO1041 - Replacement for RSPO0041

--Sreejesh

Re: Spool overflow

Former Member — Wed, 23 May 2007 07:51:38 GMT

Dear Sreejesh ,

Thanks for your mail.

i)I have checked the table TSP01 and found there are 31901 entries which is less than 32000 records.

ii)I have scheduled the job to run periodically and ran it manually too but no output requests were found in the queue.

Please guide me hoe to proceed further to avoid this error

Re: Spool overflow

Former Member — Wed, 23 May 2007 09:01:02 GMT

Hello Vadivambal,

Please do a TEMSE check using SM12 transaction or the report RSPO1043.

If there are any errors correct them.

Also delete the spools. 31901 is too close to threshold.

Also it might very well be that the bulk of the spools would have got generated very recently- last couple of days. The variant in your spool deletion job will be such that it is not picking such recent requests.

Go to SP01 and check how many spools have got generated in last 3-4 days. You will get an idea.

Regards.

Ruchit.

Re: Spool overflow

Former Member — Wed, 23 May 2007 12:22:49 GMT

Dear Ruchit,

I did the following

1) I did consistency check in SP12 and it got timed out since it was running more then 10 minutes in foreground.

I dont findd any option of running the same in background.

2) I ran the report RSPO1043 and changed the parameter for deletiing the requets older than 1 day also

3) In Sp01, have checked for starting from 16 of may and found that there are 102 requets.

plaese let me know how to go about it

Re: Spool overflow

Former Member — Wed, 23 May 2007 13:28:43 GMT

Hello Vadivambal,

In SP01 find how many spools are there in your system.

Keep the user,date and time fields blank and execute. Gimme the number.

Regards.

Ruchit.

Re: Spool overflow

Former Member — Thu, 24 May 2007 04:58:42 GMT

Dear Ruchit,

In spo1, i have got 28,394 entries by keeping time and date and user fileds as empty.

Can i have ur personnel email id ?

Re: Spool overflow

Former Member — Thu, 24 May 2007 07:11:02 GMT

Dear Vadivambal,

As per the forum policy e-mail address must not be published and I would like to stick by that policy. I am sorry for that.

I suppose there is some thing you want to inform through spool. I guess some screenshot of the SP01 transaction.

Anyways the information I need I have got it. 28,394 is pretty huge number considering the fact that your are running the spool deletion job.

I faced a similar error long time back and this is what I did.

1. From SP01 I got the list of all spool requests that were present in the system.

2. Next I identified the dates on which they were really created.

3. I deleted the oldest spools through SP01 transaction itself. The reason being if I run the spool deletion job it will also try to create a spool request which since in this case maay not be possible; will also get cancelled. Of course you may retain the spool requests that are business critical though very old spools are not really needed.

4. Next I executed the report RSPO1041. In that selection criterion is critical.

Select all check boxes

Without output request

In processing

Completed

Incorrect

and give time period as older than the number of days based on your analysis.

Also under category and/or select or radio buttons. Also select all check boxes under obsolete. and requests with output devices that no longer exist-

Select radio button option Every day and keep the field Factory calender id blank.

I ran the report in Log with deleting mode in order to confirm what was it deleting in the first place. The output of this test run will be the spool number that will be deleted if this report is run in actual mode.

After I was satisfied with the output I actually deleted the spool requests.

This is a bit iterative but will solve your issue.

Regards.

Ruchit.

Re: Spool overflow

Former Member — Thu, 24 May 2007 08:15:43 GMT

Dear Ruchit,

That's ok.

Thanks a lot. It works.

Can you help me on one more thing.

I would like to know how to enable secure communication between SAP GUI for windows and SAP servers.Already i have posted messaage for the same in Forum.

Re: Spool overflow

Former Member — Thu, 24 May 2007 09:08:16 GMT

Hello Vadivambal,

it is great that it works. Please dont forget to assign points if my answer was helpful

For SNC communication I am checking. I remember to have checked a good OSS note or document for this.

Regards.

Ruchit..

Re: Spool overflow

Former Member — Thu, 24 May 2007 09:12:35 GMT

Hello Vadivambal,

Please check this link:

http://www.sap.com/partners/icc/scenarios/pdf/bc_snc_40_userguide2.pdf

Regards.

Ruchit.

Re: Spool overflow

Former Member — Wed, 01 May 2013 14:15:47 GMT

This message was moderated.