on 05-18-2011 9:05 AM
hi Dear,
I have installed solman with Max db on window server 2003. the commands (db_offlne, db_stop,db_online and db_stop) are working fine in DBM Command Line Interface.
while the dispatcher stopped in SAPMMC.
trc file: "dev_disp", trc level: 1, release: "701"
sysno 00
sid SOL
systemid 562 (PC with Windows NT)
relno 7010
patchlevel 0
patchno 32
intno 20020600
make: multithreaded, Unicode, 64 bit, optimized
pid 3984
Wed May 18 12:52:23 2011
kernel runs with dp version 241000(ext=110000) (@(#) DPLIB-INT-VERSION-241000-UC)
length of sys_adm_ext is 576 bytes
*** SWITCH TRC-HIDE on ***
***LOG Q00=> DpSapEnvInit, DPStart (00 3984) [dpxxdisp.c 1286]
shared lib "dw_xml.dll" version 32 successfully loaded
shared lib "dw_xtc.dll" version 32 successfully loaded
shared lib "dw_stl.dll" version 32 successfully loaded
shared lib "dw_gui.dll" version 32 successfully loaded
shared lib "dw_mdm.dll" version 32 successfully loaded
rdisp/softcancel_sequence : -> 0,5,-1
use internal message server connection to port 3900
Wed May 18 12:52:29 2011
*** WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 5 seconds
***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c 5529]
MtxInit: 30000 0 0
DpSysAdmExtInit: ABAP is active
DpSysAdmExtInit: VMC (JAVA VM in WP) is not active
DpIPCInit2: start server >solman_SOL_00 <
DpShMCreate: sizeof(wp_adm) 47312 (1752)
DpShMCreate: sizeof(tm_adm) 5912704 (29416)
DpShMCreate: sizeof(wp_ca_adm) 24064 (80)
DpShMCreate: sizeof(appc_ca_adm) 8000 (80)
DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080
DpShMCreate: sizeof(comm_adm) 552080 (1088)
DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0
DpShMCreate: sizeof(slock_adm) 0 (104)
DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
DpShMCreate: sizeof(file_adm) 0 (72)
DpShMCreate: sizeof(vmc_adm) 0 (1864)
DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)
DpShMCreate: sizeof(gw_adm) 48
DpShMCreate: SHM_DP_ADM_KEY (addr: 0000000007190050, size: 6631664)
DpShMCreate: allocated sys_adm at 0000000007190050
DpShMCreate: allocated wp_adm at 0000000007192270
DpShMCreate: allocated tm_adm_list at 000000000719DB40
DpShMCreate: allocated tm_adm at 000000000719DBA0
DpShMCreate: allocated wp_ca_adm at 0000000007741420
DpShMCreate: allocated appc_ca_adm at 0000000007747220
DpShMCreate: allocated comm_adm at 0000000007749160
DpShMCreate: system runs without slock table
DpShMCreate: system runs without file table
DpShMCreate: allocated vmc_adm_list at 00000000077CFDF0
DpShMCreate: allocated gw_adm at 00000000077CFE70
DpShMCreate: system runs without vmc_adm
DpShMCreate: allocated ca_info at 00000000077CFEA0
DpShMCreate: allocated wall_adm at 00000000077CFEB0
MBUF state OFF
DpCommInitTable: init table for 500 entries
rdisp/queue_size_check_value : -> off
ThTaskStatus: rdisp/reset_online_during_debug 0
EmInit: MmSetImplementation( 2 ).
MM global diagnostic options set: 0
<ES> client 0 initializing ....
<ES> InitFreeList
<ES> block size is 4096 kByte.
<ES> Info: em/initial_size_MB( 11263MB) not multiple of em/blocksize_KB( 4096KB)
<ES> Info: em/initial_size_MB rounded up to 11264MB
Using implementation view
<EsNT> Using memory model view.
<EsNT> Memory Reset disabled as NT default
<ES> 2815 blocks reserved for free list.
ES initialized.
J2EE server info
start = TRUE
state = STARTED
pid = 1576
argv[0] = E:\usr\sap\SOL\DVEBMGS00\exe\jcontrol.EXE
argv[1] = E:\usr\sap\SOL\DVEBMGS00\exe\jcontrol.EXE
argv[2] = pf=E:\usr\sap\SOL\SYS\profile\SOL_DVEBMGS00_solman
argv[3] = -DSAPSTART=1
argv[4] = -DCONNECT_PORT=65000
argv[5] = -DSAPSYSTEM=00
argv[6] = -DSAPSYSTEMNAME=SOL
argv[7] = -DSAPMYNAME=solman_SOL_00
argv[8] = -DSAPPROFILE=E:\usr\sap\SOL\SYS\profile\SOL_DVEBMGS00_solman
argv[9] = -DFRFC_FALLBACK=ON
argv[10] = -DFRFC_FALLBACK_HOST=localhost
start_lazy = 0
start_control = SAP J2EE startup framework
DpJ2eeStart: j2ee state = STARTED
Wed May 18 12:52:31 2011
rdisp/http_min_wait_dia_wp : 1 -> 1
***LOG CPS=> DpLoopInit, ICU ( 3.0 3.0 4.0.1) [dpxxdisp.c 1681]
***LOG Q0K=> DpMsAttach, mscon ( solman) [dpxxdisp.c 12483]
DpStartStopMsg: send start message (myname is >solman_SOL_00 <)
DpStartStopMsg: start msg sent
CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.
Wed May 18 12:52:32 2011
CCMS: start to initalize 3.X shared alert area (first segment).
DpJ2eeLogin: j2ee state = CONNECTED
DpMsgAdmin: Set release to 7010, patchlevel 0
MBUF state PREPARED
MBUF component UP
DpMBufHwIdSet: set Hardware-ID
***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c 1048]
DpMsgAdmin: Set patchno for this platform to 32
Release check o.K.
Wed May 18 12:52:35 2011
***LOG Q0I=> NiIRead: recv (10054: WSAECONNRESET: Connection reset by peer) [nixxi.cpp 4436]
*** ERROR => NiIRead: SiRecv failed for hdl 4 / sock 168
(SI_ECONN_BROKEN/10054; I4; ST; 127.0.0.1:1167) [nixxi.cpp 4436]
*** ERROR => DpJ2eeMsgProcess: NiRead failed (NIECONN_BROKEN) [dpxxj2ee.c 1212]
DpJ2eeMsgProcess: j2ee state = CONNECTED (NIECONN_BROKEN)
Wed May 18 12:53:11 2011
my types changed after wp death/restart 0xbf --> 0xbe
my types changed after wp death/restart 0xbe --> 0xbc
my types changed after wp death/restart 0xbc --> 0xb8
my types changed after wp death/restart 0xb8 --> 0xb0
my types changed after wp death/restart 0xb0 --> 0xa0
my types changed after wp death/restart 0xa0 --> 0x80
*** DP_FATAL_ERROR => DpWPCheck: no more work processes
*** DISPATCHER EMERGENCY SHUTDOWN ***
increase tracelevel of WPs
NiWait: sleep (10000ms) ...
NiISelect: timeout 10000ms
NiISelect: maximum fd=369
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed May 18 12:53:21 2011
NiISelect: TIMEOUT occured (10000ms)
dump system status
Workprocess Table (long) Wed May 18 07:53:21 2011
========================
No Ty. Pid Status Cause Start Err Sem CPU Time Program Cl User Action Table
-------------------------------------------------------------------------------------------------------------------------------
0 DIA 916 Ended no 1 0 0
1 DIA 1648 Ended no 1 0 0
2 DIA 1680 Ended no 1 0 0
3 DIA 1788 Ended no 1 0 0
4 DIA 1916 Ended no 1 0 0
5 DIA 1948 Ended no 1 0 0
6 DIA 1956 Ended no 1 0 0
7 DIA 1976 Ended no 1 0 0
8 DIA 2024 Ended no 1 0 0
9 DIA 2036 Ended no 1 0 0
10 DIA 1936 Ended no 1 0 0
11 DIA 3236 Ended no 1 0 0
12 DIA 3264 Ended no 1 0 0
13 DIA 3272 Ended no 1 0 0
14 DIA 3284 Ended no 1 0 0
15 DIA 3288 Ended no 1 0 0
16 DIA 3300 Ended no 1 0 0
17 DIA 3308 Ended no 1 0 0
18 DIA 3316 Ended no 1 0 0
19 DIA 2020 Ended no 1 0 0
20 UPD 3748 Ended no 1 0 0
21 ENQ 3768 Ended no 1 0 0
22 BTC 3152 Ended no 1 0 0
23 BTC 4072 Ended no 1 0 0
24 BTC 492 Ended no 1 0 0
25 SPO 4192 Ended no 1 0 0
26 UP2 4284 Ended no 1 0 0
Dispatcher Queue Statistics Wed May 18 07:53:21 2011
===========================
+------+--------+--------+--------+--------+--------+
| Typ | now | high | max | writes | reads |
+------+--------+--------+--------+--------+--------+
| NOWP | 0 | 4 | 2000 | 5 | 5 |
+------+--------+--------+--------+--------+--------+
| DIA | 5 | 5 | 2000 | 5 | 0 |
+------+--------+--------+--------+--------+--------+
| UPD | 0 | 0 | 2000 | 0 | 0 |
+------+--------+--------+--------+--------+--------+
| ENQ | 0 | 0 | 2000 | 0 | 0 |
+------+--------+--------+--------+--------+--------+
| BTC | 0 | 0 | 2000 | 0 | 0 |
+------+--------+--------+--------+--------+--------+
| SPO | 0 | 0 | 2000 | 0 | 0 |
+------+--------+--------+--------+--------+--------+
| UP2 | 0 | 0 | 2000 | 0 | 0 |
+------+--------+--------+--------+--------+--------+
max_rq_id 12
wake_evt_udp_now 0
wake events total 8, udp 2 ( 25%), shm 6 ( 75%)
since last update total 8, udp 2 ( 25%), shm 6 ( 75%)
Dump of tm_adm structure: Wed May 18 07:53:21 2011
=========================
Term uid man user term lastop mod wp ta a/i (modes)
Workprocess Comm. Area Blocks Wed May 18 07:53:21 2011
=============================
Slots: 300, Used: 1, Max: 0
+------+--------------+----------+-------------+
| id | owner | pid | eyecatcher |
+------+--------------+----------+-------------+
| 0 | DISPATCHER | -1 | *WPCAAD000* |
NiWait: sleep (5000ms) ...
NiISelect: timeout 5000ms
NiISelect: maximum fd=369
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed May 18 12:53:26 2011
NiISelect: TIMEOUT occured (5000ms)
DpHalt: shutdown server >solman_SOL_00 < (normal)
DpJ2eeDisableRestart
MsIDelService: delete service J2EE for myself
NiBufSend starting
NiIWrite: hdl 3 sent data (wrt=161,pac=1,MESG_IO)
MsINiWrite: sent 161 bytes
send msg (len 110+51) to name MSG_SERVER, type 0, key -
MsSndName: MS_DEL_PROPERTY ok
Send 51 bytes to MSG_SERVER
MS_DEL_PROPERTY : asynchronous call
send MsDelService(J2EE) to msgserver
DpIJ2eeShutdown: send SIGINT to SAP J2EE startup framework (pid=1576)
killing process (1576) (SOFT_KILL)
*** ERROR => DpProcKill: kill failed [dpntdisp.c 371]
DpIJ2eeShutdown: j2ee state = SHUTDOWN
SiSelNClear: set events of sock 324 to: ---
SiSelNRemove: removed sock 324 (pos=2)
SiSelNRemove: removed sock 324
NiSelIRemove: removed hdl 2
DpDelSocketInfo: del info for socket 2 (type=7)
NiICloseHandle: shutdown and close hdl 2 / sock 324 - sock -1
DpModState: buffer in state MBUF_PREPARED
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 = 1/300/27
LOCK WP ca_blk 1
make DISP owner of wp_ca_blk 1
DpRqPutIntoQueue: put request into queue (reqtype 1, prio LOW, rq_id 15)
MBUF component DOWN
NiICloseHandle: shutdown and close hdl 3 / sock 192
NiBufIClose: clear extension for hdl 3
MsIDetach: detach MS-system
cleanup EM
EsCleanup ....
EmCleanup() -> 0
Es2Cleanup: Cleanup ES2
***LOG Q05=> DpHalt, DPStop ( 3984) [dpxxdisp.c 11045]
Good Bye .....
Regards,
> my types changed after wp death/restart 0xbf --> 0xbe
> my types changed after wp death/restart 0xbe --> 0xbc
> my types changed after wp death/restart 0xbc --> 0xb8
> my types changed after wp death/restart 0xb8 --> 0xb0
> my types changed after wp death/restart 0xb0 --> 0xa0
> my types changed after wp death/restart 0xa0 --> 0x80
Your workprocesses are dying, check dev_w0
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Markus,
thanks for reply...please see below WP log..
-
trc file: "dev_w0", trc level: 1, release: "701"
-
*
ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, MJ
*
B
B Wed May 18 16:00:42 2011
B create_con (con_name=R/3)
B Loading DB library 'E:\usr\sap\SOL\DVEBMGS00\exe\dbsdbslib.dll' ...
B Library 'E:\usr\sap\SOL\DVEBMGS00\exe\dbsdbslib.dll' loaded
B Version of 'E:\usr\sap\SOL\DVEBMGS00\exe\dbsdbslib.dll' is "700.08", patchlevel (0.24)
B New connection 0 created
M sysno 00
M sid SOL
M systemid 562 (PC with Windows NT)
M relno 7010
M patchlevel 0
M patchno 32
M intno 20020600
M make: multithreaded, Unicode, 64 bit, optimized
M pid 2896
M
M kernel runs with dp version 241000(ext=110000) (@(#) DPLIB-INT-VERSION-241000-UC)
M length of sys_adm_ext is 576 bytes
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 2896) [dpxxdisp.c 1348]
I MtxInit: 30000 0 0
M DpSysAdmExtCreate: ABAP is active
M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active
M DpShMCreate: sizeof(wp_adm) 47312 (1752)
M DpShMCreate: sizeof(tm_adm) 5912704 (29416)
M DpShMCreate: sizeof(wp_ca_adm) 24064 (80)
M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)
M DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080
M DpShMCreate: sizeof(comm_adm) 552080 (1088)
M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0
M DpShMCreate: sizeof(slock_adm) 0 (104)
M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
M DpShMCreate: sizeof(file_adm) 0 (72)
M DpShMCreate: sizeof(vmc_adm) 0 (1864)
M DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)
M DpShMCreate: sizeof(gw_adm) 48
M DpShMCreate: SHM_DP_ADM_KEY (addr: 0000000009190050, size: 6631664)
M DpShMCreate: allocated sys_adm at 0000000009190050
M DpShMCreate: allocated wp_adm at 0000000009192270
M DpShMCreate: allocated tm_adm_list at 000000000919DB40
M DpShMCreate: allocated tm_adm at 000000000919DBA0
M DpShMCreate: allocated wp_ca_adm at 0000000009741420
M DpShMCreate: allocated appc_ca_adm at 0000000009747220
M DpShMCreate: allocated comm_adm at 0000000009749160
M DpShMCreate: system runs without slock table
M DpShMCreate: system runs without file table
M DpShMCreate: allocated vmc_adm_list at 00000000097CFDF0
M DpShMCreate: allocated gw_adm at 00000000097CFE70
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 00000000097CFEA0
M DpShMCreate: allocated wall_adm at 00000000097CFEB0
M
M Wed May 18 16:00:43 2011
M rdisp/queue_size_check_value : -> off
M ThTaskStatus: rdisp/reset_online_during_debug 0
X EmInit: MmSetImplementation( 2 ).
X MM global diagnostic options set: 0
X <ES> client 0 initializing ....
X Using implementation view
X <EsNT> Using memory model view.
M <EsNT> Memory Reset disabled as NT default
X ES initialized.
M ThInit: running on host solman
M
M Wed May 18 16:00:44 2011
M calling db_connect ...
C
C DBSDBSLIB : version 700.08, patch 0.024 (Make PL 0.32)
C MAXDB shared library (dbsdbslib) patchlevels (last 10)
C (0.024) Default value for max. input variables is 2000 (note 655018)
C (0.024) Profile parameter to define max. input variables (note 655018)
C (0.024) Switch SQLMODE after CREATE INDEX SERIAL (note 1267841)
C (0.024) Input parameters for SQL statements increased (note 655018)
C (0.018) Create index serial for MaxDB 7.6 (note 1267841)
C (0.018) More trace in case of packed to string conversion error (note 1262799)
C (0.016) R3trans export aborts with signal 6 (note 1262245)
C (0.009) IA64 alignment errors (note 1245982)
C (0.007) Support DB-Type 'SAP DB' by UPDSTAT (note 1225668)
C
C
C Loading SQLDBC client runtime ...
C SQLDBC SDK Version : SQLDBC.H 7.6.0 BUILD 007-123-091-175
C SQLDBC Library Version : libSQLDBC 7.6.5 BUILD 009-123-191-997
C SQLDBC client runtime is MaxDB 7.6.5.009 CL 191997
C SQLDBC supports new DECIMAL interface : 0
C SQLDBC supports VARIABLE INPUT data : 1
C SQLDBC supports keepAlive indicator : 0
C INFO : SQLOPT= -I 0 -t 0 -S SAPR3
C Try to connect (DEFAULT) on connection 0 ...
C *** ERROR => Connect to database failed, rc = -10709 (Connection failed (RTE:Database name is missing))
[dbsdbsql.cpp 137]
B ***LOG BV3=> severe db error -10709 ; work process is stopped [dbsh#2 @ 1203] [dbsh 1203 ]
B ***LOG BY2=> sql error -10709 performing CON [dblink#3 @ 431] [dblink 0431 ]
B ***LOG BY0=> Connection failed (RTE:Database name is missing) [dblink#3 @ 431] [dblink 0431 ]
M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1449]
M in_ThErrHandle: 1
M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10563]
M
M Info for wp 0
M
M pid = 2896
M severity = 0
M status = 0
M stat = WP_RUN
M waiting_for = NO_WAITING
M reqtype = DP_RQ_DIAWP
M act_reqtype = NO_REQTYPE
M rq_info = 0
M tid = -1
M mode = 255
M len = -1
M rq_id = 65535
M rq_source =
M last_tid = 0
M last_mode = 0
M semaphore = 0
M act_cs_count = 0
M csTrack = 0
M csTrackRwExcl = 0
M csTrackRwShrd = 0
M mode_cleaned_counter = 0
M control_flag = 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 attachedVm = no VM
M
M *****************************************************************************
M *
M * LOCATION SAP-Server solman_SOL_00 on host solman (wp 0)
M * ERROR ThInit: db_connect
M *
M * TIME Wed May 18 16:00:44 2011
M * RELEASE 701
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 13
M * MODULE thxxhead.c
M * LINE 10783
M * COUNTER 1
M *
M *****************************************************************************
M
M PfStatDisconnect: disconnect statistics
M Entering TH_CALLHOOKS
M ThCallHooks: call hook >BtcCallLgCl< for event BEFORE_DUMP
M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP
M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 723]
M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 261]
M Entering ThSetStatError
M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)
M Entering ThReadDetachMode
M call ThrShutDown (1)...
M ***LOG Q02=> wp_halt, WPStop (Workproc 0 2896) [dpnttool.c 334]
wp_halt but why?
Regards,
Hello majamil,
you could do us a great favour if you could put such log or trace messages into or
tags. I am not familiar with this specific error, but when scanning through such a file just look for the first occurence of WARNING or ERROR:
*** ERROR => Connect to database failed, rc = -10709 (Connection failed (RTE:Database name is missing)) [dbsdbsql.cpp 137] B
***LOG BV3=> severe db error -10709 ; work process is stopped [dbsh#2 @ 1203] [dbsh 1203 ] B
***LOG BY2=> sql error -10709 performing CON [dblink#3 @ 431] [dblink 0431 ] B
***LOG BY0=> Connection failed (RTE:Database name is missing) [dblink#3 @ 431]
Such a problem was already reported in this thread:
[Database SQL error; Connection failed|; ]
Regards,
Mark
Dear,
please check below wp log and work process still halted.
M PfStatDisconnect: disconnect statistics
M Entering TH_CALLHOOKS
M ThCallHooks: call hook >BtcCallLgCl< for event BEFORE_DUMP
M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP
M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 723]
M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 261]
M Entering ThSetStatError
M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)
M Entering ThReadDetachMode
M call ThrShutDown (1)...
M ***LOG Q02=> wp_halt, WPStop (Workproc 0 4888) [dpnttool.c 334]
waiting your reply.
Regards,
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
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.