Dispatcher running but Queue Standstill

[Former Member]

HI,

I had installed ECC6.0 IDES server.I updated kernel to lates version after that it was running fine.After i did OS level backup,when i try to start SAP through SAP management Console the process list becomes yellow and shows error as Dispatcher running but Queue standstill...

I need help as i m working for first on it...

Thanks

[Former Member]

I had checked the services sapgw is there but sapms<SID> is not there..

and i cannot connect to database through SQL management studio...SQl agent is not running

[nirmal_konchada]

Hi,

Check event logs and SQL error logs for that.

Check my previous reply

Regards,

Nirmal.K

[sunny_pahuja2]

Hi,

Is your system running ?

If yes, then check SAP note 72248 and 396309. Try to re-registering the message service to the MMC.

Thanks

Sunny

[Former Member]

There is no sapgw so called file found in C:\Windows\System32\drivers...

[Former Member]

Hi,

Check C:\WINDOWS\system32\drivers\etc path, services file should be there. Open it with notepad.

sapgw00

sapms<SID>

and also check via SQL server management studio whether SQL agent is running / DB SID (instance) is not offline.

Thanks,

Subrata

[Former Member]

My database is SQL Server 2005.WHen i try to cannect through SQL management studioit shows

TITLE: Connect to Server

-

---

Cannot connect to CAARMAECC.

-

---

ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

For help, click: http://go.microsoft.com/fwlink?ProdName=MicrosoftSQLServer&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

-

---

BUTTONS:

OK

-

---

i try to cannect SQL through SQL server Management Studio It shows

[nirmal_konchada]

Hi,

Seems to be a problem withyour SQL server.

Check whether any drive on OS has got full.

Also try to troubleshoot SQL startup.

Following link may be of any help to you :

Nirmal.K

[Former Member]

Check the note 687866 and related notes to that....hope you might get some solution.

[Former Member]

max_rq_id 14

wake_evt_udp_now 0

wake events total 10, udp 7 ( 70%), shm 3 ( 30%)

since last update total 10, udp 7 ( 70%), shm 3 ( 30%)

Dump of tm_adm structure: Thu Jan 28 18:12:32 2010

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

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

Workprocess Comm. Area Blocks Thu Jan 28 18:12:32 2010

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

Slots: 300, Used: 1, Max: 1

--------

---

+

---

+--

---

+

id

owner

pid

eyecatcher

--------

---

+

---

+--

---

+

0

DISPATCHER

-1

WPCAAD000

NiWait: sleep (5000ms) ...

NiISelect: timeout 5000ms

NiISelect: maximum fd=1037

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Jan 28 10:12:37 2010

NiISelect: TIMEOUT occured (5000ms)

DpHalt: shutdown server >CAARMAECC_IDE_00 < (normal)

DpJ2eeDisableRestart

DpModState: buffer in state MBUF_PREPARED

NiBufSend starting

NiIWrite: hdl 2 sent data (wrt=110,pac=1,MESG_IO)

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

Stop icman

killing process (2016) (SOFT_KILL)

Terminate gui connections

wait for end of work processes

wait for end of gateway

[DpProcDied] Process lives (PID:1860 HANDLE:756)

waiting for termination of gateway ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1037

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Jan 28 10:12:38 2010

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process died (PID:1860 HANDLE:756)

wait for end of icman

[DpProcDied] Process lives (PID:2016 HANDLE:768)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1037

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Jan 28 10:12:39 2010

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives (PID:2016 HANDLE:768)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1037

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Jan 28 10:12:41 2010

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives (PID:2016 HANDLE:768)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1037

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Jan 28 10:12:42 2010

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives (PID:2016 HANDLE:768)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1037

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Jan 28 10:12:43 2010

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives (PID:2016 HANDLE:768)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1037

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Jan 28 10:12:44 2010

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process died (PID:2016 HANDLE:768)

DpStartStopMsg: send stop message (myname is >CAARMAECC_IDE_00 <)

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 = 189 bytes

NiBufSend starting

NiIWrite: hdl 2 sent data (wrt=562,pac=1,MESG_IO)

MsINiWrite: sent 562 bytes

send msg (len 110+452) to name -, type 4, key -

DpStartStopMsg: stop msg sent

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 recv would block (errno=EAGAIN)

NiIRead: read for hdl 2 timed out (0ms)

DpHalt: no more messages from the message server

DpHalt: send keepalive to synchronize with the message server

NiBufSend starting

NiIWrite: hdl 2 sent data (wrt=114,pac=1,MESG_IO)

MsINiWrite: sent 114 bytes

send msg (len 110+4) to name MSG_SERVER, type 0, key -

MsSndName: MS_NOOP ok

Send 4 bytes to MSG_SERVER

NiIRead: hdl 2 received data (rcd=114,pac=1,MESG_IO)

NiBufIIn: NIBUF len=114

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 114 bytes

MSG received, len 110+4, flag 3, from MSG_SERVER , typ 0, key -

