on 08-23-2005 11:28 PM
Hi to all
I have installed the NW ABAP stack and make it work once. But now, after a short while the SAP system successfully starts, when I try to login to the NSP system, the dispatcher process (disp+work.exe) stops.
I wanted to uninstall the DB instance but it (I guess normally) gives the error:
<i>Error! Connection failed to node (local) for database NSP: database instance not found</i>
How can this error be corrected?
Here is the system log:
<b>Severity Typ MNo Text</b>
Information DP Q05 SAP Basis System: R/3 System stop, dispatcher PID 27
Error DP Q0M SAP Basis System: Message server disconnected
Information RD S30 Communications data: SAP gateway was closed
Warning D1 Q02 SAP Basis System: Stop Workproc 1, PID 3808
Warning D0 Q02 SAP Basis System: Stop Workproc 0, PID 3800
Warning B2 Q02 SAP Basis System: Stop Workproc 2, PID 3828
Error B2 R19 SAP Basis System: Initialization DB-Connect Failed, Return Code 000256
B2 BY0 Database: > CONNECT: (database not running)
Error B2 BY2 Database: Database error -709 at CON
Warning B2 BV3 Database: SQL error -709 occurred (possible network problems?). Work process is stopped
Error D0 R19 SAP Basis System: Initialization DB-Connect Failed, Return Code 000256
D0 BY0 Database: > CONNECT: (database not running)
Error D0 BY2 Database: Database error -709 at CON
Warning D0 BV3 Database: SQL error -709 occurred (possible network problems?). Work process is stopped
Error D1 R19 SAP Basis System: Initialization DB-Connect Failed, Return Code 000256
D1 BY0 Database: > CONNECT: (database not running)
Error D1 BY2 Database: Database error -709 at CON
Warning D1 BV3 Database: SQL error -709 occurred (possible network problems?). Work process is stopped
Information DP Q1C SAP Basis System: MsgServer Hardware ID Was Determined
Information RD S00 Communications data: SAP Gateway Started (PID: 3744)
Information W0 Q0Q SAP Basis System: Start Workproc 0, Pid 3800
Information W1 Q0Q SAP Basis System: Start Workproc 1, Pid 3808
Information W2 Q0Q SAP Basis System: Start Workproc 2, Pid 3828
Information DP Q0K SAP Basis System: Connection to message server (on excellency) established
DP GZZ SAP Basis System: > 2 possible network problems detected - check tracefile and adjus
Information DP Q00 SAP Basis System: R/3 System start, SAPSYSTEM 00, dispatcher PID 2776
Information MS Q01 SAP Basis System: Start Msg Server, 1 times since system startup. PID 2768
Information MS E10 SAP Basis System: Buffer SCSA Generated with Length 4096
Thanks & Regards...
*--Serdar <a href="https://www.sdn.sap.com:443http://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.sdn.businesscard.sdnbusinesscard?u=qbk%2bsag%2bjiw%3d">[ BC ]</a>
Hi,
Before un-installing the Db server,check the trace file dev_disp in usr/sap/<SID>/DVG../work.
Let me know what is the O.S and DB you are using.
Are SAP and DB services are running?
Rgs
vikas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vikas
Following is the trace file content:
-
trc file: "dev_disp", trc level: 1, release: "640"
-
Wed Aug 24 01:10:24 2005
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 43
intno 20020600
make: multithreaded, ASCII
pid 2776
Wed Aug 24 01:10:25 2005
***LOG Q00=> DpSapEnvInit, DPStart (00 2776) [dpxxdisp.c 1100]
shared lib "dw_xml.dll" version 43 successfully loaded
shared lib "dw_xtc.dll" version 43 successfully loaded
shared lib "dw_stl.dll" version 43 successfully loaded
shared lib "dw_gui.dll" version 43 successfully loaded
Wed Aug 24 01:10:36 2005
WARNING => DpNetCheck: NiHostToAddr(www.doesnotexist0209.qqq.nxst) took 11 seconds
Wed Aug 24 01:10:51 2005
WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 15 seconds
***LOG GZZ=> 2 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) 2488 (828)
DpShMCreate: sizeof(tm_adm) 2219848 (11044)
DpShMCreate: sizeof(wp_ca_adm) 18000 (60)
DpShMCreate: sizeof(appc_ca_adm) 1200 (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: 039E0040, size: 2496480)
DpShMCreate: allocated sys_adm at 039E0040
DpShMCreate: allocated wp_adm at 039E17A8
DpShMCreate: allocated tm_adm_list at 039E2160
DpShMCreate: allocated tm_adm at 039E2188
DpShMCreate: allocated wp_ca_adm at 03C000D0
DpShMCreate: allocated appc_ca_adm at 03C04720
DpShMCreate: allocated comm_adm_list at 03C04BD0
DpShMCreate: allocated comm_adm at 03C04BE8
DpShMCreate: allocated vmc_adm_list at 03C339E8
DpShMCreate: system runs without vmc_adm
DpShMCreate: allocated ca_info at 03C33A10
DpShMCreate: allocated wall_adm at 03C33A18
MBUF state OFF
EmInit: MmSetImplementation( 2 ).
<ES> client 0 initializing ....
Wed Aug 24 01:10:52 2005
<ES> InitFreeList
<ES> block size is 1024 kByte.
Using implementation flat
<EsNT> Memory Reset disabled as NT default
<ES> 191 blocks reserved for free list.
ES initialized.
rdisp/http_min_wait_dia_wp : 1 -> 1
***LOG Q0K=> DpMsAttach, mscon ( excellency) [dpxxdisp.c 9736]
Wed Aug 24 01:10:55 2005
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 43
Release check o.K.
Wed Aug 24 01:11:33 2005
ERROR => W0 (pid 3800) died [dpxxdisp.c 12187]
ERROR => W1 (pid 3808) died [dpxxdisp.c 12187]
my types changed after wp death/restart 0x89 --> 0x88
ERROR => W2 (pid 3828) died [dpxxdisp.c 12187]
my types changed after wp death/restart 0x88 --> 0x80
DP_FATAL_ERROR => DpWPCheck: no more work processes
DISPATCHER EMERGENCY SHUTDOWN ***
increase tracelevel of WPs
killing W0-3800 (SIGUSR2)
ERROR => DpWpKill(3800, SIGUSR2) failed [dpxxtool.c 2468]
killing W1-3808 (SIGUSR2)
ERROR => DpWpKill(3808, SIGUSR2) failed [dpxxtool.c 2468]
killing W2-3828 (SIGUSR2)
ERROR => DpWpKill(3828, SIGUSR2) failed [dpxxtool.c 2468]
NiWait: sleep (10000 msecs) ...
NiISelect: timeout 10000 ms
NiISelect: maximum fd=1673
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Aug 24 01:11:43 2005
NiISelect: TIMEOUT occured (10000 ms)
dump system status
Workprocess Table (long) Tue Aug 23 22:11:43 2005
========================
No Ty. Pid Status Cause Start Err Sem CPU Time Program Cl User Action Table
-
0 DIA 3800 Ended no 1 0 0
1 DIA 3808 Ended no 1 0 0
2 BTC 3828 Ended no 1 0 0
Dispatcher Queue Statistics Tue Aug 23 22:11:43 2005
===========================
--------
+
Typ | now | high | max | writes | reads |
--------
+
NOWP | 0 | 3 | 2000 | 10 | 10 |
--------
+
DIA | 3 | 3 | 2000 | 3 | 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 11
wake_evt_udp_now 0
wake events total 7, udp 6 ( 85%), shm 1 ( 14%)
since last update total 7, udp 6 ( 85%), shm 1 ( 14%)
Dump of tm_adm structure: Tue Aug 23 22:11:43 2005
=========================
Term uid man user term lastop mod wp ta a/i (modes)
Workprocess Comm. Area Blocks Tue Aug 23 22:11:43 2005
=============================
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=1673
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Aug 24 01:11:48 2005
NiISelect: TIMEOUT occured (5000 ms)
Shutdown server ...
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 (3744) (SOFT_KILL)
Stop icman
killing process (3788) (SOFT_KILL)
Terminate gui connections
[DpProcDied] Process lives (PID:3744 HANDLE:1628)
waiting for termination of gateway
NiWait: sleep (1000 msecs) ...
NiISelect: timeout 1000 ms
NiISelect: maximum fd=1673
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Aug 24 01:11:49 2005
NiISelect: TIMEOUT occured (1000 ms)
[DpProcDied] Process died (PID:3744 HANDLE:1628)
[DpProcDied] Process died (PID:3788 HANDLE:1620)
DpHalt: cancel all lcom connections
MPI CancelAll 2 -> 0
MPI DeleteAll 2 -> 0
NiIMyHostName: hostname = 'excellency'
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 9962]
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 = 1/300/3
LOCK WP ca_blk 1
make DISP owner of wp_ca_blk 1
DpRqPutIntoQueue: put request into queue (reqtype 1, prio LOW, rq_id 17)
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 1640
MsIDetach: detach MS-system
EsCleanup ....
***LOG Q05=> DpHalt, DPStop ( 2776) [dpxxdisp.c 8495]
Good Bye .....
Hope this makes sense about solving the problem...
Thanks...
Same problem here.
Does not work even if adding the sapdp00s 4700/tcp
I think there is something fundamentally wrong for this to happen.
Emergency shutdown..?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI IM HAVING THE SAME PROBLEM
DID YOU FIND ANY SOLUTION FOR THIS ...
IS THERE ANY PROBLEM IN THE ASSIGNING THE WORK GROUP NAME SOME THING LIKE THAT
VERY MUCH CONFUSED ...
REGARDS
VIJAY BASKER
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Serdar,
First of all you have to stop the all services of SAP* & DB* then can only you can uninstall that.
Cheers,
Vivek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vivek
I see. I will try to install the database instance again as soon as possible. I cannot give points since the pointing scala is miisng at the left. I will revisit and try sooner.
Thanks & Regards...
*--Serdar <a href="https://www.sdn.sap.com:443http://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.sdn.businesscard.sdnbusinesscard?u=qbk%2bsag%2bjiw%3d">[ BC ]</a>
I have had the same problem and searched thru a lot of the forums. The solution which worked for me is the following :
· Open the file c:windowssystem32driversetcservices in your workstation (use wordpad or notepad as editor)
· Check if the following lines are present in the services file, if they are not present just enter them and save the file
· sapmsNSP 3600/tcp
· sapdp00 3200/tcp
· sapdp00s 4700/tcp
· sapgw00 3300/tcp
· Restart your system and try again.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
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.