disp+work.EXE stoped

[Former Member]

Dear All

In my IDES system, in SAPMMC window when i am going start the instance all three process are starting (msg_server, dispwork.EXE and igswd.EXE) three process showing green colour after some seconds dispwork.EXE process showing stopped status, remaining two process are in running status

please reply

[JPReyes]

Can you post dev_w0?

regards

Juan

[Former Member]

---

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

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, MJ

*

B

B Wed Nov 25 14:47:19 2009

B create_con (con_name=R/3)

B Loading DB library 'F:\usr\sap\IED\DVEBMGS00\exe\dboraslib.dll' ...

B Library 'F:\usr\sap\IED\DVEBMGS00\exe\dboraslib.dll' loaded

B Version of 'F:\usr\sap\IED\DVEBMGS00\exe\dboraslib.dll' is "700.08", patchlevel (0.107)

B New connection 0 created

M sysno 00

M sid IED

M systemid 560 (PC with Windows NT)

M relno 7000

M patchlevel 0

M patchno 111

M intno 20050900

M make: multithreaded, Unicode, optimized

M pid 3480

M

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

M length of sys_adm_ext is 576 bytes

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

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) 18672 (1436)

M DpShMCreate: sizeof(tm_adm) 4232256 (21056)

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 DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0

M DpShMCreate: sizeof(slock_adm) 0 (96)

M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

M DpShMCreate: sizeof(file_adm) 0 (72)

M DpShMCreate: sizeof(vmc_adm) 0 (1536)

M DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: SHM_DP_ADM_KEY (addr: 06000040, size: 4892312)

M DpShMCreate: allocated sys_adm at 06000040

M DpShMCreate: allocated wp_adm at 06002090

M DpShMCreate: allocated tm_adm_list at 06006980

M DpShMCreate: allocated tm_adm at 060069B0

M DpShMCreate: allocated wp_ca_adm at 0640FDF0

M DpShMCreate: allocated appc_ca_adm at 06415BB0

M DpShMCreate: allocated comm_adm at 06417AF0

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 064989B0

M DpShMCreate: allocated gw_adm at 064989F0

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 06498A20

M DpShMCreate: allocated wall_adm at 06498A28

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 0 initializing ....

X Using implementation view

X <EsNT> Using memory model view.

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M

M Wed Nov 25 14:47:20 2009

M ThInit: running on host sapdev

M

M Wed Nov 25 14:47:21 2009

M calling db_connect ...

C Prepending F:\usr\sap\IED\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 /@IED on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 094B6E58 094BC3F4 094BBC7C

C Attaching to DB Server IED (con_hdl=0,svchp=094BBBC8,srvhp=094CB954)

C

C Wed Nov 25 14:47:31 2009

C Starting user session (con_hdl=0,svchp=094BBBC8,srvhp=094CB954,usrhp=09516CA8)

C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017

[dboci.c 4532]

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

[dbsloci.c 11042]

C Try to connect with default password

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

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 094B6E58 094BC3F4 094BBC7C

C Starting user session (con_hdl=0,svchp=094BBBC8,srvhp=094CB954,usrhp=09516CA8)

C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=28000

[dboci.c 4532]

C Detaching from DB Server (con_hdl=0,svchp=094BBBC8,srvhp=094CB954)

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

[dbsloci.c 11042]

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

M in_ThErrHandle: 1

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

M

M Info for wp 0

M

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 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 req.vm = no VM

M attachedVm = no VM

M

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

M *

M * LOCATION SAP-Server sapdev_IED_00 on host sapdev (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Wed Nov 25 14:47:31 2009

M * RELEASE 700

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10486

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

[JPReyes]

ORA-28000: the account is locked 

Read,

Note 951167 - ORA-28000: the account is locked

Regards

Juan

[Former Member]

Hi

i checked that note , i am enable to unlock the user, which user to unlock

[Former Member]

I have checked note and unlocked SYS and SYSTEM user of oracle, still the problem is not solved

[former_member184548]

Hello

Can you check your SAP<SID> account status. This may be locked. If you unlock it it will resolve the problem. You should do any changes to this user's password by using brtools.

Thanks

Atul

[former_member190272]

Hi ,

Please check ur service user password and try to start server vai sid adm user.

Regards,

Pankaj

[JPReyes]

Connecting as SAPSR3

Thats the user you need to unlock... you're not reading before posting

Regards

Juan

[Former Member]

still the problem not resolved

[JPReyes]

do and R3trans and post the trans.log after SAPSR3 has been unlocked... I presume this can be a problem with the OPS$ user

Regards

Juan

[Former Member]

Please refer note 50088.

[Former Member]

r3trans returns 0000, i checked in developers trace there is error in W0 to W12, i have found sql error '1017'

[Former Member]

Dear All My problem is resolved, i referred sap note 400241

[Former Member]

Hi,

It indicates SAP Instance is getting shutdown when tried for start-up.

Following could help to resolve the start-up issue.

1) If SAP instance was up and running fine earlier (you have not done any changes in any of the parameters), try to stop the instance, restart SAP service, and then try to start SAP instance using MMC.

2) Check if DB connectivity is thru using R3trans -d (it should return 0000) from command prompt (with <sid>adm user). If not, start DB first and then try to start SAP instance.

3) If you hvae performed any kind of profile parameters and you are trying to restart SAP instance as part of it, revert the same and perform activity as mentioned in step-1, to start SAP instance.

4) Refer trace files in ../work directory to find where the exact issue is.

If I am missing any other option, let us know what makes the instance stopped, and we could nerrow down the SAP instance startup issue.

Regards,

Pramod

[Former Member]

R3trans -d returns 0012