cancel
Showing results for 
Search instead for 
Did you mean: 

disp+work.exe suddenly stop after 1 minute on my demo system

Former Member
0 Kudos

i could not find the problem. dev_disp and dev_w0 file are as under

dev_disp

*** ERROR => W0 (pid 2760) died [dpxxdisp.c   14241]

*** ERROR => W1 (pid 2924) died [dpxxdisp.c   14241]

*** ERROR => W2 (pid 2116) died [dpxxdisp.c   14241]

*** ERROR => W3 (pid 3884) died [dpxxdisp.c   14241]

*** ERROR => W4 (pid 3680) died [dpxxdisp.c   14241]

*** ERROR => W5 (pid 696) died [dpxxdisp.c   14241]

my types changed after wp death/restart 0xbf --> 0xbe

*** ERROR => W6 (pid 3140) died [dpxxdisp.c   14241]

my types changed after wp death/restart 0xbe --> 0xbc

*** ERROR => W7 (pid 3908) died [dpxxdisp.c   14241]

my types changed after wp death/restart 0xbc --> 0xb8

*** ERROR => W8 (pid 1216) died [dpxxdisp.c   14241]

*** ERROR => W9 (pid 2212) died [dpxxdisp.c   14241]

*** ERROR => W10 (pid 3724) died [dpxxdisp.c   14241]

my types changed after wp death/restart 0xb8 --> 0xb0

*** ERROR => W11 (pid 3712) died [dpxxdisp.c   14241]

my types changed after wp death/restart 0xb0 --> 0xa0

*** ERROR => W12 (pid 1712) died [dpxxdisp.c   14241]

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

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Jan 01 00:36:13 2007

NiISelect: TIMEOUT occured (10000ms)

dump system status

Workprocess Table (long)                              Sun Dec 31 19:06:13 2006

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

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

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

0 DIA     2760 Ended         no      1   0             0                                                             

1 DIA     2924 Ended         no      1   0             0                                                             

2 DIA     2116 Ended         no      1   0             0                                                             

3 DIA     3884 Ended         no      1   0             0                                                             

4 DIA     3680 Ended         no      1   0             0                                                             

5 DIA      696 Ended         no      1   0             0                                                             

6 UPD     3140 Ended         no      1   0             0                                                             

7 ENQ     3908 Ended         no      1   0             0                                                             

8 BTC     1216 Ended         no      1   0             0                                                             

9 BTC     2212 Ended         no      1   0             0                                                             

10 BTC     3724 Ended         no      1   0             0                                                             

11 SPO     3712 Ended         no      1   0             0                                                             

12 UP2     1712 Ended         no      1   0             0                                                             

Dispatcher Queue Statistics                              Sun Dec 31 19:06:13 2006

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

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

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

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

| NOWP |      0 |      2 |   2000 |      5 |      5 |

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

|  DIA |      5 |      5 |   2000 |      5 |      0 |

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

|  UPD |      0 |      0 |   2000 |      0 |      0 |

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

|  ENQ |      0 |      0 |   2000 |      0 |      0 |

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

|  BTC |      0 |      0 |   2000 |      0 |      0 |

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

|  SPO |      0 |      0 |   2000 |      0 |      0 |

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

|  UP2 |      0 |      0 |   2000 |      0 |      0 |

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

max_rq_id                    12

wake_evt_udp_now          0

wake events                total     8,  udp     6 ( 75%),  shm     2 ( 25%)

since last update          total     8,  udp     6 ( 75%),  shm     2 ( 25%)

Dump of tm_adm structure:                              Sun Dec 31 19:06:13 2006

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

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

Workprocess Comm. Area Blocks                              Sun Dec 31 19:06:13 2006

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

Slots: 300, Used: 1, Max: 0

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

|   id | owner        |   pid    | eyecatcher  |

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

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

NiWait: sleep (5000ms) ...

NiISelect: timeout 5000ms

NiISelect: maximum fd=1585

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Jan 01 00:36:18 2007

