cancel
Showing results for 
Search instead for 
Did you mean: 

SAP management console not turning green.Disp+Work.exe stopped

Former Member
0 Kudos

I am new to SAP Basis.

Disp+Work.exe is stopped and I am unable to find the exact reason for it.

Below are the log files:

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

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

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

sysno      00

sid        ECC

systemid   562 (PC with Windows NT)

relno      7010

patchlevel 0

patchno    32

intno      20020600

make:      multithreaded, Unicode, 64 bit, optimized

pid        3180

Thu Mar 19 10:06:11 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 (00 3180) [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 3900

Thu Mar 19 10:06: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  5529]

MtxInit: 30000 0 0

DpSysAdmExtInit: ABAP is active

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

DpIPCInit2: start server >sapdev_ECC_00                           <

DpShMCreate: sizeof(wp_adm) 29792 (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: 6614144)

DpShMCreate: allocated sys_adm at 00000000092B0050

DpShMCreate: allocated wp_adm at 00000000092B2270

DpShMCreate: allocated tm_adm_list at 00000000092B96D0

DpShMCreate: allocated tm_adm at 00000000092B9730

DpShMCreate: allocated wp_ca_adm at 000000000985CFB0

DpShMCreate: allocated appc_ca_adm at 0000000009862DB0

DpShMCreate: allocated comm_adm at 0000000009864CF0

DpShMCreate: system runs without slock table

DpShMCreate: system runs without file table

DpShMCreate: allocated vmc_adm_list at 00000000098EB980

DpShMCreate: allocated gw_adm at 00000000098EBA00

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 00000000098EBA30

DpShMCreate: allocated wall_adm at 00000000098EBA40

MBUF state OFF

DpCommInitTable: init table for 500 entries

rdisp/queue_size_check_value :  -> off

ThTaskStatus: rdisp/reset_online_during_debug 0

Thu Mar 19 10:06:17 2015

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( 8119MB) not multiple of em/blocksize_KB( 4096KB)

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

Using implementation view

<EsNT> Using memory model view.

<EsNT> Memory Reset disabled as NT default

<ES> 2029 blocks reserved for free list.

ES initialized.

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 ( sapdev) [dpxxdisp.c   12483]

Thu Mar 19 10:06:18 2015

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

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.

Thu Mar 19 10:06:20 2015

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

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.

Thu Mar 19 10:06:58 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=401

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Mar 19 10:07:08 2015

NiISelect: TIMEOUT occured (10000ms)

dump system status

Workprocess Table (long) Thu Mar 19 15:07:08 2015

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

No Ty. Pid      Status  Cause Start Err Sem CPU    Time  Program          Cl  User         Action                    Table

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

0 DIA     3396 Ended         no      1   0        0                                                                         

1 DIA     3404 Ended         no      1   0        0                                                                         

2 DIA     3412 Ended         no      1   0        0                                                                         

3 DIA     3424 Ended         no      1   0        0                                                                         

4 DIA     3436 Ended         no      1   0        0                                                                         

5 DIA     3448 Ended         no      1   0        0                                                                         

6 DIA     3456 Ended         no      1   0        0                                                                         

7 DIA     3464 Ended         no      1   0        0                                                                         

8 DIA     3472 Ended         no      1   0        0                                                                         

9 DIA     3484 Ended         no      1   0        0                                                                         

10 UPD     3492 Ended         no      1   0        0                                                                         

11 ENQ     3504 Ended         no      1   0        0                                                                         

12 BTC     3516 Ended         no      1   0        0                                                                         

13 BTC     3524 Ended         no      1   0        0                                                                         

14 BTC     3532 Ended         no      1   0        0                                                                         

15 SPO     3544 Ended         no      1   0        0                                                                         

16 UP2     3556 Ended         no      1   0        0                                                                         

Dispatcher Queue Statistics Thu Mar 19 15:07:08 2015

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

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

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

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

| NOWP |      0 |      2 |   2000 |      6 |      6 |

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

