cancel
Showing results for 
Search instead for 
Did you mean: 

Dispatcher Emergency shutdown

naresh_bammidi
Contributor
0 Kudos

Dear Experts,

I was installed SAP in my system,But When i start my server WP tables status is showing ENDED and also Dispatcher is getting stopped but Message server is running .i tried by changing the ip address and all the ways which i can do.Being not a basis guy, i couldnt find the solution. Please help me out.

The following is the developer trace

*** ERROR => W0 (pid 2460) died [dpxxdisp.c 11651]
*** ERROR => W1 (pid 2468) died [dpxxdisp.c 11651]
*** ERROR => W2 (pid 2476) died [dpxxdisp.c 11651]
. . . 
*** ERROR => W11 (pid 2552) died [dpxxdisp.c 11651]
*** ERROR => W12 (pid 2592) died [dpxxdisp.c 11651]
my types changed after wp death/restart 0xbf --> 0x80
*** DP_FATAL_ERROR => DpEnvCheck: no more work processes
*** DISPATCHER EMERGENCY SHUTDOWN ***

with regards

Naresh

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Naresh,

Your dispatcher is shutting down because all the work process are dying... Can you attach your dev_w0 to this thread or paste it?

naresh_bammidi
Contributor
0 Kudos

Hi the following is the dev_w0 trace.

---------------------------------------------------
trc file: "dev_w0", trc level: 1, release: "700"
---------------------------------------------------
*
*  ACTIVE TRACE LEVEL           1
*  ACTIVE TRACE COMPONENTS      all, MJ
*
B  
B Mon Feb 27 21:32:39 2012
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.73)
B  New connection 0 created
M sysno      00
M sid        ECC
M systemid   560 (PC with Windows NT)
M relno      7000
M patchlevel 0
M patchno    75
M intno      20050900
M make:      multithreaded, Unicode, optimized
M pid        3512
M 
M  kernel runs with dp version 217000(ext=109000) (@(#) DPLIB-INT-VERSION-217000-UC)
M  length of sys_adm_ext is 572 bytes
M  ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 3512) [dpxxdisp.c   1299]
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)		18304	(1408)
M  DpShMCreate: sizeof(tm_adm)		3994272	(19872)
M  DpShMCreate: sizeof(wp_ca_adm)		24000	(80)
M  DpShMCreate: sizeof(appc_ca_adm)	8000	(80)
M  DpCommTableSize: max/headSize/ftSize/tableSize=500/8/528056/528064
M  DpShMCreate: sizeof(comm_adm)		528064	(1048)
M  DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
M  DpShMCreate: sizeof(file_adm)		0	(72)
M  DpShMCreate: sizeof(vmc_adm)		0	(1440)
M  DpShMCreate: sizeof(wall_adm)		(38456/34360/64/184)
M  DpShMCreate: sizeof(gw_adm)	48
M  DpShMCreate: SHM_DP_ADM_KEY		(addr: 05D70040, size: 4653368)
M  DpShMCreate: allocated sys_adm at 05D70040
M  DpShMCreate: allocated wp_adm at 05D71E40
M  DpShMCreate: allocated tm_adm_list at 05D765C0
M  DpShMCreate: allocated tm_adm at 05D765F0
M  DpShMCreate: allocated wp_ca_adm at 06145890
M  DpShMCreate: allocated appc_ca_adm at 0614B650
M  DpShMCreate: allocated comm_adm at 0614D590
M  DpShMCreate: system runs without file table
M  DpShMCreate: allocated vmc_adm_list at 061CE450
M  DpShMCreate: allocated gw_adm at 061CE490
M  DpShMCreate: system runs without vmc_adm
M  DpShMCreate: allocated ca_info at 061CE4C0
M  DpShMCreate: allocated wall_adm at 061CE4C8
X  EmInit: MmSetImplementation( 2 ).
X  MM global diagnostic options set: 0
X  <ES> client 0 initializing ....
X  Using implementation flat
M  <EsNT> Memory Reset disabled as NT default
X  ES initialized.
M  
M Mon Feb 27 21:32:40 2012
M  ThInit: running on host gcecc62
M  
M Mon Feb 27 21:32:41 2012
M  calling db_connect ...
C  Prepending D:\usr\sap\ECC\DVEBMGS00\exe to Path.
C  
C Mon Feb 27 21:32:42 2012
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 /@ECC on connection 0 (nls_hdl 0) ... (dbsl 700 110706)
C  Nls CharacterSet                 NationalCharSet              C      EnvHp      ErrHp ErrHpBatch
C    0 UTF8                                                      1   063A7AF8   063AD094   063AC91C
C  Attaching to DB Server ECC (con_hdl=0,svchp=063AC868,svrhp=063BE134)
C  Starting user session (con_hdl=0,svchp=063AC868,srvhp=063BE134,usrhp=063D2E88)
C  Now '/@ECC' is connected (con_hdl 0, nls_hdl 0).
C  Got SAPSR3's password from OPS$-user
C  Disconnecting from connection 0 ...
C  Closing user session (con_hdl=0,svchp=063AC868,usrhp=063D2E88)
C  Now I'm disconnected from ORACLE
C  Connecting as SAPSR3/<pwd>@ECC on connection 0 (nls_hdl 0) ... (dbsl 700 110706)
C  Nls CharacterSet                 NationalCharSet              C      EnvHp      ErrHp ErrHpBatch
C    0 UTF8                                                      1   063A7AF8   063AD094   063AC91C
C  Starting user session (con_hdl=0,svchp=063AC868,srvhp=063BE134,usrhp=063D2E88)
C  *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 28000
 [dboci.c      4391]
