cancel
Showing results for 
Search instead for 
Did you mean: 

Dispatcher is not running Disp+work.exe Stopped

Former Member
0 Kudos

Hi Gurus

Dispatcher is not running after a restart.

Developer Trace

---------------------------------------------------

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

---------------------------------------------------

sysno      11

sid        DV1

systemid   562 (PC with Windows NT)

relno      7200

patchlevel 0

patchno    100

intno      20020600

make       multithreaded, Unicode, 64 bit, optimized

profile    \\mycomp\sapmnt\DV1\SYS\profile\DV1_DVEBMGS11_mycomp

pid        3156

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

length of sys_adm_ext is 588 bytes

*** SWITCH TRC-HIDE on ***

***LOG Q00=> DpSapEnvInit, DPStart (11 3156) [dpxxdisp.c   1287]

  shared lib "dw_xml.dll" version 100 successfully loaded

  shared lib "dw_xtc.dll" version 100 successfully loaded

  shared lib "dw_stl.dll" version 100 successfully loaded

  shared lib "dw_gui.dll" version 100 successfully loaded

  shared lib "dw_mdm.dll" version 100 successfully loaded

  shared lib "dw_rndrt.dll" version 100 successfully loaded

  shared lib "dw_abp.dll" version 100 successfully loaded

  shared lib "dw_sym.dll" version 100 successfully loaded

  shared lib "dw_aci.dll" version 100 successfully loaded

rdisp/softcancel_sequence :  -> 0,5,-1

use internal message server connection to port 3911

rdisp/dynamic_wp_check : 1

rdisp/calculateLoadAverage : 1

Tue Nov 03 19:01:24 2015

*** WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 5 seconds

***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c  6404]

MtxInit: 30000 0 0

DpSysAdmExtInit: ABAP is active

DpSysAdmExtInit: VMC (JAVA VM in WP) is not active

DpIPCInit2: write dp-profile-values into sys_adm_ext

DpIPCInit2: start server >mycomp_DV1_11                           <

DpShMCreate: sizeof(wp_adm) 33968 (2264)

DpShMCreate: sizeof(tm_adm) 5517056 (27448)

DpShMCreate: sizeof(wp_ca_adm) 64000 (64)

DpShMCreate: sizeof(appc_ca_adm) 64000 (64)

DpCommTableSize: max/headSize/ftSize/tableSize=500/16/584064/584080

DpShMCreate: sizeof(comm_adm) 584080 (1144)

DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0

DpShMCreate: sizeof(slock_adm) 0 (104)

DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

DpShMCreate: sizeof(file_adm) 0 (80)

DpShMCreate: sizeof(vmc_adm) 0 (2152)

DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)

DpShMCreate: sizeof(gw_adm) 48

DpShMCreate: sizeof(j2ee_adm) 3952

DpShMCreate: SHM_DP_ADM_KEY (addr: 00000000077D0050, size: 6359680)

DpShMCreate: allocated sys_adm at 00000000077D0060

DpShMCreate: allocated wp_adm_list at 00000000077D3040

DpShMCreate: allocated wp_adm at 00000000077D3230

DpShMCreate: allocated tm_adm_list at 00000000077DB6F0

DpShMCreate: allocated tm_adm at 00000000077DB740

DpShMCreate: allocated wp_ca_adm at 0000000007D1E650

DpShMCreate: allocated appc_ca_adm at 0000000007D2E060

DpShMCreate: allocated comm_adm at 0000000007D3DA70

DpShMCreate: system runs without slock table

DpShMCreate: system runs without file table

DpShMCreate: allocated vmc_adm_list at 0000000007DCC410

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated gw_adm at 0000000007DCC4C0

DpShMCreate: allocated j2ee_adm at 0000000007DCC500

DpShMCreate: allocated ca_info at 0000000007DCD480

DpShMCreate: allocated wall_adm at 0000000007DCD510

DpCommAttachTable: attached comm table (header=0000000007D3DA70/ft=0000000007D3DA80)

DpSysAdmIntInit: initialize sys_adm

rdisp/test_roll : roll strategy is DP_NORMAL_ROLL

dia token check not active (6 token)

MBUF state OFF

DpCommInitTable: init table for 500 entries

DpRqQInit: keep protect_queue / slots_per_queue 0 / 2001 in sys_adm

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

EmInit: MmSetImplementation( 2 ).

MM global diagnostic options set: 0

<ES> client 0 initializing ....

<ES> InitFreeList

<ES> block size is 4096 kByte.

<ES> Info: em/initial_size_MB( 4091MB) not multiple of em/blocksize_KB( 4096KB)

<ES> Info: em/initial_size_MB rounded up to 4092MB

Using implementation view

<EsNT> Using memory model view.

<EsNT> Memory Reset disabled as NT default

<ES> 1022 blocks reserved for free list.

ES initialized.

mm.dump: set maximum dump mem to 96 MB

DpVmcSetActive: set vmc state DP_VMC_NOT_ACTIVE

MPI: dynamic quotas disabled.

MPI init: pipes=4000 buffers=1279 reserved=383 quota=10%

