Dispatcher stopped

[Former Member]

HI

I am having one serious problem regarding Sap Dispatcher.

I have installed IDES 5.0 on my laptop. now when i am going to start the server Sap dispatcher turned on with green light for 30 secs and immediatly it goes turned off an all ther lights changed from green to yellow.

all the process are changed from run status to Ended.

why this is happening please give me the solution to correct this problem.

Thanks in Advance.

Nilesh

[Former Member]

not get any answer.

[debasissahoo]

check the logs why it's stopped.

dev_disp

dev_w0

you can find these in /usr/sap/<SID>/DEVBMGS<nn>/work/ folder.

Post the logs

Regards,

Debasis.

[Former Member]

see the below log file for dispatcher stopped

-

---

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

-

---

Wed Oct 22 16:34:23 2008

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

length of sys_adm_ext is 524 bytes

systemid 560 (PC with Windows NT)

relno 6400

patchlevel 0

patchno 43

intno 20020600

make: multithreaded, Unicode

pid 3036

***LOG Q00=> DpSapEnvInit, DPStart (00 3036) [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 Oct 22 16:34:32 2008

• WARNING => DpNetCheck: NiHostToAddr(www.doesnotexist0205.qqq.nxst) took 9 seconds

Wed Oct 22 16:34:36 2008

• WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 4 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) 10528 (1316)

DpShMCreate: sizeof(tm_adm) 2780232 (13832)

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 (372)

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

DpShMCreate: SHM_DP_ADM_KEY (addr: 04D10040, size: 3192688)

DpShMCreate: allocated sys_adm at 04D10040

DpShMCreate: allocated wp_adm at 04D11B58

DpShMCreate: allocated tm_adm_list at 04D14478

DpShMCreate: allocated tm_adm at 04D144A0

DpShMCreate: allocated wp_ca_adm at 04FBB0E8

DpShMCreate: allocated appc_ca_adm at 04FC0EA8

DpShMCreate: allocated comm_adm_list at 04FC2DE8

DpShMCreate: allocated comm_adm at 04FC2E00

DpShMCreate: allocated vmc_adm_list at 05009AD0

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 05009AF8

DpShMCreate: allocated wall_adm at 05009B00

MBUF state OFF

EmInit: MmSetImplementation( 2 ).

<ES> client 0 initializing ....

<ES> InitFreeList

<ES> block size is 1024 kByte.

Using implementation flat

<EsNT> Memory Reset disabled as NT default

<ES> 1496 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 1462]

***LOG Q0K=> DpMsAttach, mscon ( sapprd) [dpxxdisp.c 9736]

CCMS: Initalizing shared memory of size 60000000 for monitoring segment.

Wed Oct 22 16:34:37 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 43

Release check o.K.

Wed Oct 22 16:35:16 2008

• ERROR => W0 (pid 3956) died [dpxxdisp.c 12187]

• ERROR => W1 (pid 3972) died [dpxxdisp.c 12187]

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

• ERROR => W2 (pid 4000) died [dpxxdisp.c 12187]

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

• ERROR => W3 (pid 2480) died [dpxxdisp.c 12187]

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

• ERROR => W4 (pid 3976) died [dpxxdisp.c 12187]

• ERROR => W5 (pid 3744) died [dpxxdisp.c 12187]

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

• ERROR => W6 (pid 3980) died [dpxxdisp.c 12187]

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

• ERROR => W7 (pid 4004) died [dpxxdisp.c 12187]

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-3956 (SIGUSR2)

• ERROR => DpWpKill(3956, SIGUSR2) failed [dpxxtool.c 2468]

killing W1-3972 (SIGUSR2)

• ERROR => DpWpKill(3972, SIGUSR2) failed [dpxxtool.c 2468]

killing W2-4000 (SIGUSR2)

• ERROR => DpWpKill(4000, SIGUSR2) failed [dpxxtool.c 2468]

killing W3-2480 (SIGUSR2)

• ERROR => DpWpKill(2480, SIGUSR2) failed [dpxxtool.c 2468]

killing W4-3976 (SIGUSR2)

• ERROR => DpWpKill(3976, SIGUSR2) failed [dpxxtool.c 2468]

killing W5-3744 (SIGUSR2)

• ERROR => DpWpKill(3744, SIGUSR2) failed [dpxxtool.c 2468]

killing W6-3980 (SIGUSR2)

• ERROR => DpWpKill(3980, SIGUSR2) failed [dpxxtool.c 2468]

killing W7-4004 (SIGUSR2)

• ERROR => DpWpKill(4004, SIGUSR2) failed [dpxxtool.c 2468]

NiWait: sleep (10000 msecs) ...

NiISelect: timeout 10000 ms

NiISelect: maximum fd=1601

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Oct 22 16:35:26 2008

NiISelect: TIMEOUT occured (10000 ms)

dump system status

Workprocess Table (long) Wed Oct 22 11:05:26 2008

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

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

-

---

0 DIA 3956 Ended no 1 0 0