|  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     7 ( 87%),  shm     1 ( 12%)

since last update total     8,  udp     7 ( 87%),  shm     1 ( 12%)

Dump of tm_adm structure: Thu Mar 19 15:07:08 2015

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

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

Workprocess Comm. Area Blocks Thu Mar 19 15:07:08 2015

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

Slots: 300, Used: 1, Max: 0

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

|   id | owner        |   pid    | eyecatcher  |

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

|    0 | DISPATCHER   |       -1 | *WPCAAD000* |

NiWait: sleep (5000ms) ...

NiISelect: timeout 5000ms

NiISelect: maximum fd=401

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Mar 19 10:07:13 2015

NiISelect: TIMEOUT occured (5000ms)

DpHalt: shutdown server >sapdev_ECC_00                           < (normal)

DpJ2eeDisableRestart

DpModState: buffer in state MBUF_PREPARED

NiBufSend starting

NiIWrite: hdl 2 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 (3380) (SOFT_KILL)

Stop icman

killing process (3388) (SOFT_KILL)

Terminate gui connections

wait for end of work processes

wait for end of gateway

[DpProcDied] Process lives  (PID:3380  HANDLE:368)

waiting for termination of gateway ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=401

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Mar 19 10:07:14 2015

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process died  (PID:3380  HANDLE:368)

wait for end of icman

[DpProcDied] Process lives  (PID:3388  HANDLE:380)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=401

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Mar 19 10:07:15 2015

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:3388  HANDLE:380)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=401

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Mar 19 10:07:16 2015

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:3388  HANDLE:380)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=401

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Mar 19 10:07:17 2015

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:3388  HANDLE:380)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=401

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Mar 19 10:07:18 2015

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:3388  HANDLE:380)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=401

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Mar 19 10:07:19 2015

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:3388  HANDLE:380)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=401

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Mar 19 10:07:20 2015

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:3388  HANDLE:380)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=401

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Mar 19 10:07:21 2015

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:3388  HANDLE:380)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=401

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Mar 19 10:07:22 2015

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:3388  HANDLE:380)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=401

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Mar 19 10:07:23 2015

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:3388  HANDLE:380)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=401

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Mar 19 10:07:24 2015

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:3388  HANDLE:380)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=401

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Mar 19 10:07:25 2015

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process died  (PID:3388  HANDLE:380)

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

DpStartStopMsg: Write AD_STARTSTOP message with type=  0, name=sapdev_ECC_00       , sapsysnr= 0, hostname=sapdev                                                         

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 2 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 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

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 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

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 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

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 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

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 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

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 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

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 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

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 2 recv would block (errno=EAGAIN)

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

DpHalt: no more messages from the message server

DpHalt: send keepalive to synchronize with the message server

NiBufSend starting

NiIWrite: hdl 2 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 2 recv would block (errno=EAGAIN)

NiIPeek: peek successful for hdl 2 (r)

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

NiBufIIn: NIBUF len=114

NiBufIIn: packet complete for hdl 2

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 2 recv would block (errno=EAGAIN)

Thu Mar 19 10:07:26 2015

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

NiIRead: read for hdl 2 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 2 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 2 in set0

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

NiBufISelRemove: remove hdl 2 from set0

SiSelNRemove: removed sock 284 (pos=2)

SiSelNRemove: removed sock 284

NiSelIRemove: removed hdl 2

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/17

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 2 / sock 284

NiBufIClose: clear extension for hdl 2

MsIDetach: detach MS-system

cleanup EM

EsCleanup ....

EmCleanup() -> 0

Es2Cleanup: Cleanup ES2

***LOG Q05=> DpHalt, DPStop ( 3180) [dpxxdisp.c   11045]

Good Bye .....

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

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

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

*

*  ACTIVE TRACE LEVEL           1

*  ACTIVE TRACE COMPONENTS      all, MJ

*

B Thu Mar 19 10:06:17 2015

B  create_con (con_name=R/3)

