cancel
Showing results for 
Search instead for 
Did you mean: 

the disp+work.exe is starting and stoping after 1 min

Former Member
0 Kudos

The  disp+work.exe is starting , But then stopping after 1 min.


Virtual memory is set to 25 gb


Attached is the dev_disp file




Accepted Solutions (0)

Answers (9)

Answers (9)

former_member186895
Participant
0 Kudos

Hello ,

Problem seems to be from sidadm and sapservicesid user.

Please try to login with these user at o.s level.

Thanks

former_member182657
Active Contributor
0 Kudos

In addition check for UAC & should be in disabled mode as well,refer SAP Note   1386328 - Logon to Management Studio Error 18456

Regards,

former_member182657
Active Contributor
0 Kudos
Former Member
0 Kudos

Hi ,

Not able to find the dev_w0. Please paste the dev_w0 result.

Regards

RK

Former Member
0 Kudos

Hi,

I some how manage to Start the database.

But the problem with the sap system still exist

former_member182657
Active Contributor
0 Kudos

Hi,


But the problem with the sap system still exist

Please elaborate in detail & share dev_w0 & trans.log files as well as requested earlier .

Former Member
0 Kudos

What is the output of R3trans -d (after starting database)

Also check sap profile parameters, hostname maintained correctly or nor

Former Member
0 Kudos

R3trans -d :


Microsoft Windows [Version 5.2.3790]

(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\b71adm>R3trans -d

This is R3trans version 6.18 (release 710 - 08.08.11 - 18:03:42).

unicode enabled version

R3trans finished (0000).

C:\Documents and Settings\b71adm>

Dev_w0 file is attached

Former Member
0 Kudos

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

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

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

sysno      00

sid        BI1

systemid   562 (PC with Windows NT)

relno      7200

patchlevel 0

patchno    400

intno      20020600

make       multithreaded, Unicode, 64 bit, optimized

profile    C:\usr\sap\BI1\SYS\profile\BI1_DVEBMGS00_BI70EHP1

pid        4892

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

length of sys_adm_ext is 588 bytes

*** SWITCH TRC-HIDE on ***

***LOG Q00=> DpSapEnvInit, DPStart (00 4892) [dpxxdisp.c   1320]

  shared lib "dw_xml.dll" version 400 successfully loaded

  shared lib "dw_xtc.dll" version 400 successfully loaded

  shared lib "dw_stl.dll" version 400 successfully loaded

  shared lib "dw_gui.dll" version 400 successfully loaded

  shared lib "dw_mdm.dll" version 400 successfully loaded

  shared lib "dw_rndrt.dll" version 400 successfully loaded

  shared lib "dw_abp.dll" version 400 successfully loaded

  shared lib "dw_sym.dll" version 400 successfully loaded

  shared lib "dw_aci.dll" version 400 successfully loaded

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

use internal message server connection to port 3900

rdisp/dynamic_wp_check : 1

rdisp/calculateLoadAverage : 1

Thu Apr 16 07:21:16 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  6438]

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

DpShMCreate: sizeof(wp_adm) 42864 (2256)

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/1384064/1384080

DpShMCreate: sizeof(comm_adm) 1384080 (2744)

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

DpShMCreate: sizeof(slock_adm) 0 (296)

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

DpShMCreate: sizeof(file_adm) 0 (80)

DpShMCreate: sizeof(vmc_adm) 0 (2160)

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

DpShMCreate: sizeof(gw_adm) 48

DpShMCreate: sizeof(j2ee_adm) 3952

DpShMCreate: SHM_DP_ADM_KEY (addr: 0000000005490050, size: 7174832)

DpShMCreate: allocated sys_adm at 0000000005490060

DpShMCreate: allocated wp_adm_list at 00000000054930B0

DpShMCreate: allocated wp_adm at 00000000054932A0

DpShMCreate: allocated tm_adm_list at 000000000549DA20

DpShMCreate: allocated tm_adm at 000000000549DA70

DpShMCreate: allocated wp_ca_adm at 00000000059E0980