Tue Nov 03 19:01:25 2015

rdisp/http_min_wait_dia_wp : 1 -> 1

***LOG CPS=> DpLoopInit, ICU ( 4.0.1 4.0.1 5.1) [dpxxdisp.c   1673]

***LOG Q0K=> DpMsAttach, mscon ( mycomp) [dpxxdisp.c   12339]

MBUF state LOADING

DpStartStopMsg: send start message (myname is >mycomp_DV1_11                           <)

DpStartStopMsg: start msg sent

CCMS uses Shared Memory Key 73 for monitoring.

CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

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

Tue Nov 03 19:01:26 2015

CCMS: Checking Downtime Configuration of Monitoring Segment.

CCMS: AlMsUpload called by wp 1024.

Tue Nov 03 19:01:35 2015

CCMS: AlMsUpload successful for C:\usr\sap\DV1\DVEBMGS11\log\ALMTTREE.DAT (4023 MTEs).

Tue Nov 03 19:01:36 2015

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

DpMBufHwIdSet: set Hardware-ID

***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c   1296]

MBUF state ACTIVE

DpWpBlksLow: max wp blocks in queue is 800 (80 %)

MBUF component UP

DpMsgProcess: 1 server in MBUF

DpAppcBlksLow: max appc blocks in queue is 500 (50 %)

Tue Nov 03 19:03:25 2015

*** ERROR => DpHdlDeadWp: W0 (pid 2380) died (severity=0, status=0) [dpxxwp.c     1522]

*** ERROR => DpHdlDeadWp: W1 (pid 3668) died (severity=0, status=0) [dpxxwp.c     1522]

*** ERROR => DpHdlDeadWp: W2 (pid 2324) died (severity=0, status=0) [dpxxwp.c     1522]

*** ERROR => DpHdlDeadWp: W3 (pid 1764) died (severity=0, status=0) [dpxxwp.c     1522]

*** ERROR => DpHdlDeadWp: W4 (pid 3588) died (severity=0, status=0) [dpxxwp.c     1522]

*** ERROR => DpHdlDeadWp: W5 (pid 3056) died (severity=0, status=0) [dpxxwp.c     1522]

*** ERROR => DpHdlDeadWp: W6 (pid 3504) died (severity=0, status=0) [dpxxwp.c     1522]

*** ERROR => DpHdlDeadWp: W7 (pid 3716) died (severity=0, status=0) [dpxxwp.c     1522]

*** ERROR => DpHdlDeadWp: W8 (pid 3280) died (severity=0, status=0) [dpxxwp.c     1522]

*** ERROR => DpHdlDeadWp: W9 (pid 3740) died (severity=0, status=0) [dpxxwp.c     1522]

*** ERROR => DpHdlDeadWp: W10 (pid 3336) died (severity=0, status=0) [dpxxwp.c     1522]

*** ERROR => DpHdlDeadWp: W11 (pid 3396) died (severity=0, status=0) [dpxxwp.c     1522]

*** ERROR => DpHdlDeadWp: W12 (pid 3244) died (severity=0, status=0) [dpxxwp.c     1522]

*** DP_FATAL_ERROR => DpWPCheck: no more work processes

*** DISPATCHER EMERGENCY SHUTDOWN ***

increase tracelevel of WPs

NiWait: sleep (10000ms) ...

NiISelect: timeout 10000ms

NiISelect: maximum fd=921

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Tue Nov 03 19:03:35 2015

NiISelect: TIMEOUT occured (10000ms)

dump system status

Workprocess Table (long) Tue Nov 03 13:33:35 2015

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

No Type  Pid    Status  Cause Start Rstr  Err Sem Time Program          Cl  User         Action                    Table

-------------------------------------------------------------------------------------------------------------------------------

0 DIA       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

1 DIA       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

2 DIA       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

3 DIA       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

4 DIA       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

5 DIA       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

6 UPD       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

7 UPD       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

8 ENQ       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

9 BTC       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

10 BTC       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

11 SPO       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

12 UP2       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

Dispatcher Queue Statistics Tue Nov 03 13:33:35 2015

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

+------+--------+--------+--------+------------+------------+

|  Typ |    now |   high |    max | writes     |  reads     |

+------+--------+--------+--------+------------+------------+

| NOWP |      0 |      4 |   2000 |          5 |          5 |

+------+--------+--------+--------+------------+------------+

|  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 |      1 |      1 |   2000 |          1 |          0 |

+------+--------+--------+--------+------------+------------+

|  UP2 |      0 |      0 |   2000 |          0 |          0 |

+------+--------+--------+--------+------------+------------+

max_rq_id 11

wake_evt_udp_now 0

wake events       total     9,  udp     3 ( 33%),  shm     6 ( 66%)

since last update total     9,  udp     3 ( 33%),  shm     6 ( 66%)

DpGetLoadAverage: la1[1] = 1.833333 / -1.000000 %

DpGetLoadAverage: la5[1] = 0.466667 / -1.000000 %

DpGetLoadAverage: la15[1] = 0.211111 / -1.000000 %

Dispatcher Load Statistics

