Solved: SAP failed to start after database restore

Former Member · ‎12-05-2007

SAP Version: SAP R/3 Enterprise

Database: MSSQL Server 2000

OS: Windows

We had performed a database restore from the backup which was taken before the system rebuilt. The SAP failed to bring up as the dispatcher stopped due to the work processes died. After the database restore, we had run the SAP Tools for MSSQL Server but still did not manage to bring up the system. Please find below the logs for the developer trace and the dev_w0.

dev_disp

-

trc file: "dev_disp", trc level: 1, release: "640"

-

Wed Dec 05 11:03:58 2007

kernel runs with dp version 136000(ext=102000) (@(#) DPLIB-INT-VERSION-136000-UC)

length of sys_adm_ext is 524 bytes

sysno 00

sid Q02

systemid 560 (PC with Windows NT)

relno 6400

patchlevel 0

patchno 196

intno 20020600

make: multithreaded, Unicode

pid 2896

***LOG Q00=> DpSapEnvInit, DPStart (00 2896) [dpxxdisp.c 1102]

shared lib "dw_xml.dll" version 196 successfully loaded

shared lib "dw_xtc.dll" version 196 successfully loaded

shared lib "dw_stl.dll" version 196 successfully loaded

shared lib "dw_gui.dll" version 196 successfully loaded

shared lib "dw_mdm.dll" version 196 successfully loaded

Wed Dec 05 11:04:02 2007

WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 4 seconds

***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c 3881]

MtxInit: -2 0 0

DpSysAdmExtInit: ABAP is active

DpIPCInit2: start server >ibwoksapq02_Q02_00 <

DpShMCreate: sizeof(wp_adm) 15840 (1320)

DpShMCreate: sizeof(tm_adm) 2969176 (14772)

DpShMCreate: sizeof(wp_ca_adm) 24000 (80)

DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

DpShMCreate: sizeof(comm_adm) 290000 (580)

DpShMCreate: sizeof(vmc_adm) 0 (424)

DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)

DpShMCreate: SHM_DP_ADM_KEY (addr: 07910040, size: 3386992)

DpShMCreate: allocated sys_adm at 07910040

DpShMCreate: allocated wp_adm at 07911B88

DpShMCreate: allocated tm_adm_list at 07915968

DpShMCreate: allocated tm_adm at 07915990

DpShMCreate: allocated wp_ca_adm at 07BEA7E8

DpShMCreate: allocated appc_ca_adm at 07BF05A8

DpShMCreate: allocated comm_adm_list at 07BF24E8

DpShMCreate: allocated comm_adm at 07BF2500

DpShMCreate: allocated vmc_adm_list at 07C391D0

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 07C391F8

DpShMCreate: allocated wall_adm at 07C39200

MBUF state OFF

EmInit: MmSetImplementation( 2 ).

<ES> client 0 initializing ....

Wed Dec 05 11:04:03 2007

<ES> InitFreeList

<ES> block size is 1024 kByte.

Using implementation flat

<EsNT> Memory Reset disabled as NT default

<ES> 1131 blocks reserved for free list.

ES initialized.

rdisp/http_min_wait_dia_wp : 1 -> 1

***LOG CPS=> DpLoopInit, ICU ( 2.6.1 2.6 4.0) [dpxxdisp.c 1476]

***LOG Q0K=> DpMsAttach, mscon ( ibwoksapq02) [dpxxdisp.c 10113]

DpStartStopMsg: send start message (myname is >ibwoksapq02_Q02_00 <)

DpStartStopMsg: start msg sent

CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

CCMS: start to initalize 3.X shared alert area (first segment).

DpMsgAdmin: Set release to 6400, patchlevel 0

MBUF state PREPARED

MBUF component UP

DpMBufHwIdSet: set Hardware-ID

***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c 1025]

DpMsgAdmin: Set patchno for this platform to 196

Release check o.K.

Wed Dec 05 11:04:43 2007

ERROR => W0 (pid 1368) died [dpxxdisp.c 12682]
ERROR => W1 (pid 2032) died [dpxxdisp.c 12682]
ERROR => W2 (pid 772) died [dpxxdisp.c 12682]
ERROR => W3 (pid 3272) died [dpxxdisp.c 12682]
ERROR => W4 (pid 2980) died [dpxxdisp.c 12682]

my types changed after wp death/restart 0xbf --> 0xbe

ERROR => W5 (pid 3344) died [dpxxdisp.c 12682]

my types changed after wp death/restart 0xbe --> 0xbc

ERROR => W6 (pid 2848) died [dpxxdisp.c 12682]

my types changed after wp death/restart 0xbc --> 0xb8