NiISelect: TIMEOUT occured (5000ms)

DpHalt: shutdown server >yasadm_YAS_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 (2360) (SOFT_KILL)

Stop icman

killing process (544) (SOFT_KILL)

Terminate gui connections

wait for end of work processes

wait for end of gateway

[DpProcDied] Process lives  (PID:2360  HANDLE:1556)

waiting for termination of gateway ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1585

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Jan 01 00:36:19 2007

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process died  (PID:2360  HANDLE:1556)

wait for end of icman

[DpProcDied] Process lives  (PID:544  HANDLE:1560)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1585

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Jan 01 00:36:20 2007

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:544  HANDLE:1560)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1585

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Jan 01 00:36:21 2007

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:544  HANDLE:1560)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1585

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Jan 01 00:36:22 2007

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:544  HANDLE:1560)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1585

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Jan 01 00:36:23 2007

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:544  HANDLE:1560)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1585

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Jan 01 00:36:24 2007

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:544  HANDLE:1560)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1585

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Jan 01 00:36:25 2007

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:544  HANDLE:1560)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1585

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Jan 01 00:36:26 2007

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:544  HANDLE:1560)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1585

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Jan 01 00:36:27 2007

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:544  HANDLE:1560)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1585

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Jan 01 00:36:28 2007

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:544  HANDLE:1560)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1585

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Jan 01 00:36:29 2007

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:544  HANDLE:1560)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1585

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Jan 01 00:36:30 2007

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process died  (PID:544  HANDLE:1560)

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

NiIMyHostName: hostname = 'yasadm'

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)

Mon Jan 01 00:36:31 2007

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

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

NiBufISelRemove: remove hdl 2 from set0

SiSelNRemove: removed sock 1496 (pos=2)

SiSelNRemove: removed sock 1496

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

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 1496

NiBufIClose: clear extension for hdl 2

MsIDetach: detach MS-system

cleanup EM

EsCleanup ....

EmCleanup() -> 0

Es2Cleanup: Cleanup ES2

***LOG Q05=> DpHalt, DPStop ( 3664) [dpxxdisp.c   10259]

Good Bye .....

dev_w0

Mon Jan 01 00:35:26 2007

M  calling db_connect ...

C  Prepending E:\usr\sap\YAS\DVEBMGS00\exe to Path.

C  Oracle Client Version: '10.2.0.1.0'

C  Client NLS settings: AMERICAN_AMERICA.UTF8

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

C  Connecting as /@YAS on connection 0 (nls_hdl 0) ... (dbsl 700 110706)

C  Nls CharacterSet                 NationalCharSet              C      EnvHp      ErrHp ErrHpBatch

C    0 UTF8                                                      1   06C6BEB8   06C71454   06C70CDC

C  Attaching to DB Server YAS (con_hdl=0,svchp=06C70C28,svrhp=06C82134)

C  Starting user session (con_hdl=0,svchp=06C70C28,srvhp=06C82134,usrhp=06CCD998)

C  *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1033

[dboci.c      4391]

C  Detaching from DB Server (con_hdl=0,svchp=06C70C28,srvhp=06C82134)

C  *** ERROR => CONNECT failed with sql error '1033'

[dbsloci.c    10933]

C  Try to connect with default password

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

C  Nls CharacterSet                 NationalCharSet              C      EnvHp      ErrHp ErrHpBatch

C    0 UTF8                                                      1   06C6BEB8   06C71454   06C70CDC

C  Attaching to DB Server YAS (con_hdl=0,svchp=06C70C28,svrhp=06C82134)

C  Starting user session (con_hdl=0,svchp=06C70C28,srvhp=06C82134,usrhp=06CCD998)

C  *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1033

[dboci.c      4391]

C  Detaching from DB Server (con_hdl=0,svchp=06C70C28,srvhp=06C82134)

C  *** ERROR => CONNECT failed with sql error '1033'

[dbsloci.c    10933]