+------+---------+---------+---------+

|  Typ |     LA1 |     LA5 |    LA15 |

+------+---------+---------+---------+

|  DIA |   1.833 |   0.467 |   0.211 |

+------+---------+---------+---------+

DpGetLoadAverage: la1[2] = 0.000000 / -1.000000 %

DpGetLoadAverage: la5[2] = 0.000000 / -1.000000 %

DpGetLoadAverage: la15[2] = 0.000000 / -1.000000 %

|  UPD |   0.000 |   0.000 |   0.000 |

+------+---------+---------+---------+

DpGetLoadAverage: la1[3] = 0.000000 / -1.000000 %

DpGetLoadAverage: la5[3] = 0.000000 / -1.000000 %

DpGetLoadAverage: la15[3] = 0.000000 / -1.000000 %

|  ENQ |   0.000 |   0.000 |   0.000 |

+------+---------+---------+---------+

DpGetLoadAverage: la1[4] = 0.000000 / -1.000000 %

DpGetLoadAverage: la5[4] = 0.000000 / -1.000000 %

DpGetLoadAverage: la15[4] = 0.000000 / -1.000000 %

|  BTC |   0.000 |   0.000 |   0.000 |

+------+---------+---------+---------+

DpGetLoadAverage: la1[5] = 0.166667 / -1.000000 %

DpGetLoadAverage: la5[5] = 0.033333 / -1.000000 %

DpGetLoadAverage: la15[5] = 0.022222 / -1.000000 %

|  SPO |   0.167 |   0.033 |   0.022 |

+------+---------+---------+---------+

DpGetLoadAverage: la1[6] = 0.000000 / -1.000000 %

DpGetLoadAverage: la5[6] = 0.000000 / -1.000000 %

DpGetLoadAverage: la15[6] = 0.000000 / -1.000000 %

|  UP2 |   0.000 |   0.000 |   0.000 |

+------+---------+---------+---------+

Dump of tm_adm structure: Tue Nov 03 13:33:35 2015

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

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

RM-T15, U16,                 , , 19:01:36, M0, W-1,     , 1/0

Workprocess Comm. Area Blocks Tue Nov 03 13:33:35 2015

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

Slots: 1000, Used: 1, Max: 1

+------+--------------+----------+-------------+

|   id | owner        |   pid    | eyecatcher  |

+------+--------------+----------+-------------+

|    0 | DISPATCHER   |       -1 | 0xdeadbeef |

NiWait: sleep (5000ms) ...

NiISelect: timeout 5000ms

NiISelect: maximum fd=921

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Tue Nov 03 19:03:40 2015

NiISelect: TIMEOUT occured (5000ms)

DpHalt: shutdown server >mycomp_DV1_11                           < (normal)

DpJ2eeDisableRestart

DpMBufRead: read server list from MBUF (1 entries)

DpMBufMod: name [mycomp_DV1_11                           ], types 191 state 3 (0x0 0x0 0x0 0x0)

DpMBufMod: call hooks for event MBUF_DPEVT_DSTATE (5->3)

AdGetSelfIdentRecord: >                                                                           <

AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 60

AdCallRegisteredCvtToExt: opcode 60 call 0000000140987240

AdCallRegisteredCvtToExt: opcode 60 exit rc=SAP_O_K

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 0000000140987EE0

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 0000000140987EE0

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 0000000140987EE0

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 0000000140987EE0

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 0000000140987EE0

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 0000000140987EE0

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 0000000140987EE0

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 0000000140987EE0

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 0000000140987EE0

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 0000000140987EE0

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

DpWpBlksLow: wp_blks_in_queue/limit/max = 1/800/1000

DpLockWpBlkEx: lock wp ca_blk 1

make DISP owner of wp_ca_blk 1

DpRqIPutIntoQ: put elem in queue DIA, elems=6

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

MBUF server state SHUTDOWN

DpModState: change state STARTING -> SHUTDOWN

NiBufSend starting

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

MsINiWrite: sent 110 bytes

Tue Nov 03 19:03:41 2015

MsIModState: change state to SHUTDOWN

DpModState: change server state from STARTING to SHUTDOWN

DpHalt: 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

DpHalt: stop work processes

DpHalt: stop gateway

killing process (2772) (SOFT_KILL)

DpHalt: stop icman

killing process (1596) (SOFT_KILL)

DpHalt: terminate gui connections

send SHUTDOWN to REM TM 15

DpWpBlksLow: wp_blks_in_queue/limit/max = 2/800/1000

DpLockWpBlkEx: lock wp ca_blk 2

return errno (-17) to T15

DpTmSend: errormsg without overhead: use mode 0

NiBufIAlloc: malloc NiBufadm, to 0 bytes

DpTmSend: try to send 14 bytes to T15/M0

NiBufSend starting

NiIWrite: hdl 25 sent data (wrt=14,pac=1,MESG_IO)

REL WP ca_blk 2

set status of T15 to TM_DISCONNECTED

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

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

NiBufISelRemove: remove hdl 25 from set0

SiSelNRemove: removed sock 908 (pos=3)

