Skip to Content
author's profile photo Former Member
Former Member

Spool error / TemSe error

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Dec 31, 2013 at 05:31 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 31, 2013 at 11:04 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 31, 2013 at 11:36 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 31, 2013 at 11:47 PM

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

    Thanks

    Rishi

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.