DpShMCreate: allocated appc_ca_adm at 00000000059F0390

DpShMCreate: allocated comm_adm at 00000000059FFDA0

DpShMCreate: system runs without slock table

DpShMCreate: system runs without file table

DpShMCreate: allocated vmc_adm_list at 0000000005B51C40

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated gw_adm at 0000000005B51CF0

DpShMCreate: allocated j2ee_adm at 0000000005B51D30

DpShMCreate: allocated ca_info at 0000000005B52CB0

DpShMCreate: allocated wall_adm at 0000000005B52D40

DpCommAttachTable: attached comm table (header=00000000059FFDA0/ft=00000000059FFDB0)

DpSysAdmIntInit: initialize sys_adm

rdisp/test_roll : roll strategy is DP_NORMAL_ROLL

dia token check not active (10 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> EsILock: use spinlock for locking

<ES> InitFreeList

<ES> block size is 4096 kByte.

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

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

Using implementation view

<EsNT> Using memory model view.

<EsNT> Memory Reset disabled as NT default

<ES> 1471 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%

rdisp/http_min_wait_dia_wp : 1 -> 1

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

***LOG Q0K=> DpMsAttach, mscon ( BI70EHP1) [dpxxdisp.c   12674]

MBUF state LOADING

***LOG Q0I=> NiPGetHostByName: 'BI70EHP1.approva.int' not found: getaddrinfo [ninti.c 895]

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

DpStartStopMsg: start msg sent

CCMS: Initialized monitoring segment of size 60000000.

CCMS: Initialized CCMS Headers in the shared monitoring segment.

CCMS: Checking Downtime Configuration of Monitoring Segment.

CCMS: AlMsUpload called by wp 1024.

Thu Apr 16 07:21:17 2015

CCMS: AlMsUpload successful for C:\usr\sap\BI1\DVEBMGS00\log\ALMTTREE.DAT (1244 MTEs).

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 %)

Thu Apr 16 07:21:56 2015

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

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

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

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

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

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

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

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

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

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

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

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

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

*** ERROR => DpHdlDeadWp: W13 (pid 4980) died (severity=0, status=0) [dpxxwp.c     1727]

*** ERROR => DpHdlDeadWp: W14 (pid 4888) died (severity=0, status=0) [dpxxwp.c     1727]

*** ERROR => DpHdlDeadWp: W15 (pid 1396) died (severity=0, status=0) [dpxxwp.c     1727]

*** ERROR => DpHdlDeadWp: W16 (pid 3624) died (severity=0, status=0) [dpxxwp.c     1727]

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

*** DISPATCHER EMERGENCY SHUTDOWN ***

increase tracelevel of WPs

NiWait: sleep (10000ms) ...

NiISelect: timeout 10000ms

NiISelect: maximum fd=1349

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Apr 16 07:22:06 2015

NiISelect: TIMEOUT occured (10000ms)

dump system status

Workprocess Table (long) Thu Apr 16 11:22:06 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 DIA       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

7 DIA       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

8 DIA       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

9 DIA       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

10 UPD       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

11 ENQ       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

12 BTC       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

13 BTC       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

14 BTC       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

15 SPO       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

16 UP2       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

Dispatcher Queue Statistics Thu Apr 16 11:22:06 2015

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

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

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

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

| NOWP |      0 |      2 |   2000 |          5 |          5 |

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

|  DIA |      3 |      3 |   2000 |          3 |          0 |

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

|  UPD |      0 |      0 |   2000 |          0 |          0 |

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

|  ENQ |      0 |      0 |   2000 |          0 |          0 |

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

|  BTC |      0 |      0 |   2000 |          0 |          0 |

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

|  SPO |      0 |      0 |   2000 |          0 |          0 |

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

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

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

max_rq_id 7

wake_evt_udp_now 0

wake events       total     5,  udp     5 (100%),  shm     0 (  0%)

since last update total     5,  udp     5 (100%),  shm     0 (  0%)

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

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

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

Dispatcher Load Statistics

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

