cancel
Showing results for 
Search instead for 
Did you mean: 

DB error 1562 at DEL access to table TSPEVJOB

Former Member
0 Kudos

I have checked consitencys check using sp12 , and deleted some incosistency

Temse object according sapnote , even thought the job is failing daily.

Kindly suggest

ABAP runtime errors SPOOL_I/O_ERROR

Occurred on 25.01.2007 at 07:44:08

-

-


I/O error in the spool system.

-

-


What happened?

-

-


The current ABAP/4 program had to be terminated due to an error

in the SAP spool system when processing.

-

-


What can you do?

-

-


Please contact the group responsible for your SAP System.

-

Please make a note of the actions and input which caused the error.

-

To resolve the problem, contact your

SAP system administrator.

Select the "Print" function to obtain a hardcopy of the

current termination message.

-

-


Error analysis

-

-


An I/O error occurred when calling the SAP spool system. This may be

due to an overflow in the spool database.

-

More detailed description of error: "dbrtab errorin rspoi01__insert_table_TSP01

"

Further information:

See below under "Spool error information".

-

-


How to correct the error

-

-


If the spool database has overflowed, you must perform a

reorganization.

You may able to find an interim solution to the problem in the

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

please use the following search criteria:

-

-


"SPOOL_I/O_ERROR"

"RSPO0041 " or "RSPO0041 "

"NEW_PAGE"

-

-


If you cannot solve the problem yourself, please send the

following documents to SAP:

1. A hard copy print describing the problem.

To obtain this, select the "Print" function on the current screen.

-

2. A suitable hardcopy prinout of the system log.

To obtain this, call the system log with Transaction SM21

and select the "Print" function to print out the relevant

part.

3. If the programs are your own programs or modified SAP programs,

supply the source code.

To do this, you can either use the "PRINT" command in the editor or

print the programs using the report RSINCL00.

4. Details regarding the conditions under which the error occurred

or which actions and input led to the error.

-

-


System environment

-

-


SAP Release.............. "40B"

Application server....... "apus67"

Network address.......... "172.24.2.79"

Operating system......... "HP-UX"

Release.................. "B.11.11"

Hardware type............ "9000/879"

Database server.......... "apus67"

Database type............ "ORACLE"

Database name............ "IP2"

Database owner........... "SAPR3"

Character set............ "en_US.iso88591"

SAP kernel............... "40B"

Created on............... "Nov 21 2005 00:21:23"

Created in............... "HP-UX B.11.00 A 9000/800"

Database version......... "ora OCI_920_64"

Patch level.............. "1050"

Patch text............... " "

Supported environment....

Database................. "ORACLE 8.0..., ORACLE 8.1..., ORACLE

9.2...*"

SAP database version..... "40B"

Operating system......... "HP-UX B.11, HP-UX B.10"

-

-


User, transaction...

-

-


Client.............. 000

User................ "SAP*"

Language key........ "E"

Transaction......... " "

Program............. "RSPO0041 "

Screen.............. "SAPMSSY0 1000"

Screen line......... 6

-

-


Information on where termination occurred

-

-


The termination occurred in the ABAP/4 program "RSPO0041 " in

"NEW_PAGE".

The main program was "RSPO0041 ".

The termination occurred in line 412

of the source code of program "RSPO0041 " (when calling the editor 4120).

The program "RSPO0041 " was started as a background job.

-

-


Source code extract

-

-


003820 *END of TOP-OF-PAGE.

003830

003840 FORM WRITE_MSG USING A_PROB A_MSG.

003850

003860 IF ERR_PROT = ' ' AND ALL_PROT = ' ' AND LISTONLY = ' '.

003870 " Use MESSAGE W when neccessary.

003880 ELSEIF A_PROB = 3. " COL_TOTAL INTENSIFIED OFF

003890 SUMMARY.

003900 WRITE: / A_MSG.

003910 DETAIL.

003920 ELSEIF A_PROB = 12. " COL_NORMAL INTENSIFIED

003930 SUMMARY.

003940 WRITE: / A_MSG.

003950 DETAIL.

003960 ELSEIF A_PROB = 2. " COL_NORMAL INTENSIFIED OFF

003970 WRITE: / A_MSG.

003980 ELSE.

003990 WRITE: / A_MSG.

004000 ENDIF.

004010 PAGE_STARTED = 'X'.

004020

004030 ENDFORM.

004040

004050

004060 FORM NEW_PAGE USING A_PAGE_KIND.

004070

004080 PAGE_KIND = A_PAGE_KIND.

004090 IF ERR_PROT = ' ' AND ALL_PROT = ' ' AND LISTONLY = ' '.

004100 " Use MESSAGE W when neccessary.

004110 ELSEIF PAGE_STARTED = 'X'.

-

-


NEW-PAGE.

004130 PAGE_STARTED = ' '.

004140 ELSE.

004150 " Nothing.

004160 ENDIF.

004170

004180 ENDFORM.

004190

004200

004210 START-OF-SELECTION.

004220

004230 * Dummies to predefine text variables.

004240 MSG = 'Kriterien zur Auswahl der zu löschenden Spool-Aufträge'(100).

004250 MSG = 'Verfallsdatum'(101).

004260 MSG = 'Suche über Mindestalter'(102).

004270 MSG = 'Warnungen als Popups oder Protokoll-Listen'(103).

004280

004290 * Correct incomplete parameters.

004300 *

004310 IF CLIENT = SPACE. CLIENT = '*'. ENDIF.

-

-


Contents of system fields

-

-


SY field contents..................... SY field contents.....................

-

-


-

-


-

-


-

-


SY-SUBRC 0 SY-INDEX 0

SY-TABIX 19 SY-DBCNT 25

SY-FDPOS 40 SY-LSIND 0

SY-PAGNO 1 SY-LINNO 26

SY-COLNO 1

-

-


Chosen variables

-

-


Name.......................... Contents.1........2........3....+....4

-

-


-

-


PAGE_KIND P

5

0

A_PAGE_KIND P

5

0

ERR_PROT X

5

8

ALL_PROT

2

0

LISTONLY

2

0

PAGE_STARTED X

5

8

MSG **** 0000010200 can not be deleted ( 8

2222233333333332226662667266266667662223

AAAA0000001020000031E0EF4025045C54540808

... + 40 /dbrtab error in rspos01__select_from_TS

2667766267767266277767335576666756766555

F4224120522F209E0230F301FF35C534F62FDF43

... + 80 P01

53322222222222222222

00100000000000000000

TEXT-100 Criteria for selecting spool requests fo

4767676626672766667666277666276776777266

3294529106F2035C5349E7030FFC02515534306F

... + 40 r deletion

7266667666

2045C549FE

TEXT-101 Expiration date

477676766626676

58092149FE04145

TEXT-102 Search from minimum age

56676626766266666762666

351238062FD0D9E9D5D0175

-

-


Active calls / events

-

-


Nr.... Type........ Name..........................

Programm

Include Line

-

-


1 FORM NEW_PAGE

RSPO0041

RSPO0041 412

2 EVENT START-OF-SELECTION

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

this stuff is rollback segment related. Therefore you should consider to switch to AUM.

andreas_herzog
Active Contributor
0 Kudos

a) sap 40b is no longer supported...

b) ora-1562: failed to extend rollback segment ; normally foloowd by another ora error

-> i would suggest to enlarge the psaproll tablespace by adding another datafile...use sapdba/brtools

GreetZ, AH

Former Member
0 Kudos

PSAP ROLL Table space having 44% free space rightnow.