on 01-12-2015 5:51 PM
Can someone please help? I've been trying to figure this out for the last week without any success.
My problem is 2 fold.
1) SAP BW used to work but stopped working a few days ago. When I start the databases the disp+work.exe is grey and has a status of Stopped. When BW was working the disp+work.exe was yellow but I was still able to connect.
2) SAP BPC 7.5 isn't working at all. Meaning, I am not able to connect to it. I receive an error stating that the IP is unreachable. I think the 2 problems are related but I could be wrong.
Here is the dev_disp log. I hope this helps and I appreciate any help.
---------------------------------------------------
trc file: "dev_disp", trc level: 1, release: "701"
---------------------------------------------------
sysno 41
sid PDV
systemid 562 (PC with Windows NT)
relno 7010
patchlevel 0
patchno 32
intno 20020600
make: multithreaded, Unicode, 64 bit, optimized
pid 3328
Sat Jan 10 02:11:25 2015
kernel runs with dp version 241000(ext=110000) (@(#) DPLIB-INT-VERSION-241000-UC)
length of sys_adm_ext is 576 bytes
*** SWITCH TRC-HIDE on ***
***LOG Q00=> DpSapEnvInit, DPStart (41 3328) [dpxxdisp.c 1286]
shared lib "dw_xml.dll" version 32 successfully loaded
shared lib "dw_xtc.dll" version 32 successfully loaded
shared lib "dw_stl.dll" version 32 successfully loaded
shared lib "dw_gui.dll" version 32 successfully loaded
shared lib "dw_mdm.dll" version 32 successfully loaded
rdisp/softcancel_sequence : -> 0,5,-1
use internal message server connection to port 3941
Sat Jan 10 02:11:30 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 5529]
MtxInit: 30000 0 0
DpSysAdmExtInit: ABAP is active
DpSysAdmExtInit: VMC (JAVA VM in WP) is not active
DpIPCInit2: start server >erpukpltm_PDV_41 <
DpShMCreate: sizeof(wp_adm) 21024 (1752)
DpShMCreate: sizeof(tm_adm) 5912704 (29416)
DpShMCreate: sizeof(wp_ca_adm) 24064 (80)
DpShMCreate: sizeof(appc_ca_adm) 8000 (80)
DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080
DpShMCreate: sizeof(comm_adm) 552080 (1088)
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 (72)
DpShMCreate: sizeof(vmc_adm) 0 (1864)
DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)
DpShMCreate: sizeof(gw_adm) 48
DpShMCreate: SHM_DP_ADM_KEY (addr: 00000000092B0050, size: 6605376)
DpShMCreate: allocated sys_adm at 00000000092B0050
DpShMCreate: allocated wp_adm at 00000000092B2270
DpShMCreate: allocated tm_adm_list at 00000000092B7490
DpShMCreate: allocated tm_adm at 00000000092B74F0
DpShMCreate: allocated wp_ca_adm at 000000000985AD70
DpShMCreate: allocated appc_ca_adm at 0000000009860B70
DpShMCreate: allocated comm_adm at 0000000009862AB0
DpShMCreate: system runs without slock table
DpShMCreate: system runs without file table
DpShMCreate: allocated vmc_adm_list at 00000000098E9740
DpShMCreate: allocated gw_adm at 00000000098E97C0
DpShMCreate: system runs without vmc_adm
DpShMCreate: allocated ca_info at 00000000098E97F0
DpShMCreate: allocated wall_adm at 00000000098E9800
MBUF state OFF
DpCommInitTable: init table for 500 entries
rdisp/queue_size_check_value : -> off
ThTaskStatus: rdisp/reset_online_during_debug 0
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( 10230MB) not multiple of em/blocksize_KB( 4096KB)
<ES> Info: em/initial_size_MB rounded up to 10232MB
Using implementation view
<EsNT> Using memory model view.
<EsNT> Memory Reset disabled as NT default
<ES> 2557 blocks reserved for free list.
ES initialized.
J2EE server info
start = TRUE
state = STARTED
pid = 3208
argv[0] = D:\usr\sap\PDV\DVEBMGS41\exe\jcontrol.EXE
argv[1] = D:\usr\sap\PDV\DVEBMGS41\exe\jcontrol.EXE
argv[2] = pf=D:\usr\sap\PDV\SYS\profile\PDV_DVEBMGS41_erpukpltm
argv[3] = -DSAPSTART=1
argv[4] = -DCONNECT_PORT=65000
argv[5] = -DSAPSYSTEM=41
argv[6] = -DSAPSYSTEMNAME=PDV
argv[7] = -DSAPMYNAME=erpukpltm_PDV_41
argv[8] = -DSAPPROFILE=D:\usr\sap\PDV\SYS\profile\PDV_DVEBMGS41_erpukpltm
argv[9] = -DFRFC_FALLBACK=ON
argv[10] = -DFRFC_FALLBACK_HOST=localhost
start_lazy = 0
start_control = SAP J2EE startup framework
DpJ2eeStart: j2ee state = STARTED
rdisp/http_min_wait_dia_wp : 1 -> 1
***LOG CPS=> DpLoopInit, ICU ( 3.0 3.0 4.0.1) [dpxxdisp.c 1681]
***LOG Q0K=> DpMsAttach, mscon ( erpukpltm) [dpxxdisp.c 12483]
DpStartStopMsg: send start message (myname is >erpukpltm_PDV_41 <)
DpStartStopMsg: start msg sent
CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.
CCMS: Initalizing shared memory of size 60000000 for monitoring segment.
CCMS: Checking Downtime Configuration of Monitoring Segment.
CCMS: start to initalize 3.X shared alert area (first segment).
DpJ2eeLogin: j2ee state = CONNECTED
DpMsgAdmin: Set release to 7010, patchlevel 0
MBUF state PREPARED
MBUF component UP
DpMBufHwIdSet: set Hardware-ID
***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c 1048]
DpMsgAdmin: Set patchno for this platform to 32
Release check o.K.
Sat Jan 10 02:11:32 2015
***LOG Q0I=> NiIRead: recv (10054: WSAECONNRESET: Connection reset by peer) [nixxi.cpp 4436]
*** ERROR => NiIRead: SiRecv failed for hdl 4 / sock 236
(SI_ECONN_BROKEN/10054; I4; ST; 127.0.0.1:2797) [nixxi.cpp 4436]
*** ERROR => DpJ2eeMsgProcess: NiRead failed (NIECONN_BROKEN) [dpxxj2ee.c 1212]
DpJ2eeMsgProcess: j2ee state = CONNECTED (NIECONN_BROKEN)
Sat Jan 10 02:12:10 2015
my types changed after wp death/restart 0xbf --> 0xbe
my types changed after wp death/restart 0xbe --> 0xbc
my types changed after wp death/restart 0xbc --> 0xb8
my types changed after wp death/restart 0xb8 --> 0xb0
my types changed after wp death/restart 0xb0 --> 0xa0
my types changed after wp death/restart 0xa0 --> 0x80
*** DP_FATAL_ERROR => DpWPCheck: no more work processes
*** DISPATCHER EMERGENCY SHUTDOWN ***
increase tracelevel of WPs
NiWait: sleep (10000ms) ...
NiISelect: timeout 10000ms
NiISelect: maximum fd=377
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Sat Jan 10 02:12:20 2015
NiISelect: TIMEOUT occured (10000ms)
dump system status
Workprocess Table (long) Sat Jan 10 02:12:20 2015
========================
No Ty. Pid Status Cause Start Err Sem CPU Time Program Cl User Action Table
-------------------------------------------------------------------------------------------------------------------------------
0 DIA 2552 Ended no 1 0 0
1 DIA 2936 Ended no 1 0 0
2 DIA 3372 Ended no 1 0 0
3 DIA 3376 Ended no 1 0 0
4 DIA 4360 Ended no 1 0 0
5 UPD 4368 Ended no 1 0 0
6 ENQ 3860 Ended no 1 0 0
7 BTC 3424 Ended no 1 0 0
8 BTC 1512 Ended no 1 0 0
9 BTC 2852 Ended no 1 0 0
10 SPO 4100 Ended no 1 0 0
11 UP2 4164 Ended no 1 0 0
Dispatcher Queue Statistics Sat Jan 10 02:12:20 2015
===========================
+------+--------+--------+--------+--------+--------+
| Typ | now | high | max | writes | reads |
+------+--------+--------+--------+--------+--------+
| NOWP | 0 | 2 | 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 | 0 | 0 | 2000 | 0 | 0 |
+------+--------+--------+--------+--------+--------+
| UP2 | 0 | 0 | 2000 | 0 | 0 |
+------+--------+--------+--------+--------+--------+
max_rq_id 12
wake_evt_udp_now 0
wake events total 8, udp 6 ( 75%), shm 2 ( 25%)
since last update total 8, udp 6 ( 75%), shm 2 ( 25%)
Dump of tm_adm structure: Sat Jan 10 02:12:20 2015
=========================
Term uid man user term lastop mod wp ta a/i (modes)
Workprocess Comm. Area Blocks Sat Jan 10 02:12:20 2015
=============================
Slots: 300, Used: 1, Max: 0
+------+--------------+----------+-------------+
| id | owner | pid | eyecatcher |
+------+--------------+----------+-------------+
| 0 | DISPATCHER | -1 | *WPCAAD000* |
NiWait: sleep (5000ms) ...
NiISelect: timeout 5000ms
NiISelect: maximum fd=377
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Sat Jan 10 02:12:25 2015
NiISelect: TIMEOUT occured (5000ms)
DpHalt: shutdown server >erpukpltm_PDV_41 < (normal)
DpJ2eeDisableRestart
MsIDelService: delete service J2EE for myself
NiBufSend starting
NiIWrite: hdl 3 sent data (wrt=161,pac=1,MESG_IO)
MsINiWrite: sent 161 bytes
send msg (len 110+51) to name MSG_SERVER, type 0, key -
MsSndName: MS_DEL_PROPERTY ok
Send 51 bytes to MSG_SERVER
MS_DEL_PROPERTY : asynchronous call
send MsDelService(J2EE) to msgserver
DpIJ2eeShutdown: send SIGINT to SAP J2EE startup framework (pid=3208)
killing process (3208) (SOFT_KILL)
*** ERROR => DpProcKill: kill failed [dpntdisp.c 371]
DpIJ2eeShutdown: j2ee state = SHUTDOWN
SiSelNClear: set events of sock 328 to: ---
SiSelNRemove: removed sock 328 (pos=2)
SiSelNRemove: removed sock 328
NiSelIRemove: removed hdl 2
DpDelSocketInfo: del info for socket 2 (type=7)
NiICloseHandle: shutdown and close hdl 2 / sock 328 - sock -1
DpModState: buffer in state MBUF_PREPARED
NiBufSend starting
NiIWrite: hdl 3 sent data (wrt=110,pac=1,MESG_IO)
MsINiWrite: sent 110 bytes
MsIModState: change state to SHUTDOWN
DpModState: change server state from STARTING to SHUTDOWN
Switch off Shared memory profiling
ShmProtect( 57, 3 )
ShmProtect(SHM_PROFILE, SHM_PROT_RW
ShmProtect( 57, 1 )
ShmProtect(SHM_PROFILE, SHM_PROT_RD
DpWakeUpWps: wake up all wp's
Stop work processes
Stop gateway
killing process (2820) (SOFT_KILL)
Stop icman
killing process (1792) (SOFT_KILL)
Terminate gui connections
wait for end of work processes
wait for end of gateway
[DpProcDied] Process lives (PID:2820 HANDLE:336)
waiting for termination of gateway ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=377
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Sat Jan 10 02:12:26 2015
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process died (PID:2820 HANDLE:336)
wait for end of icman
[DpProcDied] Process lives (PID:1792 HANDLE:352)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=377
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Sat Jan 10 02:12:27 2015
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:1792 HANDLE:352)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=377
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Sat Jan 10 02:12:28 2015
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:1792 HANDLE:352)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=377
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Sat Jan 10 02:12:29 2015
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:1792 HANDLE:352)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=377
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Sat Jan 10 02:12:30 2015
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:1792 HANDLE:352)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=377
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Sat Jan 10 02:12:31 2015
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:1792 HANDLE:352)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=377
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Sat Jan 10 02:12:32 2015
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:1792 HANDLE:352)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=377
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Sat Jan 10 02:12:33 2015
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:1792 HANDLE:352)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=377
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Sat Jan 10 02:12:34 2015
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:1792 HANDLE:352)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=377
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Sat Jan 10 02:12:35 2015
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:1792 HANDLE:352)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=377
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Sat Jan 10 02:12:36 2015
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:1792 HANDLE:352)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=377
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Sat Jan 10 02:12:37 2015
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process died (PID:1792 HANDLE:352)
[DpProcDied] Process died (PID:3208 HANDLE:320)
DpStartStopMsg: send stop message (myname is >erpukpltm_PDV_41 <)
DpStartStopMsg: Write AD_STARTSTOP message with type= 0, name=erpukpltm_PDV_41 , sapsysnr=41, hostname=erpukpltm
AdGetSelfIdentRecord: > <
AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0
AdCvtRecToExt: opcode 4 (AD_STARTSTOP), ser 0, ex 0, errno 0
DpConvertRequest: net size = 189 bytes
NiBufSend starting
NiIWrite: hdl 3 sent data (wrt=562,pac=1,MESG_IO)
MsINiWrite: sent 562 bytes
send msg (len 110+452) to name -, type 4, key -
DpStartStopMsg: stop msg sent
NiIRead: hdl 3 received data (rcd=274,pac=1,MESG_IO)
NiBufIIn: NIBUF len=274
NiBufIIn: packet complete for hdl 3
NiBufReceive starting
MsINiRead: received 274 bytes
MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -
DpHalt: received 164 bytes from message server
NiIRead: hdl 3 received data (rcd=274,pac=1,MESG_IO)
NiBufIIn: NIBUF len=274
NiBufIIn: packet complete for hdl 3
NiBufReceive starting
MsINiRead: received 274 bytes
MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -
DpHalt: received 164 bytes from message server
NiIRead: hdl 3 received data (rcd=274,pac=1,MESG_IO)
NiBufIIn: NIBUF len=274
NiBufIIn: packet complete for hdl 3
NiBufReceive starting
MsINiRead: received 274 bytes
MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -
DpHalt: received 164 bytes from message server
NiIRead: hdl 3 received data (rcd=274,pac=1,MESG_IO)
NiBufIIn: NIBUF len=274
NiBufIIn: packet complete for hdl 3
NiBufReceive starting
MsINiRead: received 274 bytes
MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -
DpHalt: received 164 bytes from message server
NiIRead: hdl 3 received data (rcd=274,pac=1,MESG_IO)
NiBufIIn: NIBUF len=274
NiBufIIn: packet complete for hdl 3
NiBufReceive starting
MsINiRead: received 274 bytes
MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -
DpHalt: received 164 bytes from message server
NiIRead: hdl 3 received data (rcd=274,pac=1,MESG_IO)
NiBufIIn: NIBUF len=274
NiBufIIn: packet complete for hdl 3
NiBufReceive starting
MsINiRead: received 274 bytes
MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -
DpHalt: received 164 bytes from message server
NiIRead: hdl 3 received data (rcd=114,pac=1,MESG_IO)
NiBufIIn: NIBUF len=114
NiBufIIn: packet complete for hdl 3
NiBufReceive starting
MsINiRead: received 114 bytes
MSG received, len 110+4, flag 3, from MSG_SERVER , typ 0, key -
DpHalt: received 4 bytes from message server
NiIRead: hdl 3 received data (rcd=274,pac=1,MESG_IO)
NiBufIIn: NIBUF len=274
NiBufIIn: packet complete for hdl 3
NiBufReceive starting
MsINiRead: received 274 bytes
MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -
DpHalt: received 164 bytes from message server
NiIRead: hdl 3 recv would block (errno=EAGAIN)
NiIRead: read for hdl 3 timed out (0ms)
DpHalt: no more messages from the message server
DpHalt: send keepalive to synchronize with the message server
NiBufSend starting
NiIWrite: hdl 3 sent data (wrt=114,pac=1,MESG_IO)
MsINiWrite: sent 114 bytes
send msg (len 110+4) to name MSG_SERVER, type 0, key -
MsSndName: MS_NOOP ok
Send 4 bytes to MSG_SERVER
NiIRead: hdl 3 recv would block (errno=EAGAIN)
NiIPeek: peek successful for hdl 3 (r)
NiIRead: hdl 3 received data (rcd=114,pac=1,MESG_IO)
NiBufIIn: NIBUF len=114
NiBufIIn: packet complete for hdl 3
NiBufReceive starting
MsINiRead: received 114 bytes
MSG received, len 110+4, flag 3, from MSG_SERVER , typ 0, key -
Received 4 bytes from MSG_SERVER
Received opcode MS_NOOP from msg_server, reply MSOP_OK
MsOpReceive: ok
MsSendKeepalive : keepalive sent to message server
NiIRead: hdl 3 recv would block (errno=EAGAIN)
Sat Jan 10 02:12:38 2015
NiIPeek: peek for hdl 3 timed out (r; 1000ms)
NiIRead: read for hdl 3 timed out (1000ms)
DpHalt: no more messages from the message server
DpHalt: sync with message server o.k.
detach from message server
***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c 12829]
NiBufSend starting
NiIWrite: hdl 3 sent data (wrt=110,pac=1,MESG_IO)
MsINiWrite: sent 110 bytes
MsIDetach: send logout to msg_server
MsIDetach: call exit function
DpMsShutdownHook called
NiBufISelUpdate: new MODE -- (r-) for hdl 3 in set0
SiSelNSet: set events of sock 264 to: ---
NiBufISelRemove: remove hdl 3 from set0
SiSelNRemove: removed sock 264 (pos=3)
SiSelNRemove: removed sock 264
NiSelIRemove: removed hdl 3
MBUF state OFF
AdGetSelfIdentRecord: > <
AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0
AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0
AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0
blks_in_queue/wp_ca_blk_no/wp_max_no = 1/300/12
LOCK WP ca_blk 1
make DISP owner of wp_ca_blk 1
DpRqPutIntoQueue: put request into queue (reqtype 1, prio LOW, rq_id 15)
MBUF component DOWN
NiICloseHandle: shutdown and close hdl 3 / sock 264
NiBufIClose: clear extension for hdl 3
MsIDetach: detach MS-system
cleanup EM
EsCleanup ....
EmCleanup() -> 0
Es2Cleanup: Cleanup ES2
***LOG Q05=> DpHalt, DPStop ( 3328) [dpxxdisp.c 11045]
Good Bye .....
Hello Rafael,
could you please attach also dev_w0?
Regards,
Alwina
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sure. Here it is.
---------------------------------------------------
trc file: "dev_w0", trc level: 1, release: "701"
---------------------------------------------------
*
* ACTIVE TRACE LEVEL 1
* ACTIVE TRACE COMPONENTS all, MJ
*
B
B Mon Jan 12 20:46:12 2015
B create_con (con_name=R/3)
B Loading DB library 'D:\usr\sap\PDV\DVEBMGS41\exe\dboraslib.dll' ...
B Library 'D:\usr\sap\PDV\DVEBMGS41\exe\dboraslib.dll' loaded
B Version of 'D:\usr\sap\PDV\DVEBMGS41\exe\dboraslib.dll' is "700.08", patchlevel (0.25)
B New connection 0 created
M sysno 41
M sid PDV
M systemid 562 (PC with Windows NT)
M relno 7010
M patchlevel 0
M patchno 32
M intno 20020600
M make: multithreaded, Unicode, 64 bit, optimized
M pid 2820
M
M kernel runs with dp version 241000(ext=110000) (@(#) DPLIB-INT-VERSION-241000-UC)
M length of sys_adm_ext is 576 bytes
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 2820) [dpxxdisp.c 1348]
I MtxInit: 30000 0 0
M DpSysAdmExtCreate: ABAP is active
M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active
M DpShMCreate: sizeof(wp_adm) 21024 (1752)
M DpShMCreate: sizeof(tm_adm) 5912704 (29416)
M DpShMCreate: sizeof(wp_ca_adm) 24064 (80)
M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)
M DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080
M DpShMCreate: sizeof(comm_adm) 552080 (1088)
M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0
M DpShMCreate: sizeof(slock_adm) 0 (104)
M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
M DpShMCreate: sizeof(file_adm) 0 (72)
M DpShMCreate: sizeof(vmc_adm) 0 (1864)
M DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)
M DpShMCreate: sizeof(gw_adm) 48
M DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000B2B0050, size: 6605376)
M DpShMCreate: allocated sys_adm at 000000000B2B0050
M DpShMCreate: allocated wp_adm at 000000000B2B2270
M DpShMCreate: allocated tm_adm_list at 000000000B2B7490
M DpShMCreate: allocated tm_adm at 000000000B2B74F0
M DpShMCreate: allocated wp_ca_adm at 000000000B85AD70
M DpShMCreate: allocated appc_ca_adm at 000000000B860B70
M DpShMCreate: allocated comm_adm at 000000000B862AB0
M DpShMCreate: system runs without slock table
M DpShMCreate: system runs without file table
M DpShMCreate: allocated vmc_adm_list at 000000000B8E9740
M DpShMCreate: allocated gw_adm at 000000000B8E97C0
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 000000000B8E97F0
M DpShMCreate: allocated wall_adm at 000000000B8E9800
M
M Mon Jan 12 20:46:13 2015
M rdisp/queue_size_check_value : -> off
M ThTaskStatus: rdisp/reset_online_during_debug 0
X EmInit: MmSetImplementation( 2 ).
X MM global diagnostic options set: 0
X <ES> client 0 initializing ....
X Using implementation view
X <EsNT> Using memory model view.
M <EsNT> Memory Reset disabled as NT default
X ES initialized.
M ThInit: running on host erpukpltm
M
M Mon Jan 12 20:46:14 2015
M calling db_connect ...
C Prepending D:\usr\sap\PDV\DVEBMGS41\exe to Path.
C Oracle Client Version: '10.2.0.1.0'
C Client NLS setting (OCINlsGetInfo): 'AMERICAN_AMERICA.UTF8'
C Logon as OPS$-user to get SAPSR3's password
C Connecting as /@PDV on connection 0 (nls_hdl 0) ... (dbsl 700 151208)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 0 000000000E0C00C0 0000000002F1E7D0 000000000E0C8A68
C Attaching to DB Server PDV (con_hdl=0,svchp=000000000E0C8928,srvhp=000000000E0C9208)
C Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=000000000E0C8928, srvhp=000000000E0C9208, usrhp=0000000002F1EFE8)
C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1035
[dboci.c 4704]
C Detaching from DB Server (con_hdl=0,svchp=000000000E0C8928,srvhp=000000000E0C9208)
C *** ERROR => CONNECT failed with sql error '1035'
[dbsloci.c 11175]
C Try to connect with default password
C Connecting as SAPSR3/<pwd>@PDV on connection 0 (nls_hdl 0) ... (dbsl 700 151208)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 0 000000000E0C00C0 0000000002F1E7D0 000000000E0C8A68
C Attaching to DB Server PDV (con_hdl=0,svchp=000000000E0C8928,srvhp=000000000E0C9208)
C Starting user session: OCISessionBegin(con_hdl=0, usr=SAPSR3/<pwd>, svchp=000000000E0C8928, srvhp=000000000E0C9208, usrhp=0000000002F1EFE8)
C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=28000
[dboci.c 4704]
C Detaching from DB Server (con_hdl=0,svchp=000000000E0C8928,srvhp=000000000E0C9208)
C *** ERROR => CONNECT failed with sql error '28000'
[dbsloci.c 11175]
B ***LOG BY2=> sql error 28000 performing CON [dbsh#2 @ 1208] [dbsh 1208 ]
B ***LOG BY0=> ORA-28000: the account is locked [dbsh#2 @ 1208] [dbsh 1208 ]
B ***LOG BY2=> sql error 28000 performing CON [dblink#3 @ 431] [dblink 0431 ]
B ***LOG BY0=> ORA-28000: the account is locked [dblink#3 @ 431] [dblink 0431 ]
M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1449]
M in_ThErrHandle: 1
M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10563]
M
M Info for wp 0
M
M pid = 2820
M severity = 0
M status = 0
M stat = WP_RUN
M waiting_for = NO_WAITING
M reqtype = DP_RQ_DIAWP
M act_reqtype = NO_REQTYPE
M rq_info = 0
M tid = -1
M mode = 255
M len = -1
M rq_id = 65535
M rq_source =
M last_tid = 0
M last_mode = 0
M semaphore = 0
M act_cs_count = 0
M csTrack = 0
M csTrackRwExcl = 0
M csTrackRwShrd = 0
M mode_cleaned_counter = 0
M control_flag = 0
M int_checked_resource(RFC) = 0
M ext_checked_resource(RFC) = 0
M int_checked_resource(HTTP) = 0
M ext_checked_resource(HTTP) = 0
M report = > <
M action = 0
M tab_name = > <
M attachedVm = no VM
M
M *****************************************************************************
M *
M * LOCATION SAP-Server erpukpltm_PDV_41 on host erpukpltm (wp 0)
M * ERROR ThInit: db_connect
M *
M * TIME Mon Jan 12 20:46:14 2015
M * RELEASE 701
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 13
M * MODULE thxxhead.c
M * LINE 10783
M * COUNTER 1
M *
M *****************************************************************************
M
M PfStatDisconnect: disconnect statistics
M Entering TH_CALLHOOKS
M ThCallHooks: call hook >BtcCallLgCl< for event BEFORE_DUMP
M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP
M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 723]
M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 261]
M Entering ThSetStatError
M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)
M Entering ThReadDetachMode
M call ThrShutDown (1)...
M ***LOG Q02=> wp_halt, WPStop (Workproc 0 2820) [dpnttool.c 334]
>>B ***LOG BY0=> ORA-28000: the account is locked [dbsh#2 @ 1208] [dbsh 1208 ]<<
Unlock the SAPSR3 user from SQL
Follow this SAP note
951167 - ORA-28000: the account is locked
Cheers
RB
Is there an alternate way for me to connect to the server? I receive an TNS:protocol adapter error when I try to connect via the command prompt.
Background: I started this project last monday and I was able to get SAP BW to work, meaning I was able to login even though the disp+work.exe in the processes windows was yellow. At the time SAP BPC didn't work. I've updated the services and host text files to include the server IP address since then. On friday, I was not able to connect to SAP BW and now I am receiving the TNS: protocol adapter error.
There isn't anyone else that I can ask for help. The server was down for awhile but now my company wants to bring it back online.
Hi Rafael,
What are the outputs of below commands :
1. lsnrctl status (need to execute with ora<sid> user)
2. ps -ef | grep oracle
Regards,
Nikhil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Looks like listener daemon isnt running?
can you check with <SID>adm following: tnsping PDV
also DpNetCheck: NiAddrToHost(1.0.0.0) <-
maybe nslookup erpukpltm
could you please past also R3trans -d log ?
Thanks
Stan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Check if your oracle listner is running, if not start the listener and then try using sql prompt.
Regards,
Nikhil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
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.