ERROR => W7 (pid 3056) died [dpxxdisp.c 12682]
ERROR => W8 (pid 3308) died [dpxxdisp.c 12682]
ERROR => W9 (pid 596) died [dpxxdisp.c 12682]

my types changed after wp death/restart 0xb8 --> 0xb0

ERROR => W10 (pid 1988) died [dpxxdisp.c 12682]

my types changed after wp death/restart 0xb0 --> 0xa0

ERROR => W11 (pid 2136) died [dpxxdisp.c 12682]

my types changed after wp death/restart 0xa0 --> 0x80

DP_FATAL_ERROR => DpWPCheck: no more work processes
DISPATCHER EMERGENCY SHUTDOWN ***

increase tracelevel of WPs

killing W0-1368 (SIGUSR2)

ERROR => DpWpKill(1368, SIGUSR2) failed [dpxxtool.c 2508]

killing W1-2032 (SIGUSR2)

ERROR => DpWpKill(2032, SIGUSR2) failed [dpxxtool.c 2508]

killing W2-772 (SIGUSR2)

ERROR => DpWpKill(772, SIGUSR2) failed [dpxxtool.c 2508]

killing W3-3272 (SIGUSR2)

ERROR => DpWpKill(3272, SIGUSR2) failed [dpxxtool.c 2508]

killing W4-2980 (SIGUSR2)

ERROR => DpWpKill(2980, SIGUSR2) failed [dpxxtool.c 2508]

killing W5-3344 (SIGUSR2)

ERROR => DpWpKill(3344, SIGUSR2) failed [dpxxtool.c 2508]

killing W6-2848 (SIGUSR2)

ERROR => DpWpKill(2848, SIGUSR2) failed [dpxxtool.c 2508]

killing W7-3056 (SIGUSR2)

ERROR => DpWpKill(3056, SIGUSR2) failed [dpxxtool.c 2508]

killing W8-3308 (SIGUSR2)

ERROR => DpWpKill(3308, SIGUSR2) failed [dpxxtool.c 2508]

killing W9-596 (SIGUSR2)

ERROR => DpWpKill(596, SIGUSR2) failed [dpxxtool.c 2508]

killing W10-1988 (SIGUSR2)

ERROR => DpWpKill(1988, SIGUSR2) failed [dpxxtool.c 2508]

killing W11-2136 (SIGUSR2)

ERROR => DpWpKill(2136, SIGUSR2) failed [dpxxtool.c 2508]

NiWait: sleep (10000 msecs) ...

NiISelect: timeout 10000 ms

NiISelect: maximum fd=1569

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Dec 05 11:04:53 2007

NiISelect: TIMEOUT occured (10000 ms)

dump system status

Workprocess Table (long) Wed Dec 05 11:04:53 2007

========================

No Ty. Pid Status Cause Start Err Sem CPU Time Program Cl User Action Table

-

0 DIA 1368 Ended no 1 0 0

1 DIA 2032 Ended no 1 0 0

2 DIA 772 Ended no 1 0 0

3 DIA 3272 Ended no 1 0 0

4 DIA 2980 Ended no 1 0 0

5 UPD 3344 Ended no 1 0 0

6 ENQ 2848 Ended no 1 0 0

7 BTC 3056 Ended no 1 0 0

8 BTC 3308 Ended no 1 0 0

9 BTC 596 Ended no 1 0 0

10 SPO 1988 Ended no 1 0 0

11 UP2 2136 Ended no 1 0 0

Dispatcher Queue Statistics Wed Dec 05 11:04:53 2007

===========================

--------

+
+
+
+--

+

Typ

now

high

max

writes

reads

--------

+
+
+
+--

+

NOWP

0

5

2000

11

--------

+
+
+
+--

+

DIA

3

2000

5

2

--------

+
+
+
+--

+

UPD

0

2000

0

--------

+
+
+
+--

+

ENQ

0

2000

0

--------

+
+
+
+--

+

BTC

0

2000

0

--------

+
+
+
+--

+

SPO

0

2000

0

--------

+
+
+
+--

+

UP2

0

2000

0

--------

+
+
+
+--

+

max_rq_id 17

wake_evt_udp_now 0

wake events total 13, udp 6 ( 46%), shm 7 ( 53%)

since last update total 13, udp 6 ( 46%), shm 7 ( 53%)

Dump of tm_adm structure: Wed Dec 05 11:04:53 2007

=========================

Term uid man user term lastop mod wp ta a/i (modes)

EX-T12, U13, , 158.155.25.171, 11:04:07, M0, W-1, , 1/0

Workprocess Comm. Area Blocks Wed Dec 05 11:04:53 2007

=============================

Slots: 300, Used: 1, Max: 0

--------

+
+--

+

id

owner

pid

eyecatcher

--------

+
+--

+

0

DISPATCHER

-1

