disp+work.exe stopped ***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings

[Former Member]

Dear All,

We are running SAP development and quality ECC6 on Win 2003 64 Bit.

development and quality both instance are install on same system. development server working fine but when we are trying to start Quality server instance showing green for few second after that it was showing yellow color. and disp+work.exe stopped.

We are unable to login in SAP Quality server. Pls help out.

Trace :

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

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

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

sysno      01

sid        SEQ

systemid   562 (PC with Windows NT)

relno      7010

patchlevel 0

patchno    55

intno      20020600

make:      multithreaded, Unicode, 64 bit, optimized

pid        3568

Wed Nov 21 12:40:37 2012

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

length of sys_adm_ext is 576 bytes

*** SWITCH TRC-HIDE on ***

***LOG Q00=> DpSapEnvInit, DPStart (01 3568) [dpxxdisp.c   1287]

          shared lib "dw_xml.dll" version 55 successfully loaded

          shared lib "dw_xtc.dll" version 55 successfully loaded

          shared lib "dw_stl.dll" version 55 successfully loaded

          shared lib "dw_gui.dll" version 55 successfully loaded

          shared lib "dw_mdm.dll" version 55 successfully loaded

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

use internal message server connection to port 3901

Wed Nov 21 12:40:50 2012

*** WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 13 seconds

***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c  5532]

MtxInit: 30000 0 0

DpSysAdmExtInit: ABAP is active

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

DpIPCInit2: start server >spldev_SEQ_01                           <

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: 0000000009390050, size: 6614144)

DpShMCreate: allocated sys_adm at 0000000009390050

DpShMCreate: allocated wp_adm at 0000000009392270

DpShMCreate: allocated tm_adm_list at 00000000093996D0

DpShMCreate: allocated tm_adm at 0000000009399730

DpShMCreate: allocated wp_ca_adm at 000000000993CFB0

DpShMCreate: allocated appc_ca_adm at 0000000009942DB0

DpShMCreate: allocated comm_adm at 0000000009944CF0

DpShMCreate: system runs without slock table

DpShMCreate: system runs without file table

DpShMCreate: allocated vmc_adm_list at 00000000099CB980

DpShMCreate: allocated gw_adm at 00000000099CBA00

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 00000000099CBA30

DpShMCreate: allocated wall_adm at 00000000099CBA40

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.

Using implementation view

<EsNT> Using memory model view.

<EsNT> Memory Reset disabled as NT default

<ES> 4092 blocks reserved for free list.

ES initialized.

mm.dump: set maximum dump mem to 96 MB

rdisp/http_min_wait_dia_wp : 1 -> 1

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

***LOG Q0K=> DpMsAttach, mscon ( spldev) [dpxxdisp.c   12560]

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

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

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 55

Release check o.K.

Wed Nov 21 12:41:30 2012

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

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Nov 21 12:41:40 2012

NiISelect: TIMEOUT occured (10000ms)

dump system status

Workprocess Table (long)                              Wed Nov 21 07:11:40 2012

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

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

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

0 DIA     2416 Ended         no      1   0        0                                                                         

1 DIA     1608 Ended         no      1   0        0                                                                         

2 DIA     5948 Ended         no      1   0        0                                                                         

3 DIA     5964 Ended         no      1   0        0                                                                         

4 DIA     5076 Ended         no      1   0        0                                                                         

5 DIA     4356 Ended         no      1   0        0                                                                         

6 DIA     6152 Ended         no      1   0        0                                                                         

7 DIA     4868 Ended         no      1   0        0                                                                         

8 DIA     5456 Ended         no      1   0        0                                                                         

9 DIA     6068 Ended         no      1   0        0                                                                         

10 UPD     3876 Ended         no      1   0        0                                                                         

11 ENQ     5044 Ended         no      1   0        0                                                                         

12 BTC     5620 Ended         no      1   0        0                                                                         

13 BTC     5684 Ended         no      1   0        0                                                                         

14 BTC     1612 Ended         no      1   0        0                                                                         