SiSelNRemove: removed sock 908

NiSelIRemove: removed hdl 25

DpDelSocketInfo: del info for nihdl 25 (pos/type=3/3)

NiICloseHandle: shutdown and close hdl 25/sock 908

NiBufIClose: clear extension for hdl 25

dp_tm_adm[15].stat = DP_SLOT_FREE

DpGetSchedule: next schedule 1446557616/922000

DpGetSchedule: no schedule found

DpITmSlotRelease: release slot 15

DpListRemove: remove elem 15 from tmadm_inuse_list

DpListRemove: 15 elems in tmadm_inuse_list

DpListInsert: insert elem 15 into tmadm_free_list (at begin)

DpListInsert: 186 elems in tmadm_free_list

DpHalt: wait for end of work processes

DpHalt: wait for end of gateway

[DpProcDied] Process lives  (PID:2772  HANDLE:792)

DpHalt: waiting for termination of gateway ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=921

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Tue Nov 03 19:03:42 2015

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:2772  HANDLE:792)

DpHalt: waiting for termination of gateway ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=921

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Tue Nov 03 19:03:43 2015

NiISelect: TIMEOUT occured (1000ms)

*** ERROR => [DpProcDied] Process died  (PID:2772  HANDLE:792  rc:0x0) [dpnttool2.c  147]

DpHalt: wait for end of icman

[DpProcDied] Process lives  (PID:1596  HANDLE:800)

DpHalt: waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=921

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Tue Nov 03 19:03:44 2015

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:1596  HANDLE:800)

DpHalt: waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=921

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Tue Nov 03 19:03:45 2015

NiISelect: TIMEOUT occured (1000ms)

*** ERROR => [DpProcDied] Process died  (PID:1596  HANDLE:800  rc:0x0) [dpnttool2.c  147]

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

DpStartStopMsg: Write AD_STARTSTOP message with type=  0, name=mycomp_DV1_11       , sapsysnr=11, hostname=mycomp                                                         

AdGetSelfIdentRecord: >                                                                           <

AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 60

AdCallRegisteredCvtToExt: opcode 60 call 0000000140987240

AdCallRegisteredCvtToExt: opcode 60 exit rc=SAP_O_K

AdCvtRecToExt: opcode 4 (AD_STARTSTOP), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 4

AdCallRegisteredCvtToExt: opcode 4 call 00000001409832D0

AdCallRegisteredCvtToExt: opcode 4 exit rc=SAP_O_K

DpConvertRequest: net size = 189 bytes

NiBufIAlloc: malloc MSLIB-BUF, to 32110 bytes

NiBufSend starting

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

MsINiWrite: sent 562 bytes

MsISnd2: send msg (ms hdr/msg 110/452 bytes) to name                    -, type 4, key -

DpStartStopMsg: stop msg sent

NiBufIAlloc: malloc MSLIB-BUF, to 32110 bytes

NiBufIAlloc: malloc NIBUF-IN, to 32110 bytes

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

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 17

NiBufReceive starting

MsINiRead: received 274 bytes

MsIReceive: received msg (ms hdr/msg 110/164 bytes), flag 1, from MSG_SERVER          , typ 0, key -

DpHalt: received 164 bytes from message server

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

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

DpHalt: more messages from the message server

DpHalt: send keepalive to synchronize with the message server

NiBufSend starting

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

MsINiWrite: sent 114 bytes

MsISnd2: send msg (ms hdr/msg 110/4 bytes) to name           MSG_SERVER, type 0, key -

MsSndName: MS_NOOP ok

Send 4 bytes to MSG_SERVER

NiBufIAlloc: malloc MSLIB-BUF, to 32110 bytes

NiBufIAlloc: malloc NIBUF-IN, to 32110 bytes

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

NiBufIIn: NIBUF len=114

NiBufIIn: packet complete for hdl 17

NiBufReceive starting

MsINiRead: received 114 bytes

MsIReceive: received msg (ms hdr/msg 110/4 bytes), 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

MsISendKeepalive : keepalive sent to message server

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

Tue Nov 03 19:03:46 2015

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

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

DpHalt: no more messages from the message server

DpHalt: sync with message server o.k.

DpHalt: detach from message server

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

NiBufSend starting

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

MsINiWrite: sent 110 bytes

MsIDetach: send logout to msg_server (mycomp / 3911)

MsIDetach: call exit function

DpMsShutdownHook called

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

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

NiBufISelRemove: remove hdl 17 from set0

SiSelNRemove: removed sock 788 (pos=2)

SiSelNRemove: removed sock 788

NiSelIRemove: removed hdl 17

DpDelSocketInfo: del info for nihdl 17 (pos/type=2/4)

MBUF state OFF

AdGetSelfIdentRecord: >                                                                           <

AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 60

AdCallRegisteredCvtToExt: opcode 60 call 0000000140987240

AdCallRegisteredCvtToExt: opcode 60 exit rc=SAP_O_K

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 0000000140987EE0

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 0000000140987EE0

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

DpWpBlksLow: wp_blks_in_queue/limit/max = 2/800/1000

