cancel
Showing results for 
Search instead for 
Did you mean: 

Spool error / TemSe error

Former Member
0 Kudos

Dear Experts,

Last week our SAP got stuck and was not able to login in the system, we restarted SAP and then we were able to connect.

But I am not able to find out the reason for this.

Please find SM21 logs below for that day:

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

00:32:00 BTC  009 000 DDIC                    BY  M SQL error 30046 occurred; work process in reconnect status
00:32:00 DIA  005 000 SAPSYS                  BY  M SQL error 30046 occurred; work process in reconnect status
00:32:00 BTC  007 000 DDIC                    BY  M SQL error 30046 occurred; work process in reconnect status
00:32:00 DIA  000 000 SAPSYS                  BY  M SQL error 30046 occurred; work process in reconnect status
00:32:00 DIA  011 000 SAPSYS                  BY  M SQL error 30046 occurred; work process in reconnect status
00:32:00 DIA  004 000 SAPSYS                  BY  M SQL error 30046 occurred; work process in reconnect status
00:32:00 BTC  006 000 DDIC                    BY  M SQL error 30046 occurred; work process in reconnect status
00:32:00 BTC  012 000 DDIC                    BY  M SQL error 30046 occurred; work process in reconnect status
00:32:00 BTC  007 000 DDIC                    F6  H Database error: TemSe->XRTAB(3)->1 for table TST01 key
00:32:00 BTC  012 000 DDIC                    F7  U Spool: Database Access Error: db_rsql 1 for Table
00:32:00 BTC  006 000 DDIC                    F6  H Database error: TemSe->XRTAB(2)->1 for table TST03 key [000]SPOOL0000006713 ,1
00:32:00 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:32:00 BTC  006 000 DDIC                    F3  U Database I/O error
00:32:00 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:32:00 BTC  007 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:32:00 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:32:00 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:32:00 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:32:00 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:32:00 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:32:00 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:32:00 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:32:00 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:32:00 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:32:00 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:32:00 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:32:00 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:32:00 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:32:00 SPO  014 000 SAPSYS                  BY  M SQL error 30046 occurred; work process in reconnect status
00:32:00 BTC  006 000 DDIC                    F6  H Database error: TemSe->XRTAB(0)->1 for table TST01 key 000SPOOL0000006712 1,2
00:32:00 BTC  006 000 DDIC                    F6  H Database error: TemSe->XRTAB(0)->1 for table TST01 key 000SPOOL0000006712 1,2
00:35:10 BTC  012 000 DDIC                    BV  4 Work process is in reconnect status
00:35:29 DIA  000                             BV  4 Work process is in reconnect status
00:35:29 DIA  004                             BV  4 Work process is in reconnect status
00:36:05 DIA  002                             BV  4 Work process is in reconnect status
00:36:10 BTC  012 000 DDIC                    BY  M SQL error 30012 occurred; work process in reconnect status
00:36:13 DIA  001                             BV  4 Work process is in reconnect status
00:36:15 DIA  003                             BV  4 Work process is in reconnect status
00:38:20 BTC  007 000 DDIC                    R3  9 Error in DB rollback/SyFlush, return code 000256
00:38:21 BTC  006 000 DDIC                    R3  9 Error in DB rollback/SyFlush, return code 000256
00:38:21 DIA  011 000 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
00:38:21 BTC  009 000 DDIC                    R3  9 Error in DB rollback/SyFlush, return code 000256
00:38:21 DIA  005 000 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
00:38:22 SPO  014 000 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
00:39:10 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:40:10 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:41:10 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:41:49 DIA  000 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
00:41:50 DIA  004 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
00:42:10 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:42:25 DIA  002 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
00:42:33 DIA  001 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
00:42:35 DIA  003 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
00:43:10 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:44:10 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:45:10 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:46:10 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:47:10 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:47:51 DIA  011 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
00:47:52 SPO  014 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
00:48:10 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:48:48 DIA  005 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
00:49:10 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:50:10 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:51:10 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:51:19 DIA  000 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
00:51:20 DIA  004 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
00:51:55 DIA  002 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
00:52:10 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:52:24 DIA  003 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
00:53:10 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:54:10 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:54:48 DIA  001 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
00:55:11 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:56:11 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:57:11 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:57:21 DIA  011 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
00:57:22 SPO  014 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
00:58:11 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
00:58:32 DIA  005 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
00:59:11 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
01:00:11 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
01:00:50 DIA  000 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:01:11 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
01:01:50 DIA  002 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:02:11 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
01:02:24 DIA  003 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:03:11 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
01:03:50 DIA  004 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:04:11 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
01:05:11 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
01:06:11 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
01:06:32 DIA  001 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:06:52 SPO  014 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:07:11 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
01:07:50 DIA  011 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:08:11 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
01:08:32 DIA  005 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:09:11 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
01:10:11 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
01:10:20 DIA  000 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:11:11 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
01:11:20 DIA  002 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:12:11 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
01:12:24 DIA  003 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:13:11 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
01:14:11 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
01:14:32 DIA  004 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:15:11 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
01:16:02 DIA  001 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:16:11 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
01:16:23 SPO  014 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:17:11 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
01:17:20 DIA  011 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:18:02 DIA  005 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:18:11 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
01:19:11 BTC  012 000 DDIC                    F7  L Spool: RT_READ_... Reports Error 1 for Table
01:19:50 DIA  000 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:20:11 BTC  012 000 DDIC                    F6  H Database error: TemSe->XRTAB(2)->1 for table TST03 key
01:20:11 BTC  012 000 DDIC                    F3  U Database I/O error
01:20:11 BTC  012 000 DDIC                    F3  U Database I/O error
01:20:11 BTC  012 000 DDIC                    F7  1 Error in TemSe Management
01:21:11 BTC  012 000 DDIC                    F6  H Database error: TemSe->XRTAB(2)->1 for table TST03 key 000SPOOL0000006711 1,1
01:21:11 BTC  012 000 DDIC                    F3  U Database I/O error
01:21:11 BTC  012 000 DDIC                    F3  U Database I/O error
01:21:11 BTC  012 000 DDIC                    F7  1 Error in TemSe Management
01:21:11 BTC  012 000 DDIC                    AB  0 Run-time error "SPOOL_I/O_ERROR" occurred
01:22:24 DIA  003 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:22:32 DIA  002 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:24:02 DIA  004 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:24:11 BTC  012 000 DDIC                    F2  0 Calling program reports invalid handle for TemSe object (magic==X'4f444f23')
01:24:11 BTC  012 000 DDIC                    F2  0 Calling program reports invalid handle for TemSe object (magic==X'4f444f23')
01:24:11 BTC  012 000 DDIC                    F7  1 Error in TemSe Management
01:25:32 DIA  001 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:25:53 SPO  014 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:26:50 DIA  011 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:27:32 DIA  005 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:30:32 DIA  000 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:31:55 DIA  003 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:32:24 DIA  002 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:33:32 DIA  004 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:35:02 DIA  001 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:35:23 SPO  014 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:36:20 DIA  011 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:38:32 DIA  005 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:40:02 DIA  000 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:41:25 DIA  003 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:41:54 DIA  002 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:43:02 DIA  004 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:44:32 DIA  001 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:44:53 SPO  014 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:46:32 DIA  011 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:48:02 DIA  005 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:49:32 DIA  000 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:50:55 DIA  003 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:51:25 DIA  002 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:52:32 DIA  004 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:54:23 SPO  014 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:54:32 DIA  001 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:56:02 DIA  011 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:57:32 DIA  005 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
01:59:02 DIA  000 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
02:00:25 DIA  003 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
02:02:24 DIA  004 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
02:02:32 DIA  002 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
02:03:54 SPO  014 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
02:04:02 DIA  001 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
02:05:32 DIA  011 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
02:07:02 DIA  005 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
02:08:32 DIA  000 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
02:10:32 DIA  003 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
02:11:58 DIA  004 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
02:12:24 DIA  002 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
02:13:24 SPO  014 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
02:13:32 DIA  001 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
02:15:02 DIA  011 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
02:16:32 DIA  005 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
02:18:32 DIA  000 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
02:20:02 DIA  003 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
02:21:28 DIA  004 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
02:22:00 DIA  002 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
02:22:54 SPO  014 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
02:23:02 DIA  001 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
02:24:32 DIA  011 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
02:26:32 DIA  005 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
02:28:02 DIA  000 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
02:29:32 DIA  003 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
02:30:58 DIA  004 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:02:28 DIA  005 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:04:27 DIA  000 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:07:24 DIA  004 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:07:27 DIA  003 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:07:57 SPO  014 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:08:35 DIA  002 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:09:58 DIA  001 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:10:35 DIA  011 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:11:58 DIA  005 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:13:58 DIA  000 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:16:55 DIA  004 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:17:24 DIA  003 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:17:28 SPO  014 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:18:06 DIA  002 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:19:28 DIA  001 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:20:05 DIA  011 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:21:28 DIA  005 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:23:28 DIA  000 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:25:19 DP                                   Q0  I Operating system call recv failed (error no. 73 )
07:25:19 DP                                   Q0  I Operating system call recv failed (error no. 73 )
07:25:19 DP                                   Q0  4 Connection to user 19999 ( ), terminal 40 (C02LINWS6041) lost
07:25:19 DP                                   Q0  4 Connection to user 19995 ( ), terminal 22 (C02LINWS6041) lost
07:25:19 DP                                   Q0  I Operating system call recv failed (error no. 73 )
07:25:19 DP                                   Q0  I Operating system call recv failed (error no. 73 )
07:25:19 DP                                   Q0  I Operating system call recv failed (error no. 73 )
07:25:19 DP                                   Q0  4 Connection to user 19998 ( ), terminal 53 (C02LINWS6041) lost
07:25:19 DP                                   Q0  4 Connection to user 19997 ( ), terminal 27 (C02LINWS6041) lost
07:25:19 DP                                   Q0  4 Connection to user 19996 ( ), terminal 46 (C02LINWS6041) lost
07:25:49 DP                                   Q0  G Request (type DIA) cannot be processed
07:25:49 DP                                   Q0  G Request (type DIA) cannot be processed
07:25:49 DP                                   Q0  G Request (type DIA) cannot be processed
07:26:24 DP                                   Q0  G Request (type DIA) cannot be processed
07:26:25 DIA  004 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:26:55 DIA  003                             R3  9 Error in DB rollback/SyFlush, return code 000256
07:26:58 SPO  014 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:27:36 DIA  002                             R3  9 Error in DB rollback/SyFlush, return code 000256
07:28:59 DIA  001 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:30:58 DIA  005 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:32:58 DIA  000 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:35:54 DIA  011                             R3  9 Error in DB rollback/SyFlush, return code 000256
07:35:55 DIA  004 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:36:25 DIA  003 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:36:28 SPO  014 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:37:06 DIA  002 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:38:29 DIA  001 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:40:28 DIA  005 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
07:42:28 DIA  000                             R3  9 Error in DB rollback/SyFlush, return code 000256
07:45:25 DIA  011                             R3  9 Error in DB rollback/SyFlush, return code 000256
07:45:25 DIA  004                             R3  9 Error in DB rollback/SyFlush, return code 000256
09:13:29 DIA  003                             R3  9 Error in DB rollback/SyFlush, return code 000256
09:13:30 SPO  014 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
09:13:30 DIA  000 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
09:13:30 DIA  001 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
09:13:38 DIA  002 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
09:13:40 DP                                   Q0  G Request (type DIA) cannot be processed
09:13:50 DIA  005                             R3  9 Error in DB rollback/SyFlush, return code 000256
09:13:55 DIA  011                             R3  9 Error in DB rollback/SyFlush, return code 000256
09:13:57 DIA  004                             R3  9 Error in DB rollback/SyFlush, return code 000256
09:14:00 DIA  003 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
09:14:01 SPO  014 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
09:14:01 DIA  000                             R3  9 Error in DB rollback/SyFlush, return code 000256
09:14:01 DIA  001                             R3  9 Error in DB rollback/SyFlush, return code 000256
09:14:08 DIA  002 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
09:15:33 DIA  011                             R3  9 Error in DB rollback/SyFlush, return code 000256
09:15:40 DIA  002 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
09:15:40 DIA  005 SAPSYS                  R3  9 Error in DB rollback/SyFlush, return code 000256
09:15:43 DIA  004                             R3  9 Error in DB rollback/SyFlush, return code 000256
09:16:13 SPO  014                             BY  Y Work process has left reconnect status
09:16:13 DIA  011                             BY  Y Work process has left reconnect status
09:16:13 DIA  004                             BY  Y Work process has left reconnect status
09:16:13 DIA  005                             BY  Y Work process has left reconnect status
09:16:13 DIA  002                             BY  Y Work process has left reconnect status
09:16:14 DIA  011 000 SAPSYS                  EE  A OPERATION MODES: Switch to operation mode Day_mode triggered
09:16:14 DP                                   Q1  O The configuration of the work processes will be changed
09:16:14 DP                                   Q0  V Work process 13 switched from request type BTC to DIA
09:16:14 DP                                   Q0  V Work process 12 switched from request type BTC to DIA
09:16:14 DP                                   Q0  V Work process 9 switched from request type BTC to DIA
09:16:14 DIA  001                             BY  Y Work process has left reconnect status
09:16:14 BTC  009                             BY  Y Work process has left reconnect status
09:16:14 DIA  003                             BY  Y Work process has left reconnect status
09:16:14 BTC  012                             BY  Y Work process has left reconnect status
09:16:14 BTC  006                             BY  Y Work process has left reconnect status
09:16:14 BTC  007                             BY  Y Work process has left reconnect status
09:16:14 DIA  000                             BY  Y Work process has left reconnect status
09:16:18 BTC  006 000 DDIC                    EJ  H Status of job ARV_BC_XMB_WRP20131228003019, number 00301900 corrected (R -> A)
09:16:20 BTC  006 000 DDIC                    EJ  H Status of job SAP_COLLECTOR_FOR_JOBSTATISTIC, number 00301800 corrected (R -> A)
09:16:22 BTC  006 000 DDIC                    EJ  H Status of job SAP_REORG_JOBS, number 00301700 corrected (R -> A)
09:16:24 BTC  006 000 DDIC                    EJ  H Status of job SAP_REORG_SPOOL, number 00301700 corrected (R -> A)
09:16:26 BTC  006 000 DDIC                    EJ  H Status of job SAP_SPOOL_CONSISTENCY_CHECK, number 00301800 corrected (R -> A)
09:16:47 BTC  008 500 BASIS                   BS  5 The buffer synchronization has not been called for 31545 seconds
09:19:09 DIA  000 000 SAPSYS                  BS  6 Synchronization record with number 15942153 could not be found in table DDLOG

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