15 SPO     2216 Ended         no      1   0        0                                                                         

16 UP2     5592 Ended         no      1   0        0                                                                         

Dispatcher Queue Statistics                              Wed Nov 21 07:11:40 2012

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

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

|  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:                              Wed Nov 21 07:11:40 2012

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

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

Workprocess Comm. Area Blocks                              Wed Nov 21 07:11:40 2012

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

Slots: 300, Used: 1, Max: 0

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

|   id | owner        |   pid    | eyecatcher  |

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

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

NiWait: sleep (5000ms) ...

NiISelect: timeout 5000ms

NiISelect: maximum fd=221

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Nov 21 12:41:45 2012

NiISelect: TIMEOUT occured (5000ms)

DpHalt: shutdown server >spldev_SEQ_01                           < (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 (6424) (SOFT_KILL)

Stop icman

killing process (6980) (SOFT_KILL)

Terminate gui connections

wait for end of work processes

wait for end of gateway

[DpProcDied] Process lives  (PID:6424  HANDLE:188)

waiting for termination of gateway ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=221

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Nov 21 12:41:46 2012

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process died  (PID:6424  HANDLE:188)

wait for end of icman

[DpProcDied] Process lives  (PID:6980  HANDLE:200)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=221

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Nov 21 12:41:47 2012

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:6980  HANDLE:200)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=221

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Nov 21 12:41:48 2012

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:6980  HANDLE:200)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=221

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Nov 21 12:41:49 2012

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:6980  HANDLE:200)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=221

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Nov 21 12:41:50 2012

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:6980  HANDLE:200)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=221

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Nov 21 12:41:51 2012

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:6980  HANDLE:200)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=221

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Nov 21 12:41:52 2012

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:6980  HANDLE:200)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=221

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Nov 21 12:41:53 2012

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:6980  HANDLE:200)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=221

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Nov 21 12:41:54 2012

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:6980  HANDLE:200)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=221

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Nov 21 12:41:55 2012

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:6980  HANDLE:200)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=221

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Nov 21 12:41:56 2012

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:6980  HANDLE:200)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=221

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Nov 21 12:41:57 2012

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process died  (PID:6980  HANDLE:200)

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

DpStartStopMsg: Write AD_STARTSTOP message with type=  0, name=spldev_SEQ_01       , sapsysnr= 1, hostname=spldev                                                         

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)

Wed Nov 21 12:41:58 2012

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

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 108 to: ---

NiBufISelRemove: remove hdl 2 from set0

SiSelNRemove: removed sock 108 (pos=2)

SiSelNRemove: removed sock 108

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

DpSemRq: key: 2, units: 1, timeout: -1

DpSemRel: key: 2, units: 1

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

MBUF component DOWN

NiICloseHandle: shutdown and close hdl 2 / sock 108

NiBufIClose: clear extension for hdl 2

MsIDetach: detach MS-system

cleanup EM

EsCleanup ....

EmCleanup() -> 0

Es2Cleanup: Cleanup ES2

***LOG Q05=> DpHalt, DPStop ( 3568) [dpxxdisp.c   11122]

Good Bye .....

Regards,

Nana

[Former Member]

Sir,

Listener status is working.

Host name and IP address is updated in host file.

3/4 times we had down the instance, database and restart OS but problem is as it is.

Quality server Os virtual memory (MB) allocation status.

                    Min          Max

C:\  drive - 4000          12000

D:\  drive - 4000          12000

E:\  drive - 4000          12000

Required Memory :

24500

Is it virtual memory issue.

but on same server we are running test server (200) it was working fine.

Regards,

Nana

[Former Member]

Hi Nana,

It is not the virtual memory issue. Please check my recommendations.

Best regards,

Orkun Gedik

[Former Member]

Sir,

We had check quality server from consultant as per her investigation due to data base corrupt said problem was occurred. Now we are going to restore database.

Trace of consultant:

C:\Documents and Settings\seqadm.SAP>R3trans -d

This is R3trans version 6.14 (release 701 - 12.06.09 - 15:20:00).

