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
Product and Topic Expert
Product and Topic Expert
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?