B  Loading DB library 'D:\usr\sap\ECC\DVEBMGS00\exe\dboraslib.dll' ...

B  Library 'D:\usr\sap\ECC\DVEBMGS00\exe\dboraslib.dll' loaded

B  Version of 'D:\usr\sap\ECC\DVEBMGS00\exe\dboraslib.dll' is "700.08", patchlevel (0.25)

B  New connection 0 created

M sysno      00

M sid        ECC

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        3396

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 3396) [dpxxdisp.c   1348]

I  MtxInit: 30000 0 0

M  DpSysAdmExtCreate: ABAP is active

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

M Thu Mar 19 10:06:18 2015

M  DpShMCreate: sizeof(wp_adm) 29792 (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: 6614144)

M  DpShMCreate: allocated sys_adm at 000000000B2B0050

M  DpShMCreate: allocated wp_adm at 000000000B2B2270

M  DpShMCreate: allocated tm_adm_list at 000000000B2B96D0

M  DpShMCreate: allocated tm_adm at 000000000B2B9730

M  DpShMCreate: allocated wp_ca_adm at 000000000B85CFB0

M  DpShMCreate: allocated appc_ca_adm at 000000000B862DB0

M  DpShMCreate: allocated comm_adm at 000000000B864CF0

M  DpShMCreate: system runs without slock table

M  DpShMCreate: system runs without file table

M  DpShMCreate: allocated vmc_adm_list at 000000000B8EB980

M  DpShMCreate: allocated gw_adm at 000000000B8EBA00

M  DpShMCreate: system runs without vmc_adm

M  DpShMCreate: allocated ca_info at 000000000B8EBA30

M  DpShMCreate: allocated wall_adm at 000000000B8EBA40

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 Thu Mar 19 10:06:19 2015

M  ThInit: running on host sapdev

M Thu Mar 19 10:06:20 2015

M  calling db_connect ...

C  Prepending D:\usr\sap\ECC\DVEBMGS00\exe to Path.

C Thu Mar 19 10:06:23 2015

C  Oracle Client Version: '10.2.0.4.0'

C  Client NLS setting (OCINlsGetInfo): 'AMERICAN_AMERICA.UTF8'

C  Logon as OPS$-user to get SAPSR3's password

C  Connecting as /@ECC on connection 0 (nls_hdl 0) ... (dbsl 700 151208)

C  Nls CharacterSet                 NationalCharSet              C      EnvHp      ErrHp ErrHpBatch

C    0 UTF8                                                      0 0000000002F130C0 0000000002F1B2F0 0000000002F1CB18

C  Attaching to DB Server ECC (con_hdl=0,svchp=0000000002F1C9D8,srvhp=000000000F7B0118)

C  Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=0000000002F1C9D8, srvhp=000000000F7B0118, usrhp=0000000002F1DC10)

C  CbApplInfoGet() failed! Ignore, but uninstall callback to avoid more erroneous calls

C Thu Mar 19 10:06:24 2015

C  Now '/@ECC' is connected: con_hdl=0, nls_hdl=0, session_id=126.

C  Got SAPSR3's password from OPS$-user

C  Disconnecting from connection 0 ...

C  Closing user session (con_hdl=0,svchp=0000000002F1C9D8,usrhp=0000000002F1DC10)

C  Now I'm disconnected from ORACLE

C  Connecting as SAPSR3/<pwd>@ECC on connection 0 (nls_hdl 0) ... (dbsl 700 151208)

C  Nls CharacterSet                 NationalCharSet              C      EnvHp      ErrHp ErrHpBatch

C    0 UTF8                                                      0 0000000002F130C0 0000000002F1B2F0 0000000002F1CB18

C  Starting user session: OCISessionBegin(con_hdl=0, usr=SAPSR3/<pwd>, svchp=0000000002F1C9D8, srvhp=000000000F7B0118, usrhp=0000000002F1DC10)

C  Now 'SAPSR3/<pwd>@ECC' is connected: con_hdl=0, nls_hdl=0, session_id=125.