unicode enabled version

R3trans finished (0000).

C:\Documents and Settings\seqadm.SAP>notepad trans.log

C:\Documents and Settings\seqadm.SAP>SQLPLUS /NOLOG

SQL*Plus: Release 10.2.0.4.0 - Production on Sat Nov 24 14:35:43 2012

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

SQL> conn /

Connected.

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64

bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

C:\Documents and Settings\seqadm.SAP>brtools

BR0651I BRTOOLS 7.00 (42)

BR0280I BRTOOLS time stamp: 2012-11-24 14.36.12

BR0656I Choice menu 1 - please make a selection

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

BR*Tools main menu

1 = Instance management

2 - Space management

3 - Segment management

4 - Backup and database copy

5 - Restore and recovery

6 - Check and verification

7 - Database statistics

8 - Additional functions

9 - Exit program

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

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

BR0662I Enter your choice:

7

BR0280I BRTOOLS time stamp: 2012-11-24 14.36.19

BR0663I Your choice: '7'

BR0280I BRTOOLS time stamp: 2012-11-24 14.36.19

BR0656I Choice menu 13 - please make a selection

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

Processing database statistics

1 = Update database statistics

2 - Collect missing statistics

3 - Delete harmful statistics

4 - Manage database statistics

5 - Collect dictionary statistics

6 - Collect system statistics

7 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

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

BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2012-11-24 14.36.24

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0280I BRTOOLS time stamp: 2012-11-24 14.36.24

BR0657I Input menu 42 - please enter/check input values

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

BRCONNECT main options for update statistics

1 - BRCONNECT profile (profile) ......... [initSEQ.sap]

2 - Database user/password (user) ....... [/]

3 ~ Collection method (method) .......... []

4 ~ Sample size (sample) ................ []

5 ~ Bucket count (bucket) ............... []

6 ~ DBMS_STATS parallel degree (degree) . []

7 ~ Change threshold (change) ........... []

8 ~ Database owner for update (owner) ... []

9 ~ Ignore DBSTATC table (ignore) ....... []

10 ~ Exclude from update (exclude) ....... []

11 ~ Tables for update (table) ........... [all]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

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

BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2012-11-24 14.36.27

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0280I BRTOOLS time stamp: 2012-11-24 14.36.27

BR0657I Input menu 43 - please enter/check input values

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

Additional BRCONNECT options for update statistics

1 - Confirmation mode (confirm) ......... [yes]

2 - Query mode (query) .................. [no]

3 - Parallel threads (parallel) ......... [1]

4 - Update history tables (history) ..... [no]

5 - Retain old statistics (retain) ...... [no]

6 ~ Time limit in minutes (limit) ....... []

7 ~ Force options (force) ............... []

8 # Time interval in minutes (interval) . []

9 - Extended output (output) ............ [no]

10 - Message language (language) ......... [E]