B  ***LOG BV3=> severe db error 1033      ; work process is stopped [dbsh#2 @ 1199] [dbsh    1199 ]

B  ***LOG BY2=> sql error 1033   performing CON [dblink#3 @ 431] [dblink  0431 ]

B  ***LOG BY0=> ORA-01033: ORACLE initialization or shutdown in progress [dblink#3 @ 431] [dblink  0431 ]

M  ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c   1411]

M  in_ThErrHandle: 1

M  *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   10156]

M  Info for wp 0

M    stat = 4

M    reqtype = 1

M    act_reqtype = -1

M    rq_info = 0

M    tid = -1

M    mode = 255

M    len = -1

M    rq_id = 65535

M    rq_source = 255

M    last_tid = 0

M    last_mode = 0

M    semaphore = 0

M    act_cs_count = 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    vm = V-1

M  *****************************************************************************

M  *

M  *  LOCATION    SAP-Server yasadm_YAS_00 on host yasadm (wp 0)

M  *  ERROR       ThInit: db_connect

M  *

M  *  TIME        Mon Jan 01 00:35:26 2007

M  *  RELEASE     700

M  *  COMPONENT   Taskhandler

M  *  VERSION     1

M  *  RC          13

M  *  MODULE      thxxhead.c

M  *  LINE        10354

M  *  COUNTER     1

M  *

M  *****************************************************************************

M  PfStatDisconnect: disconnect statistics

M  Entering TH_CALLHOOKS

M  ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M  *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c   720]

M  *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c  260]

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 2760) [dpnttool.c   327]

Thanks in advance

Milan Kothari

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member215981
Active Participant
0 Kudos

Hello,

please check sap note 655240 .

655240 Composite SAP note: ORA-01033

Best Regards,

Yong Luo

Former Member
0 Kudos

Hi everyone, thanks for reply, Actually the problem with sapsr3 user , i had change the password of sapsr3 user with the help of alter user command..

bxiv
Active Contributor
0 Kudos

Good to hear, don't forget to mark any of the posts that helped you solved the issue to help future viewers with fixing their systems.

Reagan
Advisor
Advisor
0 Kudos

Hello

Make sure you have Oracle instant Client installed. Check this SAP note for more information.

Note 998004 - Update the Oracle Instant Client on Windows

Also is the database up ?

Please provide the output of this SQL statment.

select name, open_mode from v$database;

Regards

RB

Former Member
0 Kudos

Hi,

1)Please check any space issue in the Oracle filesystem..

After that Open Dos command Prompt

c:> sqlplus /nolog

sql> connect sys/manager as sysdba

sql>shutdown immediate

sql> startup

sql> exit

Regards

JayaPrakash

bxiv
Active Contributor
0 Kudos

milan kothari wrote:

C  Try to connect with default password

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

C  Nls CharacterSet                 NationalCharSet              C      EnvHp      ErrHp ErrHpBatch

C    0 UTF8                                                      1   06C6BEB8   06C71454   06C70CDC

C  Attaching to DB Server YAS (con_hdl=0,svchp=06C70C28,svrhp=06C82134)

C  Starting user session (con_hdl=0,svchp=06C70C28,srvhp=06C82134,usrhp=06CCD998)

C  *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1033

[dboci.c      4391]

C  Detaching from DB Server (con_hdl=0,svchp=06C70C28,srvhp=06C82134)

C  *** ERROR => CONNECT failed with sql error '1033'

[dbsloci.c    10933]

B  ***LOG BV3=> severe db error 1033      ; work process is stopped [dbsh#2 @ 1199] [dbsh    1199 ]

B  ***LOG BY2=> sql error 1033   performing CON [dblink#3 @ 431] [dblink  0431 ]

B  ***LOG BY0=> ORA-01033: ORACLE initialization or shutdown in progress [dblink#3 @ 431] [dblink  0431 ]

To me it looks like you have a DB login issue; is the Oracle SQL setup for your system?