cancel
Showing results for 
Search instead for 
Did you mean: 

work process ended

Former Member
0 Kudos

dear sap guis

when i start the sapserver all abap workprocess will be ended.

plz suggest how to solve this problem

the following matter is developer trace ...

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

-


*

  • ACTIVE TRACE LEVEL 1

  • ACTIVE TRACE COMPONENTS all, MJ

*

B

B Tue Apr 01 11:48:32 2008

B create_con (con_name=R/3)

B Loading DB library 'D:\usr\sap\DEV\DVEBMGS03\exe\dboraslib.dll' ...

B Library 'D:\usr\sap\DEV\DVEBMGS03\exe\dboraslib.dll' loaded

B Version of 'D:\usr\sap\DEV\DVEBMGS03\exe\dboraslib.dll' is "700.08", patchlevel (0.107)

B New connection 0 created

M sysno 03

M sid DEV

M systemid 560 (PC with Windows NT)

M relno 7000

M patchlevel 0

M patchno 114

M intno 20050900

M make: multithreaded, Unicode, optimized

M pid 788

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 788) [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) 15800 (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: 06130040, size: 4889440)

M DpShMCreate: allocated sys_adm at 06130040

M DpShMCreate: allocated wp_adm at 06132090

M DpShMCreate: allocated tm_adm_list at 06135E48

M DpShMCreate: allocated tm_adm at 06135E78

M DpShMCreate: allocated wp_ca_adm at 0653F2B8

M DpShMCreate: allocated appc_ca_adm at 06545078

M DpShMCreate: allocated comm_adm at 06546FB8

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 065C7E78

M DpShMCreate: allocated gw_adm at 065C7EB8

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 065C7EE8

M DpShMCreate: allocated wall_adm at 065C7EF0

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 ThInit: running on host sapdev

M

M Tue Apr 01 11:48:33 2008

M calling db_connect ...

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

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 05E650B8 05E6A654 05E69EDC

C Attaching to DB Server DEV (con_hdl=0,svchp=05E69E28,srvhp=05E7BA24)

C

C Tue Apr 01 11:48:34 2008

C Starting user session (con_hdl=0,svchp=05E69E28,srvhp=05E7BA24,usrhp=05EC8958)

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

[dboci.c 4532]

C Detaching from DB Server (con_hdl=0,svchp=05E69E28,srvhp=05E7BA24)

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

[dbsloci.c 11042]

C Try to connect with default password

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

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 05E650B8 05E6A654 05E69EDC

C Attaching to DB Server DEV (con_hdl=0,svchp=05E69E28,srvhp=05E7BA24)

C Starting user session (con_hdl=0,svchp=05E69E28,srvhp=05E7BA24,usrhp=05EC8958)

C

C Tue Apr 01 11:48:35 2008

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

[dboci.c 4532]

C Detaching from DB Server (con_hdl=0,svchp=05E69E28,srvhp=05E7BA24)

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

[dbsloci.c 11042]

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 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_DEV_03 on host sapdev (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Tue Apr 01 11:48:35 2008

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Vivek_Hegde
Active Contributor
0 Kudos

Hello,

Follow these steps;

1)first do cleanipc by using following command,

cleanipc remove <instance number>

2)Shutdown Oracle

SHUTDOWN IMMEDIATE

3) Do ps -eaf|grep oracle*

If you find any oracle processes running then kill thyem.

4) Start Oracle using STARTUP

5)Start Listener (LSNRCTL > start )

4)Start SAP System

Regards

Vivek

Former Member
0 Kudos

Hi,

From the log it seems your database is not started. Try to start the database manually.Then try to start SAP service.

also check the user you are using to start sap service has all administrative write with reaspect to database & sap <sid> groups

rajesh

9822723146

Former Member
0 Kudos

Hi Rajesh,

The database is started, meanwhile when i run the command R3trans -d, i get the error

2EETW169 no connect possible: "DBMS = ORACLE"

dbs_ora_tnsname = 'NGP' "

r3trans finished (0012).

Regards.

Former Member
0 Kudos

Hi

ORACLE listener is running? have you recently done DB upgrade? if so please upgrade your DB client too.

Jansi