11 - BRCONNECT command line (command) .... [-p initSEQ.sap -l E -f stats -t "all

" -p 1]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

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

BR0662I Enter your choice:

3

BR0280I BRTOOLS time stamp: 2012-11-24 14.36.33

BR0663I Your choice: '3'

BR0682I Enter integer value for "parallel" (1-16) [1]:

4

BR0280I BRTOOLS time stamp: 2012-11-24 14.36.34

BR0683I New value for "parallel": '4'

BR0280I BRTOOLS time stamp: 2012-11-24 14.36.34

BR0657I Input menu 43 - please enter/check input values

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

Additional BRCONNECT options for update statistics

1 - Confirmation mode (confirm) ......... [yes]

2 - Query mode (query) .................. [no]

3 - Parallel threads (parallel) ......... [4]

4 - Update history tables (history) ..... [no]

5 - Retain old statistics (retain) ...... [no]

6 ~ Time limit in minutes (limit) ....... []

7 ~ Force options (force) ............... []

8 # Time interval in minutes (interval) . []

9 - Extended output (output) ............ [no]

10 - Message language (language) ......... [E]

11 - BRCONNECT command line (command) .... [-p initSEQ.sap -l E -f stats -t "all

" -p 4]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

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

BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2012-11-24 14.36.37

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0291I BRCONNECT will be started with options '-p initSEQ.sap -l E -f stats -t

"all" -p 4'

BR0280I BRTOOLS time stamp: 2012-11-24 14.36.38

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

c

BR0280I BRTOOLS time stamp: 2012-11-24 14.36.40

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

###############################################################################

BR0801I BRCONNECT 7.00 (42)

BR0280I BRCONNECT time stamp: 2012-11-24 14.36.56

BR0301W SQL error -376 at location BrDbaSynCheck-1, SQL statement:

'SELECT COUNT(*) FROM SAP_SDBAH WHERE BEG = '00000000000000''

ORA-00376: file 7 cannot be read at this time

ORA-01110: data file 7: 'L:\ORACLE\SEQ\SAPDATA2\SR3_4\SR3.DATA4'

BR0280I BRCONNECT time stamp: 2012-11-24 14.36.57

BR0301E SQL error -376 at location BrLicCheck-14, SQL statement:

'SELECT COUNT(*) FROM SAP_SAPLIKEY'

ORA-00376: file 7 cannot be read at this time

ORA-01110: data file 7: 'L:\ORACLE\SEQ\SAPDATA2\SR3_4\SR3.DATA4'

BR0280I BRCONNECT time stamp: 2012-11-24 14.36.57

BR0301W SQL error -376 at location brc_dblog_open-1, SQL statement:

'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('

20121124143640', 'sta', 'SEQ', 'ALL', '9999', ' ', 'cejyknuu', '7.00 (42)')'

ORA-00376: file 7 cannot be read at this time

ORA-01110: data file 7: 'L:\ORACLE\SEQ\SAPDATA2\SR3_4\SR3.DATA4'

BR0324W Insertion of database log header failed

BR0806I End of BRCONNECT processing: cejyknuu.sta 2012-11-24 14.36.57

BR0280I BRCONNECT time stamp: 2012-11-24 14.36.57

BR0804I BRCONNECT terminated with errors

###############################################################################

BR0292I Execution of BRCONNECT finished with return code 3

BR0668I Warnings or errors occurred - you can continue to ignore them or go back

to repeat the last action

BR0280I BRTOOLS time stamp: 2012-11-24 14.36.58

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

Thanks and regards,

Nana

Mumbai

[Former Member]

Please check Note 328785 - ORA-00376: File cannot be read at this time. Hope it help to resolve your issue.

Regards,

Roman

[Former Member]

Ok. It is good to restore the database, if it is possible. Because datafile recovery operation could be more cost-effective.

Best regards,

Orkun Gedik

[jayaprakashhj]

Hi Guru,

I have just posted the similar issue in discussion. Please look into it. Please let me know how to get 'dev_w0' trace file. I am new to SAP, so, please elaborate your directions/suggestions/recommendations.

Thank you,

Regards,

Jayaprakash.

[Former Member]

Hi,

Could you upload dev_w0 trace, here?

Best regards,

Orkun Gedik

[Former Member]

Sir,

Thanks for reply,

Trace of "dev_w0"

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

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

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

*

*  ACTIVE TRACE LEVEL           1

*  ACTIVE TRACE COMPONENTS      all, MJ

*

B 

B Thu Nov 22 15:43:55 2012

B  create_con (con_name=R/3)

B  Loading DB library 'I:\usr\sap\SEQ\DVEBMGS01\exe\dboraslib.dll' ...

B  Library 'I:\usr\sap\SEQ\DVEBMGS01\exe\dboraslib.dll' loaded

B  Version of 'I:\usr\sap\SEQ\DVEBMGS01\exe\dboraslib.dll' is "700.08", patchlevel (0.42)

B  New connection 0 created

M sysno      01

M sid        SEQ

M systemid   562 (PC with Windows NT)

M relno      7010

M patchlevel 0

M patchno    55

M intno      20020600

M make:      multithreaded, Unicode, 64 bit, optimized

M pid        5616

M

M  kernel runs with dp version 242000(ext=110000) (@(#) DPLIB-INT-VERSION-242000-UC)

M  length of sys_adm_ext is 576 bytes

M  ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 5616) [dpxxdisp.c   1349]

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)                    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: 000000000B390050, size: 6614144)

M  DpShMCreate: allocated sys_adm at 000000000B390050

M  DpShMCreate: allocated wp_adm at 000000000B392270

M  DpShMCreate: allocated tm_adm_list at 000000000B3996D0

M  DpShMCreate: allocated tm_adm at 000000000B399730

M  DpShMCreate: allocated wp_ca_adm at 000000000B93CFB0

M  DpShMCreate: allocated appc_ca_adm at 000000000B942DB0

M  DpShMCreate: allocated comm_adm at 000000000B944CF0

M  DpShMCreate: system runs without slock table

M  DpShMCreate: system runs without file table

M  DpShMCreate: allocated vmc_adm_list at 000000000B9CB980

M  DpShMCreate: allocated gw_adm at 000000000B9CBA00

M  DpShMCreate: system runs without vmc_adm

M  DpShMCreate: allocated ca_info at 000000000B9CBA30

M  DpShMCreate: allocated wall_adm at 000000000B9CBA40

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.

X  mm.dump: set maximum dump mem to 96 MB

M 

M Thu Nov 22 15:43:56 2012

M  ThInit: running on host spldev

M 

M Thu Nov 22 15:43:57 2012

M  calling db_connect ...

C  Prepending I:\usr\sap\SEQ\DVEBMGS01\exe to Path.

C 

C Thu Nov 22 15:43:59 2012

C  Oracle Client Version: '10.2.0.2.0'

C  application info callback registered

C  Client NLS setting (OCINlsGetInfo): connection handle 0 -> 'AMERICAN_AMERICA.UTF8'

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

C  Connecting as /@SEQ on connection 0 (nls_hdl 0) ... (dbsl 701 220409)

C  Nls CharacterSet                 NationalCharSet                   EnvHp      ErrHp ErrHpBatch

C    0 UTF8                                                      000000000D2C90C0 00000000024BF180 00000000051B7A68

C  Attaching to DB Server SEQ (con_hdl=0,svchp=00000000051B7928,srvhp=000000000D2D1118)

C 

C Thu Nov 22 15:44:00 2012

C  Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=00000000051B7928, srvhp=000000000D2D1118, usrhp=00000000024BF998)