|  Typ |     LA1 |     LA5 |    LA15 |

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

|  DIA |   0.000 |   0.000 |   0.033 |

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

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.000000 / -1.000000 %

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

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

|  SPO |   0.000 |   0.000 |   0.000 |

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

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: Thu Apr 16 11:22:06 2015

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

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

RM-T19, U20,                 , , 07:21:23, M0, W-1,     , 1/0

Workprocess Comm. Area Blocks Thu Apr 16 11:22:06 2015

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

Slots: 1000, Used: 1, Max: 1

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

|   id | owner        |   pid    | eyecatcher  |

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

|    0 | DISPATCHER   |       -1 | 0xdeadbeef |

NiWait: sleep (5000ms) ...

NiISelect: timeout 5000ms

NiISelect: maximum fd=1349

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Apr 16 07:22:11 2015

NiISelect: TIMEOUT occured (5000ms)

DpHalt: shutdown server >BI70EHP1_BI1_00                         < (normal)

DpJ2eeDisableRestart

DpMBufRead: read server list from MBUF (1 entries)

DpMBufMod: name [BI70EHP1_BI1_00                         ], 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 00000001415EF5C0

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 00000001415F0310

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 00000001415F0310

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 00000001415F0310

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 00000001415F0310

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 00000001415F0310

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 00000001415F0310

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 00000001415F0310

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 00000001415F0310

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 00000001415F0310

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 00000001415F0310

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

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

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

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

*** ERROR => DpProcKill: kill failed [dpntdisp.c   397]

DpHalt: stop icman

killing process (3520) (SOFT_KILL)

DpHalt: terminate gui connections

send SHUTDOWN to REM TM 19

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

DpLockWpBlkEx: lock wp ca_blk 2

return errno (-17) to T19

DpTmSend: errormsg without overhead: use mode 0

NiBufIAlloc: malloc NiBufadm, to 0 bytes

DpTmSend: try to send 14 bytes to T19/M0

NiBufSend starting

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

REL WP ca_blk 2

set status of T19 to TM_DISCONNECTED

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

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

NiBufISelRemove: remove hdl 25 from set0

SiSelNRemove: removed sock 1216 (pos=3)

SiSelNRemove: removed sock 1216

NiSelIRemove: removed hdl 25

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

NiICloseHandle: shutdown and close hdl 25/sock 1216

NiBufIClose: clear extension for hdl 25

dp_tm_adm[19].stat = DP_SLOT_FREE

DpGetSchedule: next schedule 1429183336/234000

DpGetSchedule: no schedule found

DpITmSlotRelease: release slot 19

DpListRemove: remove elem 19 from tmadm_inuse_list

DpListRemove: 19 elems in tmadm_inuse_list

DpListInsert: insert elem 19 into tmadm_free_list (at begin)

DpListInsert: 182 elems in tmadm_free_list

DpHalt: wait for end of work processes

DpHalt: wait for end of gateway

*** ERROR => [DpProcDied] Process died  (PID:268  HANDLE:1312  rc:0x1) [dpnttool2.c  147]

DpHalt: wait for end of icman

[DpProcDied] Process lives  (PID:3520  HANDLE:1324)

DpHalt: waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1349

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Apr 16 07:22:12 2015

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:3520  HANDLE:1324)

DpHalt: waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1349

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Apr 16 07:22:13 2015

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:3520  HANDLE:1324)

DpHalt: waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1349

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Apr 16 07:22:14 2015

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:3520  HANDLE:1324)

DpHalt: waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1349

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Apr 16 07:22:15 2015

NiISelect: TIMEOUT occured (1000ms)

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

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

DpStartStopMsg: Write AD_STARTSTOP message with type=  0, name=BI70EHP1_BI1_00     , sapsysnr= 0, hostname=BI70EHP1                                                       

AdGetSelfIdentRecord: >                                                                           <

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

AdCallRegisteredCvtToExt: opcode 60

AdCallRegisteredCvtToExt: opcode 60 call 00000001415EF5C0

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 00000001415EB650

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

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