Received 4 bytes from MSG_SERVER

Received opcode MS_NOOP from msg_server, reply MSOP_OK

MsOpReceive: ok

MsSendKeepalive : keepalive sent to message server

NiIRead: hdl 2 recv would block (errno=EAGAIN)

Thu Jan 28 10:12:45 2010

NiIPeek: peek for hdl 2 timed out (r; 1000ms)

NiIRead: read for hdl 2 timed out (1000ms)

DpHalt: no more messages from the message server

DpHalt: sync with message server o.k.

detach from message server

***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c 13054]

NiBufSend starting

NiIWrite: hdl 2 sent data (wrt=110,pac=1,MESG_IO)

MsINiWrite: sent 110 bytes

MsIDetach: send logout to msg_server

MsIDetach: call exit function

DpMsShutdownHook called

NiBufISelUpdate: new MODE -- (r-) for hdl 2 in set0

SiSelNSet: set events of sock 752 to: ---

NiBufISelRemove: remove hdl 2 from set0

SiSelNRemove: removed sock 752 (pos=2)

SiSelNRemove: removed sock 752

NiSelIRemove: removed hdl 2

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

LOCK WP ca_blk 1

make DISP owner of wp_ca_blk 1

DpSemRq: key: 2, units: 1, timeout: -1

DpSemRel: key: 2, units: 1

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

MBUF component DOWN

NiICloseHandle: shutdown and close hdl 2 / sock 752

NiBufIClose: clear extension for hdl 2

MsIDetach: detach MS-system

cleanup EM

EsCleanup ....

EmCleanup() -> 0

Es2Cleanup: Cleanup ES2

***LOG Q05=> DpHalt, DPStop ( 3488) [dpxxdisp.c 11241]

Good Bye .....

[Former Member]

Hi,

Please check the entries in services file (windows --> run drivers , like C:\WINDOWS\system32\drivers\etc).

One entry sapgw<instance number) service will be there

like:

sapgw00 3200

Check for mesage server service also.

Subrata

[Former Member]

---

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

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, MJ

*

M sysno 00

M sid IDE

M systemid 562 (PC with Windows NT)

M relno 7000

M patchlevel 0

M patchno 278

M intno 20050900

M make: multithreaded, Unicode, 64 bit, optimized

M pid 3668

M

M

M Thu Jan 28 10:10:43 2010

M kernel runs with dp version 245000(ext=110000) (@(#) DPLIB-INT-VERSION-245000-UC)

M length of sys_adm_ext is 576 bytes

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

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) 29792 (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: 0000000013940050, size: 6614144)

M DpShMCreate: allocated sys_adm at 0000000013940050

M DpShMCreate: allocated wp_adm at 0000000013942270

M DpShMCreate: allocated tm_adm_list at 00000000139496D0

M DpShMCreate: allocated tm_adm at 0000000013949730

M DpShMCreate: allocated wp_ca_adm at 0000000013EECFB0

M DpShMCreate: allocated appc_ca_adm at 0000000013EF2DB0

M DpShMCreate: allocated comm_adm at 0000000013EF4CF0

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 0000000013F7B980

M DpShMCreate: allocated gw_adm at 0000000013F7BA00

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 0000000013F7BA30

M DpShMCreate: allocated wall_adm at 0000000013F7BA40

M DpRqQInit: Parameter rdisp/queue_lock_level = 2

M rdisp/queue_size_check_value : -> on,50,30,40,500,50,500,80

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.

X mm.dump: set maximum dump mem to 96 MB

M

M Thu Jan 28 10:10:44 2010

M ThInit: rdisp/cleanup_after_crash = 1

M ThInit: running on host CAARMAECC

M calling db_connect ...

B Loading DB library 'D:\usr\sap\IDE\DVEBMGS00\exe\dbmssslib.dll' ...

B Library 'D:\usr\sap\IDE\DVEBMGS00\exe\dbmssslib.dll' loaded

B Version of 'D:\usr\sap\IDE\DVEBMGS00\exe\dbmssslib.dll' is "700.08", patchlevel (0.278)

C Callback functions for dynamic profile parameter registered

C Thread ID:2224

C Thank You for using the SLOLEDB-interface

C Using dynamic link library 'D:\usr\sap\IDE\DVEBMGS00\exe\dbmssslib.dll'

C dbmssslib.dll patch info

C patchlevel 0

C patchno 278

C patchcomment Remove default for DDLOG identity column (1513170)

C np:(local) connection used on CAARMAECC

C CopyLocalParameters: dbuser is 'ide'

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C

C Thu Jan 28 10:10:59 2010

C OpenOledbConnection: line 24466. hr: 0x8000ffff Login timeout expired

C sloledb.cpp [OpenOledbConnection,line 24466]: Error/Message: (err 0, sev 0), Login timeout expired

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 24466]: Error/Message: (err 2, sev 0), An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 24466]: Error/Message: (err 2, sev 0), Named Pipes Provider: Could not open a connection to SQL Server [2].

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 24466]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C