C 

C Thu Nov 22 15:44:01 2012

C     CbApplInfoGet() failed (ignored 1).

C  Now '/@SEQ' is connected: con_hdl=0, nls_hdl=0, session_id=55.

C  *** ERROR => ORA-1403 when accessing table SAPUSER

[dbsloci.c    11627]

C  Disconnecting from connection 0 ...

C  Closing user session (con_hdl=0,svchp=00000000051B7928,usrhp=00000000024BF998)

C  Now I'm disconnected from ORACLE

C  Try to connect with default password

C  Connecting as SAPSR3/<pwd>@SEQ on connection 0 (nls_hdl 0) ... (dbsl 701 220409)

C  Nls CharacterSet                 NationalCharSet                   EnvHp      ErrHp ErrHpBatch

C    0 UTF8                                                      000000000D2C90C0 00000000024BF180 00000000051B7A68

C  Starting user session: OCISessionBegin(con_hdl=0, usr=SAPSR3/<pwd>, svchp=00000000051B7928, srvhp=000000000D2D1118, usrhp=00000000024BF998)

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

C  Database NLS settings: AMERICAN_AMERICA.UTF8

C  DB instance SEQ is running on SPLDEV with ORACLE version 10.2.0.4.0 since NOV 22, 2012, 15:41:19

B  Connection 0 opened (DBSL handle 0)

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

B  000 000 R/3                            000000000 ACTIVE       NO  NO  YES NO  NO  000 255 255 20121122 154357 SPLDEV                       

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

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,*.png,*.swc,*.swf

I 