NiIPeek: peek successful for hdl 17 (r)

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)

Thu Apr 16 07:22:16 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   13071]

NiBufSend starting

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

MsINiWrite: sent 110 bytes

MsIDetach: send logout to msg_server (BI70EHP1 / 3900)

MsIDetach: call exit function

DpMsShutdownHook called

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

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

NiBufISelRemove: remove hdl 17 from set0

SiSelNRemove: removed sock 1236 (pos=2)

SiSelNRemove: removed sock 1236

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 00000001415EF5C0

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 00000001415F0310

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 00000001415F0310

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

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

MBUF component DOWN

NiICloseHandle: shutdown and close hdl 17/sock 1236

NiBufIClose: clear extension for hdl 17

MsIDetach: detach MS-system (BI70EHP1 / 3900)

DpHalt: cleanup EM

EsCleanup( )

EsCleanup ....

EmCleanup() -> 0

Es2Cleanup: Cleanup ES2

***LOG Q05=> DpHalt, DPStop ( 4892) [dpxxdisp.c   11581]

DpHalt: Good Bye .....

Former Member
0 Kudos

Trans.log :

4 ETW000 R3trans version 6.23 (release 720 - 31.10.12 - 20:12:06).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 16.04.2015 - 11:29:03

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]  Thu Apr 16 11:29:03 2015                                                3166  0.003166

4 ETW000  [     dev trc,00000]  db_con_init called                                                        52  0.003218

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

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

4 ETW000                                                                                                  49  0.003324

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

4 ETW000  [     dev trc,00000]  Loading DB library 'dbmssslib.dll' ...                                   384  0.004030

4 ETW000  [     dev trc,00000]  DlLoadLib success: LoadLibrary("dbmssslib.dll"), hdl 0, addr 0000000187230000

4 ETW000                                                                                                8959  0.012989

4 ETW000  [     dev trc,00000]      using "C:\usr\sap\BI1\SYS\exe\uc\NTAMD64\dbmssslib.dll"               25  0.013014

4 ETW000  [     dev trc,00000]  Library 'dbmssslib.dll' loaded                                            26  0.013040

4 ETW000  [     dev trc,00000]  function DbSlExpFuns loaded from library dbmssslib.dll                    31  0.013071

4 ETW000  [     dev trc,00000]  Version of 'dbmssslib.dll' is "720.00", patchlevel (0.324)              8734  0.021805

4 ETW000  [     dev trc,00000]  function dsql_db_init loaded from library dbmssslib.dll                   51  0.021856

4 ETW000  [     dev trc,00000]  function dbdd_exp_funs loaded from library dbmssslib.dll                  26  0.021882

4 ETW000  [     dev trc,00000]  New connection 0 created                                                  40  0.021922

4 ETW000  [     dev trc,00000]  0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = 

4 ETW000                                                                                                  70  0.021992

4 ETW000  [     dev trc,00000]  db_con_connect (con_name=R/3)                                             42  0.022034

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

4 ETW000                                                                                                  51  0.022085

4 ETW000  [     dev trc,00000]  find_con_by_name found the following connection:                          33  0.022118

4 ETW000  [     dev trc,00000]  0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = 

4 ETW000                                                                                                 219  0.022337

4 ETW000  [     dev trc,00000]  Thread ID:2520                                                          4380  0.026717

4 ETW000  [     dev trc,00000]  Thank You for using the SLODBC-interface                                  41  0.026758

4 ETW000  [     dev trc,00000]  Using dynamic link library 'C:\usr\sap\BI1\SYS\exe\uc\NTAMD64\dbmssslib.dll'

4 ETW000                                                                                                  48  0.026806

4 ETW000  [     dev trc,00000]  dbmssslib.dll patch info                                                  76  0.026882

4 ETW000  [     dev trc,00000]    SAP patchlevel  0                                                       25  0.026907

4 ETW000  [     dev trc,00000]    SAP patchno  400                                                       106  0.027013