DpLockWpBlkEx: lock wp ca_blk 2

make DISP owner of wp_ca_blk 2

DpRqIPutIntoQ: put elem in queue DIA, elems=7

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

MBUF component DOWN

NiICloseHandle: shutdown and close hdl 17/sock 788

NiBufIClose: clear extension for hdl 17

MsIDetach: detach MS-system (mycomp / 3911)

DpHalt: cleanup EM

EsCleanup( )

EsCleanup ....

EmCleanup() -> 0

Es2Cleanup: Cleanup ES2

***LOG Q05=> DpHalt, DPStop ( 3156) [dpxxdisp.c   11252]

DpHalt: Good Bye .....

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

DEV_RD

---------------------------------------------------

trc file: "dev_rd", trc level: 1, release: "720"

---------------------------------------------------

Tue Nov 03 19:01:25 2015

***LOG S00=> GwInitReader, gateway started ( 2772) [gwxxrd.c     1758]

systemid   562 (PC with Windows NT)

relno      7200

patchlevel 0

patchno    96

intno      20020600

make       multithreaded, Unicode, 64 bit, optimized

pid        2772

gateway runs with dp version 131000(ext=118000) (@(#) DPLIB-INT-VERSION-131000-UC)

gateway (version=720.2011.04.20)

Tue Nov 03 19:01:26 2015

gw/reg_no_conn_info = 1

gw/local_addr : 0.0.0.0

gw/reg_no_conn_info = 1

* SWITCH TRC-RESOLUTION from 1 TO 1

CCMS: initialize CCMS Monitoring for ABAP instance with J2EE addin.

CCMS uses Shared Memory Key 73 for monitoring.

CCMS: SemInMgt: Semaphore Management initialized by AlAttachShm_Doublestack.

CCMS: SemInit: Semaphore 38 initialized by AlAttachShm_Doublestack.

CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

Bind service sapgw11 (socket) to port 3311

GwIRegInitRegInfo: reg_info file C:\usr\sap\DV1\DVEBMGS11\data\reginfo.DAT not found

GwPrintMyHostAddr: my host addresses are :

  1 : [192.168.1.5] mycomp.puffin.com (HOSTNAME)

  2 : [127.0.0.1] genuine.microsoft.com (LOCALHOST)

  3 : [192.168.0.2] mycomp.puffin.com (NILIST)

Full qualified hostname = mycomp.puffin.com

DpSysAdmExtCreate: ABAP is active

DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active

Tue Nov 03 19:01:27 2015

DpIPCInit2: read dp-profile-values from sys_adm_ext

DpShMCreate: sizeof(wp_adm) 33968 (2264)

DpShMCreate: sizeof(tm_adm) 5517056 (27448)

DpShMCreate: sizeof(wp_ca_adm) 64000 (64)

DpShMCreate: sizeof(appc_ca_adm) 64000 (64)

DpCommTableSize: max/headSize/ftSize/tableSize=500/16/584064/584080

DpShMCreate: sizeof(comm_adm) 584080 (1144)

DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0

DpShMCreate: sizeof(slock_adm) 0 (104)

DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

DpShMCreate: sizeof(file_adm) 0 (80)

DpShMCreate: sizeof(vmc_adm) 0 (2152)

DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)

DpShMCreate: sizeof(gw_adm) 48

DpShMCreate: sizeof(j2ee_adm) 3952

DpShMCreate: SHM_DP_ADM_KEY (addr: 0000000011DD0050, size: 6359680)

DpShMCreate: allocated sys_adm at 0000000011DD0060

DpShMCreate: allocated wp_adm_list at 0000000011DD3040

DpShMCreate: allocated wp_adm at 0000000011DD3230

DpShMCreate: allocated tm_adm_list at 0000000011DDB6F0

DpShMCreate: allocated tm_adm at 0000000011DDB740

DpShMCreate: allocated appc_ca_adm at 000000001232E060

DpShMCreate: allocated comm_adm at 000000001233DA70

DpShMCreate: system runs without slock table

DpShMCreate: system runs without file table

DpShMCreate: allocated vmc_adm_list at 00000000123CC410

Tue Nov 03 19:01:28 2015

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated gw_adm at 00000000123CC4C0

DpShMCreate: allocated j2ee_adm at 00000000123CC500

DpShMCreate: allocated ca_info at 00000000123CD480

Tue Nov 03 19:01:30 2015

DpCommAttachTable: attached comm table (header=000000001233DA70/ft=000000001233DA80)

Tue Nov 03 19:01:32 2015

MtxInit: -2 0 0

DpRqQInit: use protect_queue / slots_per_queue 0 / 2001 from sys_adm

Tue Nov 03 19:03:41 2015

GwISigint: received SIGINT (2), start shutdown phase

Tue Nov 03 19:03:42 2015

***LOG S30=> GwStopGateway, gateway stopped () [gwxxrd.c     12995]

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

DEV_W0

---------------------------------------------------

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

---------------------------------------------------

*

*  ACTIVE TRACE LEVEL           1

*  ACTIVE TRACE COMPONENTS      all, MJ

*

M sysno      11

M sid        DV1

M systemid   562 (PC with Windows NT)

M relno      7200

M patchlevel 0

M patchno    100

M intno      20020600

M make       multithreaded, Unicode, 64 bit, optimized

M profile    \\mycomp\sapmnt\DV1\SYS\profile\DV1_DVEBMGS11_mycomp

M pid        2380

M

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

M  length of sys_adm_ext is 588 bytes

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

I  MtxInit: 30000 0 0

M  DpSysAdmExtCreate: ABAP is active

M  DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active

M  DpIPCInit2: read dp-profile-values from sys_adm_ext

M  DpShMCreate: sizeof(wp_adm) 33968 (2264)

M  DpShMCreate: sizeof(tm_adm) 5517056 (27448)

M  DpShMCreate: sizeof(wp_ca_adm) 64000 (64)

M  DpShMCreate: sizeof(appc_ca_adm) 64000 (64)

M  DpCommTableSize: max/headSize/ftSize/tableSize=500/16/584064/584080

M  DpShMCreate: sizeof(comm_adm) 584080 (1144)

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

M  DpShMCreate: sizeof(vmc_adm) 0 (2152)

M  DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)