I Thu Nov 22 15:44:03 2012

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: 000000000FF10050, size: 525344)

M  ThCreateNoBuffer                    allocated 544152 bytes for 1000 entries at 0000000018770050

M  ThCreateNoBuffer                    index size: 3000 elems

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

X  EmInit: MmSetImplementation( 2 ).

X  MM global diagnostic options set: 0

X  <ES> client 0 initializing ....

X  Using implementation view

X  ES initialized.

X  mm.dump: set maximum dump mem to 96 MB

B  dbntab: NTAB buffers attached

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

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

B  dbntab: Buffer FTAB(item array)   (addr: 00000000188DE580, size: 1280000)

B  dbntab: Buffer FTAB(data area)    (addr: 0000000018A16D80, size: 30720000)

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

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

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

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

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

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

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

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

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

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

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

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

C     OCIStmtExecute() failed with -1=OCI_ERROR

C     SQL error 376:

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

[dbsloci.c    12992]

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

[dbsloci.c    13011]

C  sc_p=000000000D23E158,no=1,idc_p=000000000D2580C0,con=0,act=1,slen=66,smax=256,#vars=0,stmt=0000000005309DB0,table=DDNTT                        

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

C  sc_p=000000000D23E158,no=1,idc_p=000000000D2580C0,con=0,act=1,slen=66,smax=256,#vars=0,stmt=0000000005309DB0,table=DDNTT                        

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

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=00000000024AD6C0,vda_p=00000000052BF950

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 7 cannot be read at this time

B  ORA-01110: data file 7: 'L:\ORACLE\SEQ\SAPDATA2\SR3_4\SR3.DATA4'

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

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

ORA-01110: data file 7: 'L:\ORACLE\SEQ\SAPDATA2\SR3_4\SR3.DATA4' [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   2118]

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

M  in_ThErrHandle: 1

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

M 

M  Info for wp 0

M 

M    pid = 5616

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 spldev_SEQ_01 on host spldev (wp 0)

M  *  ERROR       ThInit: ThIPCInit

M  *

M  *  TIME        Thu Nov 22 15:44:03 2012

M  *  RELEASE     701

M  *  COMPONENT   Taskhandler

M  *  VERSION     1

M  *  RC          17

M  *  MODULE      thxxhead.c

M  *  LINE        10854

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

dev_w0.dat.zip

[former_member227150]

Hi,

Please check for the Oracle Listener, if it is working.

You can also check for the entry of the hostname in the c:\windows\system32\drivers\etc\hosts file.

Thanks

[Former Member]

Gaurav,

>> C  *** ERROR => ORA-1403 when accessing table SAPUSER

Check the  OPS$ mechanish has been configured correctly. For the further information; Note 400241 - Problems with ops$ or sapr3 connect to Oracle

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

>> B  ORA-01110: data file 7: 'L:\ORACLE\SEQ\SAPDATA2\SR3_4\SR3.DATA4'

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

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

>>ORA-01110: data file 7: 'L:\ORACLE\SEQ\SAPDATA2\SR3_4\SR3.DATA4' [dbstat#2 @ 849] [dbstat  0849 ]

The datafile might be corrupted. Perform th "dbv" check over the datafiles, especially on sr3.data4

>> B  db_stinit failed

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

This problem is related with the shared memory allocation. Restart the service or the system to avoid this error.

Best regards,

Orkun Gedik

[Former Member]

>> C  *** ERROR => ORA-1403 when accessing table SAPUSER

You have no data in table SAPUSER. You need to have only 1 row for SAPSR3 user. Please use

brconnect -u system/<password> -f chpass -o <sapowner> -p <password>

command to correct this error.

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

>> B  ORA-01110: data file 7: 'L:\ORACLE\SEQ\SAPDATA2\SR3_4\SR3.DATA4'

Check the state of the file. Most likely the file if offline. See Note 328785 - ORA-00376: File cannot be read at this time

After that try again. You need to correct errors sequentially. The following errors like

>> B  db_stinit failed

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

may dissapear with no actions taken.

Regards,

Roman