DISP+WORK.exe process shutsdown

[Former Member]

Hi Guys,

I been facing this problem for almost 2 days now, and I

searched online a lot... but can't really solved this issue.

When I start SAPMMC and start the server, all the processes load.

msg_server, dispwork and igswd, but after 2 mins the DISPWORK process

shutsdown... I have no clue why.

another thing is that I can't even get into my Oracle database, the database pwd

I set while installation is not recogination. if that is the problem how do I reset my pwd?

or how do I get the DISP+WORK process up and running?

this is what is in the dev_disp file...

-

---

-

---

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

-

---

Wed Nov 07 13:32:38 2007

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 3236

***LOG Q00=> DpSapEnvInit, DPStart (43 3236) [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 Nov 07 13:32:43 2007

• 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) 6624 (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: 03990040, size: 2505416)

DpShMCreate: allocated sys_adm at 03990040

DpShMCreate: allocated wp_adm at 039917A8

DpShMCreate: allocated tm_adm_list at 03993188

DpShMCreate: allocated tm_adm at 039931B0

DpShMCreate: allocated wp_ca_adm at 03BB10F8

DpShMCreate: allocated appc_ca_adm at 03BB5748

DpShMCreate: allocated comm_adm_list at 03BB6EB8

DpShMCreate: allocated comm_adm at 03BB6ED0

DpShMCreate: allocated vmc_adm_list at 03BE5CD0

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 03BE5CF8

DpShMCreate: allocated wall_adm at 03BE5D00

MBUF state OFF

Wed Nov 07 13:32:44 2007

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> 306 blocks reserved for free list.

ES initialized.

rdisp/http_min_wait_dia_wp : 1 -> 1

Wed Nov 07 13:32:45 2007

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

Wed Nov 07 13:32:46 2007

CCMS: start to initalize 3.X shared alert area (first segment).

Wed Nov 07 13:32:47 2007

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 Nov 07 13:33:25 2007

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

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

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

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

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

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

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

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

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

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

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

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

• ERROR => W7 (pid 4020) 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-3972 (SIGUSR2)

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

killing W1-3984 (SIGUSR2)

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

killing W2-2296 (SIGUSR2)

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

killing W3-3640 (SIGUSR2)

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

killing W4-2144 (SIGUSR2)

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

killing W5-4004 (SIGUSR2)

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

killing W6-4012 (SIGUSR2)

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

killing W7-4020 (SIGUSR2)

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

NiWait: sleep (10000 msecs) ...

NiISelect: timeout 10000 ms

NiISelect: maximum fd=1661

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Nov 07 13:33:35 2007

NiISelect: TIMEOUT occured (10000 ms)

dump system status

Workprocess Table (long) Wed Nov 07 17:33:35 2007

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

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

-

---

0 DIA 3972 Ended no 1 0 0

1 DIA 3984 Ended no 1 0 0

2 UPD 2296 Ended no 1 0 0

3 ENQ 3640 Ended no 1 0 0

4 BTC 2144 Ended no 1 0 0

5 BTC 4004 Ended no 1 0 0

6 SPO 4012 Ended no 1 0 0

7 UP2 4020 Ended no 1 0 0

Dispatcher Queue Statistics Wed Nov 07 17:33:35 2007

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

--------

---

+

---

+

---

+

---

+--

---

+

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 7 ( 77%), shm 2 ( 22%)

since last update total 9, udp 7 ( 77%), shm 2 ( 22%)

Dump of tm_adm structure: Wed Nov 07 17:33:35 2007

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

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

Workprocess Comm. Area Blocks Wed Nov 07 17:33:35 2007

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

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

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Nov 07 13:33:40 2007

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

Stop icman

killing process (3964) (SOFT_KILL)

Terminate gui connections

[DpProcDied] Process lives (PID:700 HANDLE:1624)

waiting for termination of gateway

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1661

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Nov 07 13:33:41 2007

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process died (PID:700 HANDLE:1624)

[DpProcDied] Process died (PID:3964 HANDLE:1616)

DpHalt: cancel all lcom connections

MPI CancelAll 2 -> 0

MPI DeleteAll 2 -> 0

NiIMyHostName: hostname = 'GHome'

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 1640

MsIDetach: detach MS-system

EsCleanup ....

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

Good Bye .....

========

and this is the DEV_MS log file...

-

---

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

-

---

[Thr 3220] Wed Nov 07 13:32:36 2007

[Thr 3220] systemid 560 (PC with Windows NT)

[Thr 3220] relno 6400

[Thr 3220] patchlevel 0

[Thr 3220] patchno 43

[Thr 3220] intno 20020600

[Thr 3220] pid 3208

[Thr 3220] ***LOG Q01=> MsSInit, MSStart (Msg Server 1 3208) [msxxserv.c 1661]

[Thr 3220] Wed Nov 07 13:32:37 2007

[Thr 3220] MsHttpInit: full qualified hostname = GHome.Gur

[Thr 3220] HTTP logging is switch off

[Thr 3220] set HTTP state to LISTEN

[Thr 3220] MsHttpOwnDomain: own domain[1] = Gur

[Thr 3220] *** I listen to port sapmsGPS (3643) ***

[Thr 3220] *** HTTP port 8143 state LISTEN ***

[Thr 3220] CUSTOMER KEY: >L0342667635<