M  DpShMCreate: sizeof(gw_adm) 48

M  DpShMCreate: sizeof(j2ee_adm) 3952

M  DpShMCreate: SHM_DP_ADM_KEY (addr: 0000000010000050, size: 6359680)

M  DpShMCreate: allocated sys_adm at 0000000010000060

M  DpShMCreate: allocated wp_adm_list at 0000000010003040

M  DpShMCreate: allocated wp_adm at 0000000010003230

M  DpShMCreate: allocated tm_adm_list at 000000001000B6F0

M  DpShMCreate: allocated tm_adm at 000000001000B740

M  DpShMCreate: allocated wp_ca_adm at 000000001054E650

M  DpShMCreate: allocated appc_ca_adm at 000000001055E060

M  DpShMCreate: allocated comm_adm at 000000001056DA70

M  DpShMCreate: system runs without slock table

M  DpShMCreate: system runs without file table

M  DpShMCreate: allocated vmc_adm_list at 00000000105FC410

M  DpShMCreate: system runs without vmc_adm

M  DpShMCreate: allocated gw_adm at 00000000105FC4C0

M  DpShMCreate: allocated j2ee_adm at 00000000105FC500

M  DpShMCreate: allocated ca_info at 00000000105FD480

M  DpShMCreate: allocated wall_adm at 00000000105FD510

M  DpCommAttachTable: attached comm table (header=000000001056DA70/ft=000000001056DA80)

M  DpRqQInit: use protect_queue / slots_per_queue 0 / 2001 from sys_adm

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

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  DpVmcSetActive: set vmc state DP_VMC_NOT_ACTIVE

M Tue Nov 03 19:01:27 2015

M  ThStart: taskhandler started

M  ThInit: initializing DIA work process W0

M Tue Nov 03 19:01:29 2015

M  ThInit: running on host mycomp

M Tue Nov 03 19:01:34 2015

M  calling db_connect ...

B  Loading DB library 'C:\usr\sap\DV1\DVEBMGS11\exe\dbmssslib.dll' ...

B  Library 'C:\usr\sap\DV1\DVEBMGS11\exe\dbmssslib.dll' loaded

B  Version of 'C:\usr\sap\DV1\DVEBMGS11\exe\dbmssslib.dll' is "720.00", patchlevel (0.98)

C  Callback functions for dynamic profile parameter registered

C  Thread ID:3228

C  Thank You for using the SLODBC-interface

C  Using dynamic link library 'C:\usr\sap\DV1\DVEBMGS11\exe\dbmssslib.dll'

C  dbmssslib.dll patch info

C    SAP patchlevel  0

C    SAP patchno  100

C    Last MSSQL DBSL patchlevel 0

C    Last MSSQL DBSL patchno         98

C    Last MSSQL DBSL patchcomment Convert RAW input parameters to literals (1611849)

C  ODBC Driver chosen: SQL Server Native Client 10.0 native

C  lpc:(local) connection used on mycomp

C Tue Nov 03 19:01:50 2015

C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2292]

C  (2) [08001] [Microsoft][SQL Server Native Client 10.0]Shared Memory Provider: Could not open a connection to SQL Server [2].

C  native_db_err 2 severity 0 errclass set to DBSL_EC_RESTART

C  sl_glob.dbsl_ca.errclass set to DBSL_EC_RESTART

C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2292]

C  (0) [HYT00] [Microsoft][SQL Server Native Client 10.0]Login timeout expired

C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2292]

C  (2) [08001] [Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

C Tue Nov 03 19:02:05 2015

C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2292]

C  (2) [08001] [Microsoft][SQL Server Native Client 10.0]Shared Memory Provider: Could not open a connection to SQL Server [2].

C  native_db_err 2 severity 0 errclass set to DBSL_EC_RESTART

C  sl_glob.dbsl_ca.errclass set to DBSL_EC_RESTART

C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2292]

C  (0) [HYT00] [Microsoft][SQL Server Native Client 10.0]Login timeout expired