WPCAAD000

NiWait: sleep (5000 msecs) ...

NiISelect: timeout 5000 ms

NiISelect: maximum fd=1569

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Dec 05 11:04:58 2007

NiISelect: TIMEOUT occured (5000 ms)

DpHalt: shutdown server >ibwoksapq02_Q02_00 < (normal)

DpJ2eeDisableRestart

DpModState: buffer in state MBUF_PREPARED

NiBufSend starting

NiIWrite: write 110, 1 packs, MESG_IO, hdl 3, data complete

MsINiWrite: sent 110 bytes

MsIModState: change state to SHUTDOWN

DpModState: change server state from STARTING to SHUTDOWN

Switch off Shared memory profiling

ShmProtect( 57, 3 )

ShmProtect(SHM_PROFILE, SHM_PROT_RW

ShmProtect( 57, 1 )

ShmProtect(SHM_PROFILE, SHM_PROT_RD

DpWakeUpWps: wake up all wp's

Stop work processes...

Stop gateway

killing process (3968) (SOFT_KILL)

Stop icman

killing process (196) (SOFT_KILL)

Terminate gui connections

[DpProcDied] Process lives (PID:3968 HANDLE:1540)

waiting for termination of gateway

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1569

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Dec 05 11:04:59 2007

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process died (PID:3968 HANDLE:1540)

[DpProcDied] Process lives (PID:196 HANDLE:1548)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1569

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Dec 05 11:05:00 2007

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process lives (PID:196 HANDLE:1548)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1569

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Dec 05 11:05:01 2007

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process lives (PID:196 HANDLE:1548)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1569

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Dec 05 11:05:02 2007

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process lives (PID:196 HANDLE:1548)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1569

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Dec 05 11:05:03 2007

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process lives (PID:196 HANDLE:1548)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1569

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Dec 05 11:05:04 2007

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process lives (PID:196 HANDLE:1548)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1569

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Dec 05 11:05:05 2007

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process lives (PID:196 HANDLE:1548)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1569

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Dec 05 11:05:06 2007

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process lives (PID:196 HANDLE:1548)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1569

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Dec 05 11:05:07 2007

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process lives (PID:196 HANDLE:1548)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1569

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Dec 05 11:05:08 2007

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process lives (PID:196 HANDLE:1548)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1569

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Dec 05 11:05:09 2007

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process died (PID:196 HANDLE:1548)

DpHalt: cancel all lcom connections

MPI CancelAll 2 -> 0

MPI DeleteAll 2 -> 0

DpStartStopMsg: send stop message (myname is >ibwoksapq02_Q02_00 <)

NiIMyHostName: hostname = 'ibwoksapq02'

AdGetSelfIdentRecord: > <

AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0

AdCvtRecToExt: opcode 4 (AD_STARTSTOP), ser 0, ex 0, errno 0

DpConvertRequest: net size = 163 bytes

NiBufSend starting

NiIWrite: write 562, 1 packs, MESG_IO, hdl 3, data complete

MsINiWrite: sent 562 bytes

send msg (len 110+452) to name -, type 4, key -

DpStartStopMsg: stop msg sent

NiIRead: read 229, 1 packs, MESG_IO, hdl 3, data complete

NiBufIn: NIBUF len=229

NiBufIn: Packet complete for hdl 3

NiBufReceive starting

MsINiRead: received 229 bytes

MSG received, len 110+119, flag 1, from MSG_SERVER, typ 0, key -

DpHalt: received 119 bytes from message server

NiIRead: read 229, 1 packs, MESG_IO, hdl 3, data complete

NiBufIn: NIBUF len=229

NiBufIn: Packet complete for hdl 3

NiBufReceive starting

MsINiRead: received 229 bytes

MSG received, len 110+119, flag 1, from MSG_SERVER, typ 0, key -

DpHalt: received 119 bytes from message server

NiIRead: read 229, 1 packs, MESG_IO, hdl 3, data complete

NiBufIn: NIBUF len=229

NiBufIn: Packet complete for hdl 3

NiBufReceive starting

MsINiRead: received 229 bytes

MSG received, len 110+119, flag 1, from MSG_SERVER, typ 0, key -

DpHalt: received 119 bytes from message server

NiIRead: read 229, 1 packs, MESG_IO, hdl 3, data complete

NiBufIn: NIBUF len=229

NiBufIn: Packet complete for hdl 3

NiBufReceive starting

MsINiRead: received 229 bytes

MSG received, len 110+119, flag 1, from MSG_SERVER, typ 0, key -

DpHalt: received 119 bytes from message server

NiIRead: read 229, 1 packs, MESG_IO, hdl 3, data complete

NiBufIn: NIBUF len=229

NiBufIn: Packet complete for hdl 3

NiBufReceive starting

MsINiRead: received 229 bytes

MSG received, len 110+119, flag 1, from MSG_SERVER, typ 0, key -

DpHalt: received 119 bytes from message server

NiIRead: read 229, 1 packs, MESG_IO, hdl 3, data complete

NiBufIn: NIBUF len=229

NiBufIn: Packet complete for hdl 3

NiBufReceive starting

MsINiRead: received 229 bytes

MSG received, len 110+119, flag 1, from MSG_SERVER, typ 0, key -

DpHalt: received 119 bytes from message server

NiIRead: read 229, 1 packs, MESG_IO, hdl 3, data complete

NiBufIn: NIBUF len=229

NiBufIn: Packet complete for hdl 3

NiBufReceive starting

MsINiRead: received 229 bytes

MSG received, len 110+119, flag 1, from MSG_SERVER, typ 0, key -

DpHalt: received 119 bytes from message server

NiPRead: WSAEWOULDBLOCK 1.time 4

NiIPeek: peek for hdl 3 / socket 1476 timed out (r; 0)

DpHalt: no more messages from the message server

DpHalt: send keepalive to synchronize with the message server

NiBufSend starting

NiIWrite: write 114, 1 packs, MESG_IO, hdl 3, data complete

MsINiWrite: sent 114 bytes

send msg (len 110+4) to name MSG_SERVER, type 0, key -

MsSndName: MS_NOOP ok

Send 4 bytes to MSG_SERVER

NiIRead: read 114, 1 packs, MESG_IO, hdl 3, data complete

NiBufIn: NIBUF len=114

NiBufIn: Packet complete for hdl 3

NiBufReceive starting

MsINiRead: received 114 bytes

MSG received, len 110+4, flag 3, from MSG_SERVER, typ 0, key -

Received 4 bytes from MSG_SERVER

Received opcode MS_NOOP from msg_server, reply MSOP_OK

MsOpReceive: ok

MsSendKeepalive : keepalive sent to message server

NiPRead: WSAEWOULDBLOCK 1.time 4

Wed Dec 05 11:05:10 2007

NiIPeek: peek for hdl 3 / socket 1476 timed out (r; 1000)

DpHalt: no more messages from the message server

DpHalt: sync with message server o.k.

detach from message server

***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c 10403]

NiBufSend starting

NiIWrite: write 110, 1 packs, MESG_IO, hdl 3, data complete

MsINiWrite: sent 110 bytes

MsIDetach: send logout to msg_server

MsIDetach: call exit function

DpMsShutdownHook called

NiSelClear: removed hdl 3 from selectset

MBUF state OFF

AdGetSelfIdentRecord: > <

AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

blks_in_queue/wp_ca_blk_no/wp_max_no = 1/300/12

LOCK WP ca_blk 1

make DISP owner of wp_ca_blk 1

DpRqPutIntoQueue: put request into queue (reqtype 1, prio LOW, rq_id 23)

MBUF component DOWN

NiBufClose: clear extensions for hdl 3

NiBufSetStat: bufstat of hdl 3 changed from OK to OFF

NiICloseHandle: shutdown and close hdl 3 / socket 1476

MsIDetach: detach MS-system

EsCleanup ....

***LOG Q05=> DpHalt, DPStop ( 2896) [dpxxdisp.c 8776]

Good Bye .....

dev_w0

-

trc file: "dev_w0", trc level: 1, release: "640"

-

*

ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, M

*

B

B Wed Dec 05 11:04:03 2007

B create_con (con_name=R/3)

B Loading DB library 'C:\usr\sap\Q02\SYS\exe\run\dbmssslib.dll' ...

B Library 'C:\usr\sap\Q02\SYS\exe\run\dbmssslib.dll' loaded

B Version of 'C:\usr\sap\Q02\SYS\exe\run\dbmssslib.dll' is "640.00", patchlevel (0.195)

B New connection 0 created

M sysno 00

M sid Q02

M systemid 560 (PC with Windows NT)

M relno 6400

M patchlevel 0

M patchno 196

M intno 20020600

M make: multithreaded, Unicode

M pid 1368

M

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 1368) [dpxxdisp.c 1162]

