on 04-16-2015 12:40 PM
Hello ,
Problem seems to be from sidadm and sapservicesid user.
Please try to login with these user at o.s level.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In addition check for UAC & should be in disabled mode as well,refer SAP Note 1386328 - Logon to Management Studio Error 18456
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If possible refer SAP KBA 1876651 - Error in File ~xxx.rpt: Unable to connect: incorrect log on parameters. Details: [Database...
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
Not able to find the dev_w0. Please paste the dev_w0 result.
Regards
RK
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I some how manage to Start the database.
But the problem with the sap system still exist
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
---------------------------------------------------
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 .....
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'"
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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).
Hi,
Could you share trans.log & dev_w0 log files ?
Thanks,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please share dev_w0 trace file
Regards
Mrinal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sanket,
Check your database running or not?
if not started first start then start sap.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
------------------------------
Hi Sanket,
You can check sa user is locked?
net stop mssqlserver
net start mssqlserver
Regards,
V Srinivasan
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.