C  Detaching from DB Server (con_hdl=0,svchp=063AC868,srvhp=063BE134)
C  *** ERROR => CONNECT failed with sql error '28000'
 [dbsloci.c    10933]
B  ***LOG BY2=> sql error 28000  performing CON [dbsh#2 @ 1204] [dbsh    1204 ]
B  ***LOG BY0=> ORA-28000: the account is locked [dbsh#2 @ 1204] [dbsh    1204 ]
B  ***LOG BY2=> sql error 28000  performing CON [dblink#3 @ 431] [dblink  0431 ]
B  ***LOG BY0=> ORA-28000: the account is locked [dblink#3 @ 431] [dblink  0431 ]
M  ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c   1411]
M  in_ThErrHandle: 1
M  
M Mon Feb 27 21:32:43 2012
M  *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   10156]
M  
M  Info for wp 0
M  
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  *
M  *  LOCATION    SAP-Server gcecc62_ECC_00 on host gcecc62 (wp 0)
M  *  ERROR       ThInit: db_connect
M  *
M  *  TIME        Mon Feb 27 21:32:43 2012
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  
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 3512) [dpnttool.c   327]

with regards

Naresh

Former Member
0 Kudos

Dear Nagaresh,

The error is caused because your Oracle account is locked and causing the work process to shut down:

LOG BY0=> ORA-28000: the account is locked

Reading note 951167 should solve the issue.

951167 ORA-28000: the account is locked

Cheers,

Maurício

Former Member
0 Kudos

Hi,

ORA-28000: the account is locked

Seems that SAPSR3 is locked in the Oracle database.

Please paste the output for the below SQL query

Login to sqlplus "/as sysbda"

select username, account_status from dba_users ;

Br,

Venky

naresh_bammidi
Contributor
0 Kudos

Hi Venky,

Yes you are right .SAPR3 is Locked.i executed the query please find the output here

SQL> conn /as sysdba
Connected.
SQL> select username,account_status from dba_users;

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
OPS$GCECC62\ECCADM             OPEN
OPS$GCECC62\SAPSERVICEECC      OPEN
SYS                            OPEN
SYSTEM                         OPEN
SAPSR3                         LOCKED(TIMED)
OUTLN                          LOCKED
TSMSYS                         EXPIRED & LOCKED
DIP                            EXPIRED & LOCKED
DBSNMP                         EXPIRED & LOCKED

Please tell me how to UNLOCK the account.

Former Member
0 Kudos

Naresh,

You can unlock by issuing the following command:

ALTER USER SAPSR3 ACCOUNT UNLOCK;

Cheers,

Maurício

Former Member
0 Kudos

Hi Naresh,

Pls unlock with alter user sapsr3 account unlock;

And set the password to never expiry and invalid login attempts to unlimited.

select profile from DBA_USERS where username = <username>

Remember the profile name

alter profile <profile_name> limit password_life_time UNLIMITED;

alter <profile_name> default limit failed_login_attempts unlimited;

Br,

Venky

naresh_bammidi
Contributor
0 Kudos

Thank you so much Venky,You saved my time

with regards

Naresh

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Naresh,

Please mention the environment details like OS version, SAP release etc..

Just a check

Goto your profile directory and run sappfpar check pf=<instance_profile>

And correct the errors.

Br,

Venky

Former Member
0 Kudos

Dear All,

I am facing problem in dual stack system (Java+Abap) on windows 2008. Its showing SAPSR3 and SAPSR3DB  password expired and same has bee change password but when I start dispatcher then automatic sapsr3 locked(Timed). Then again unlock sapsr3 and start dispatcher and again stop and locked sapsr3. Now I run following command and same problem dispatcher stop and but now sapsr3/sapsr3db not locking.

drop user "OPS$UBSBWD\sidADM" cascade;

drop public synonym SAPUSER;

create user "OPS$UBSBWD\SIDADM" default tablespace <<usually psapsr3usr>> temporary tablespace <<usually psaptemp>> identified externally;

grant connect, resource to "OPS$UBSBWD\SIDADM";

create table "OPS$UBSBWD\SIDADM".SAPUSER ( USERID VARCHAR2(256), PASSWD VARCHAR2 (256));

insert into "OPS$UBSBWD\SIDADM".SAPUSER values ('SAPBID', 'sap');

alter user SAPBID identified by sap;

create public synonym sapuser for OPS$UBSBWD\SIDADM.SAPUSER;

grant select, update on sapuser to "OPS$UBSBWD\SIDADM";

Please help............

Thanks,

Jitendra Kumar