I MtxInit: -2 0 0

M DpSysAdmExtCreate: ABAP is active

M DpShMCreate: sizeof(wp_adm) 15840 (1320)

M DpShMCreate: sizeof(tm_adm) 2969176 (14772)

M DpShMCreate: sizeof(wp_ca_adm) 24000 (80)

M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

M DpShMCreate: sizeof(comm_adm) 290000 (580)

M DpShMCreate: sizeof(vmc_adm) 0 (424)

M DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)

M DpShMCreate: SHM_DP_ADM_KEY (addr: 08110040, size: 3386992)

M DpShMCreate: allocated sys_adm at 08110040

M DpShMCreate: allocated wp_adm at 08111B88

M DpShMCreate: allocated tm_adm_list at 08115968

M DpShMCreate: allocated tm_adm at 08115990

M DpShMCreate: allocated wp_ca_adm at 083EA7E8

M DpShMCreate: allocated appc_ca_adm at 083F05A8

M DpShMCreate: allocated comm_adm_list at 083F24E8

M DpShMCreate: allocated comm_adm at 083F2500

M DpShMCreate: allocated vmc_adm_list at 084391D0

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 084391F8

M DpShMCreate: allocated wall_adm at 08439200

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X

X Wed Dec 05 11:04:04 2007

X Using implementation flat

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M calling db_connect ...

