on 10-29-2008 12:25 PM
Hello All,
I have made a system copy of the PRD by restoring the database and running the STM tool available at the SMP.
The execution of the tool has finished successfully.
But when i am trying to start the SAP the status of all the wp is 32.
I am pasting the Developer Trace below please can anyone help me solving this issue.
-
trc file: "dev_w1", trc level: 1, release: "620"
-
*
ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, M
*
B
B Wed Oct 29 14:50:08 2008
B create_con (con_name=R/3)
B Loading DB library 'E:\usr\sap\HSQ\SYS\exe\run\dbmssslib.dll' ...
B Library 'E:\usr\sap\HSQ\SYS\exe\run\dbmssslib.dll' loaded
B Version of 'E:\usr\sap\HSQ\SYS\exe\run\dbmssslib.dll' is "620.02", patchlevel (0.524)
B New connection 0 created
M systemid 560 (PC with Windows NT)
M relno 6200
M patchlevel 0
M patchno 674
M intno 20020600
M pid 2896
M
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 1 2896) [dpxxdisp.c 1028]
I
I Wed Oct 29 14:50:27 2008
I MtxInit: -2 0 0
M DpShMCreate: sizeof(wp_adm) 11280 (752)
M DpShMCreate: sizeof(tm_adm) 1690816 (8412)
M DpShMCreate: sizeof(wp_ca_adm) 18000 (60)
M DpShMCreate: sizeof(appc_ca_adm) 6000 (60)
M DpShMCreate: sizeof(comm_adm) 192000 (384)
M DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)
M DpShMCreate: SHM_DP_ADM_KEY (addr: 04040040, size: 1976320)
M DpShMCreate: allocated sys_adm at 04040040
M DpShMCreate: allocated wp_adm at 04040560
M DpShMCreate: allocated tm_adm_list at 04043170
M DpShMCreate: allocated tm_adm at 04043198
M DpShMCreate: allocated wp_ca_adm at 041DFE58
M DpShMCreate: allocated appc_ca_adm at 041E44A8
M DpShMCreate: allocated comm_adm_list at 041E5C18
M DpShMCreate: allocated comm_adm at 041E5C30
M DpShMCreate: allocated ca_info at 04214A30
M DpShMCreate: allocated wall_adm at 04214A38
X EmInit: MmSetImplementation( 2 ).
X <ES> client 1 initializing ....
X Using implementation std
M <EsNT> Memory Reset enabled as NT default
X ES initialized.
M calling db_connect ...
C
C Wed Oct 29 14:50:29 2008
C SQLOLEDB Provider Release:08.10.3959
C
C Wed Oct 29 14:50:32 2008
C Shared cache sizes: header 52 bytes, 10000 names (13360000 bytes), 1000 dynamic statements (5436000 bytes), total 18796052 bytes
C Using shared procedure name cache initialized by another process.
C Thank You for using the SLOLEDB-interface
C Connected to db server : [saphse-qa], dbname: HSQ, dbuser: hsq
C Using dynamic link library 'E:\usr\sap\HSQ\SYS\exe\run\dbmssslib.dll'
C dbmssslib.dll patch info
C patchlevel 0
C patchno 524
C patchcomment DBDYNPSOURCE/DBDYNPSOURCE~, SHADOW_IMPORT_ALL (578789)
B Connection 0 opened
B Wp Hdl ConName ConId ConState TX PRM RCT Date Time DBHost
B 000 000 R/3 000000000 ACTIVE NO YES NO 20081029 145027 SAPHSE-QA
C The IRow interface is supported by this OLEDB provider
M db_connect o.k.
M
M Wed Oct 29 14:50:37 2008
M CrtChkOsSem: create check mutex and RC=[already exists] (Key:4/Name:SAP_SYSTEM_MUTEX_0_4/Hdl:1288)
I
I Wed Oct 29 14:50:52 2008
I MtxInit: 1 0 0
X EmInit: MmSetImplementation( 2 ).
X <ES> client 1 initializing ....
X Using implementation std
X ES initialized.
B db_con_shm_ini: WP_ID = 1, WP_CNT = 15
B dbtbxbuf: Buffer TABL (addr: 100E00C8, size: 30000000, end: 11D7C448)
B dbtbxbuf: Buffer TABLP (addr: 0E8A00C8, size: 10240000, end: 0F2640C8)
B dbexpbuf: Buffer EIBUF (addr: 0F2800D0, size: 4194304, end: 0F6800D0)
B dbexpbuf: Buffer ESM (addr: 0F6900D0, size: 4194304, end: 0FA900D0)
B dbexpbuf: Buffer CUA (addr: 0FAA00D0, size: 3072000, end: 0FD8E0D0)
B dbexpbuf: Buffer OTR (addr: 11D800D0, size: 4194304, end: 121800D0)
B ***LOG BYK=> current SQL statement exceeds a database limit [dbtrtab#3 @ 3918] [dbtrtab 3918 ]
B dbtrtab ERROR LOG (hdl_dbsl_error): DbSl 'PRE' -> 2
B tab='SVERS', cid=0, strgctxt:p=00000000, inp:#=0
B lob:fld=1, lob:frag=0, gen:fld=0, gen:frag=0, upb:fld=0..0, upb:frag=0, upb:chk=31117912
B ***LOG BY7=> invalid cursor specified 65535 for database selection [dbcrtab#5 @ 2883] [dbcrtab 2883 ]
M *** ERROR => ThShMInit: ThReadDBVersion [thxxhead.c 2289]
M *** ERROR => ThIPCInit: ThShMInit failed, shutdown server [thxxhead.c 1674]
M in_ThErrHandle: 1
M ThIErrHandle: I'm during shutdown
M Entering ThSetStatError
M ThIErrHandle: normal shutdown
M
M Wed Oct 29 14:51:01 2008
M Entering ThReadDetachMode
M call ThrShutDown (1)...
B dbtbxbuf: Saving TBX statistics:
B dbtbxbuf: 0 object entries written.
M ***LOG Q02=> wp_halt, WPStop (Workproc 1 2896) [dpnttool.c 346]
Immediate response will be appreciated.
Regards,
Mudassir.
Hello Sunil,
The R/3 version is 4.7 and the DB we are using is Ms Sql 2000 on Windows 2003 Server.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hello sunil..
i have done kernal upgrade to 640 and tried still the same problem..
please go through the log of (dev_disp)
-
trc file: "dev_disp", trc level: 1, release: "640"
-
Sat Nov 01 09:43:32 2008
kernel runs with dp version 128(ext=102) (@(#) DPLIB-INT-VERSION-128)
length of sys_adm_ext is 312 bytes
systemid 560 (PC with Windows NT)
relno 6400
patchlevel 0
patchno 25
intno 20020600
make: multithreaded, ASCII
pid 900
***LOG Q00=> DpSapEnvInit, DPStart (00 900) [dpxxdisp.c 1100]
shared lib "dw_xml.dll" version 26 successfully loaded
shared lib "dw_xtc.dll" version 26 successfully loaded
shared lib "dw_stl.dll" version 26 successfully loaded
shared lib "dw_gui.dll" version 26 successfully loaded
Sat Nov 01 09:43:36 2008
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 3886]
MtxInit: -2 0 0
DpSysAdmExtInit: ABAP is active
DpSysAdmExtInit: JAVA is not active
DpShMCreate: sizeof(wp_adm) 12424 (828)
DpShMCreate: sizeof(tm_adm) 2219848 (11044)
DpShMCreate: sizeof(wp_ca_adm) 18000 (60)
DpShMCreate: sizeof(appc_ca_adm) 6000 (60)
DpShMCreate: sizeof(comm_adm) 192000 (384)
DpShMCreate: sizeof(vmc_adm) 0 (320)
DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)
DpShMCreate: SHM_DP_ADM_KEY (addr: 04480040, size: 2511216)
DpShMCreate: allocated sys_adm at 04480040
DpShMCreate: allocated wp_adm at 044817A8
DpShMCreate: allocated tm_adm_list at 04484830
DpShMCreate: allocated tm_adm at 04484858
DpShMCreate: allocated wp_ca_adm at 046A27A0
DpShMCreate: allocated appc_ca_adm at 046A6DF0
DpShMCreate: allocated comm_adm_list at 046A8560
DpShMCreate: allocated comm_adm at 046A8578
DpShMCreate: allocated vmc_adm_list at 046D7378
DpShMCreate: system runs without vmc_adm
DpShMCreate: allocated ca_info at 046D73A0
DpShMCreate: allocated wall_adm at 046D73A8
MBUF state OFF
Sat Nov 01 09:43:37 2008
EmInit: MmSetImplementation( 2 ).
<ES> client 0 initializing ....
<ES> InitFreeList
<ES> block size is 1024 kByte.
Using implementation std
<EsNT> Memory Reset enabled as NT default
<EsNT> EsIUnamFileMapInit: Initialize the memory 561 MB
<ES> 560 blocks reserved for free list.
ES initialized.
rdisp/http_min_wait_dia_wp : 1 -> 1
***LOG Q0K=> DpMsAttach, mscon ( saphse-qa) [dpxxdisp.c 9719]
Sat Nov 01 09:43:38 2008
CCMS: Initalizing shared memory of size 40000000 for monitoring segment.
Sat Nov 01 09:43:39 2008
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 25
Release check o.K.
Sat Nov 01 09:44:18 2008
ERROR => W1 (pid 2492) died [dpxxdisp.c 12170]
ERROR => W8 (pid 2888) died [dpxxdisp.c 12170]
ERROR => W9 (pid 2980) died [dpxxdisp.c 12170]
my types changed after wp death/restart 0xbf --> 0xbb
ERROR => W11 (pid 684) died [dpxxdisp.c 12170]
ERROR => W14 (pid 2156) died [dpxxdisp.c 12170]
Sat Nov 01 09:44:56 2008
ERROR => OpenProcess PID 2892 failed for checking semaphore 4
ERROR_INVALID_PARAMETER: The parameter is incorrect. [semnt.c 1908]
ERROR => W2 (pid 2528) died [dpxxdisp.c 12170]
ERROR => W3 (pid 2540) died [dpxxdisp.c 12170]
ERROR => W4 (pid 2532) died [dpxxdisp.c 12170]
ERROR => W5 (pid 2860) died [dpxxdisp.c 12170]
ERROR => W6 (pid 2848) died [dpxxdisp.c 12170]
ERROR => W7 (pid 2892) died [dpxxdisp.c 12170]
my types changed after wp death/restart 0xbb --> 0xb9
ERROR => W13 (pid 1720) died [dpxxdisp.c 12170]
my types changed after wp death/restart 0xb9 --> 0x99
Sat Nov 01 09:45:16 2008
ERROR => W0 (pid 2448) died [dpxxdisp.c 12170]
my types changed after wp death/restart 0x99 --> 0x9b
ERROR => W2 (pid 2528) died [dpxxdisp.c 12170]
ERROR => W5 (pid 2860) died [dpxxdisp.c 12170]
my types changed after wp death/restart 0x9b --> 0x9a
ERROR => W6 (pid 2848) died [dpxxdisp.c 12170]
ERROR => W7 (pid 2892) died [dpxxdisp.c 12170]
my types changed after wp death/restart 0x9a --> 0x98
ERROR => W10 (pid 3004) died [dpxxdisp.c 12170]
my types changed after wp death/restart 0x98 --> 0x90
ERROR => W12 (pid 2816) died [dpxxdisp.c 12170]
my types changed after wp death/restart 0x90 --> 0x80
DP_FATAL_ERROR => DpWPCheck: no more work processes
DISPATCHER EMERGENCY SHUTDOWN ***
increase tracelevel of WPs
killing W0-2448 (SIGUSR2)
ERROR => DpWpKill(2448, SIGUSR2) failed [dpxxtool.c 2468]
killing W1-2492 (SIGUSR2)
ERROR => DpWpKill(2492, SIGUSR2) failed [dpxxtool.c 2468]
killing W2-2528 (SIGUSR2)
ERROR => DpWpKill(2528, SIGUSR2) failed [dpxxtool.c 2468]
killing W3-2540 (SIGUSR2)
ERROR => DpWpKill(2540, SIGUSR2) failed [dpxxtool.c 2468]
killing W4-2532 (SIGUSR2)
ERROR => DpWpKill(2532, SIGUSR2) failed [dpxxtool.c 2468]
killing W5-2860 (SIGUSR2)
ERROR => DpWpKill(2860, SIGUSR2) failed [dpxxtool.c 2468]
killing W6-2848 (SIGUSR2)
ERROR => DpWpKill(2848, SIGUSR2) failed [dpxxtool.c 2468]
killing W7-2892 (SIGUSR2)
ERROR => DpWpKill(2892, SIGUSR2) failed [dpxxtool.c 2468]
killing W8-2888 (SIGUSR2)
ERROR => DpWpKill(2888, SIGUSR2) failed [dpxxtool.c 2468]
killing W9-2980 (SIGUSR2)
ERROR => DpWpKill(2980, SIGUSR2) failed [dpxxtool.c 2468]
killing W10-3004 (SIGUSR2)
ERROR => DpWpKill(3004, SIGUSR2) failed [dpxxtool.c 2468]
killing W11-684 (SIGUSR2)
ERROR => DpWpKill(684, SIGUSR2) failed [dpxxtool.c 2468]
killing W12-2816 (SIGUSR2)
ERROR => DpWpKill(2816, SIGUSR2) failed [dpxxtool.c 2468]
killing W13-1720 (SIGUSR2)
ERROR => DpWpKill(1720, SIGUSR2) failed [dpxxtool.c 2468]
killing W14-2156 (SIGUSR2)
ERROR => DpWpKill(2156, SIGUSR2) failed [dpxxtool.c 2468]
NiWait: sleep (10000 msecs) ...
NiISelect: timeout 10000 ms
NiISelect: maximum fd=1561
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Sat Nov 01 09:45:26 2008
NiISelect: TIMEOUT occured (10000 ms)
dump system status
Workprocess Table (long) Sat Nov 01 06:45:26 2008
========================
No Ty. Pid Status Cause Start Err Sem CPU Time Program Cl User Action Table
-
0 DIA 2448 Ended no 1 0 0
1 DIA 2492 Ended no 1 0 0
2 DIA 2528 Ended no 2 0 0
3 DIA 2540 Ended no 1 0 0
4 DIA 2532 Ended no 1 0 0
5 DIA 2860 Ended no 2 0 0
6 UPD 2848 Ended no 2 0 0
7 UPD 2892 Ended no 2 0 0
8 UPD 2888 Ended no 1 0 0
9 ENQ 2980 Ended no 1 0 0
10 BTC 3004 Ended no 1 0 0
11 BTC 684 Ended no 1 0 0
12 SPO 2816 Ended no 1 0 0
13 UP2 1720 Ended no 1 0 0
14 UP2 2156 Ended no 1 0 0
Dispatcher Queue Statistics Sat Nov 01 06:45:26 2008
===========================
--------
+
Typ | now | high | max | writes | reads |
--------
+
NOWP | 0 | 4 | 2000 | 25 | 25 |
--------
+
DIA | 0 | 4 | 2000 | 6 | 6 |
--------
+
UPD | 0 | 0 | 2000 | 0 | 0 |
--------
+
ENQ | 0 | 0 | 2000 | 0 | 0 |
--------
+
BTC | 0 | 0 | 2000 | 0 | 0 |
--------
+
SPO | 0 | 1 | 2000 | 1 | 1 |
--------
+
UP2 | 0 | 0 | 2000 | 0 | 0 |
--------
+
max_rq_id 30
wake_evt_udp_now 0
wake events total 26, udp 21 ( 80%), shm 5 ( 19%)
since last update total 26, udp 21 ( 80%), shm 5 ( 19%)
Dump of tm_adm structure: Sat Nov 01 06:45:26 2008
=========================
Term uid man user term lastop mod wp ta a/i (modes)
EX-T15, U16, , 192.168.0.123, 09:44:32, M0, W-1, , 1/0
Workprocess Comm. Area Blocks Sat Nov 01 06:45:26 2008
=============================
Slots: 300, Used: 0, Max: 0
--------
+
id | owner | pid | eyecatcher |
--------
+
0 | DISPATCHER | -1 | WPCAAD000 |
NiWait: sleep (5000 msecs) ...
NiISelect: timeout 5000 ms
NiISelect: maximum fd=1561
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Sat Nov 01 09:45:31 2008
NiISelect: TIMEOUT occured (5000 ms)
Shutdown server ...
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 (2764) (SOFT_KILL)
Stop icman
killing process (2468) (SOFT_KILL)
Terminate gui connections
[DpProcDied] Process lives (PID:2764 HANDLE:1540)
waiting for termination of gateway
NiWait: sleep (1000 msecs) ...
NiISelect: timeout 1000 ms
NiISelect: maximum fd=1561
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Sat Nov 01 09:45:32 2008
NiISelect: TIMEOUT occured (1000 ms)
[DpProcDied] Process died (PID:2764 HANDLE:1540)
[DpProcDied] Process lives (PID:2468 HANDLE:1528)
waiting for termination of icman
NiWait: sleep (1000 msecs) ...
NiISelect: timeout 1000 ms
NiISelect: maximum fd=1561
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Sat Nov 01 09:45:33 2008
NiISelect: TIMEOUT occured (1000 ms)
[DpProcDied] Process lives (PID:2468 HANDLE:1528)
waiting for termination of icman
NiWait: sleep (1000 msecs) ...
NiISelect: timeout 1000 ms
NiISelect: maximum fd=1561
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Sat Nov 01 09:45:34 2008
NiISelect: TIMEOUT occured (1000 ms)
[DpProcDied] Process lives (PID:2468 HANDLE:1528)
waiting for termination of icman
NiWait: sleep (1000 msecs) ...
NiISelect: timeout 1000 ms
NiISelect: maximum fd=1561
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Sat Nov 01 09:45:35 2008
NiISelect: TIMEOUT occured (1000 ms)
[DpProcDied] Process lives (PID:2468 HANDLE:1528)
waiting for termination of icman
NiWait: sleep (1000 msecs) ...
NiISelect: timeout 1000 ms
NiISelect: maximum fd=1561
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Sat Nov 01 09:45:36 2008
NiISelect: TIMEOUT occured (1000 ms)
[DpProcDied] Process lives (PID:2468 HANDLE:1528)
waiting for termination of icman
NiWait: sleep (1000 msecs) ...
NiISelect: timeout 1000 ms
NiISelect: maximum fd=1561
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Sat Nov 01 09:45:37 2008
NiISelect: TIMEOUT occured (1000 ms)
[DpProcDied] Process lives (PID:2468 HANDLE:1528)
waiting for termination of icman
NiWait: sleep (1000 msecs) ...
NiISelect: timeout 1000 ms
NiISelect: maximum fd=1561
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Sat Nov 01 09:45:38 2008
NiISelect: TIMEOUT occured (1000 ms)
[DpProcDied] Process lives (PID:2468 HANDLE:1528)
waiting for termination of icman
NiWait: sleep (1000 msecs) ...
NiISelect: timeout 1000 ms
NiISelect: maximum fd=1561
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Sat Nov 01 09:45:39 2008
NiISelect: TIMEOUT occured (1000 ms)
[DpProcDied] Process lives (PID:2468 HANDLE:1528)
waiting for termination of icman
NiWait: sleep (1000 msecs) ...
NiISelect: timeout 1000 ms
NiISelect: maximum fd=1561
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Sat Nov 01 09:45:40 2008
NiISelect: TIMEOUT occured (1000 ms)
[DpProcDied] Process lives (PID:2468 HANDLE:1528)
waiting for termination of icman
NiWait: sleep (1000 msecs) ...
NiISelect: timeout 1000 ms
NiISelect: maximum fd=1561
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Sat Nov 01 09:45:41 2008
NiISelect: TIMEOUT occured (1000 ms)
[DpProcDied] Process lives (PID:2468 HANDLE:1528)
waiting for termination of icman
NiWait: sleep (1000 msecs) ...
NiISelect: timeout 1000 ms
NiISelect: maximum fd=1561
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Sat Nov 01 09:45:42 2008
NiISelect: TIMEOUT occured (1000 ms)
[DpProcDied] Process died (PID:2468 HANDLE:1528)
DpHalt: cancel all lcom connections
MPI CancelAll 2 -> 0
MPI DeleteAll 2 -> 0
NiIMyHostName: hostname = 'saphse-qa'
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 -
detach from message server
***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c 9945]
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
AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0
blks_in_queue/wp_ca_blk_no/wp_max_no = 0/300/15
LOCK WP ca_blk 1
make DISP owner of wp_ca_blk 1
DpRqPutIntoQueue: put request into queue (reqtype 1, prio LOW, rq_id 36)
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 1548
MsIDetach: detach MS-system
EsCleanup ....
***LOG Q05=> DpHalt, DPStop ( 900) [dpxxdisp.c 8478]
Good Bye .....
This is the log of (dev_w0)
-
trc file: "dev_w0", trc level: 1, release: "640"
-
*
ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, M
*
B
B Sat Nov 01 09:43:38 2008
B create_con (con_name=R/3)
B Loading DB library 'E:\usr\sap\HSQ\SYS\exe\run\dbmssslib.dll' ...
B Library 'E:\usr\sap\HSQ\SYS\exe\run\dbmssslib.dll' loaded
B Version of 'E:\usr\sap\HSQ\SYS\exe\run\dbmssslib.dll' is "640.00", patchlevel (0.26)
B New connection 0 created
M systemid 560 (PC with Windows NT)
M relno 6400
M patchlevel 0
M patchno 25
M intno 20020600
M make: multithreaded, ASCII
M pid 2448
M
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 2448) [dpxxdisp.c 1160]
I MtxInit: -2 0 0
M DpSysAdmExtCreate: ABAP is active
M DpSysAdmExtCreate: JAVA is not active
M DpShMCreate: sizeof(wp_adm) 12424 (828)
M DpShMCreate: sizeof(tm_adm) 2219848 (11044)
M DpShMCreate: sizeof(wp_ca_adm) 18000 (60)
M DpShMCreate: sizeof(appc_ca_adm) 6000 (60)
M DpShMCreate: sizeof(comm_adm) 192000 (384)
M DpShMCreate: sizeof(vmc_adm) 0 (320)
M DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)
M DpShMCreate: SHM_DP_ADM_KEY (addr: 04480040, size: 2511216)
M DpShMCreate: allocated sys_adm at 04480040
M DpShMCreate: allocated wp_adm at 044817A8
M DpShMCreate: allocated tm_adm_list at 04484830
M DpShMCreate: allocated tm_adm at 04484858
M DpShMCreate: allocated wp_ca_adm at 046A27A0
M DpShMCreate: allocated appc_ca_adm at 046A6DF0
M DpShMCreate: allocated comm_adm_list at 046A8560
M DpShMCreate: allocated comm_adm at 046A8578
M DpShMCreate: allocated vmc_adm_list at 046D7378
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 046D73A0
M DpShMCreate: allocated wall_adm at 046D73A8
X
X Sat Nov 01 09:43:39 2008
X EmInit: MmSetImplementation( 2 ).
X <ES> client 0 initializing ....
X Using implementation std
M <EsNT> Memory Reset enabled as NT default
X ES initialized.
M calling db_connect ...
C Thank You for using the SLOLEDB-interface
C Using dynamic link library 'E:\usr\sap\HSQ\SYS\exe\run\dbmssslib.dll'
C dbmssslib.dll patch info
C patchlevel 0
C patchno 26
C patchcomment MSSQL: GetNextMsst1 error (754819)
C np:(local) connection used on SAPHSE-QA
C
C Sat Nov 01 09:43:41 2008
C Failed to initialize provider SQLNCLI. See note #734034 for more information.
C Using provider SQLOLEDB instead.
C Provider Release:08.10.3959
C Failed to initialize provider SQLNCLI. See note #734034 for more information.
C Using provider SQLOLEDB instead.
C Cache sizes: header 52 bytes, 20000 names (26720000 bytes), 1000 dynamic statements (5432000 bytes), total 32152052 bytes
C Initializing shared procedure name cache SAPHSE-QA_HSQHSQ_HSQ_MEM.
C procedure cache created/attached
C
C Sat Nov 01 09:43:51 2008
C Connected to db server : [SAPHSE-QA] server_used : [np:(local)], dbname: HSQ, dbuser: hsq
C pn_id:SAPHSE-QA_HSQHSQ_HSQ
B Connection 0 opened
B Wp Hdl ConName ConId ConState TX PRM RCT MAX OPT Date Time DBHost
B 000 000 R/3 000000000 ACTIVE NO YES NO 255 255 20081101 094339 SAPHSE-QA
C The IRow interface is supported by this OLEDB provider
M db_connect o.k.
M
M Sat Nov 01 09:43:56 2008
M CrtChkOsSem: create check mutex and RC=[already exists] (Key:4/Name:SAP_SYSTEM_MUTEX_0_4/Hdl:1272)
I
I Sat Nov 01 09:45:06 2008
I *** ERROR => OpenProcess PID 3004 failed for checking semaphore 4
ERROR_INVALID_PARAMETER: The parameter is incorrect. [semnt.c 1908]
I MtxInit: 0 0 0
M SHM_PRES_BUF (addr: 09A30040, size: 4400000)
M SHM_ROLL_AREA (addr: 781B0040, size: 68812800)
M SHM_PAGING_AREA (addr: 09E70040, size: 35717120)
M SHM_ROLL_ADM (addr: 0C090040, size: 688570)
M SHM_PAGING_ADM (addr: 0C140040, size: 525344)
M ThCreateNoBuffer allocated 320144 bytes for 1000 entries at 0C1D0040
M ThCreateNoBuffer index size: 3000 elems
M ThCreateVBAdm allocated 7424 bytes (50 server) at 0C220040
X EmInit: MmSetImplementation( 2 ).
X <ES> client 0 initializing ....
X Using implementation std
X ES initialized.
C The IRow interface is supported by this OLEDB provider
B db_con_shm_ini: WP_ID = 0, WP_CNT = 15
C Failed to initialize provider SQLNCLI. See note #734034 for more information.
C Using provider SQLOLEDB instead.
B
B Sat Nov 01 09:45:07 2008
B dbtbxbuf: Buffer TABL (addr: 115D00C8, size: 30000000, end: 1326C448)
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 = 14529984
B ***LOG BB0=> buffer TABL started with length 30000000 bytes [dbtbxbuf#6 @ 15692] [dbtbxbuf1569 2]
B dbtbxbuf: Buffer TABLP (addr: 0EEB00C8, size: 10240000, end: 0F8740C8)
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 = 5068224
B ***LOG BB0=> buffer TABLP started with length 10240000 bytes [dbtbxbuf#6 @ 15692] [dbtbxbuf1569 2]
B dbtbxbuf: Reading TBX statistics:
B dbtbxbuf: Opening E:\usr\sap\HSQ\DVEBMGS00\data\tbxnew failed (No such file or directory).
B dbtbxbuf: Renaming E:\usr\sap\HSQ\DVEBMGS00\data\tbxnew to E:\usr\sap\HSQ\DVEBMGS00\data\tbxstat failed (No such file or directory).
B dbtbxbuf: 0 object entries precreated
B Layout of EIBUF buffer shared memory:
B 0: 1 * 4 = 4
B 1: 1 * 288 = 288
B 2: 15 * 20 = 300
B 3: 4001 * 40 = 160040
B 4: 2000 * 136 = 272000
B 5: 4001 * 4 = 16004
B 6: 1 * 200 = 200
B 7: 65 * 4 = 260
B 8: 29259 * 128 = 3745152
B Tracing = 0, Shm Protection = 0, Force checks = 0
B dbexpbuf: Buffer EIBUF (addr: 0F8900D0, size: 4194304, end: 0FC900D0)
B ***LOG BB0=> buffer EIBUF started with length 4096k bytes [dbexpbuf#5 @ 2322] [dbexpbuf2322 ]
B Layout of ESM buffer shared memory:
B 0: 1 * 4 = 4
B 1: 1 * 288 = 288
B 2: 15 * 20 = 300
B 3: 4001 * 40 = 160040
B 4: 2000 * 136 = 272000
B 5: 4001 * 4 = 16004
B 6: 1 * 200 = 200
B 7: 65 * 4 = 260
B 8: 29259 * 128 = 3745152
B Tracing = 0, Shm Protection = 0, Force checks = 0
B dbexpbuf: Buffer ESM (addr: 132700D0, size: 4194304, end: 136700D0)
B ***LOG BB0=> buffer ESM started with length 4096k bytes [dbexpbuf#5 @ 2322] [dbexpbuf2322 ]
B Layout of CUA buffer shared memory:
B 0: 1 * 4 = 4
B 1: 1 * 288 = 288
B 2: 15 * 20 = 300
B 3: 3001 * 40 = 120040
B 4: 1500 * 136 = 204000
B 5: 3001 * 4 = 12004
B 6: 1 * 200 = 200
B 7: 193 * 4 = 772
B 8: 10681 * 256 = 2734336
B Tracing = 0, Shm Protection = 0, Force checks = 0
B dbexpbuf: Buffer CUA (addr: 0FCA00D0, size: 3072000, end: 0FF8E0D0)
B ***LOG BB0=> buffer CUA started with length 3000k bytes [dbexpbuf#5 @ 2322] [dbexpbuf2322 ]
B Layout of OTR buffer shared memory:
B 0: 1 * 4 = 4
B 1: 1 * 288 = 288
B 2: 15 * 20 = 300
B 3: 4001 * 40 = 160040
B 4: 2000 * 136 = 272000
B 5: 4001 * 4 = 16004
B 6: 1 * 200 = 200
B 7: 81 * 4 = 324
B 8: 29258 * 128 = 3745024
B Tracing = 0, Shm Protection = 0, Force checks = 0
B dbexpbuf: Buffer OTR (addr: 136800D0, size: 4194304, end: 13A800D0)
B ***LOG BB0=> buffer OTR started with length 4096k bytes [dbexpbuf#5 @ 2322] [dbexpbuf2322 ]
B ***LOG BB0=> buffer CALE started with length 500000 bytes [dbcalbuf#1 @ 2206] [dbcalbuf2206 ]
B *** ERROR => missing return code handler
caller does not handle code 256 from dbntab#7[3124]
==> calling sap_dext to abort transaction
[dbeh.c 93]
M -
C-STACK -
SAP (R) - R/3(TM) Callstack, Version 1.0
Copyright (C) SAP AG. All rights reserved.
-
Callstack without Exception:
App : disp+work.EXE (pid=2448)
When : 11/1/2008 9:45:7.437
Threads : 2
-
Computer Name : SAPHSE-QA
User Name : SAPServiceHSQ
-
Number of Processors: 2
Processor Type: x86 Family 6 Model 15 Stepping 13
Windows Version : 5.2 Current Build: 3790
-
State Dump for Thread Id 9b8
eax=00000000 ebx=00000000 ecx=0000066a edx=00052b4a esi=003f6004 edi=003f5fd8
eip=7c8285ec esp=0300f570 ebp=0300f580 iopl=0 nv up ei pl nz ac po nc
cs=001b ss=0023 ds=0023 es=0023 fs=003b gs=0000 efl=00000216
function : KiFastSystemCallRet
7c8285ec c3 ret
7c8285ed 8da42400000000 lea esp,[esp] ss:0300f570=7c8285f4
7c8285f4 8d642400 lea esp,[esp] ss:0601e03f=00000000
--> Stack Back Trace <--
FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
0300f580 003f5fd8 00000000 00000001 0192d324 000009b8 ntdll!KiFastSystemCallRet
00000000 00000000 00000000 00000000 00000000 00000000 <nosymbols>
-
State Dump for Thread Id bd4
eax=019c7164 ebx=00000103 ecx=057dfea4 edx=00000000 esi=00000000 edi=00000000
eip=7c8285ec esp=057dfeb0 ebp=057dfef4 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:057dfeb0=7c8270fb
7c8285f4 8d642400 lea esp,[esp] ss:087ee97f=00000000
--> Stack Back Trace <--
FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
057dfef4 00fc37ec 000006a0 00000000 00000000 041b3fb8 ntdll!KiFastSystemCallRet
057dff84 7c36b381 00000000 00000000 00000000 041b3e88 disp+work!SigIMsgFunc [signt.c (559)]
057dffb8 77e64829 041b3e88 00000000 00000000 041b3e88 MSVCR71!endthreadex
057dffec 00000000 7c36b312 041b3e88 00000000 00000000 kernel32!GetModuleHandleA
-
M -
M ***LOG R1B=> ThControl, sap_dext-call (00 ) [thxxdynp.c 355]
M in_ThErrHandle: 1
M *** ERROR => ThControl: illegal sap_dext call !!! (step 1, th_errno 5, action 1, level 1) [thxxhead.c 9379]
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 saphse-qa_HSQ_00 on host saphse-qa (wp 0)
M * ERROR ThControl: illegal sap_dext call !!!
M *
M * TIME Sat Nov 01 09:45:07 2008
M * RELEASE 640
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 5
M * MODULE thxxhead.c
M * LINE 9555
M * COUNTER 1
M *
M *****************************************************************************
M
M Entering ThSetStatError
M Entering ThReadDetachMode
M ThISend: still inside critical section semaphore ?
Hello Manoj,
The kernal release which i was using was 620, then i upgraded the kernal to 640 and tried again but failed to up the SAP.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I still dont understand why exactly the SAP is not coming up.
I have searched for these things over the internet but fail to get the solution.
What could be the reason??
Regards,
Mudassir.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
find help on these error message on the Internet:
current SQL statement exceeds a database limit.
invalid cursor specified 65535 for database selection
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.