C  Database NLS settings: AMERICAN_AMERICA.UTF8

C  DB instance ECC is running on SAPDEV with ORACLE version 10.2.0.4.0 since MAR 19, 2015, 10:05:34

B  Connection 0 opened (DBSL handle 0)

B  Wp  Hdl ConName          ConId     ConState     TX  PRM RCT TIM MAX OPT Date     Time   DBHost         

B  000 000 R/3              000000000 ACTIVE       NO  YES NO  000 255 255 20150319 100620 SAPDEV         

C  build_stmt: reallocating stmt buffer: 256 -> 2000 characters

M Thu Mar 19 10:06:25 2015

M  db_connect o.k.

M  ICT: exclude compression: *.zip,*.cs,*.rar,*.arj,*.z,*.gz,*.tar,*.lzh,*.cab,*.hqx,*.ace,*.jar,*.ear,*.war,*.css,*.pdf,*.js,*.gzip,*.uue,*.bz2,*.iso,*.sda,*.sar,*.gif,*.swc,*.swf

I Thu Mar 19 10:06:26 2015

I  MtxInit: 0 0 0

M  SHM_PRES_BUF (addr: 0000000010090050, size: 4400000)

M  SHM_ROLL_AREA (addr: 000007FFDDA80050, size: 268435456)

M  SHM_PAGING_AREA (addr: 00000000104D0050, size: 134217728)

M  SHM_ROLL_ADM (addr: 00000000184E0050, size: 2678942)

M  SHM_PAGING_ADM (addr: 000000000FDB0050, size: 525344)

M  ThCreateNoBuffer allocated 544152 bytes for 1000 entries at 000000000FE40050

M  ThCreateNoBuffer index size: 3000 elems

M  ThCreateVBAdm allocated 12176 bytes (50 server) at 000000000FED0050

X  EmInit: MmSetImplementation( 2 ).

X  MM global diagnostic options set: 0

X  <ES> client 0 initializing ....

X  Using implementation view

X  ES initialized.

B  dbntab: NTAB buffers attached

B  dbntab: Buffer FTAB(hash header)  (addr: 00000000187700E0, size: 584)

B  dbntab: Buffer FTAB(anchor array) (addr: 0000000018770330, size: 320072)

B  dbntab: Buffer FTAB(item array)   (addr: 00000000187BE580, size: 1280000)

B  dbntab: Buffer FTAB(data area)    (addr: 00000000188F6D80, size: 30720000)

B  dbntab: Buffer IREC(hash header)  (addr: 000000001A6500E0, size: 584)

B  dbntab: Buffer IREC(anchor array) (addr: 000000001A650330, size: 320072)

B  dbntab: Buffer IREC(item array)   (addr: 000000001A69E580, size: 320000)

B  dbntab: Buffer IREC(data area)    (addr: 000000001A6EC780, size: 6144000)

B  dbntab: Buffer STAB(hash header)  (addr: 000000001ACD00E0, size: 584)

B  dbntab: Buffer STAB(anchor array) (addr: 000000001ACD0330, size: 320072)

B  dbntab: Buffer STAB(item array)   (addr: 000000001AD1E580, size: 320000)

B  dbntab: Buffer STAB(data area)    (addr: 000000001AD6C780, size: 3072000)

B  dbntab: Buffer TTAB(hash header)  (addr: 000000001B0600E0, size: 2360)

B  dbntab: Buffer TTAB(anchor array) (addr: 000000001B060A20, size: 320072)

B  dbntab: Buffer TTAB(item array)   (addr: 000000001B0AEC70, size: 800000)

B  dbntab: Buffer TTAB(data area)    (addr: 000000001B172170, size: 5840000)

C  OCI-call failed with -1=OCI_ERROR

C     SQL error 376: 'ORA-00376: file 18 cannot be read at this time

C  ORA-01110: data file 18: 'E:\ORACLE\ECC\SAPDATA1\SR3_15\SR3.DATA15''