[Thr 3220] Wed Nov 07 13:33:41 2007

[Thr 3220] *** ERROR => MsSClientHandle: no server provides service ENQ (4), requested from GHome_GPS_43 [msxxserv.c 4196]

[Thr 3220] Wed Nov 07 13:44:01 2007

[Thr 3220] *** ERROR => MsSCheckConnections: no response from client C0 (192.168.1.143) after 300 secs received [msxxserv.c 2919]

[Thr 3220] *** ERROR => MsSCheckConnections: disconnect now [192.168.1.143] [msxxserv.c 2923]

Please help me if possible...

[Former Member]

Is the DB on a separate system? Have you tried logging directly into in on that box? Can you get into the DB at all?

Another thing to check is to see if another program is grabbing the port that the DB listener users. Use 'netstat -a -b' from the command line to see what ports are being used and the related programs.

- jph

no the DB is on the same system and I can't get into it...

I have the 'netstat -a -b' command and port 1521 was not even in there so i guess its not running?

[Former Member]

Yeah. That sounds correct. You might want to check the services to see if it (the listener) is setup to come up with the server. You might also want to check the event log for any failed services.

[former_member204746]

your Oracle listener is down or malfunctioning, try this command:

lsnrctl start

then, restart SAP

[Former Member]

yeah thats what I was think, I was able to login 2 days ago...

but something happened and now I can't get into the database either...

how do I reset the schema password?

I been searching no luck...

theres no firewall...

i just dont get it it was working in the morning the disp+work process stopped.

[Former Member]

Is the DB on a separate system? Have you tried logging directly into in on that box? Can you get into the DB at all?

Another thing to check is to see if another program is grabbing the port that the DB listener uses. Use 'netstat -a -b' from the command line to see what ports are being used and the related programs.

Finally, do you have a backup of the DB? That might be the quickest fix.

- jph

Message was edited by:

Joe Haynes

[Former Member]

Here this is the DEV_W0 file...

-

---

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

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

B

B Wed Nov 07 13:32:45 2007

B create_con (con_name=R/3)

B Loading DB library 'K:\usr\sap\GPS\SYS\exe\run\dboraslib.dll' ...

B Library 'K:\usr\sap\GPS\SYS\exe\run\dboraslib.dll' loaded

B Version of 'K:\usr\sap\GPS\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, ASCII

M pid 3972

M

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

I MtxInit: -2 0 0

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: JAVA is not active

M

M Wed Nov 07 13:32:46 2007

M DpShMCreate: sizeof(wp_adm) 6624 (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: 03990040, size: 2505416)

M DpShMCreate: allocated sys_adm at 03990040

M DpShMCreate: allocated wp_adm at 039917A8

M DpShMCreate: allocated tm_adm_list at 03993188

M DpShMCreate: allocated tm_adm at 039931B0

M DpShMCreate: allocated wp_ca_adm at 03BB10F8

M DpShMCreate: allocated appc_ca_adm at 03BB5748

M DpShMCreate: allocated comm_adm_list at 03BB6EB8

M DpShMCreate: allocated comm_adm at 03BB6ED0

M DpShMCreate: allocated vmc_adm_list at 03BE5CD0

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 03BE5CF8

M DpShMCreate: allocated wall_adm at 03BE5D00

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 Nov 07 13:32:47 2007

M calling db_connect ...

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

C

C Wed Nov 07 13:32:49 2007

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

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

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

C Attaching to DB Server GPS (con_hdl=0,svchp=038430DC,svrhp=03843CB4)

C

C Wed Nov 07 13:32:53 2007

C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12541

[dboci.c 3514]

C

C Wed Nov 07 13:32:54 2007

C *** ERROR => CONNECT failed with sql error '12541'

[dbsloci.c 9750]

C Try to connect with default password

C Connecting as SAPGPS/<pwd>@GPS on connection 0 ...

C Detaching from DB Server (con_hdl=0,svchp=038430DC,srvhp=03843CB4)

C Attaching to DB Server GPS (con_hdl=0,svchp=038430DC,svrhp=03843CB4)

C

C Wed Nov 07 13:32:55 2007

C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12541

[dboci.c 3514]

C *** ERROR => CONNECT failed with sql error '12541'

[dbsloci.c 9750]

B ***LOG BY2=> sql error 12541 performing CON [dbsh#2 @ 1200] [dbsh 1200 ]

B ***LOG BY0=> ORA-12541: TNS:no listener [dbsh#2 @ 1200] [dbsh 1200 ]

B ***LOG BY2=> sql error 12541 performing CON [dblink#1 @ 419] [dblink 0419 ]

B ***LOG BY0=> ORA-12541: TNS:no listener [dblink#1 @ 419] [dblink 0419 ]

M ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c 1269]

M in_ThErrHandle: 1

M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, 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 Wed Nov 07 13:32:56 2007

M * LOCATION SAP-Server GHome_GPS_43 on host GHome (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Wed Nov 07 13:32:55 2007

M * RELEASE 640

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

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 3972) [dpnttool.c 357]

[Former Member]

From the last log it looks like your work processes are unable to log into the DB using the account info they have. Have you changed any of the accounts at the DB level? That would account for this failure.

J. Haynes

Denver

[former_member204746]

supply contents from dev_w0