C Thu Jan 28 10:11:14 2010

C OpenOledbConnection: line 24466. hr: 0x8000ffff Login timeout expired

C sloledb.cpp [OpenOledbConnection,line 24466]: Error/Message: (err 0, sev 0), Login timeout expired

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 24466]: Error/Message: (err 2, sev 0), An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 24466]: Error/Message: (err 2, sev 0), Named Pipes Provider: Could not open a connection to SQL Server [2].

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 24466]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C

C Thu Jan 28 10:11:29 2010

C OpenOledbConnection: line 24466. hr: 0x8000ffff Login timeout expired

C sloledb.cpp [OpenOledbConnection,line 24466]: Error/Message: (err 0, sev 0), Login timeout expired

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 24466]: Error/Message: (err 2, sev 0), An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 24466]: Error/Message: (err 2, sev 0), Named Pipes Provider: Could not open a connection to SQL Server [2].

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 24466]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C failed to establish conn to np:(local).

C Retrying without protocol specifier: (local)

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C

C Thu Jan 28 10:11:45 2010

C OpenOledbConnection: line 24466. hr: 0x8000ffff Login timeout expired

C sloledb.cpp [OpenOledbConnection,line 24466]: Error/Message: (err 0, sev 0), Login timeout expired

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 24466]: Error/Message: (err 2, sev 0), An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 24466]: Error/Message: (err 2, sev 0), Named Pipes Provider: Could not open a connection to SQL Server [2].

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 24466]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C

C Thu Jan 28 10:12:01 2010

C OpenOledbConnection: line 24466. hr: 0x8000ffff Login timeout expired

C sloledb.cpp [OpenOledbConnection,line 24466]: Error/Message: (err 0, sev 0), Login timeout expired

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 24466]: Error/Message: (err 2, sev 0), An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 24466]: Error/Message: (err 2, sev 0), Named Pipes Provider: Could not open a connection to SQL Server [2].

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 24466]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C

C Thu Jan 28 10:12:17 2010

C OpenOledbConnection: line 24466. hr: 0x8000ffff Login timeout expired

C sloledb.cpp [OpenOledbConnection,line 24466]: Error/Message: (err 0, sev 0), Login timeout expired

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 24466]: Error/Message: (err 2, sev 0), An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 24466]: Error/Message: (err 2, sev 0), Named Pipes Provider: Could not open a connection to SQL Server [2].

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 24466]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C failed to establish conn. 0

B ***LOG BY2=> sql error -1 performing CON [dbsh#3 @ 1208] [dbsh 1208 ]

B ***LOG BY0=> Login timeout expired [dbsh#3 @ 1208] [dbsh 1208 ]

B ***LOG BY2=> sql error -1 performing CON [dblink#8 @ 433] [dblink 0433 ]

B ***LOG BY0=> Login timeout expired [dblink#8 @ 433] [dblink 0433 ]

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

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10632]

M

M Info for wp 0

M

M pid = 3668

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 CAARMAECC_IDE_00 on host CAARMAECC (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Thu Jan 28 10:12:17 2010

M * RELEASE 700

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10852

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

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 262]

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 3668) [dpnttool.c 333]

[nirmal_konchada]

Error/Message: (err 2, sev 0), An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. C Procname: [OpenOledbConnection - no proc] C sloledb.cpp [OpenOledbConnection,line 24466]: Error/Message: (err 2, sev 0), Named Pipes Provider: Could not open a connection to SQL Server [2]. C Procname: [OpenOledbConnection - no proc] C sloledb.cpp [OpenOledbConnection,line 24466]: Error/Message: (err 0, sev 0), Invalid connection string attribute C Procname: [OpenOledbConnection - no proc] C Using Provider SQLNCLI C OpenOledbConnection: MARS property was set successfully. C C Thu Jan 28 10:11:14 2010 C OpenOledbConnection: line 24466. hr: 0x8000ffff Login timeout expired C sloledb.cpp [OpenOledbConnection,line 24466]: Error/Message: (err 0, sev 0), Login timeout expired

Seems to be a problem with the connection to the database.

Whats your DB???

And also check whether all the DB related services are up ad running.

Regards,

Nirmal.K

[Former Member]

I am working on it for first time.will you please tell me how to check Log DEV_WO.What to observe in it?

Thanks

[nirmal_konchada]

Hi,

You can find the log in work directry.

Paste the cotents of the file here.

Regards,

Nirmal.K

[Former Member]

Login to SIDadm prompt and change the directory to /usr/sap/SID/DVEBMGS00/work and check for the trace file for dispatcher..i.e :- dev_disp..view the log if you can locate some thing.

[Former Member]

Hi,

Go to dir /usr/sap/<SID>/DVEBMGS<instance number>/work (in GUI -->tcode AL11, DIR_HOME).

Please check dev_disp (trace of dispatcher).

Thanks,

subrata

[nirmal_konchada]

Check log dev_w0

Regards,

Nirmal.K