C  *** ERROR => Error 376 in stmt_fetch() from oci_execute_stmt(), orpc=0

[dbsloci.c    12925]

C  *** ERROR => ORA-376 occurred when executing SQL stmt (parse error offset=0)

[dbsloci.c    12944]

C  sc_p=0000000002EE3158,no=1,idc_p=0000000002EFD0C0,con=0,act=1,slen=66,smax=256,#vars=0,stmt=000000000F7BE380,table=DDNTT                        

C  SELECT COUNT(*) FROM DDNTT WHERE TABFORM <> 'J' AND TABFORM <> 'V';

C  sc_p=0000000002EE3158,no=1,idc_p=0000000002EFD0C0,con=0,act=1,slen=66,smax=256,#vars=0,stmt=000000000F7BE380,table=DDNTT                        

C  prep=0,lit=0,nsql=0,lobret=0,#exec=1,dbcnt=0,upsh_p=0000000000000000,ocistmth_p=000000000F7BB370

C  IN : cols=0,rmax=1,xcnt=0,rpc=0,rowi=0,rtot=0,upto=-1,rsize=0,vmax=0,bound=0,iobuf_p=0000000000000000,vda_p=0000000000000000

C       lobs=0,lmax=0,lpcnt=0,larr=0000000000000000,lcurr_p=0000000000000000,rret=0

C  OUT: cols=1,rmax=1,xcnt=1,rpc=0,rowi=0,rtot=0,upto=-1,rsize=4,vmax=32,bound=1,iobuf_p=00000000024AE3F0,vda_p=0000000002DC0010

C       lobs=0,lmax=0,lpcnt=0,larr=0000000000000000,lcurr_p=0000000000000000,rret=0

C  SELECT COUNT(*) FROM DDNTT WHERE TABFORM <> 'J' AND TABFORM <> 'V';