1 DIA 3972 Ended no 1 0 0

2 UPD 4000 Ended no 1 0 0

3 ENQ 2480 Ended no 1 0 0

4 BTC 3976 Ended no 1 0 0

5 BTC 3744 Ended no 1 0 0

6 SPO 3980 Ended no 1 0 0

7 UP2 4004 Ended no 1 0 0

Dispatcher Queue Statistics Wed Oct 22 11:05:26 2008

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

--------

---

+

---

+

---

+

---

+--

---

+

Typ

now

high

max

writes

reads

--------

---

+

---

+

---

+

---

+--

---

+

NOWP

0

3

2000

10

10

--------

---

+

---

+

---

+

---

+--

---

+

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 13

wake_evt_udp_now 0

wake events total 9, udp 8 ( 88%), shm 1 ( 11%)

since last update total 9, udp 8 ( 88%), shm 1 ( 11%)

Dump of tm_adm structure: Wed Oct 22 11:05:26 2008

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

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

Workprocess Comm. Area Blocks Wed Oct 22 11:05:26 2008

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

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=1601

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Oct 22 16:35:31 2008

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 (3884) (SOFT_KILL)

Stop icman

killing process (3952) (SOFT_KILL)

Terminate gui connections

[DpProcDied] Process lives (PID:3884 HANDLE:1572)

waiting for termination of gateway

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1601

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Oct 22 16:35:32 2008

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process died (PID:3884 HANDLE:1572)

[DpProcDied] Process died (PID:3952 HANDLE:1564)

DpHalt: cancel all lcom connections

MPI CancelAll 2 -> 0

MPI DeleteAll 2 -> 0

NiIMyHostName: hostname = 'sapprd'

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/8

LOCK WP ca_blk 1

make DISP owner of wp_ca_blk 1

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

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 1580

MsIDetach: detach MS-system

EsCleanup ....

***LOG Q05=> DpHalt, DPStop ( 3036) [dpxxdisp.c 8495]

Good Bye .....

-

---

-

---

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

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

B

B Wed Oct 22 16:34:37 2008

B create_con (con_name=R/3)

B Loading DB library 'C:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' ...

B Library 'C:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' loaded

B Version of 'C:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' is "640.00", patchlevel (0.39)

B New connection 0 created

M systemid 560 (PC with Windows NT)

M relno 6400

M patchlevel 0

M patchno 43

M intno 20020600

M make: multithreaded, Unicode

M pid 3956

M

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

I MtxInit: -2 0 0

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: JAVA is not active

M DpShMCreate: sizeof(wp_adm) 10528 (1316)

M DpShMCreate: sizeof(tm_adm) 2780232 (13832)

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 (372)

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

M DpShMCreate: SHM_DP_ADM_KEY (addr: 04D10040, size: 3192688)

M DpShMCreate: allocated sys_adm at 04D10040

M DpShMCreate: allocated wp_adm at 04D11B58

M DpShMCreate: allocated tm_adm_list at 04D14478

M DpShMCreate: allocated tm_adm at 04D144A0

M DpShMCreate: allocated wp_ca_adm at 04FBB0E8

M DpShMCreate: allocated appc_ca_adm at 04FC0EA8

M DpShMCreate: allocated comm_adm_list at 04FC2DE8

M DpShMCreate: allocated comm_adm at 04FC2E00

M DpShMCreate: allocated vmc_adm_list at 05009AD0

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 05009AF8

M DpShMCreate: allocated wall_adm at 05009B00

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Using implementation flat

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M

M Wed Oct 22 16:34:38 2008

M calling db_connect ...

C Got ORACLE_HOME=D:\oracle\ora92 from environment

C Client NLS settings: AMERICAN_AMERICA.UTF8

C Got TNS_ADMIN=
sapprd\sapmnt\PRD\SYS\profile\oracle from environment

C Logon as OPS$-user to get SAPPRD's password

C Connecting as /@PRD on connection 0 ...

C Attaching to DB Server PRD (con_hdl=0,svchp=07DEC888,svrhp=07DFE154)

C Starting user session (con_hdl=0,svchp=07DEC888,srvhp=07DFE154,usrhp=07E49A38)

C Now I'm connected to ORACLE

C Got SAPPRD's password from OPS$-user

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=07DEC888,usrhp=07E49A38)

C Now I'm disconnected from ORACLE

C Connecting as SAPPRD/<pwd>@PRD on connection 0 ...

C Starting user session (con_hdl=0,svchp=07DEC888,srvhp=07DFE154,usrhp=07E49A38)

C Now I'm connected to ORACLE

C Database NLS settings: AMERICAN_AMERICA.UTF8

C Database instance prd is running on SAPPRD with ORACLE version 9.2.0.4.0 since 20081022

B Connection 0 opened

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 20081022 163438 SAPPRD

M db_connect o.k.

I MtxInit: 0 0 0

M SHM_PRES_BUF (addr: 09790040, size: 4400000)

M SHM_ROLL_AREA (addr: 32560040, size: 218726400)

