on 11-06-2013 3:14 PM
Hello colleagues,
I am managing an ERP 6.0 EHP6 system running on HANA and was trying to configure TREX installed on the same host. While running the report ESH_ADM_INDEX_ALL_SC in SE38 and is not coming up after that. I tried a kernel upgrade and system came up once but again went down while running the report.
While starting the system disp+work goes to state "System is STARTING" and stops. In the current status of system in SAP MMC, I can see an error in the DatabaseClient category. ABAP_SQL_ERROR:[Error DBIF_RSQL_SQL_ERROR_OCCURED........
Below is the developer trace of disp+work.
************************************************************************************************************************************
---------------------------------------------------
trc file: "dev_disp", trc level: 1, release: "740"
---------------------------------------------------
sysno 00
sid BO4
systemid 562 (PC with Windows NT)
relno 7400
patchlevel 0
patchno 37
intno 20020600
make multithreaded, Unicode, 64 bit, optimized
profile \\p246198\sapmnt\BO4\SYS\profile\BO4_DVEBMGS00_p246198
pid 5212
Wed Nov 06 15:41:51 2013
kernel runs with dp version 184000(ext=116000) (@(#) DPLIB-INT-VERSION-184000-UC)
length of sys_adm_ext is 500 bytes
*** SWITCH TRC-HIDE on ***
***LOG Q00=> DpSapEnvInit, DPStart (00 5212) [dpInit.c 548]
shared lib "dw_xml.dll" version 37 successfully loaded
shared lib "dw_xtc.dll" version 37 successfully loaded
shared lib "dw_stl.dll" version 37 successfully loaded
shared lib "dw_gui.dll" version 37 successfully loaded
shared lib "dw_mdm.dll" version 37 successfully loaded
shared lib "dw_rndrt.dll" version 37 successfully loaded
shared lib "dw_abp.dll" version 37 successfully loaded
DpCheckMulticast: check of multicast address o.k.
rdisp/softcancel_sequence : -> 0,5,-5
use internal message server connection to port 3901
rdisp/shutdown/disable_login : 0
rdisp/snapshot(CREATE): DP_CS_RESOURCES_EXHAUSTED
rdisp/snapshot(PERIOD):300 sec
rdisp/snapshot(LINES):10000 lines
DpCommonParamInit: rdisp/core_file_size = default --> no change
Wed Nov 06 15:41:56 2013
*** 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 4927]
MtxInit: 30000 0 0
DpIPCInit2: write dp-profile-values into sys_adm_ext
DpIPCInit2: start server >p246198_BO4_00 <
DpShMCreate: alloate/attach shared memory (mode=CREATE)
DpShMCreate: sizeof(wp_adm) 22848 (1088)
DpShMCreate: sizeof(tm_adm) 7055904 (35104)
DpShMCreate: sizeof(ca_adm) 432000 (72)
DpCommTableSize: max/headSize/ftSize/tableSize=500/16/1336064/1455152
DpShMCreate: sizeof(comm_adm) 1455152 (2648)
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)
DpSockTableSize: max/headSize/ftSize/tableSize=500/16/520064/520080
DpShMCreate: sizeof(sock_adm) 520080 (1016)
DpShMCreate: sizeof(vmc_adm) 0 (3208)
DpShMCreate: sizeof(wall_adm) (ft=41664/fi=67472/hd=64/rec=192)
DpShMCreate: sizeof(amc_rec_adm) (ft=86464/fi=67472/hd=64/rec=408)
DpShMCreate: sizeof(websocket_adm) (ft=38464/hd=64/rec=176)
DpShMCreate: sizeof(gw_adm) 48
DpShMCreate: sizeof(j2ee_adm) 3936
DpShMCreate: SHM_DP_ADM_KEY (addr: 00000000129C0050, size: 9896768)
DpShMCreate: allocated sys_adm at 00000000129C0250
DpShMCreate: allocated wp_adm_list at 00000000129D1C80
DpShMCreate: allocated wp_adm at 00000000129D1FA0
DpShMCreate: allocated tm_adm_list at 00000000129D7AE0
DpShMCreate: allocated tm_adm at 00000000129D7D20
DpShMCreate: allocated ca_adm at 0000000013092940
DpShMCreate: allocated comm_adm at 00000000130FC2C0
DpShMCreate: system runs without slock table
DpShMCreate: allocated sock_adm at 000000001325F8F0
DpShMCreate: allocated vmc_adm_list at 00000000132DEA80
DpShMCreate: system runs without VMC
DpShMCreate: allocated gw_adm at 00000000132DED20
DpShMCreate: allocated j2ee_adm at 00000000132DEF50
DpShMCreate: allocated ca_info at 00000000132E00B0
DpShMCreate: allocated wall_adm (ft) at 00000000132E02F0
DpShMCreate: allocated wall_adm (fi) at 00000000132EA7B0
DpShMCreate: allocated wall_adm (head) at 00000000132FB140
DpShMCreate: allocated amc_rec_adm (ft) at 00000000132FB380
DpShMCreate: allocated amc_rec_adm (fi) at 0000000013310740
DpShMCreate: allocated amc_rec_adm (head) at 00000000133210D0
DpShMCreate: allocated websocket_adm (ft) at 0000000013321310
DpShMCreate: allocated websocket_adm (head) at 000000001332AB50
DpShMCreate: initialized 21 eyes
DpSysAdmIntInit: initialize sys_adm
Scheduler info
--------------
WP info
#dia = 10
#btc = 0
#standby = 0
#max = 21
General Scheduler info
preemptionInfo.isActive = true
preemptionInfo.timeslice = 500
preemptionInfo.checkLoad = true
Prio Class High
maxRuntime[RQ_Q_PRIO_HIGH] = 600 sec
maxRuntimeHalf[RQ_Q_PRIO_HIGH] = 300 sec
Prio Class Normal
maxRuntime[RQ_Q_PRIO_NORMAL] = 3600 sec
maxRuntimeHalf[RQ_Q_PRIO_NORMAL] = 1800 sec
maxTicketsForPrio[RQ_Q_PRIO_NORMAL] = 8
withPrioTickets[RQ_Q_PRIO_NORMAL] = true
Prio Class Low
maxRuntime[RQ_Q_PRIO_LOW] = infinite
maxRuntimeHalf[RQ_Q_PRIO_LOW] = infinite
maxTicketsForPrio[RQ_Q_PRIO_LOW] = 8
withPrioTickets[RQ_Q_PRIO_LOW] = true
DpCommAttachTable: attached comm table (header=00000000130FC2C0/ft=00000000130FC2D0/fi=00000000132425D0)
DpSockAttachTable: attached sock table (header=000000001325F8F0/ft=000000001325F900)
MBUF state OFF
DpCommInitTable: init table for 500 entries
DpSockInitTable: init table for 500 entries
EmInit: MmSetImplementation( 2 ).
MM global diagnostic options set: 0
<ES> client 21 initializing ....
<ES> EsILock: use spinlock for locking
<ES> InitFreeList
<ES> block size is 4096 kByte.
<ES> Info: em/initial_size_MB( 34399MB) not multiple of em/blocksize_KB( 4096KB)
<ES> Info: em/initial_size_MB rounded up to 34400MB
<ES> Info: disclaim threshold = 0 MB
<ES> Info: disclaim coasting/alloc = 300 s
<ES> Info: disclaim coasting/free = 0 s
<ES> Info: blockdisclaimsize_KB = 0 KB
Using implementation view
<EsNT> Using memory model view.
<EsNT> Memory Reset disabled as NT default
<ES> 8599 blocks reserved for free list.
ES initialized.
mm.dump: set maximum dump mem to 96 MB
rdisp/calculateLoadAverage : 1
=================================================
= SSL Initialization platform tag=(ntamd64-msc16)
= (740_REL,Sep 27 2013,mt,ascii-uc,SAP_UC/size_t/void* = 16/64/64)
DIR_INSTANCE="F:\usr\sap\BO4\DVEBMGS00"
DIR_LIBRARY="F:\usr\sap\BO4\DVEBMGS00\exe"
= Initialization with _no_ default credentials
ssl/ssl_lib="F:\usr\sap\BO4\DVEBMGS00\exe\sapcrypto.dll"
profile param "ssl/ssl_lib" = "F:\usr\sap\BO4\DVEBMGS00\exe\sapcrypto.dll"
resulting Filename = "F:\usr\sap\BO4\DVEBMGS00\exe\sapcrypto.dll"
= found CommonCryptoLib (SAPCRYPTOLIB) Version 8.4.7 pl35 (2.0 SP1 Patch 2) (Aug 13 2013) MT-safe
= current UserID: P246198\SAPServiceBO4
= found SECUDIR environment variable
= using SECUDIR=F:\usr\sap\BO4\DVEBMGS00\sec
ssl/ciphersuites="193:HIGH:MEDIUM:+e3DES"
ssl/client_ciphersuites="192:HIGH:MEDIUM:+e3DES"
= Success -- SapCryptoLib SSL ready!
=================================================
***LOG Q0K=> DpMsAttach, mscon ( p246198) [dpMessageSer 1513]
MBUF state LOADING
DpStartStopMsg: send start message (myname is >p246198_BO4_00 <)
DpStartStopMsg: start msg sent to message server o.k.
MPI: dynamic quotas disabled.
MPI init: pipes=4000 buffers=6395 reserved=1918 quota=10%
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.
Wed Nov 06 15:41:59 2013
CCMS: AlMsUpload successful for F:\usr\sap\BO4\DVEBMGS00\log\ALMTTREE.DAT (5685 MTEs).
Wed Nov 06 15:42:00 2013
CCMS: start to initalize 3.X shared alert area (first segment).
DpCheckPreemptionTicker: created thread for DpPremptionTicker
DpMBufHwIdSet: set Hardware-ID
***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c 1330]
MBUF state ACTIVE
DpMBufTypeMod: MBUF component UP (event=MBUF_DPEVT_UP)
DpMsgProcess: 1 server in MBUF
DpMsCheckServices()
DpMsCheckServices: send DpDelService(J2EE) to msgserver
Wed Nov 06 15:42:36 2013
*** ERROR => DpHdlDeadWp: W0 (pid 180) died (severity=0, status=0) [dpxxwp.c 1277]
********** SERVER SNAPSHOT 1 (Reason: Workprocess 0 died) - begin **********
Scheduler info
--------------
WP info
DpNumberOfDiaWps: dia_wps 9, standby_wps 0
#dia = 9
#btc = 3
#standby = 0
#max = 21
General Scheduler info
preemptionInfo.isActive = true
preemptionInfo.timeslice = 500
preemptionInfo.checkLoad = true
Prio Class High
maxRuntime[RQ_Q_PRIO_HIGH] = 600 sec
maxRuntimeHalf[RQ_Q_PRIO_HIGH] = 300 sec
Prio Class Normal
maxRuntime[RQ_Q_PRIO_NORMAL] = 3600 sec
maxRuntimeHalf[RQ_Q_PRIO_NORMAL] = 1800 sec
maxTicketsForPrio[RQ_Q_PRIO_NORMAL] = 8
withPrioTickets[RQ_Q_PRIO_NORMAL] = true
Prio Class Low
maxRuntime[RQ_Q_PRIO_LOW] = infinite
maxRuntimeHalf[RQ_Q_PRIO_LOW] = infinite
maxTicketsForPrio[RQ_Q_PRIO_LOW] = 8
withPrioTickets[RQ_Q_PRIO_LOW] = true
Actual tickets in use
actTicketsInUseForPrio[RQ_Q_PRIO_NORMAL] = 0
actTicketsInUseForPrio[RQ_Q_PRIO_LOW] = 0
Queue Statistics Wed Nov 06 14:42:36 2013
------------------------------------------------------------
Number of lost wakeup datagrams: 0
Max. number of queue elements : 14000
NOWP: 0 (peak 5, writeCount 8, readCount 😎
DIA: 4 (peak 4, writeCount 4, readCount 0)
UPD: 0 (peak 0, writeCount 0, readCount 0)
ENQ: 0 (peak 0, writeCount 0, readCount 0)
BTC: 0 (peak 0, writeCount 0, readCount 0)
SPO: 0 (peak 0, writeCount 0, readCount 0)
UP2: 0 (peak 0, writeCount 0, readCount 0)
Session queue dump (high priority, 1 elements, peak 1):
-1 <- 26 < EmbryoQueue_DIA> -> -1
Session queue dump (normal priority, 0 elements, peak 0):
Session queue dump (low priority, 0 elements, peak 0):
Dump of queue <EmbryoQueue_DIA> in slot 26 (4 requests, port=0):
-1 <- 4 (rq_id 7, DIA, REQ_HANDLER_AUTOTH) -> 5
4 <- 5 (rq_id 9, DIA, REQ_HANDLER_MSADM) -> 2
5 <- 2 (rq_id 13, DIA, REQ_HANDLER_AUTOABAP) -> 3
2 <- 3 (rq_id 15, DIA, REQ_HANDLER_BGRFC_WATCHDOG) -> -1
Infos about some special queues:
Queue <DispatcherQueue> in slot 0 (port=55510) has no requests
Queue <GatewayQueue> in slot 1 (port=0) has no requests
Queue <IcmanQueue> in slot 2 (port=55596) has no requests
Queue <StartServiceQueue> in slot 3 (port=0) has no requests
Workprocess Table (long) Wed Nov 06 14:42:36 2013
------------------------------------------------------------
Current snapshot id: 1
Number of preemptions : 0
|No |Pid |Type|State |Cause|Err|Prio|Sess-Key |Sess-Type|Locked|Sem|Time |Program |Cli|User |Action |Action-Info |
|---+------+----+-------+-----+---+----+----------------+---------+------+---+-----+----------------------------------------+---+------------+--------------------+--------------------|
| 0| |DIA |WP_KILL| |1 | | | | | | | | | | | |
| 1|4296 |DIA |WP_NEW | | | | | | | | | | | | | |
| 2|5164 |DIA |WP_NEW | | | | | | | | | | | | | |
| 3|5156 |DIA |WP_NEW | | | | | | | | | | | | | |
| 4|6064 |DIA |WP_NEW | | | | | | | | | | | | | |
| 5|6096 |DIA |WP_NEW | | | | | | | | | | | | | |
| 6|6092 |DIA |WP_NEW | | | | | | | | | | | | | |
| 7|6084 |DIA |WP_NEW | | | | | | | | | | | | | |
| 8|1172 |DIA |WP_NEW | | | | | | | | | | | | | |
| 9|6136 |DIA |WP_NEW | | | | | | | | | | | | | |
| 10|5940 |UPD |WP_NEW | | | | | | | | | | | | | |
| 11|3940 |BTC |WP_NEW | | | | | | | | | | | | | |
| 12|5160 |BTC |WP_NEW | | | | | | | | | | | | | |
| 13|2712 |BTC |WP_NEW | | | | | | | | | | | | | |
| 14|6132 |SPO |WP_NEW | | | | | | | | | | | | | |
| 15|4616 |UP2 |WP_NEW | | | | | | | | | | | | | |
Session Table Wed Nov 06 14:42:36 2013
------------------------------------------------------------
No logons/sessions found
CA Blocks
0 INVALID -1
1 ca_blk slots of 6000 in use, 1 currently unowned (in request queues)
********** SERVER SNAPSHOT 1 (Reason: Workprocess 0 died) - end **********
***LOG Q41=> DpDumpInternalTables, () [dpxxdisp.c 3069]
my types changed after wp death/restart: 0x9b --> 0xbb
*** ERROR => DpHdlDeadWp: W1 (pid 4296) died (severity=0, status=0) [dpxxwp.c 1277]
DpSkipSnapshot: delayed snapshot exist, skip new snapshot
*** ERROR => DpHdlDeadWp: W2 (pid 5164) died (severity=0, status=0) [dpxxwp.c 1277]
DpSkipSnapshot: delayed snapshot exist, skip new snapshot
*** ERROR => DpHdlDeadWp: W3 (pid 5156) died (severity=0, status=0) [dpxxwp.c 1277]
DpSkipSnapshot: delayed snapshot exist, skip new snapshot
*** ERROR => DpHdlDeadWp: W4 (pid 6064) died (severity=0, status=0) [dpxxwp.c 1277]
DpSkipSnapshot: delayed snapshot exist, skip new snapshot
*** ERROR => DpHdlDeadWp: W5 (pid 6096) died (severity=0, status=0) [dpxxwp.c 1277]
DpSkipSnapshot: delayed snapshot exist, skip new snapshot
*** ERROR => DpHdlDeadWp: W6 (pid 6092) died (severity=0, status=0) [dpxxwp.c 1277]
DpSkipSnapshot: delayed snapshot exist, skip new snapshot
*** ERROR => DpHdlDeadWp: W7 (pid 6084) died (severity=0, status=0) [dpxxwp.c 1277]
DpSkipSnapshot: delayed snapshot exist, skip new snapshot
*** ERROR => DpHdlDeadWp: W8 (pid 1172) died (severity=0, status=0) [dpxxwp.c 1277]
DpSkipSnapshot: delayed snapshot exist, skip new snapshot
*** ERROR => DpHdlDeadWp: W9 (pid 6136) died (severity=0, status=0) [dpxxwp.c 1277]
DpSkipSnapshot: delayed snapshot exist, skip new snapshot
*** ERROR => DpHdlDeadWp: W10 (pid 5940) died (severity=0, status=0) [dpxxwp.c 1277]
DpSkipSnapshot: delayed snapshot exist, skip new snapshot
*** ERROR => DpHdlDeadWp: W11 (pid 3940) died (severity=0, status=0) [dpxxwp.c 1277]
DpSkipSnapshot: delayed snapshot exist, skip new snapshot
*** ERROR => DpHdlDeadWp: W12 (pid 5160) died (severity=0, status=0) [dpxxwp.c 1277]
DpSkipSnapshot: delayed snapshot exist, skip new snapshot
*** ERROR => DpHdlDeadWp: W13 (pid 2712) died (severity=0, status=0) [dpxxwp.c 1277]
DpSkipSnapshot: delayed snapshot exist, skip new snapshot
*** ERROR => DpHdlDeadWp: W14 (pid 6132) died (severity=0, status=0) [dpxxwp.c 1277]
DpSkipSnapshot: delayed snapshot exist, skip new snapshot
*** ERROR => DpHdlDeadWp: W15 (pid 4616) died (severity=0, status=0) [dpxxwp.c 1277]
DpSkipSnapshot: delayed snapshot exist, skip new snapshot
*** DP_FATAL_ERROR => DpWpCheck: no more work processes
*** DISPATCHER EMERGENCY SHUTDOWN ***
increase tracelevel of WPs
NiIWait: sleep (10000ms) ...
NiISelect: timeout 10000ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Nov 06 15:42:37 2013
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Nov 06 15:42:38 2013
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Nov 06 15:42:39 2013
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Nov 06 15:42:40 2013
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Nov 06 15:42:41 2013
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Nov 06 15:42:42 2013
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Nov 06 15:42:43 2013
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Nov 06 15:42:44 2013
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Nov 06 15:42:45 2013
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Nov 06 15:42:46 2013
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
NiISelect: TIMEOUT occured (10000ms)
dump system status
Workprocess Table (long) Wed Nov 06 14:42:46 2013
------------------------------------------------------------
DpMBufServGetOverloaded: load info of server >p246198_BO4_00 < is DP_NORMAL_LOAD
Current snapshot id: 1
Number of preemptions : 0
|No |Pid |Type|State |Cause|Err|Prio|Sess-Key |Sess-Type|Locked|Sem|Time |Program |Cli|User |Action |Action-Info |
|---+------+----+-------+-----+---+----+----------------+---------+------+---+-----+----------------------------------------+---+------------+--------------------+--------------------|
| 0| |DIA |WP_KILL| |1 | | | | | | | | | | | |
| 1| |DIA |WP_KILL| |1 | | | | | | | | | | | |
| 2| |DIA |WP_KILL| |1 | | | | | | | | | | | |
| 3| |DIA |WP_KILL| |1 | | | | | | | | | | | |
| 4| |DIA |WP_KILL| |1 | | | | | | | | | | | |
| 5| |DIA |WP_KILL| |1 | | | | | | | | | | | |
| 6| |DIA |WP_KILL| |1 | | | | | | | | | | | |
| 7| |DIA |WP_KILL| |1 | | | | | | | | | | | |
| 8| |DIA |WP_KILL| |1 | | | | | | | | | | | |
| 9| |DIA |WP_KILL| |1 | | | | | | | | | | | |
| 10| |UPD |WP_KILL| |1 | | | | | | | | | | | |
| 11| |BTC |WP_KILL| |1 | | | | | | | | | | | |
| 12| |BTC |WP_KILL| |1 | | | | | | | | | | | |
| 13| |BTC |WP_KILL| |1 | | | | | | | | | | | |
| 14| |SPO |WP_KILL| |1 | | | | | | | | | | | |
| 15| |UP2 |WP_KILL| |1 | | | | | | | | | | | |
Queue Statistics Wed Nov 06 14:42:46 2013
------------------------------------------------------------
Number of lost wakeup datagrams: 0
Max. number of queue elements : 14000
NOWP: 0 (peak 5, writeCount 8, readCount 😎
DIA: 4 (peak 4, writeCount 4, readCount 0)
UPD: 0 (peak 0, writeCount 0, readCount 0)
ENQ: 0 (peak 0, writeCount 0, readCount 0)
BTC: 0 (peak 0, writeCount 0, readCount 0)
SPO: 0 (peak 0, writeCount 0, readCount 0)
UP2: 0 (peak 0, writeCount 0, readCount 0)
Session queue dump (high priority, 1 elements, peak 1):
-1 <- 26 < EmbryoQueue_DIA> -> -1
Session queue dump (normal priority, 0 elements, peak 0):
Session queue dump (low priority, 0 elements, peak 0):
Dump of queue <EmbryoQueue_DIA> in slot 26 (4 requests, port=0):
-1 <- 4 (rq_id 7, DIA, REQ_HANDLER_AUTOTH) -> 5
4 <- 5 (rq_id 9, DIA, REQ_HANDLER_MSADM) -> 2
5 <- 2 (rq_id 13, DIA, REQ_HANDLER_AUTOABAP) -> 3
2 <- 3 (rq_id 15, DIA, REQ_HANDLER_BGRFC_WATCHDOG) -> -1
Infos about some special queues:
Queue <DispatcherQueue> in slot 0 (port=55510) has no requests
Queue <GatewayQueue> in slot 1 (port=0) has no requests
Queue <IcmanQueue> in slot 2 (port=55596) has no requests
Queue <StartServiceQueue> in slot 3 (port=0) has no requests
Logon Table Wed Nov 06 14:42:46 2013
------------------------------------------------------------
No logons/sessions found
CA Blocks
0 INVALID -1
1 ca_blk slots of 6000 in use, 1 currently unowned (in request queues)
NiIWait: sleep (5000ms) ...
NiISelect: timeout 5000ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Nov 06 15:42:47 2013
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Nov 06 15:42:48 2013
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Nov 06 15:42:49 2013
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Nov 06 15:42:50 2013
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Nov 06 15:42:51 2013
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
NiISelect: TIMEOUT occured (500ms)
NiISelect: timeout 500ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
NiISelect: TIMEOUT occured (5000ms)
DpSkipSnapshot: delayed snapshot exist, skip new snapshot
DpHalt: shutdown server >p246198_BO4_00 < (normal)
DpUpdateStatusFile: update status file F:\usr\sap\BO4\DVEBMGS00\work\disp+work.status, unique number = 2
DpJ2eeDisableRestart
DpMBufRead: read server list from MBUF (1 entries)
DpMBufMod: name [p246198_BO4_00 ], types 155 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 0000000141553610
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 00000001415543E0
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 00000001415543E0
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 00000001415543E0
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 00000001415543E0
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 00000001415543E0
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 00000001415543E0
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 00000001415543E0
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 00000001415543E0
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 00000001415543E0
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 00000001415543E0
AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K
DpRqCreate: creating REQ_HANDLER_MSADM request (rq_id 17, slot 13)
DpCaLockBlk: locked ca_blk 1
DpRqSendRequest: REQ_HANDLER_MSADM (rq_id 17) from DISP to DISP
DpCaGiveUpOwnerOfBlk: give up ownership of ca_blk 1
rq_id 17
-OUT- ca_blk 1 len 1180
-OUT- reqHdlId REQ_HANDLER_MSADM
-OUT- sender address:
-OUT- type LOCAL
-OUT- agentType DISP
-OUT- receiver address:
-OUT- type LOCAL
-OUT- agentType DISP
RqQAddRequest: Add request rq_id 17 (NOWP) to queue <DispatcherQueue> in slot 0 at the end
Dump of queue <DispatcherQueue> in slot 0 (1 requests, in use, port=55510):
-1 <- 0 (rq_id 17, NOWP, REQ_HANDLER_MSADM) -> -1
RqQQueueNotifySelectableHandle: Reuse NI connection for queue <DispatcherQueue> in slot 0 on port 55510 (10026)
RqQQueueNotifySelectableHandle: Signal selectable handle for queue <DispatcherQueue> in slot 0 on port 55510 (id=6)
NiDgHdlSend: hdl 361 sent 1 of 1 bytes to 127.0.0.1:55510
RqQQueueGetNumberOfRequests: Queue <DispatcherQueue> in slot 0 contains 1 requests of type NOWP
DpRqPutIntoQueue: put request into DISP queue (workerType 0, prio LOW, rq_id 17), queue has 1 requests
DpRqFree: freeing REQ_HANDLER_MSADM request (rq_id 17, slot 13)
DpMBufTypeMod: MBUF server state SHUTDOWN (event=MBUF_DPEVT_DSTATE)
DpModState: change state STARTING -> SHUTDOWN
NiBufIAlloc: malloc MSLIB-BUF, to 32110 bytes
NiBufSend starting
NiIWrite: hdl 353 sent data (wrt=110,pac=1,MESG_IO)
<<< NiBufISelUpdate: hdl 353(0, SAP_O_K)
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 (6108) (SOFT_KILL)
DpHalt: stop icman
killing process (4248) (SOFT_KILL)
DpHalt: terminate gui connections
DpHalt: wait for end of work processes
DpHalt: wait for end of gateway
[DpProcDied] Process lives (PID:6108 HANDLE:1120)
DpHalt: waiting for termination of gateway ...
NiIWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1221
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Nov 06 15:42:52 2013
NiISelect: TIMEOUT occured (500ms)
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process died (PID:6108 HANDLE:1120 rc:0x0)
DpHalt: wait for end of icman
[DpProcDied] Process died (PID:4248 HANDLE:1128 rc:0x0)
DpStartStopMsg: send stop message (myname is >p246198_BO4_00 <)
DpStartStopMsg: Write AD_STARTSTOP message with type= 0, name=p246198_BO4_00 , sapsysnr= 0, hostname=p246198
AdGetSelfIdentRecord: > <
AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0
AdCallRegisteredCvtToExt: opcode 60
AdCallRegisteredCvtToExt: opcode 60 call 0000000141553610
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 0000000141550780
AdCallRegisteredCvtToExt: opcode 4 exit rc=SAP_O_K
DpRqCreate: creating REQ_HANDLER_ADM request (rq_id 19, slot 14)
DpRqConvertToNetForm: converted from intern to net (164 bytes), rq_id 19
DpRqFree: freeing REQ_HANDLER_ADM request (rq_id 19, slot 14)
NiBufIAlloc: malloc MSLIB-BUF, to 32110 bytes
NiBufSend starting
NiIWrite: hdl 353 sent data (wrt=866,pac=1,MESG_IO)
<<< NiBufISelUpdate: hdl 353(0, SAP_O_K)
MsINiWrite: sent 866 bytes
MsISndTypeOnce: send msg (ms hdr/msg 110/756 bytes) to MSG_SERVER, type 1
DpStartStopMsg: stop msg sent to message server o.k.
NiBufIAlloc: malloc MSLIB-BUF, to 32110 bytes
NiBufIAlloc: malloc NIBUF-IN, to 32110 bytes
NiIRead: hdl 353 received data (rcd=274,pac=1,MESG_IO)
NiBufIIn: NIBUF len=274
NiBufIIn: packet complete for hdl 353
NiBufReceive starting
<<< NiBufISelUpdate: hdl 353(0, SAP_O_K)
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
NiBufIAlloc: malloc NIBUF-IN, to 32110 bytes
NiIRead: hdl 353 received data (rcd=274,pac=1,MESG_IO)
NiBufIIn: NIBUF len=274
NiBufIIn: packet complete for hdl 353
NiBufReceive starting
<<< NiBufISelUpdate: hdl 353(0, SAP_O_K)
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 353 recv would block (errno=EAGAIN)
NiIRead: read for hdl 353 timed out (0ms)
DpHalt: more messages from the message server
DpHalt: send keepalive to synchronize with the message server
NiBufSend starting
NiIWrite: hdl 353 sent data (wrt=114,pac=1,MESG_IO)
<<< NiBufISelUpdate: hdl 353(0, SAP_O_K)
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 353 recv would block (errno=EAGAIN)
NiIPeek: peek successful for hdl 353 (r)
NiBufIAlloc: malloc NIBUF-IN, to 32110 bytes
NiIRead: hdl 353 received data (rcd=114,pac=1,MESG_IO)
NiBufIIn: NIBUF len=114
NiBufIIn: packet complete for hdl 353
NiBufReceive starting
<<< NiBufISelUpdate: hdl 353(0, SAP_O_K)
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 353 recv would block (errno=EAGAIN)
Wed Nov 06 15:42:53 2013
NiIPeek: peek for hdl 353 timed out (r; 1000ms)
NiIRead: read for hdl 353 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 () [dpMessageSer 1856]
NiBufSend starting
NiIWrite: hdl 353 sent data (wrt=110,pac=1,MESG_IO)
<<< NiBufISelUpdate: hdl 353(0, SAP_O_K)
MsINiWrite: sent 110 bytes
MsIDetach: send logout to msg_server (p246198 / 3901)
MsIDetach: call exit function
DpMsShutdownHook called
NiBufISelUpdate: new MODE -- (r-) for hdl 353 in set0
SiSelNSet: set events of sock 1080 to: ---
<<< NiBufISelUpdate: hdl 353(0, SAP_O_K)
NiBufISelRemove: remove hdl 353 from set0
<<< NiBufISelUpdate: hdl 353(0, SAP_O_K)
SiSelNRemove: removed sock 1080
NiSelIRemove: removed hdl 353
DpDelSocketInfo: del info for nihdl 353 (pos/type=44/4)
DpMBufClearGlobalHighLoadCounter: reset global load flags
MBUF state OFF
AdGetSelfIdentRecord: > <
AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0
AdCallRegisteredCvtToExt: opcode 60
AdCallRegisteredCvtToExt: opcode 60 call 0000000141553610
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 00000001415543E0
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 00000001415543E0
AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K
DpRqCreate: creating REQ_HANDLER_MSADM request (rq_id 20, slot 15)
DpCaLockBlk: locked ca_blk 2
DpRqSendRequest: REQ_HANDLER_MSADM (rq_id 20) from DISP to DISP
DpCaGiveUpOwnerOfBlk: give up ownership of ca_blk 2
rq_id 20
-OUT- ca_blk 2 len 348
-OUT- reqHdlId REQ_HANDLER_MSADM
-OUT- sender address:
-OUT- type LOCAL
-OUT- agentType DISP
-OUT- receiver address:
-OUT- type LOCAL
-OUT- agentType DISP
RqQAddRequest: Add request rq_id 20 (NOWP) to queue <DispatcherQueue> in slot 0 at the end
Dump of queue <DispatcherQueue> in slot 0 (3 requests, in use, port=55510):
-1 <- 0 (rq_id 17, NOWP, REQ_HANDLER_MSADM) -> 1
0 <- 1 (rq_id 18, NOWP, REQ_HANDLER_ICMAN_OPCODE) -> 6
1 <- 6 (rq_id 20, NOWP, REQ_HANDLER_MSADM) -> -1
RqQQueueNotifySelectableHandle: Reuse NI connection for queue <DispatcherQueue> in slot 0 on port 55510 (10026)
RqQQueueNotifySelectableHandle: Signal selectable handle for queue <DispatcherQueue> in slot 0 on port 55510 (id=8)
NiDgHdlSend: hdl 361 sent 1 of 1 bytes to 127.0.0.1:55510
RqQQueueGetNumberOfRequests: Queue <DispatcherQueue> in slot 0 contains 3 requests of type NOWP
DpRqPutIntoQueue: put request into DISP queue (workerType 0, prio LOW, rq_id 20), queue has 3 requests
DpRqFree: freeing REQ_HANDLER_MSADM request (rq_id 20, slot 15)
DpMBufTypeMod: MBUF component DOWN (event=MBUF_DPEVT_DOWN)
NiICloseHandle: shutdown and close hdl 353/sock 1080
NiBufIClose: clear extension for hdl 353
MsIDetach: detach MS-system (p246198 / 3901)
DpHalt: cleanup EM
EsCleanup( )
EsCleanup ....
EmCleanup() -> 0
Es2Cleanup: Cleanup ES2
***LOG Q05=> DpHalt, DPStop ( 5212) [dpInit.c 3353]
DpHalt: Good Bye .....
************************************************************************************************************************************
Could you please help me here ? Please let me know if you require any additional information.
Thanks and regards,
Sudarsan.
Hello
Check the dev_w0 trace file.
Also check whether the database is up and running.
What is the output of R3trans -d ?
Regards
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Reagan,
Thank you for your reply.
R3Trans -d throws an error.
F:\usr\sap>R3trans -d
This is R3trans version 6.24 (release 740 - 26.09.13 - 20:13:07 ).
unicode enabled version
2EETW169 no connect possible: "DBMS = HDB --- SERV
ER = '' PORT = ''"
R3trans finished (0012).
I tried upgrading the kernel, but didn;t help.
here is the output of the dev_w0 trace file.
---------------------------------------------------
trc file: "dev_w0", trc level: 1, release: "740"
---------------------------------------------------
*
* ACTIVE TRACE LEVEL 1
* ACTIVE TRACE COMPONENTS all, MJ
*
M sysno 00
M sid BO4
M systemid 562 (PC with Windows NT)
M relno 7400
M patchlevel 0
M patchno 37
M intno 20020600
M make multithreaded, Unicode, 64 bit, optimized
M profile \\p246198\sapmnt\BO4\SYS\profile\BO4_DVEBMGS00_p246198
M pid 180
M
M
M Wed Nov 06 15:41:57 2013
M kernel runs with dp version 184000(ext=116000) (@(#) DPLIB-INT-VERSION-184000-UC)
M length of sys_adm_ext is 500 bytes
M ***LOG Q0Q=> tskh_init, WPStart (Workp. 0 180) [dpInit.c 658]
M DpCommonParamInit: rdisp/core_file_size = default --> no change
I MtxInit: 30000 0 0
M DpIPCInit2: read dp-profile-values from sys_adm_ext
M DpShMCreate: alloate/attach shared memory (mode=ATTACH)
M DpShMCreate: sizeof(wp_adm) 22848 (1088)
M DpShMCreate: sizeof(tm_adm) 7055904 (35104)
M DpShMCreate: sizeof(ca_adm) 432000 (72)
M DpCommTableSize: max/headSize/ftSize/tableSize=500/16/1336064/1455152
M DpShMCreate: sizeof(comm_adm) 1455152 (2648)
M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0
M DpShMCreate: sizeof(slock_adm) 0 (296)
M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
M DpShMCreate: sizeof(file_adm) 0 (80)
M DpSockTableSize: max/headSize/ftSize/tableSize=500/16/520064/520080
M DpShMCreate: sizeof(sock_adm) 520080 (1016)
M DpShMCreate: sizeof(vmc_adm) 0 (3208)
M DpShMCreate: sizeof(wall_adm) (ft=41664/fi=67472/hd=64/rec=192)
M DpShMCreate: sizeof(amc_rec_adm) (ft=86464/fi=67472/hd=64/rec=408)
M DpShMCreate: sizeof(websocket_adm) (ft=38464/hd=64/rec=176)
M DpShMCreate: sizeof(gw_adm) 48
M DpShMCreate: sizeof(j2ee_adm) 3936
M DpShMCreate: SHM_DP_ADM_KEY (addr: 0000000014BE0050, size: 9896768)
M DpShMCreate: allocated sys_adm at 0000000014BE0250
M DpShMCreate: allocated wp_adm_list at 0000000014BF1C80
M DpShMCreate: allocated wp_adm at 0000000014BF1FA0
M DpShMCreate: allocated tm_adm_list at 0000000014BF7AE0
M DpShMCreate: allocated tm_adm at 0000000014BF7D20
M DpShMCreate: allocated ca_adm at 00000000152B2940
M DpShMCreate: allocated comm_adm at 000000001531C2C0
M DpShMCreate: system runs without slock table
M DpShMCreate: allocated sock_adm at 000000001547F8F0
M DpShMCreate: allocated vmc_adm_list at 00000000154FEA80
M DpShMCreate: system runs without VMC
M DpShMCreate: allocated gw_adm at 00000000154FED20
M DpShMCreate: allocated j2ee_adm at 00000000154FEF50
M DpShMCreate: allocated ca_info at 00000000155000B0
M DpShMCreate: allocated wall_adm (ft) at 00000000155002F0
M DpShMCreate: allocated wall_adm (fi) at 000000001550A7B0
M DpShMCreate: allocated wall_adm (head) at 000000001551B140
M DpShMCreate: allocated amc_rec_adm (ft) at 000000001551B380
M DpShMCreate: allocated amc_rec_adm (fi) at 0000000015530740
M DpShMCreate: allocated amc_rec_adm (head) at 00000000155410D0
M DpShMCreate: allocated websocket_adm (ft) at 0000000015541310
M DpShMCreate: allocated websocket_adm (head) at 000000001554AB50
M DpShMCreate: initialized 21 eyes
M DpCommAttachTable: attached comm table (header=000000001531C2C0/ft=000000001531C2D0/fi=00000000154625D0)
M DpSockAttachTable: attached sock table (header=000000001547F8F0/ft=000000001547F900)
X EmInit: MmSetImplementation( 2 ).
X MM global diagnostic options set: 0
X <ES> client 0 initializing ....
X <ES> EsILock: use spinlock for locking
X Using implementation view
X <EsNT> Using memory model view.
M <EsNT> Memory Reset disabled as NT default
X ES initialized.
X mm.dump: set maximum dump mem to 96 MB
M ThStart: taskhandler started
M ThInit: initializing DIA work process W0
M
M Wed Nov 06 15:42:00 2013
M ThInit: running on host p246198
I MtxInit: 0 0 0
M calling db_connect ...
B Loading DB library 'F:\usr\sap\BO4\DVEBMGS00\exe\dbhdbslib.dll' ...
B Library 'F:\usr\sap\BO4\DVEBMGS00\exe\dbhdbslib.dll' loaded
B Version of 'F:\usr\sap\BO4\DVEBMGS00\exe\dbhdbslib.dll' is "740.10", patchlevel (0.36)
C Callback functions for dynamic profile parameter registered
C
C DBHDBSLIB : version 740.10, patch 0.036 (Make PL 0.37)
C HDB shared library (dbhdbslib) patchlevels (last 10)
C (0.036) Use connect option CURRENTSCHEMA on 2nd db connection (note 1913960)
C (0.032) Error Handling for Supplier Callbacks of DBSL (note 1903475)
C (0.030) INT1 swap problem fixed (note 1881003)
C (0.025) INT1 output parameter overflow (note 1881003)
C (0.022) Smaller corrections in release 7.40 (th, dp, vmc, dpmon) (note 1821404)
C (0.015) Omit trace entry on SQL object unknown or already exists (note 1849107)
C (0.007) Sybase ASE: enable forced committed read (note 1826505)
C (0.006) Exception during startup with higher dbsl tracelevel (note 1600066)
C (0.002) Invaild returncode by INSERT-SELECT fixed (note 1600066)
C (0.002) Bulk size of lobs optimized (note 1600066)
C
C
C Loading SQLDBC client runtime ...
C SQLDBC Module : F:\usr\sap\BO4\hdbclient\libSQLDBCHDB.dll
C SQLDBC Runtime : libSQLDBCHDB 1.00.60 Build 0379371-1510
C SQLDBC client runtime is 1.00.60.0379371
C
C Try to connect via secure store (DEFAULT) on connection 0 ...
C
C Wed Nov 06 15:42:01 2013
C *** ERROR => Connect to database failed, rc=1, rcSQL=-10709
[dbhdbsql.cpp 331]
C SQLCODE : -10709
C SQLERRTEXT : Connection failed (RTE:[89006] System call 'connect' failed, rc=10061:No connection could be made be\
C cause the target machine actively refused it)
B ***LOG BV3=> severe db error -10709 ; work process is stopped [dbsh 1244]
B ***LOG BY2=> sql error -10709 performing CON [dblink 550]
B ***LOG BY0=> Connection failed (RTE:[89006] System call 'connect' failed, rc=10061:No connection could be made because the target machine actively refused it) [dblink 550]
M ***LOG R19=> ThDbConnect, db_connect ( DB-Connect 000256) [thDatabase.c 75]
M in_ThErrHandle: 1
M *** ERROR => ThInit: db_connect (step TH_INIT, thRc ERROR-DB-CONNECT_ERROR, action STOP_WP, level 1) [thxxhead.c 2158]
M
M Info for wp 0
M
M pid = 180
M severity = 0
M status = 0
M stat = WP_NEW
M waiting_for = NO_WAITING
M workerType = DP_WORKER_DIAWP
M currentSession = T-1/U65535/M255
M lastSession = T-1/U65535/M255
M act_cs_count = 0
M csTrack = 0
M csTrackRwExcl = 0
M csTrackRwShrd = 0
M mode_cleaned_counter = 0
M control_flag = 0
M report = > <
M action = 0
M tab_name = > <
M
M ThIErrHandle: no current incoming request
M
M
M *****************************************************************************
M *
M * LOCATION SAP-Server p246198_BO4_00 on host p246198 (wp 0)
M * ERROR ThInit: db_connect
M *
M * TIME Wed Nov 06 15:42:01 2013
M * RELEASE 740
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 16797709
M * MODULE D:/depot/bas/740_REL/src/krn/si/th/thxxhead.c
M * LINE 2348
M * COUNTER 1
M *
M *****************************************************************************
M
M PfRejectStatistic: clear statistic record
M PfClearAllRec: clear statistic area
M PfClearAllRec: statRecordAction = STAT_RECORD_ACTION_REJECT
M Entering TH_CALLHOOKS
M ThIErrHandle: entering ThSetStatError
M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)
M call ThrShutDown (1)...
M ***LOG Q02=> wp_halt, WPStop (Workp. 0 180) [dpnttool.c 335]
************************************************
There was a server outage (database host) yesterday.
Thanks and regards,
SUdarsan.
Hi,
Is the Hana database up and running.
Can you also check the below note.
1852017 - Error 10061 when connecting SAP Instances to failed over HANA nodes
1771873 - Index server crashes with traces displaying message 'Too many open files'
Thanks
Rishi Abrol
Hello
B ***LOG BV3=> severe db error -10709 ; work process is stopped [dbsh 1244]
B ***LOG BY2=> sql error -10709 performing CON [dblink 550]
B ***LOG BY0=> Connection failed (RTE:[89006] System call 'connect' failed, rc=10061:No connection could be made because the target machine actively refused it) [dblink 550]
The problem is connection to the HANA database.
Have you checked this SAP note ?
1852017 - Error 10061 when connecting SAP Instances to failed over HANA nodes
If that note doesn't help then try restarting the AS server and the HANA appliance and see if that helps.
Regards
RB
Hello Rishi, Sriram, Atul,
Thank you for your replies.
Today the network outage was resolved and I found that some HANA services like index server was not running after that. Restart didn;t work, I had to stop and start the HDB from command line using "HDB stop" and "HDB start" ufing the user hdbadm. SAP system became up after that.
But the program, SH_ADM_INDEX_ALL_SC still does something wrong with the DB connection.
@Atul: Sorry, I didn't understand the last part of your reply, which log will be helpful for you to analyze, could you please specify some names of log files so that I can search and post the same.?
TREX and HDB are not on the same physical host, TREX is in the ERP host and HDB is on a separate host.
Thanks and regards,
Sudarsan.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I can you please try the ESH_Cockpit transaction and see that helps you.
1851024 - ESH_ADM_INDEX_ALL_SC cannot be used to index software component EA-HRGXX in Ehp6
another thing it would be more easy if you can provide the exact error log when you run ESH program.
Thanks
Rishi abrol
Hi Sudarsan,
SH_ADM_INDEX_ALL_SC program which used to create search connector for TREX and perform initial indexing for all search connectors.
As you said above due to report SH_ADM_INDEX_ALL_SC your HDB not coming up, so As per my understanding both TREX and HDB conatin indexserver as u said both running on same server so it could be the main reason for this issue .
PLease investigate in that dir and provide some more error log.
BR
Atul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What version of Trex are you currently using to do this?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sudarsan
AS per your error log I thing icm/admin_port missing in the profile parameter Kindly add the profile parameter and than check the system startup,refer the SAP KBA 1900647 - Parameter icm/admin_port
1934023 - Application server startup fail with an ICM connection error
1852017 - Error 10061 when connecting SAP Instances to failed over HANA nodes
Regards
Sriram
User | Count |
---|---|
86 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.