B  ***LOG BYL=> DBQ action required because of database error            [dbsh#2 @ 1104] [dbsh    1104 ]

B  SQL code: 376, SQL text: ORA-00376: file 18 cannot be read at this time

B  ORA-01110: data file 18: 'E:\ORACLE\ECC\SAPDATA1\SR3_15\SR3.DATA15'

B  ***LOG BY4=> sql error 376    performing SEL on table DDNTT      [dbstat#2 @ 849] [dbstat  0849 ]

B  ***LOG BY0=> ORA-00376: file 18 cannot be read at this time

ORA-01110: data file 18: 'E:\ORACLE\ECC\SAPDATA1\SR3_15\SR3.DATA15' [dbstat#2 @ 849] [dbstat  0849 ]

B  db_stinit failed

M  *** ERROR => ThCallHooks: event handler db_init for event CREATE_SHM failed [thxxtool3.c  261]

M  *** ERROR => ThIPCInit: hook failed [thxxhead.c   2105]

M  ***LOG R19=> ThInit, ThIPCInit ( TSKH-IPC-000001) [thxxhead.c   1532]

M  in_ThErrHandle: 1

M  *** ERROR => ThInit: ThIPCInit (step 1, th_errno 17, action 3, level 1) [thxxhead.c   10563]

M  Info for wp 0

M    pid = 3396

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  *  LOCATION    SAP-Server sapdev_ECC_00 on host sapdev (wp 0)

M  *  ERROR       ThInit: ThIPCInit

M  *

M  *  TIME        Thu Mar 19 10:06:26 2015

M  *  RELEASE     701

M  *  COMPONENT   Taskhandler

M  *  VERSION     1

M  *  RC          17

M  *  MODULE      thxxhead.c

M  *  LINE        10783

M  *  COUNTER     1

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 3396) [dpnttool.c   334]

Can somebody explain me the error and how to solve it?

Thanks

KS

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hi kay,

Mostly  disp+work will failed due to shared memory , if you do OS reboot the automatically the issue resolved.

Check all services(sap and Oracle) should be running.

Thanks.

Former Member
0 Kudos

Thanks Raj.I did the reboot and it is working fine now.

Answers (7)

Answers (7)

Brindavan_M
Contributor
0 Kudos

Hi,

Ttry to login into oracle and check the table space in backupmode then close the backupmode or datafile might be went offline which can be found in oracle alert log.

if your not login into oracle and facing same issue then shutdown the database and clean all the shared memory. Then start the database even after restart also the database is not started facing the same issue then you need to do restore.

Try this as well to make the datafile online

shutdown the databse

1. Reinclude the rollback segments in the "init.ora" file.

2. Mount the database.

STARTUP MOUNT;

SQL> select  Name from V&DATAFile where status = 'RECOVER';

SQL> Select name from V$DATAFILE where status = 'OFFLINE';

3. Bring the datafile back online.

SQL> ALTER DATABASE DATAFILE '<full_path_file_name>' ONLINE;

4. Perform media recovery on the datafile.

SQL> RECOVER DATAFILE '<full_path_file_name>';

           

5. Open the database.

SQL> ALTER DATABASE OPEN;

Check this Note : 328785 - ORA-00376: File cannot be read at this time

Thanks,

BM

Former Member
0 Kudos

Hi,

As per the error below the issue is due to access problem in oracle data file may be due to i/o file system issues also

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

C  OCI-call failed with -1=OCI_ERROR

C     SQL error 376: 'ORA-00376: file 18 cannot be read at this time

C  ORA-01110: data file 18: 'E:\ORACLE\ECC\SAPDATA1\SR3_15\SR3.DATA15''

C  *** ERROR => Error 376 in stmt_fetch() from oci_execute_stmt(), orpc=0

[dbsloci.c    12925]

C  *** ERROR => ORA-376 occurred when executing SQL stmt (parse error offset=0)

[dbsloci.c    12944]

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

Have you checked with server team for possible i/o issue. May be simple reboot might fix the issue after stopping the applications.

Regards,

Nikhil


Brindavan_M
Contributor
0 Kudos

Hi ,

when the "disp+work" is stooped then the connection is disconnect with database. Execute the R3trans -d in Command prompt and check dev_trace in management console root also. You may found the the issue with oracle or might be in listener problem.  check the oracle database and fix the issue.

Thanks ,

BM

Former Member
0 Kudos

Hi,

Check the below similar thread which was marked answered.

regards,

pavan

former_member182657
Active Contributor
0 Kudos

Hi Kay,


SQL error 376: 'ORA-00376: file 18 cannot be read at this time

ORA-00376

ORA-01110: data file 18: 'E:\ORACLE\ECC\SAPDATA1\SR3_15\SR3.DATA15'

Hope your issue has already been resolved by following SAP Note 328785 - ORA-00376: File cannot be read at this time

If still persisting the same,please share alert_<SID>.log file for further analysis or kindly close the thread if resolved.

Thanks,

Johan_sapbasis
Active Contributor
0 Kudos

Hi Kiran,

*** 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]

Check for clashing hostnames and IP's on your server /DNS settings.

As per Manu's suggestion as well check you E: drive for disk full perhaps, disk failure perhaps, drive letter change.

Good luck.

REGARDS,

j

manumohandas82
Active Contributor
0 Kudos

Hi KS ,

C  SELECT COUNT(*) FROM DDNTT WHERE TABFORM <> 'J' AND TABFORM <> 'V';

B  ***LOG BYL=> DBQ action required because of database error            [dbsh#2 @ 1104] [dbsh    1104 ]

B  SQL code: 376, SQL text: ORA-00376: file 18 cannot be read at this time

B  ORA-01110: data file 18: 'E:\ORACLE\ECC\SAPDATA1\SR3_15\SR3.DATA15'

It seems the database is not started properly or has issues with some data files

1 ) Can you check whether the following file exists with the correct permissions

E:\ORACLE\ECC\SAPDATA1\SR3_15\SR3.DATA15


2 ) Also check fo any errors in the alert log and attach the same


328785 - ORA-00376: File cannot be read at this time



Thanks ,

Manu