C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2292]

C  (2) [08001] [Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

C Tue Nov 03 19:02:20 2015

C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2292]

C  (2) [08001] [Microsoft][SQL Server Native Client 10.0]Shared Memory Provider: Could not open a connection to SQL Server [2].

C  native_db_err 2 severity 0 errclass set to DBSL_EC_RESTART

C  sl_glob.dbsl_ca.errclass set to DBSL_EC_RESTART

C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2292]

C  (0) [HYT00] [Microsoft][SQL Server Native Client 10.0]Login timeout expired

C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2292]

C  (2) [08001] [Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

C Tue Nov 03 19:02:38 2015

C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2292]

C  (2) [08001] [Microsoft][SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [2].

C  native_db_err 2 severity 0 errclass set to DBSL_EC_RESTART

C  sl_glob.dbsl_ca.errclass set to DBSL_EC_RESTART

C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2292]

C  (0) [HYT00] [Microsoft][SQL Server Native Client 10.0]Login timeout expired

C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2292]

C  (2) [08001] [Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

C Tue Nov 03 19:02:56 2015

C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2292]

C  (2) [08001] [Microsoft][SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [2].

C  native_db_err 2 severity 0 errclass set to DBSL_EC_RESTART

C  sl_glob.dbsl_ca.errclass set to DBSL_EC_RESTART

C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2292]

C  (0) [HYT00] [Microsoft][SQL Server Native Client 10.0]Login timeout expired

C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2292]

C  (2) [08001] [Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

C Tue Nov 03 19:03:14 2015

C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2292]

C  (2) [08001] [Microsoft][SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [2].

C  native_db_err 2 severity 0 errclass set to DBSL_EC_RESTART

C  sl_glob.dbsl_ca.errclass set to DBSL_EC_RESTART

C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2292]

C  (0) [HYT00] [Microsoft][SQL Server Native Client 10.0]Login timeout expired

C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2292]

C  (2) [08001] [Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

C  Connection 0 failed using Driver={SQL Server Native Client 10.0};Server=MYCOMP;AutoTranslate=no;Trusted_Connection=yes;WSID=mycomp;APP=R3D00 comm rd ODBC;Database=DV1;

B  ***LOG BV3=> severe db error 2         ; work process is stopped [dbsh         1241]

B  ***LOG BY2=> sql error 2      performing CON [dblink       540]

B  ***LOG BY0=> [Microsoft][SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [2].  [dblink       540]

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

M  in_ThErrHandle: 1

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

M  Info for wp 0

M    pid = 2380

M    severity = 0

M    status = 0

M    stat = WP_NEW

M    waiting_for = NO_WAITING

M    reqtype = DP_RQ_DIAWP

M    act_reqtype = NO_REQTYPE

M    req.req_info =

M    req.tid = -1

M    req.uid = 4294967295

M    req.mode = 255

M    req.len = 0

M    req.rq_id = 65535

M    req.rq_source =

M    last_tid = 0

M    last_uid = 0

M    last_mode = 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  ThIErrHandle: current request:

M  -IN-- sender_id ?                 tid  -1    wp_ca_blk   -1      wp_id -1

M  -IN-- action    -                 uid  -1    appc_ca_blk -1      type  -   

M  -IN-- new_stat  NO_CHANGE         mode 255   len         0       rq_id -1

M  *****************************************************************************

M  *

M  *  LOCATION    SAP-Server mycomp_DV1_11 on host mycomp (wp 0)

M  *  ERROR       ThInit: db_connect

M  *

M  *  TIME        Tue Nov 03 19:03:14 2015

M  *  RELEASE     720

M  *  COMPONENT   Taskhandler

M  *  VERSION     1

M  *  RC          13

M  *  MODULE      thxxhead.c

M  *  LINE        11572

M  *  COUNTER     1

M  *

M  *****************************************************************************

M  PfStatDisconnect: disconnect statistics

M  Entering TH_CALLHOOKS

M  ThCallHooks: call hook >ThrBtcCallLgCl< for event BEFORE_DUMP

M  ThCallHooks: hook >ThrBtcCallLgCl< o.k.

M  ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M  *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c   779]

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

M  ThIErrHandle: 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 (Workp. 0 2380) [dpnttool.c   339]

Accepted Solutions (0)

Answers (2)

Answers (2)

sankar_27
Active Participant
0 Kudos

make sure to check below as per PAM

1. App server , DB on correct OS Version

2. Upgrade Kernel , DB as per PAM

3. Install upgrade DB client as per DB server

yakcinar
Active Contributor
0 Kudos

Hello Harman,

It seems as if there is something wrong with DB. You can see in wp developer traces.

Can you check R3trans -d command by loging into the systems with sidadm?

Does it return 0?

C Tue Nov 03 19:01:50 2015

C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2292]

C  (2) [08001] [Microsoft][SQL Server Native Client 10.0]Shared Memory Provider: Could not open a connection to SQL Server [2].

C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2292]