M SHM_PAGING_AREA (addr: 09BD0040, size: 95682560)

M SHM_ROLL_ADM (addr: 0F720040, size: 2183680)

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

M ThCreateNoBuffer allocated 540152 bytes for 1000 entries at 0F9D0040

M ThCreateNoBuffer index size: 3000 elems

M ThCreateVBAdm allocated 12160 bytes (50 server) at 05070040

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Using implementation flat

X ES initialized.

C *** ERROR => ORA-376 occured when executing SQL statement (parse error offset = 0)

[dbsloci.c 11244]

C sc_p=04ACDAD4,no=1,idc_p=04ADDD28,con=0,act=1,slen=66,smax=256,#vars=0,stmt=07E12E08,table=DDNTT

C prep=0,lit=0,nsql=0,lobret=0,#exec=1,dbcnt=0,upsh_p=00000000,ocistmth_p=07E057D0

C IN : cols=0,rmax=0,xcnt=0,rpc=0,rowi=0,rtot=0,upto=-1,rsize=0,vmax=0,bound=0,iobuf_p=00000000,vda_p=00000000

C lobs=0,lmax=0,lpcnt=0,larr=00000000,lcurr_p=00000000,rret=0

C OUT: cols=1,rmax=1,xcnt=1,rpc=0,rowi=0,rtot=0,upto=-1,rsize=4,vmax=32,bound=1,iobuf_p=07E18518,vda_p=07E13078

C lobs=0,lmax=0,lpcnt=0,larr=00000000,lcurr_p=00000000,rret=0

C SELECT COUNT(*) FROM DDNTT WHERE TABFORM <> 'J' AND TABFORM <> 'V';

B ***LOG BY4=> sql error 376 performing SEL on table DDNTT [dbstat#1 @ 690] [dbstat 0690 ]

B ***LOG BY0=> ORA-00376: file 12 cannot be read at this time

ORA-01110: data file 12: 'D:\ORACLE\PRD\SAPDATA4\PRD_10\PRD.DATA10' [dbstat#1 @ 690] [dbstat 0690 ]

B init: Got no entries from DDNTT !

B init failed

B db_stinit failed

M *** ERROR => ThCallHooks: event handler db_init for event CREATE_SHM failed [thxxtool3.c 252]

M *** ERROR => ThIPCInit: hook failed [thxxhead.c 1901]

M ***LOG R19=> tskh_init, ThIPCInit ( TSKH-IPC-000001) [thxxhead.c 1359]

M in_ThErrHandle: 1

M *** ERROR => tskh_init: ThIPCInit (step 1, th_errno 17, action 3, level 1) [thxxhead.c 9413]

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 sapprd_PRD_00 on host sapprd (wp 0)

M * ERROR tskh_init: ThIPCInit

M *

M * TIME Wed Oct 22 16:34:38 2008

M * RELEASE 640

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 17

M * MODULE thxxhead.c

M * LINE 9589

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 252]

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 3956) [dpnttool.c 357]

[debasissahoo]

Hi,

C *** ERROR => ORA-376 occured when executing SQL statement (parse error offset = 0)
http://dbsloci.c 11244
C sc_p=04ACDAD4,no=1,idc_p=04ADDD28,con=0,act=1,slen=66,smax=256,#vars=0,stmt=07E12E08,table=DDNTT
C prep=0,lit=0,nsql=0,lobret=0,#exec=1,dbcnt=0,upsh_p=00000000,ocistmth_p=07E057D0
C IN : cols=0,rmax=0,xcnt=0,rpc=0,rowi=0,rtot=0,upto=-1,rsize=0,vmax=0,bound=0,iobuf_p=00000000,vda_p=00000000
C lobs=0,lmax=0,lpcnt=0,larr=00000000,lcurr_p=00000000,rret=0
C OUT: cols=1,rmax=1,xcnt=1,rpc=0,rowi=0,rtot=0,upto=-1,rsize=4,vmax=32,bound=1,iobuf_p=07E18518,vda_p=07E13078
C lobs=0,lmax=0,lpcnt=0,larr=00000000,lcurr_p=00000000,rret=0
C SELECT COUNT(*) FROM DDNTT WHERE TABFORM 'J' AND TABFORM 'V';
B ***LOG BY4=> sql error 376 performing SEL on table DDNTT dbstat#1 @ 690 dbstat 0690
B ***LOG BY0=> ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\ORACLE\PRD\SAPDATA4\PRD_10\PRD.DATA10' dbstat#1 @ 690 dbstat 0690
B init: Got no entries from DDNTT !
B init failed
B db_stinit failed

SAP Note Number: 328785 describes ORA-00376: File cannot be read at this time

have a look on this.

https://service.sap.com/sap/support/notes/328785

The problem here is the datafile.

D:\ORACLE\PRD\SAPDATA4\PRD_10\PRD.DATA10

You can follow the note solution part.

Regards,

Debasis.

Edited by: Debasis Sahoo on Oct 22, 2008 7:45 PM