I am not able to find the reason why we were not able to login, and after restart we were.

I have run a spool consistency test in SP12, it shows no error.

Please help me finding out the reason for this.

Version:

SAP ERP6.0 EHP6

Database: Sybase

Regards,

Harikrishna

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Can you please check the DB error logs during that period...

Thanks

Rishi

Reagan
Advisor
Advisor
0 Kudos

00:32:00 BTC  012 000 DDIC BY  M SQL error 30046 occurred; work process in reconnect status

00:32:00 BTC  007 000 DDIC F6  H Database error: TemSe->XRTAB(3)->1 for table TST01 key

00:32:00 BTC  012 000 DDIC F7  U Spool: Database Access Error: db_rsql 1 for Table

00:32:00 BTC  006 000 DDIC F6  H Database error: TemSe->XRTAB(2)->1 for table TST03 key [000]SPOOL0000006713 ,1

00:32:00 BTC  012 000 DDIC F7  L Spool: RT_READ_... Reports Error 1 for Table

00:32:00 BTC  006 000 DDIC F3  U Database I/O error

Work process in reconnect status.

You need to check what happened at the database side.

It appears to me that the database was not available.

Regards

RB

former_member182657
Active Contributor
0 Kudos

Hi Hari,

Please check these first:

- TempSe (SP12)  - consistence check -> Delete All (if systems lists any entries)

-  Printer Consistence (SPAD)->Administration->Check Consistence -> Delete All (if systems lists any entries)

-  SM12 for locks.- -> Delete All (if systems lists any entries)

-  And also check 'SAP_REORG_JOB' running fine in the system.

-  Share dev_w*.log .

Regards,

Gaurav

AtulKumarJain
Active Contributor
0 Kudos

Hi Hari,

Please check below note

1825408 - MSS: DbSlRollback96 while DBIF already active

Please could you check memory setting and no of work process in your system.

also please provide dev_w*.old log for more information.

Best Regards,

Atul