4 ETW000  [     dev trc,00000]    Last MSSQL DBSL patchlevel 0                                            63  0.027076

4 ETW000  [     dev trc,00000]    Last MSSQL DBSL patchno         324                                     43  0.027119

4 ETW000  [     dev trc,00000]    Last MSSQL DBSL patchcomment Local connection to a named instance does not use LPC (1782171)

4 ETW000                                                                                                  66  0.027185

4 ETW000  [     dev trc,00000]  ODBC Driver chosen: SQL Native Client native                            3438  0.030623

4 ETW000  [     dev trc,00000]  lpc:(local) connection used on BI70EHP1                                  278  0.030901

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2373]

4 ETW000                                                                                              122234  0.153135

4 ETW000  [     dev trc,00000]  (18456) [28000] [Microsoft][SQL Native Client][SQL Server]Login failed for user 'BI70EHP1\bi1adm'.

4 ETW000                                                                                                  77  0.153212

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2373]

4 ETW000                                                                                                  58  0.153270

4 ETW000  [     dev trc,00000]  (4060) [42000] [Microsoft][SQL Native Client][SQL Server]Cannot open database "BI1" requested by the login. The login failed.

4 ETW000                                                                                                  43  0.153313

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2373]

4 ETW000                                                                                                5040  0.158353

4 ETW000  [     dev trc,00000]  (18456) [28000] [Microsoft][SQL Native Client][SQL Server]Login failed for user 'BI70EHP1\bi1adm'.

4 ETW000                                                                                                  43  0.158396

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2373]

4 ETW000                                                                                                  41  0.158437

4 ETW000  [     dev trc,00000]  (4060) [42000] [Microsoft][SQL Native Client][SQL Server]Cannot open database "BI1" requested by the login. The login failed.

4 ETW000                                                                                                  42  0.158479

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2373]

4 ETW000                                                                                                4370  0.162849

4 ETW000  [     dev trc,00000]  (18456) [28000] [Microsoft][SQL Native Client][SQL Server]Login failed for user 'BI70EHP1\bi1adm'.

4 ETW000                                                                                                  74  0.162923

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2373]

4 ETW000                                                                                                  78  0.163001

4 ETW000  [     dev trc,00000]  (4060) [42000] [Microsoft][SQL Native Client][SQL Server]Cannot open database "BI1" requested by the login. The login failed.

4 ETW000                                                                                                  46  0.163047

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2373]

4 ETW000                                                                                                5182  0.168229

4 ETW000  [     dev trc,00000]  (18456) [28000] [Microsoft][SQL Native Client][SQL Server]Login failed for user 'BI70EHP1\bi1adm'.

4 ETW000                                                                                                  49  0.168278

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2373]

4 ETW000                                                                                                  42  0.168320

4 ETW000  [     dev trc,00000]  (4060) [42000] [Microsoft][SQL Native Client][SQL Server]Cannot open database "BI1" requested by the login. The login failed.

4 ETW000                                                                                                  42  0.168362

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2373]

4 ETW000                                                                                                4819  0.173181

4 ETW000  [     dev trc,00000]  (18456) [28000] [Microsoft][SQL Native Client][SQL Server]Login failed for user 'BI70EHP1\bi1adm'.

4 ETW000                                                                                                  46  0.173227

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2373]

4 ETW000                                                                                                  44  0.173271

4 ETW000  [     dev trc,00000]  (4060) [42000] [Microsoft][SQL Native Client][SQL Server]Cannot open database "BI1" requested by the login. The login failed.

4 ETW000                                                                                                  45  0.173316

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2373]

4 ETW000                                                                                                4638  0.177954

4 ETW000  [     dev trc,00000]  (18456) [28000] [Microsoft][SQL Native Client][SQL Server]Login failed for user 'BI70EHP1\bi1adm'.

4 ETW000                                                                                                  43  0.177997

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2373]

4 ETW000                                                                                                  41  0.178038

4 ETW000  [     dev trc,00000]  (4060) [42000] [Microsoft][SQL Native Client][SQL Server]Cannot open database "BI1" requested by the login. The login failed.