C  (2) [08001] [Microsoft][SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [2].

C  native_db_err 2 severity 0 errclass set to DBSL_EC_RESTART

C  sl_glob.dbsl_ca.errclass set to DBSL_EC_RESTART

C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2292]

C  (0) [HYT00] [Microsoft][SQL Server Native Client 10.0]Login timeout expired

C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2292]

C  (2) [08001] [Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

C  Connection 0 failed using Driver={SQL Server Native Client 10.0};Server=MYCOMP;AutoTranslate=no;Trusted_Connection=yes;WSID=mycomp;APP=R3D00 comm rd ODBC;Database=DV1;

Regards,

Yuksel AKCINAR

Former Member
0 Kudos

Hello Yuksel, thank you for your reply.

Please help me explain for "how to R3trans -d command by logging into the systems with sidadm"

Thank you

yakcinar
Active Contributor
0 Kudos

Hello Harman,

Login to system with sidadm.

Then run cmd (command prompt)

Then run "R3trans -d"

This will check whether you can connect to the DB

Regards,

Yuksel AKCINAR

Former Member
0 Kudos

It Says 0012

Former Member
0 Kudos

Please paste the  trans.log.

Also please let us know the kernel version, you might have to update the kernel patch and the R3trans.

Regards,

Ambarish.

Former Member
0 Kudos

4 ETW000 r3trans version 6.22 (release 720 - 03.06.11 - 17:57:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time   : 03.11.2015 - 20:47:32

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: r3trans -d

4 ETW000  trace at level 2 opened for a given file pointer

4 ETW000  [     dev trc,00000]  Tue Nov 03 20:47:32 2015                                                 123  0.000123

4 ETW000  [     dev trc,00000]  db_con_init called                                                        75  0.000198

4 ETW000  [     dev trc,00000]  set_use_ext_con_info(): rsdb/ssfs_connect not set => ssfs not used        78  0.000276

4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                  72  0.000348

4 ETW000  [     dev trc,00000]  create_con (con_name=R/3)                                                 39  0.000387

4 ETW000  [    dbcon.c ,00000]  *** ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library

4 ETW000                                                                                                 112  0.000499

2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."

yakcinar
Active Contributor
0 Kudos

Hello Harman,

You are running the command using dv1adm user, aren't you?

Chek dv1adm environment variables. You can check them on command prompt running set command.

There must be DBMS_TYPE environment variable set to mss.

Also check the profile files under usr/sap/DV1/SYS/prrofile whether they exist firstly.

Then check that there is "dbms/type = mss" in DEFAULT.PFL.

Regards,

Yuksel AKCINAR

Former Member
0 Kudos

sir i dont have dv1adm and rest of the folders i didnt find r3trans

Former Member
0 Kudos

profiles are there already

yakcinar
Active Contributor
0 Kudos

Hello Harrman,

dv1adm is the user. You must have logged in with that user to windows.

As you can see below, myuser is esmadm (yours is dv1adm).

When you run whoami on command prompts you can see the user.

Then run set command to see environment variables of that user.

You must see "DBMS_TYPE = mss" in environment variables.

If you can see this env variable, you can run "R3trans -d" on command prompt and you must have 0 return code.

If you are running with dv1adm user and cannot see env variable, there must have been some problem with the user. Check all env variables of dv1adm with a running SAP system sidadm user's env variables and arrange them like running one.

You are showing the profiles. Did you check the content whether there is "dbms/type = mss" in DEFAULT.PFL.

Regards,

Yuksel AKCINAR

Former Member
0 Kudos

Hello Yuksel

I'm using administrator (user).

every user has facing the same issue "dispatcher no running"

The default Profile

yakcinar
Active Contributor
0 Kudos

Hello Harman,

You can use "R3trans -d" with user dv1adm. This does not work with Administrator.

Check these;

1-

Check that whether SQL Server is running?

You can do this using SQL Server Management Studio program Or you can check MSSQLSERVER services running as seen below?

2-

Can you also check the disks whether they are full?

Regards,

Yuksel AKCINAR

Former Member
0 Kudos

No sir, SQL Server not started and it gives me the following error if i try to start

2. have two disks and they are not full one left with 65 gb(ECC) and other 250 gb

yakcinar
Active Contributor
0 Kudos

Hello Harman,

Firstly I advice you to login to system using dv1adm user. Check whethere service starts or not.


Then run Event Viewer program for windows logs and chek the logs about the SQL Server service.

Investigate the root cause of the error.

    

Regards,

Yuksel AKCINAR

Former Member
0 Kudos

Sir Yuksel

from user "dv1adm" has the same issue & it was not letting me start the SQL SERVERql (same error 3417)

Event viewer

yakcinar
Active Contributor
0 Kudos

Hello Harman,

Error says everything. There is a corruption in your master db.

You must recover master DB from backups.

Master db keeps your DV1 info, user info etc.

If you don't have backup of your master DB. rebuid it using SQL Server books (you can google)

Then attach your DV1 DB. And start services. Then sap.

I advice you to have an expert consultancy.

That's all from me.

Regards,

Yuksel AKCINAR

Former Member
0 Kudos

Thank you very much sir for your valuable guidance

Regards

Harman Singh