on 12-31-2013 2:46 AM
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
Can you please check the DB error logs during that period...
Thanks
Rishi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.