4 ETW000                                                                                                  42  0.178080

4 ETW000  [     dev trc,00000]  Connection 0 failed using Driver={SQL Native Client};Server=BI70EHP1;AutoTranslate=no;Trusted_Connection=yes;WSID=BI70EHP1;APP=R3 00 comm rd ODBC;Database=BI1;

4 ETW000                                                                                                  50  0.178130

4 ETW000  [    dblink  ,00000]  ***LOG BY2=>sql error 18456  performing CON                             3402  0.181532

4 ETW000  [    dblink  ,00000]  ***LOG BY0=>Login failed for user 'BI70EHP1\bi1adm'.                      48  0.181580

2EETW169 no connect possible: "DBMS = MSSQL                            ---  SERVER = 'BI70EHP1' DBNAME = 'BI1'"

former_member182657
Active Contributor
0 Kudos

Hi,

Issue is


Login failed for user 'BI70EHP1\bi1adm

Could you check for the credentials for user BI70EHP1 ?

Former Member
0 Kudos

Hi,

Your server in Windows , Have you taken restart of OS level, I would recommend you to please take OS level reboot,and try starting ,Hope it will work ,

Regards

RK

former_member186895
Participant
0 Kudos

Hello,

please try R3trans -d commond and check what retrun code you are getting?

Also paste log of R3trans -d here.

hope sap and db services are running in services.msc

Thanks

Former Member
0 Kudos

database is not starting

Former Member
0 Kudos

r3trans log

Microsoft Windows [Version 5.2.3790]

(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\bi1a>R3trans -d

This is R3trans version 6.23 (release 720 - 31.10.12 - 20:12:06).

unicode enabled version

R3trans=>sapparam(1c): No Profile used.

R3trans=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

2EETW169 no connect possible: "DBMS = MSSQL                            ---  SERV

ER = 'BI70EH' DBNAME = 'BI1'"

R3trans finished (0012).

srinivasan_vinayagam
Active Contributor
0 Kudos

Hi Sanket,

The issue with Database not SAP.

first try to start MS SQL Database.

login with Windows Authendication and start to start.

Regards,

V Srinivasan

Former Member
0 Kudos

with windows authentication , error 4064.

former_member182657
Active Contributor
0 Kudos

Hi,

Could you share trans.log & dev_w0 log files ?

Thanks,

Former Member
0 Kudos

Hi,

Please share dev_w0 trace file

Regards

Mrinal

srinivasan_vinayagam
Active Contributor
0 Kudos

Hi Sanket,

Check your database running or not?

if not started first start then start sap.

Former Member
0 Kudos

I tried to bring it online but the error :

TITLE: Microsoft SQL Server Management Studio

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

Cannot show requested dialog.

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

ADDITIONAL INFORMATION:

Unable to execute requested command.

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

Attempt to retrieve data for object failed for Server 'xxxxx'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&EvtSrc=Microsoft.S...

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

Failed to connect to server xxxxxx. (Microsoft.SqlServer.ConnectionInfo)

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

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=204...

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

BUTTONS:

OK

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

srinivasan_vinayagam
Active Contributor
0 Kudos

Hi Sanket,

You can check sa user is locked?

  1. Click Start > Programs > Microsoft SQL Server  > Configuration Tools > SQL Server Configuration Manager.
  2. Under SQL Server Network Configuration > Protocols for MSSQLSERVER:
    1. Double-click the protocol name TCP/IP and set the property ENABLED to Yes.
    2. Double-click the protocol name Named Pipes and set the property ENABLED to Yes.
  3. To restart MS SQL service, run the following commands in the command prompt window of the Parallels Pro Control Panel server:
  4. net stop mssqlserver
    net start mssqlserver

Regards,

V Srinivasan

Former Member
0 Kudos

>> error occurred during the login process

Looks like you were unable to login to the management studio.

If it is with SA account, then try with installation user(if Windows Authentication is enabled)

regards,

pavan