C Thread ID:2236

C Thank You for using the SLOLEDB-interface

C Using dynamic link library 'C:\usr\sap\Q02\SYS\exe\run\dbmssslib.dll'

C dbmssslib.dll patch info

C patchlevel 0

C patchno 195

C patchcomment DBCON: database names must not start with digits (1078650)

C np:(local) connection used on IBWOKSAPQ02

C CopyLocalParameters: dbuser is 'q02'

C Provider SQLNCLI could not be initialized. See note #734034 for more information.

C Using provider SQLOLEDB instead.

C OpenOledbConnection: MARS property was not set.

C

C Wed Dec 05 11:04:05 2007

C Provider Release:08.10.3959

C Provider SQLNCLI could not be initialized. See note #734034 for more information.

C Using provider SQLOLEDB instead.

C Cache sizes: header 68 bytes, 20000 names (31680000 bytes), 1000 dynamic statements (5696000 bytes), total 37376068 bytes

C Using shared procedure name cache IBWOKSAPQ02_Q02Q02_Q02_MEM initialized by another process.

C Connected to db server : [IBWOKSAPQ02] server_used : [np:(local)], dbname: Q02, dbuser: q02

C pn_id:IBWOKSAPQ02_Q02Q02_Q02

C Not using MARS (on sql 8.0)

B Connection 0 opened (DBSL handle 0)

B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date Time DBHost

B 000 000 R/3 000000000 ACTIVE NO YES NO 000 255 255 20071205 110404 IBWOKSAPQ02

C The IRow interface is supported by this OLEDB provider

M db_connect o.k.

M ICT: exclude compression: .zip,.cs,.rar,.arj,.z,.gz,.tar,.lzh,.cab,.hqx,.ace,.jar,.ear,.war,.css,.pdf,.js,.gzip,.uue,.bz2,.iso,.sda,.sar,.gif

I

I Wed Dec 05 11:04:10 2007

I *** ERROR => OpenProcess PID 3272 failed for checking semaphore 4

ERROR_INVALID_PARAMETER: The parameter is incorrect. [semnt.c 1939]

I MtxInit: 0 0 0

M SHM_PRES_BUF (addr: 0C8B0040, size: 4400128)

M SHM_ROLL_AREA (addr: 2FA50040, size: 161480704)

M SHM_PAGING_AREA (addr: 10500040, size: 73400320)

M SHM_ROLL_ADM (addr: 0CCF0040, size: 1612020)

M SHM_PAGING_ADM (addr: 0CE80040, size: 525344)

M ThCreateNoBuffer allocated 544152 bytes for 1000 entries at 0CF10040

M ThCreateNoBuffer index size: 3000 elems

M ThCreateVBAdm allocated 12160 bytes (50 server) at 0CFA0040

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Using implementation flat

X ES initialized.

C The IRow interface is supported by this OLEDB provider

B db_con_shm_ini: WP_ID = 0, WP_CNT = 12, CON_ID = -1

C Provider SQLNCLI could not be initialized. See note #734034 for more information.

C Using provider SQLOLEDB instead.

B dbtbxbuf: Buffer TABL (addr: 161000C8, size: 30000128, end: 17D9C4C8)

B dbtbxbuf: Profile: max_objects = 5000, displace = 1, reorg = 1

B dbtbxbuf: request_unit = 2000, sync_reload = 5, inval_reload = 5

B dbtbxbuf: protect_shm = 0, force_checks = 0

B dbtbxbuf: tsize_retry = 14291712

