cancel
Showing results for 
Search instead for 
Did you mean: 

Dispatcher problem

Former Member
0 Kudos

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>

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

ssimsekler
Active Contributor
0 Kudos

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...

Answers (3)

Answers (3)

Former Member
0 Kudos

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..?

Former Member
0 Kudos

I have the same problem, but my problem is after a restore DB, i have all the ports and the users.

But the system say:

SAP-Basis System: Initialization DB-Connect Failed, Return Code 000256

My system is SQL 2005 on Windows 2003 and SAP ECC 6.0 only ABAP.

Best regards and thanks for the help!

Former Member
0 Kudos

Thank you!

I solve this problem successfully, apply the note 1294762.

Best regards!

former_member184158
Active Contributor
0 Kudos

if u have done it, can you share it please, because we have the same problem .

Former Member
0 Kudos

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

Former Member
0 Kudos

Dear Serdar,

First of all you have to stop the all services of SAP* & DB* then can only you can uninstall that.

Cheers,

Vivek

ssimsekler
Active Contributor
0 Kudos

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>

Former Member
0 Kudos

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.