B ***LOG BB0=> buffer TABL started with length 30000128 bytes [dbtbxbuf#8 @ 16037] [dbtbxbuf1603 7]

B dbtbxbuf: Buffer TABLP (addr: 17DA00C8, size: 10240000, end: 187640C8)

B dbtbxbuf: Profile: max_objects = 500, displace = 1, reorg = 1

B dbtbxbuf: request_unit = 2000, sync_reload = 5, inval_reload = 5

B dbtbxbuf: protect_shm = 0, force_checks = 0

B dbtbxbuf: tsize_retry = 5044992

B ***LOG BB0=> buffer TABLP started with length 10240000 bytes [dbtbxbuf#8 @ 16037] [dbtbxbuf1603 7]

B dbtbxbuf: Reading TBX statistics:

B dbtbxbuf: 0 object entries precreated

B Layout of EIBUF buffer shared memory:

B 0: 1 * 4 = 4

B 1: 1 * 344 = 344

B 2: 12 * 20 = 240

B 3: 4001 * 48 = 192048

B 4: 2000 * 232 = 464000

B 5: 4001 * 4 = 16004

B 6: 1 * 200 = 200

B 7: 65 * 4 = 260

B 8: 13754 * 256 = 3521024

B Tracing = 0, Shm Protection = 0, Force checks = 0, Recovery delay = 500000

B dbexpbuf: Buffer EIBUF (addr: 187700D0, size: 4194304, end: 18B700D0)

B ***LOG BB0=> buffer EIBUF started with length 4096k bytes [dbexpbuf#6 @ 2342] [dbexpbuf2342 ]

B Layout of ESM buffer shared memory:

B 0: 1 * 4 = 4

B 1: 1 * 344 = 344

B 2: 12 * 20 = 240

B 3: 4001 * 48 = 192048

B 4: 2000 * 232 = 464000

B 5: 4001 * 4 = 16004

B 6: 1 * 200 = 200

B 7: 65 * 4 = 260

B 8: 13754 * 256 = 3521024

B Tracing = 0, Shm Protection = 0, Force checks = 0, Recovery delay = 500000

B dbexpbuf: Buffer ESM (addr: 18B800D0, size: 4194304, end: 18F800D0)

B ***LOG BB0=> buffer ESM started with length 4096k bytes [dbexpbuf#6 @ 2342] [dbexpbuf2342 ]

B Layout of CUA buffer shared memory:

B 0: 1 * 4 = 4

B 1: 1 * 344 = 344

B 2: 12 * 20 = 240

B 3: 3001 * 48 = 144048

B 4: 1500 * 232 = 348000

B 5: 3001 * 4 = 12004

B 6: 1 * 200 = 200

B 7: 193 * 4 = 772

B 8: 5012 * 512 = 2566144

B Tracing = 0, Shm Protection = 0, Force checks = 0, Recovery delay = 500000

B dbexpbuf: Buffer CUA (addr: 18F900D0, size: 3072000, end: 1927E0D0)

B ***LOG BB0=> buffer CUA started with length 3000k bytes [dbexpbuf#6 @ 2342] [dbexpbuf2342 ]

B Layout of OTR buffer shared memory:

B 0: 1 * 4 = 4

B 1: 1 * 344 = 344

B 2: 12 * 20 = 240

B 3: 4001 * 48 = 192048

B 4: 2000 * 232 = 464000

B 5: 4001 * 4 = 16004

B 6: 1 * 200 = 200

B 7: 81 * 4 = 324

B 8: 13754 * 256 = 3521024

B Tracing = 0, Shm Protection = 0, Force checks = 0, Recovery delay = 500000

B dbexpbuf: Buffer OTR (addr: 192800D0, size: 4194304, end: 196800D0)

B ***LOG BB0=> buffer OTR started with length 4096k bytes [dbexpbuf#6 @ 2342] [dbexpbuf2342 ]

B ***LOG BB0=> buffer CALE started with length 500000 bytes [dbcalbuf#5 @ 2274] [dbcalbuf2274 ]

M call semaphore clean-up function ...

M SemCleanup: Reset blocking on semaphore (Key:4/Slot:3)

M ***LOG Q0E=> DpSigGenHandler, Exception (c0000005) [dpnttool.c 462]

M -

C-STACK -

SAP (R) - R/3(TM) Callstack, Version 1.0

-

Application exception occurred:

Exception : c0000005 (Access Violation)

App : disp+work.EXE (pid=1368)

When : 12/5/2007 11:4:11.366

Threads : 2

-

Computer Name : IBWOKSAPQ02

User Name : SAPServiceQ02

-

Number of Processors: 4

Processor Type: x86 Family 15 Model 2 Stepping 5

Windows Version : 5.2 Current Build: 3790

-

Stack Dump for Thread Id 8bc

eax=00262802 ebx=00000002 ecx=0596b003 edx=00003d43 esi=00004200 edi=00004200

eip=00bbaf10 esp=0526fa88 ebp=0526fa94 iopl=0 nv up ei pl nz na pe nc

cs=001b ss=0023 ds=0023 es=0023 fs=003b gs=0000 efl=00010202

function : get_nec_length

00bbaef8 7403 jz get_nec_length+0x17b (00bbaefd)

00bbaefa c60100 mov byte ptr [ecx],0x0 ds:0596b003=??

00bbaefd 83c120 add ecx,0x20

00bbaf00 4a dec edx

00bbaf01 75f2 jnz get_dbtab_columns+0x87 (00bbaff5)

00bbaf03 eb19 jmp get_nec_length+0x19c (00bbaf1e)

00bbaf05 6685ff test di,di

00bbaf08 7e14 jle get_nec_length+0x19c (00bbaf1e)

00bbaf0a 83c103 add ecx,0x3

00bbaf0d 0fb7d7 movzx edx,di

FAULT-> 00bbaf10 803900 cmp byte ptr [ecx],0x0 ds:0596b003=??

00bbaf13 7403 jz get_nec_length+0x196 (00bbaf18)

00bbaf15 ff45fc inc dword ptr [ebp+0xfc] ss:0a4dd51a=????????

00bbaf18 83c120 add ecx,0x20

00bbaf1b 4a dec edx

00bbaf1c 75f2 jnz get_dbtab_columns+0xa2 (00bbb010)

00bbaf1e 5f pop edi

00bbaf1f 8b0dccfcc901 mov ecx,[FDESCR2_SIZE (01c9fccc)] ds:01c9fccc=0000017c

00bbaf25 0fbf55fc movsx edx,word ptr [ebp+0xfc] ss:0a4dd51b=????

00bbaf29 83c102 add ecx,0x2

00bbaf2c 0fafca imul ecx,edx

00bbaf2f 8d440102 lea eax,[ecxeax0x2] ds:054d0289=????????

--~~> Stack Back Trace <~~--

FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name

0526fa94 00bbefb1 00000287 0526fb24 00000000 0d064200 disp+work!get_nec_length [dbntab.c (12438)]

0526faf4 00bc2ec5 0526fb80 0526fb24 0526fb20 00000000 disp+work!ftab_select [dbntab.c (10343)]

0526fb44 00bc390e 00000000 0526fb80 00000000 01c9fcbc disp+work!fetch_entry [dbntab.c (7186)]

0526fb5c 00bc4274 00000000 0526fb80 01d577ec 01d57760 disp+work!procure_2 [dbntab.c (6855)]

0526fbb8 00c921a9 00000002 0526fc30 0526fc44 00000000 disp+work!db_ntab [dbntab.c (3104)]

0526fc4c 00c950a2 0fe300c8 0fe30040 00000000 00310030 disp+work!read_ntab [dbcalbuf.c (3177)]

0526fd40 00c95805 00000000 00000000 0fe30040 00660075 disp+work!db_cbufload [dbcalbuf.c (4507)]

0526fd68 00c97937 01d58d0c 00000008 0fe30040 0526fd90 disp+work!reset_handling [dbcalbuf.c (2676)]

0526fdac 00c97ab8 00000000 7c355852 00000000 00000005 disp+work!init_shm_and_load_cals [dbcalbuf.c (2278)]

0526fdd8 00c5904d 0526fdf4 05b30dcc 00000000 0000000a disp+work!db_cbufinst [dbcalbuf.c (1599)]

0526fe08 00ca8ed0 057c7200 057c7178 00000090 057c717c disp+work!db_calinit [dbbmng0.c (2786)]

0526fe1c 0045790a 00000011 00000004 00000000 00000000 disp+work!db_init [dblink.c (2213)]

0526fe3c 00488e83 00000011 00000000 024987e0 00000000 disp+work!ThCallHooks [thxxtool3.c (246)]

0526fe58 004980ff 00000000 00000002 0526ff04 00000000 disp+work!ThIPCInit [thxxhead.c (1914)]

0526fee8 0049c594 00000001 05425fd0 00000000 00000000 disp+work!tskh_init [thxxhead.c (1356)]

0526ff04 004233fb 00000000 7ffd8000 0526ff60 00401085 disp+work!tskhstart [thxxhead.c (1017)]

0526ff14 00401085 00000003 05425fd0 00000001 00000000 disp+work!DpMain [dpxxdisp.c (1011)]

0526ff60 0111cebb 00000003 05425fd0 05426888 017d9000 disp+work!nlsui_main [thxxanf.c (85)]

0526ffc0 77e6f23b 00000000 00000000 7ffd8000 00000000 disp+work!wmainCRTStartup [crtexe.c (395)]

0526fff0 00000000 0111cd78 00000000 00905a4d 00000003 kernel32!ProcessIdToSessionId

-

Stack Dump for Thread Id 838

eax=00000001 ebx=00000103 ecx=7c829f59 edx=00410000 esi=00000000 edi=00000000

eip=7c8285ec esp=078ffeb0 ebp=078ffef4 iopl=0 nv up ei pl zr na po nc

cs=001b ss=0023 ds=0023 es=0023 fs=003b gs=0000 efl=00000246

function : KiFastSystemCallRet

7c8285ec c3 ret

7c8285ed 8da42400000000 lea esp,[esp] ss:078ffeb0=7c8270fb

7c8285f4 8d642400 lea esp,[esp] ss:0cb6d937=00000000

--~~> Stack Back Trace <~~--

FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name

078ffef4 01076a50 000006a0 00000000 00000000 0542b0d0 ntdll!KiFastSystemCallRet

078fff84 7c349565 00000000 00000000 00000000 0542b038 disp+work!SigIMsgFunc [signt.c (632)]

078fffb8 77e64829 0542b038 00000000 00000000 0542b038 MSVCR71!endthreadex

078fffec 00000000 7c3494f6 0542b038 00000000 00000000 kernel32!GetModuleHandleA

-

M -

M

M Wed Dec 05 11:04:11 2007

M call clean-up function ...

M in_ThErrHandle: 1

M ThSigHandler: signal (step 1, th_errno 11, action 4)

M

M Info for wp 0

M

M stat = 4

M reqtype = 1

M act_reqtype = -1

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source = 255

M last_tid = 0

M last_mode = 0

M int_checked_resource(RFC) = 0

M ext_checked_resource(RFC) = 0

M int_checked_resource(HTTP) = 0

M ext_checked_resource(HTTP) = 0

M report = > <

M action = 0

M tab_name = > <

M

M *****************************************************************************

M *

M * LOCATION SAP-Server ibwoksapq02_Q02_00 on host ibwoksapq02 (wp 0)

M * ERROR ThSigHandler: signal

M *

M * TIME Wed Dec 05 11:04:11 2007

M * RELEASE 640

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 11

M * MODULE thxxhead.c

M * LINE 9806

M * COUNTER 1

M *

M *****************************************************************************

M

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 730]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 254]

M Entering ThSetStatError

M ThIErrHandle: call ThrCoreInfo

A RABAX in run level 0

A RABAX in unkown environment: task_type=0, run level=0, rabax state=80000000 ztta_task_type=0

SAP (R) - R/3(TM) Callstack, Version 1.0

-

Application exception occurred:

Exception : c0000005 (Access Violation)

App : disp+work.EXE (pid=1368)

When : 12/5/2007 11:4:11.476

Threads : 2

-

Computer Name : IBWOKSAPQ02

User Name : SAPServiceQ02

-

Number of Processors: 4

Processor Type: x86 Family 15 Model 2 Stepping 5

Windows Version : 5.2 Current Build: 3790

-

Stack Dump for Thread Id 8bc

eax=00262802 ebx=00000002 ecx=0596b003 edx=00003d43 esi=00004200 edi=00004200

eip=00bbaf10 esp=0526fa88 ebp=0526fa94 iopl=0 nv up ei pl nz na pe nc

cs=001b ss=0023 ds=0023 es=0023 fs=003b gs=0000 efl=00010202

function : get_nec_length

00bbaef8 7403 jz get_nec_length+0x17b (00bbaefd)

00bbaefa c60100 mov byte ptr [ecx],0x0 ds:0596b003=??

00bbaefd 83c120 add ecx,0x20

00bbaf00 4a dec edx

00bbaf01 75f2 jnz get_dbtab_columns+0x87 (00bbaff5)

00bbaf03 eb19 jmp get_nec_length+0x19c (00bbaf1e)

00bbaf05 6685ff test di,di

00bbaf08 7e14 jle get_nec_length+0x19c (00bbaf1e)

00bbaf0a 83c103 add ecx,0x3

00bbaf0d 0fb7d7 movzx edx,di

FAULT-> 00bbaf10 803900 cmp byte ptr [ecx],0x0 ds:0596b003=??

00bbaf13 7403 jz get_nec_length+0x196 (00bbaf18)

00bbaf15 ff45fc inc dword ptr [ebp+0xfc] ss:0a4da78e=????????

00bbaf18 83c120 add ecx,0x20

00bbaf1b 4a dec edx

00bbaf1c 75f2 jnz get_dbtab_columns+0xa2 (00bbb010)

00bbaf1e 5f pop edi

00bbaf1f 8b0dccfcc901 mov ecx,[FDESCR2_SIZE (01c9fccc)] ds:01c9fccc=0000017c

00bbaf25 0fbf55fc movsx edx,word ptr [ebp+0xfc] ss:0a4da78f=????

00bbaf29 83c102 add ecx,0x2

00bbaf2c 0fafca imul ecx,edx

00bbaf2f 8d440102 lea eax,[ecxeax0x2] ds:054cd4fd=????????