SAP work Process goes in run state,Users cannot login developer trace paste

[prasad_shetty2]

Hi team,

We have a system which is at ECC6 release 701 ABAP + java system.

The work process frequently go in run state and since this is an IDES system, I always restart the system.

Please help me since i want tio know the root cause for the same.

The dev trace is as follows, and i beleive its a listener problem by the logs.

kernel runs with dp version 244000(ext=110000) (@(#) DPLIB-INT-VERSION-244000-UC)

length of sys_adm_ext is 576 bytes

• SWITCH TRC-HIDE on ***

***LOG Q00=> DpSapEnvInit, DPStart (00 199004) [dpxxdisp.c 1287]

shared lib "dw_xml.dll" version 254 successfully loaded

shared lib "dw_xtc.dll" version 254 successfully loaded

shared lib "dw_stl.dll" version 254 successfully loaded

shared lib "dw_gui.dll" version 254 successfully loaded

shared lib "dw_mdm.dll" version 254 successfully loaded

rdisp/softcancel_sequence : -> 0,5,-1

use internal message server connection to port 3900

Mon Dec 13 08:26:23 2010

• WARNING => DpNetCheck: NiHostToAddr(www.doesnotexist0223.qqq.nxst) took 6 seconds

<EsNT> Using memory model view.

<EsNT> Memory Reset disabled as NT default

<ES> 127 blocks reserved for free list.

ES initialized.

mm.dump: set maximum dump mem to 96 MB

Mon Dec 13 08:26:29 2010

J2EE server info

start = TRUE

state = STARTED

pid = 200040

argv[0] = D:\usr\sap\BI7\DVEBMGS00\exe\jcontrol.EXE

argv[1] = D:\usr\sap\BI7\DVEBMGS00\exe\jcontrol.EXE

argv[2] = pf=D:\usr\sap\BI7\SYS\profile\BI7_DVEBMGS00_q4de3gsy203

argv[3] = -DSAPSTART=1

argv[4] = -DCONNECT_PORT=65000

argv[5] = -DSAPSYSTEM=00

argv[6] = -DSAPSYSTEMNAME=BI7

argv[7] = -DSAPMYNAME=q4de3gsy203_BI7_00

argv[8] = -DSAPPROFILE=D:\usr\sap\BI7\SYS\profile\BI7_DVEBMGS00_q4de3gsy203

argv[9] = -DFRFC_FALLBACK=ON

argv[10] = -DFRFC_FALLBACK_HOST=localhost

start_lazy = 0

start_control = SAP J2EE startup framework

DpJ2eeStart: j2ee state = STARTED

rdisp/http_min_wait_dia_wp : 1 -> 1

***LOG CPS=> DpLoopInit, ICU ( 3.0 3.0 4.0.1) [dpxxdisp.c 1694]

***LOG Q0K=> DpMsAttach, mscon ( q4de3gsy203) [dpxxdisp.c 12697]

DpStartStopMsg: send start message (myname is >q4de3gsy203_BI7_00 <)

DpStartStopMsg: start msg sent

CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

CCMS: start to initalize 3.X shared alert area (first segment).

DpMsgAdmin: Set release to 7000, patchlevel 0

MBUF state PREPARED

MBUF component UP

DpMBufHwIdSet: set Hardware-ID

***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c 1050]

DpMsgAdmin: Set patchno for this platform to 254

Release check o.K.

DpJ2eeLogin: j2ee state = CONNECTED

Mon Dec 13 08:27:09 2010

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

my types changed after wp death/restart 0xbd --> 0xb5

my types changed after wp death/restart 0xb5 --> 0x95

Mon Dec 13 08:27:29 2010

• ERROR => DpWPCheck: W1 (pid 199044) died (severity=0, status=0) [dpxxdisp.c 15841]

• ERROR => DpWPCheck: W4 (pid 199912) died (severity=0, status=0) [dpxxdisp.c 15841]

• ERROR => DpWPCheck: W6 (pid 192420) died (severity=0, status=0) [dpxxdisp.c 15841]

• ERROR => DpWPCheck: W8 (pid 199528) died (severity=0, status=0) [dpxxdisp.c 15841]

• ERROR => DpWPCheck: W9 (pid 198860) died (severity=0, status=0) [dpxxdisp.c 15841]

• ERROR => DpWPCheck: W10 (pid 199664) died (severity=0, status=0) [dpxxdisp.c 15841]

my types changed after wp death/restart 0x95 --> 0x85

• ERROR => DpWPCheck: W12 (pid 200036) died (severity=0, status=0) [dpxxdisp.c 15841]

Mon Dec 13 08:27:43 2010

***LOG Q0I=> NiIRead: recv (10054: WSAECONNRESET: Connection reset by peer) [nixxi.cpp 4424]

• ERROR => NiIRead: SiRecv failed for hdl 6 / sock 316

(SI_ECONN_BROKEN/10054; I4; ST; 127.0.0.1:4882) [nixxi.cpp 4424]

• ERROR => DpJ2eeMsgProcess: NiRead failed (NIECONN_BROKEN) [dpxxj2ee.c 1212]

DpJ2eeMsgProcess: j2ee state = CONNECTED (NIECONN_BROKEN)

Mon Dec 13 08:27:49 2010

• ERROR => DpWPCheck: W0 (pid 200632) died (severity=0, status=0) [dpxxdisp.c 15841]

• ERROR => DpWPCheck: W1 (pid 199044) died (severity=0, status=0) [dpxxdisp.c 15841]

my types changed after wp death/restart 0x85 --> 0x84

• ERROR => DpWPCheck: W3 (pid 93796) died (severity=0, status=0) [dpxxdisp.c 15841]

• ERROR => DpWPCheck: W4 (pid 199912) died (severity=0, status=0) [dpxxdisp.c 15841]

• ERROR => DpWPCheck: W5 (pid 200484) died (severity=0, status=0) [dpxxdisp.c 15841]

• ERROR => DpWPCheck: W6 (pid 192420) died (severity=0, status=0) [dpxxdisp.c 15841]

my types changed after wp death/restart 0x84 --> 0x80

• ERROR => DpWPCheck: W8 (pid 199528) died (severity=0, status=0) [dpxxdisp.c 15841]

• ERROR => DpWPCheck: W9 (pid 198860) died (severity=0, status=0) [dpxxdisp.c 15841]

• ERROR => DpWPCheck: W10 (pid 199664) died (severity=0, status=0) [dpxxdisp.c 15841]

• ERROR => DpWPCheck: W11 (pid 199720) died (severity=0, status=0) [dpxxdisp.c 15841]

• ERROR => DpWPCheck: W12 (pid 200036) died (severity=0, status=0) [dpxxdisp.c 15841]

• DP_FATAL_ERROR => DpWPCheck: no more work processes

• DISPATCHER EMERGENCY SHUTDOWN ***

increase tracelevel of WPs

NiWait: sleep (10000ms) ...

NiISelect: timeout 10000ms

NiISelect: maximum fd=493

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Dec 13 08:27:59 2010

NiISelect: TIMEOUT occured (10000ms)

dump system status

Workprocess Table (long) Mon Dec 13 07:27:59 2010

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

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

-

---

0 DIA 200632 Ended no 2 0 0

1 DIA 199044 Ended no 3 0 0

2 DIA 200280 Ended no 1 0 0

3 DIA 93796 Ended no 2 0 0

4 DIA 199912 Ended no 3 0 0

5 DIA 200484 Ended no 2 0 0

6 UPD 192420 Ended no 3 0 0

7 ENQ 199792 Ended no 1 0 0

8 BTC 199528 Ended no 3 0 0

9 BTC 198860 Ended no 3 0 0

10 BTC 199664 Ended no 3 0 0

11 SPO 199720 Ended no 2 0 0

12 UP2 200036 Ended no 3 0 0

Dispatcher Queue Statistics Mon Dec 13 07:27:59 2010

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 (184860) (SOFT_KILL)

Stop icman

killing process (190124) (SOFT_KILL)

Terminate gui connections

wait for end of work processes

wait for end of gateway

[DpProcDied] Process lives (PID:184860 HANDLE:440)

waiting for termination of gateway ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=493

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Dec 13 08:28:05 2010

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process died (PID:184860 HANDLE:440)

wait for end of icman

[DpProcDied] Process lives (PID:190124 HANDLE:448)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=493

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Dec 13 08:28:06 2010

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives (PID:190124 HANDLE:448)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=493

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Dec 13 08:28:07 2010

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives (PID:190124 HANDLE:448)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=493

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Dec 13 08:28:08 2010

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives (PID:190124 HANDLE:448)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=493

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Dec 13 08:28:09 2010

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process died (PID:190124 HANDLE:448)

[DpProcDied] Process died (PID:200040 HANDLE:424)

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

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 3 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 3 received data (rcd=274,pac=1,MESG_IO)

server

NiIRead: hdl 3 recv would block (errno=EAGAIN)

NiIRead: read for hdl 3 timed out (0ms)

DpHalt: no more messages from the message server

DpHalt: send keepalive to synchronize with the message server

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 3 recv would block (errno=EAGAIN)

Mon Dec 13 08:28:10 2010

NiIPeek: peek for hdl 3 timed out (r; 1000ms)

NiIRead: read for hdl 3 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 13043]

NiBufSend starting

NiIWrite: hdl 3 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 3 in set0

SiSelNSet: set events of sock 368 to: ---

NiBufISelRemove: remove hdl 3 from set0

SiSelNRemove: removed sock 368 (pos=3)

SiSelNRemove: removed sock 368

NiSelIRemove: removed hdl 3

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

DpSemRq: key: 2, units: 1, timeout: -1

DpSemRel: key: 2, units: 1

DpRqPutIntoQueue: put request into queue (reqtype 1, prio LOW, rq_id 15)

MBUF component DOWN

NiICloseHandle: shutdown and close hdl 3 / sock 368

NiBufIClose: clear extension for hdl 3

MsIDetach: detach MS-system

cleanup EM

EsCleanup ....

EmCleanup() -> 0

Es2Cleanup: Cleanup ES2

***LOG Q05=> DpHalt, DPStop ( 199004) [dpxxdisp.c 11230]

Good Bye .....

Please revert if you need more information.

Regards,

Prasad Shetty

[prasad_shetty2]

Hi Guys,

The brtools was updated with dbatools 50 and it solved my problem .

bottom line Brtools had the issue.

Thanks all for the help which is appreciated by me.

Regards,

Prasad Shetty

[Former Member]

does not look like brtool issue, as brtool not require to run SAP and these are database relate and you have issue with SAP application.

[prasad_shetty2]

Hi,

I updated the kernel, but still today after backup the system got hung,

I have seen the dev trace where this is more prominenet please see 0ra 01034 and 27101

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

C Connecting as /@BI7 on connection 0 (nls_hdl 0) ... (dbsl 700 140910)

C Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch

C 0 UTF8 0000000014100910 0000000014108B40 0000000014125368

C Attaching to DB Server BI7 (con_hdl=0,svchp=0000000014109818,srvhp=0000000014127658)

C Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=0000000014109818, srvhp=0000000014127658, usrhp=0000000014124D68)

C OCISessionBegin(OCI_DEFAULT) failed with SQL error 1034:

C ORA-01034: ORACLE not available

C ORA-27101: shared memory realm does not exist

C Detaching from DB Server (con_hdl=0,svchp=0000000014109818,srvhp=0000000014127658)

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

[dbsloci.c 11437]

C SAPUSER or connect error 99=DBSL_ERR_DB, oerr=1034.

C

C Mon Dec 20 22:32:25 2010

C application info callback registered

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

C Connecting as /@BI7 on connection 0 (nls_hdl 0) ... (dbsl 700 140910)

C Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch

C 0 UTF8 0000000014100910 0000000014108B40 0000000014125368

C Attaching to DB Server BI7 (con_hdl=0,svchp=0000000014109818,srvhp=0000000014127658)

C Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=0000000014109818, srvhp=0000000014127658, usrhp=0000000014124D68)

C OCISessionBegin(OCI_DEFAULT) failed with SQL error 1034:

C ORA-01034: ORACLE not available

C ORA-27101: shared memory realm does not exist

C Detaching from DB Server (con_hdl=0,svchp=0000000014109818,srvhp=0000000014127658)

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

[dbsloci.c 11437]

C SAPUSER or connect error 99=DBSL_ERR_DB, oerr=1034.

B reconnect failed for connection 0

M *** ERROR => ThHdlReconnect: db_reconnect failed (2048) [thxxhead.c 17333]

B

B Mon Dec 20 22:34:04 2010

B db_con_reconnect: reconnecting to connection 0:

B 000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

B reco = YES, frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

B opening connection 0 ...

C application info callback registered

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

C Connecting as /@BI7 on connection 0 (nls_hdl 0) ... (dbsl 700 140910)

C Nls CharacterSet NationalCharSet EnvHp

Please give em the path forward on this.

Regards,

Prasad Shetty

[ImtiazKaredia]

Your Last post shows that oracle is not available.

Can you check if oracle is running. What is output of R3trans.

What is your archive log backup schedule?

[Former Member]

Hi

The problem now differs from the one you had initially started off with. When you upgraded the Kernel, did you shutdown the database or not?

Now the SAP is not connecting to oracle. Shutdown SAP and try to start the oracle by sql command. if database comes up online, then make a r3trans -d and check for return code. Let me know the result.

Thanks

Javed Alam

[prasad_shetty2]

Hi,

I have done the upgrade properly.

After backup the system gets hang and than the dev trace shows the above logs .

Once i restart the whole system R3 trans-d is rc=0.

Regards,

Prasad Shetty

[Former Member]

Check Note 491174 - Composite SAP note for ORA-01034

[JPReyes]

You can check DPmon to see the status of the processes.. If they are all running under SAPSYS, then is most likely an issue with the kernel,

Note 1153975 - All work processes are used by the user SAPSYS

Regards

Juan

[JPReyes]

Can you post the errors in dev_w0?...

Regards

Juan

[prasad_shetty2]

HI Juan,

trace file for dev_w0 as asked

C Starting user session: OCISessionBegin(con_hdl=0, usr=SAPSR3/<pwd>, svchp=0000000013FB7748, srvhp=0000000013FB9B78, usrhp=0000000013EA1EC8)

C Now 'SAPSR3/<pwd>@BI7' is connected: con_hdl=0, nls_hdl=0, session_id=65.

C Database NLS settings: AMERICAN_AMERICA.UTF8

C DB instance BI7 is running on Q4DE3GSY203 with ORACLE version 10.2.0.2.0 since DEC 13, 2010, 08:38:55

B Connection 0 opened (DBSL handle 0)

B Wp Hdl ConName ConId ConState TX HC PRM RCT FRC TIM MAX OPT Date Time DBHost

B 000 000 R/3 000000000 ACTIVE NO NO YES NO NO 000 255 255 20101213 083926 Q4DE3GSY203

C build_stmt: reallocating stmt buffer: 256 -> 2000 characters

M db_connect o.k.

M ICT: exclude compression: .zip,.cs,.rar,.arj,.z,.gz,.tar,.lzh,.cab,.hqx,.ace,.jar,.ear,.war,.css,.pdf,.js,.gzip,.uue,.bz2,.iso,.sda,.sar,.gif,*.png

I

I Mon Dec 13 08:40:14 2010

I MtxInit: 0 0 0

M SHM_PRES_BUF (addr: 0000000015860050, size: 4400000)

M SHM_ROLL_AREA (addr: 000007FFEA010050, size: 61440000)

M SHM_PAGING_AREA (addr: 0000000015CA0050, size: 32768000)

M SHM_ROLL_ADM (addr: 0000000017BF0050, size: 633840)

M SHM_PAGING_ADM (addr: 0000000017C90050, size: 525344)

M ThCreateNoBuffer allocated 544152 bytes for 1000 entries at 0000000017D20050

M ThCreateNoBuffer index size: 3000 elems

M ThCreateVBAdm allocated 12176 bytes (50 server) at 000000000B490050

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 0 initializing ....

X Using implementation view

X ES initialized.

X mm.dump: set maximum dump mem to 96 MB

M Deactivate statistics hyper index locking

B dbntab: NTAB buffers attached

B dbntab: Buffer FTAB(hash header) (addr: 0000000017E400E0, size: 584)

B dbntab: Buffer FTAB(anchor array) (addr: 0000000017E40330, size: 320072)

B dbntab: Buffer FTAB(item array) (addr: 0000000017E8E580, size: 1280000)

B dbntab: Buffer FTAB(data area) (addr: 0000000017FC6D80, size: 30720000)

B dbntab: Buffer IREC(hash header) (addr: 0000000019D200E0, size: 584)

B dbntab: Buffer IREC(anchor array) (addr: 0000000019D20330, size: 320072)

B dbntab: Buffer IREC(item array) (addr: 0000000019D6E580, size: 320000)

B dbntab: Buffer IREC(data area) (addr: 0000000019DBC780, size: 6144000)

B dbntab: Buffer STAB(hash header) (addr: 000000001A3A00E0, size: 584)

B dbntab: Buffer STAB(anchor array) (addr: 000000001A3A0330, size: 320072)

B dbntab: Buffer STAB(item array) (addr: 000000001A3EE580, size: 320000)

B dbntab: Buffer STAB(data area) (addr: 000000001A43C780, size: 3072000)

B dbntab: Buffer TTAB(hash header) (addr: 000000001A7300E0, size: 1944)

B dbntab: Buffer TTAB(anchor array) (addr: 000000001A730880, size: 320072)

B dbntab: Buffer TTAB(item array) (addr: 000000001A77EAD0, size: 800000)

B dbntab: Buffer TTAB(data area) (addr: 000000001A841FD0, size: 5840000)

B db_con_shm_ini: WP_ID = 0, WP_CNT = 13, CON_ID = -1

B dbstat: TABSTAT buffer attached (addr: 000000001ADE9FB0)

B dbtbxbuf: Buffer TABL (addr: 000000001D7D0160, size: 30000000, end: 000000001F46C4E0)

B dbtbxbuf: Buffer TABLP (addr: 000000001F470160, size: 10240000, end: 000000001FE34160)

B dbexpbuf: Buffer EIBUF (addr: 000000001FE40170, size: 4194304, end: 0000000020240170)

B dbexpbuf: Buffer ESM (addr: 0000000020250170, size: 4194304, end: 0000000020650170)

B dbexpbuf: Buffer CUA (addr: 0000000020660170, size: 3072000, end: 000000002094E170)

B dbexpbuf: Buffer OTR (addr: 0000000020950170, size: 4194304, end: 0000000020D50170)

B dbcalbuf: Buffer CALE (addr: 0000000020D60050, size: 500000, end: 0000000020DDA170)

M CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

S *** init spool environment

S TSPEVJOB updates inside critical section: event_update_nocsec = 0

S initialize debug system

T Stack direction is downwards.

T debug control: prepare exclude for printer trace

T new memory block 00000000141756E0

S spool kernel/ddic check: Ok

S using table TSP02FX for frontend printing

S 1 spool work process(es) found

S frontend print via spool service enabled

S printer list size is 150

S printer type list size is 50

S queue size (profile) = 300

S hostspool list size = 3000

S option list size is 30

S intervals: query=50, rescan=1800, global=300 info=120

S processing queue enabled

S creating spool memory service RSPO-RCLOCKS at 000000002A0700D0

S doing lock recovery

S setting server cache root

S using server cache size 100 (prof=100)

S creating spool memory service RSPO-SERVERCACHE at 000000002A0704F0

S using messages for server info

B dbtran INFO (init_connection '<DEFAULT>' [ORACLE:700.08]):

B max_blocking_factor = 5, max_in_blocking_factor = 5,

B min_blocking_factor = 5, min_in_blocking_factor = 5,

B prefer_union_all = 0, prefer_join = 0,

B prefer_fix_blocking = 0, prefer_in_itab_opt = 1,

B convert AVG = 0, alias table FUPD = 0,

B escape_as_literal = 1, opt GE LE to BETWEEN = 0,

B select * =0x0f, character encoding = STD / <none>:-,

B use_hints = abap->1, dbif->0x1, upto->2147483647, rule_in->0,

B rule_fae->0, concat_fae->0, concat_fae_or->0

S

S Mon Dec 13 08:40:15 2010

S size of spec char cache entry: 297032 bytes (timeout 100 sec)

S size of open spool request entry: 2512 bytes

S immediate print option for implicitely closed spool requests is disabled

A **GENER Trace switched on ***

A

A -PXA--

---

A PXA INITIALIZATION

A PXA: Locked PXA-Semaphore.

A System page size: 4kb, total admin_size: 20564kb, dir_size: 20472kb.

A Attached to PXA (address 000007FFEDAB0050, size 300000K)

A abap/pxa = shared protect gen_remote

A PXA INITIALIZATION FINISHED

A -PXA--

---

A

A ABAP ShmAdm attached (addr=000007FF4FEEA000 leng=20955136 end=000007FF512E6000)

A >> Shm MMADM area (addr=000007FF50392E80 leng=247168 end=000007FF503CF400)

A >> Shm MMDAT area (addr=000007FF503D0000 leng=15818752 end=000007FF512E6000)

A RFC Destination> destination q4de3gsy203_BI7_00 host q4de3gsy203 system BI7 systnr 0 (q4de3gsy203_BI7_00)

A RFC Options> H=q4de3gsy203,S=00,d=2,

A RFC FRFC> fallback activ but this is not a central instance.

A

A RFC rfc/signon_error_log = -1

A RFC rfc/dump_connection_info = 0

A RFC rfc/dump_client_info = 0

A RFC rfc/cp_convert/ignore_error = 1

A RFC rfc/cp_convert/conversion_char = 23

A RFC rfc/wan_compress/threshold = 251

A RFC rfc/recorder_pcs not set, use defaule value: 2

A RFC rfc/delta_trc_level not set, use default value: 0

A RFC rfc/no_uuid_check not set, use default value: 0

A RFC rfc/bc_ignore_thcmaccp_retcode not set, use default value: 0

A RFC Method> initialize RemObjDriver for ABAP Objects

M ThrCreateShObjects allocated 27042 bytes at 000000002A9E0050

N

N Mon Dec 13 08:40:16 2010

N SsfSapSecin: putenv(SECUDIR=D:\usr\sap\BI7\DVEBMGS00\sec): ok

N

N =================================================

N === SSF INITIALIZATION:

N ===...SSF Security Toolkit name SAPSECULIB .

N ===...SSF trace level is 0 .

N ===...SSF library is D:\usr\sap\BI7\DVEBMGS00\exe\sapsecu.dll .

N ===...SSF hash algorithm is SHA1 .

N ===...SSF symmetric encryption algorithm is DES-CBC .

N ===...sucessfully completed.

N =================================================

N

N Mon Dec 13 08:40:17 2010

N MskiInitLogonTicketCacheHandle: Logon Ticket cache pointer retrieved from shared memory.

N MskiInitLogonTicketCacheHandle: Workprocess runs with Logon Ticket cache.

M JrfcVmcRegisterNativesDriver o.k.

W =================================================

W === ipl_Init() called

W ITS Plugin: Path dw_gui

W ITS Plugin: Description ITS Plugin - ITS rendering DLL

W ITS Plugin: sizeof(SAP_UC) 2

W ITS Plugin: Release: 700, [7000.0.254.20050900]

W ITS Plugin: Int.version, [33]

W ITS Plugin: Feature set: [22]

W ===... Calling itsp_Init in external dll ===>

W === ipl_Init() returns 0, ITSPE_OK: OK

W =================================================

N VSI: WP init in ABAP VM completed with rc=0

E Profile-Parameter: enque/deque_wait_answer = FALSE

E Profile-Parameter: enque/sync_dequeall = 0

E Replication is disabled

E EnqCcInitialize: local lock table initialization o.k.

E EnqId_SuppressIpc: local EnqId initialization o.k.

E EnqCcInitialize: local enqueue client init o.k.

S

S Mon Dec 13 08:40:19 2010

S found spool memory service RSPO-ACTIONS at 000000002A07A230

A

A Mon Dec 13 08:40:20 2010

A **GENER Trace switched off ***

M SosICreateNewAnchorArray: sos_search_anchor_semantics = 1

C

C Mon Dec 13 08:40:21 2010

C build_stmt: reallocating stmt buffer: 2000 -> 3002 characters

B table logging switched on for client '800'

M

M Mon Dec 13 08:40:23 2010

M SecAudit(RsauShmInit): WP attached to existing shared memory.

M SecAudit(RsauShmInit): addr of SCSA........... = 000000000AFC0050

M SecAudit(RsauShmInit): addr of RSAUSHM........ = 000000000AFC07C0

M SecAudit(RsauShmInit): addr of RSAUSLOTINFO... = 000000000AFC0800

M SecAudit(RsauShmInit): addr of RSAUSLOTS...... = 000000000AFC080C

M rdisp/rb_cleaned_rfc = 0

M

M Mon Dec 13 08:40:27 2010

M Deactivate ASTAT hyper index locking

M

M Mon Dec 13 08:44:30 2010

M

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

M *

M * LOCATION SAP-Gateway on host q4de3gsy203 / sapgw00

M * ERROR program dbmrfc@sapdb not registered

M *

M * TIME Mon Dec 13 08:44:30 2010

M * RELEASE 700

M * COMPONENT SAP-Gateway

M * VERSION 2

M * RC 679

M * MODULE gwr3cpic.c

M * LINE 1835

M * DETAIL TP dbmrfc@sapdb not registered

M * COUNTER 15

M *

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

M

A RFC 1485 CONVID 21905907

A * CMRC=2 DATA=0 STATUS=0 SAPRC=679 ThSAPOCMINIT

A RFC> ABAP Programm: SAPLSADC (Transaction: )

A RFC> User: RANGUPTA (Client: 001)

A RFC> Destination: SAPDB_DBM_DAEMON (handle: 2, , )

A RFC SERVER> RFC Server Session (handle: 1, 21904860, {D18C06E0-7859-F141-92A8-005056956B4B})

A RFC SERVER> Caller host:

A RFC SERVER> Caller transaction code: (Caller Program: SAPLSADC)

A RFC SERVER> Called function module: DBM_CONNECT_PUR

A TH VERBOSE LEVEL FULL

A ** RABAX: end RX_GET_MESSAGE

M

M Mon Dec 13 08:45:54 2010

M

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

M *

M * LOCATION SAP-Gateway on host q4de3gsy203 / sapgw00

M * ERROR program dbmrfc@sapdb not registered

M *

M * TIME Mon Dec 13 08:45:54 2010

M * RELEASE 700

M * COMPONENT SAP-Gateway

M * VERSION 2

M * RC 679

M * MODULE gwr3cpic.c

M * LINE 1835

M * DETAIL TP dbmrfc@sapdb not registered

M * COUNTER 30

M *

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

M

A RFC 1485 CONVID 21998657

A * CMRC=2 DATA=0 STATUS=0 SAPRC=679 ThSAPOCMINIT

A RFC> ABAP Programm: SAPLSADC (Transaction: )

A RFC> User: RANGUPTA (Client: 001)

A RFC> Destination: SAPDB_DBM_DAEMON (handle: 2, , )

A RFC SERVER> RFC Server Session (handle: 1, 21997642, {038D06E0-8E49-F147-92A8-005056956B4B})

A RFC SERVER> Caller host:

A RFC SERVER> Caller transaction code: (Caller Program: SAPLSADC)

A RFC SERVER> Called function module: DBM_CONNECT_PUR

A TH VERBOSE LEVEL FULL

A ** RABAX: end RX_GET_MESSAGE

M

M Mon Dec 13 08:48:12 2010

M

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

M *

M * LOCATION SAP-Gateway on host q4de3gsy203 / sapgw00

M * ERROR program dbmrfc@sapdb not registered

M *

M * TIME Mon Dec 13 08:48:12 2010

M * RELEASE 700

M * COMPONENT SAP-Gateway

M * VERSION 2

M * RC 679

M * MODULE gwr3cpic.c

M * LINE 1835

M * DETAIL TP dbmrfc@sapdb not registered

M * COUNTER 45

M *

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

M

A RFC 1485 CONVID 22146986

A * CMRC=2 DATA=0 STATUS=0 SAPRC=679 ThSAPOCMINIT

A RFC> ABAP Programm: SAPLSADC (Transaction: )

A RFC> User: RANGUPTA (Client: 001)

A RFC> Destination: SAPDB_DBM_DAEMON (handle: 2, , )

A RFC SERVER> RFC Server Session (handle: 1, 22145986, {558D06E0-45BF-F199-92A8-005056956B4B})

A RFC SERVER> Caller host:

A RFC SERVER> Caller transaction code: (Caller Program: SAPLSADC)

A RFC SERVER> Called function module: DBM_CONNECT_PUR

A TH VERBOSE LEVEL FULL

A ** RABAX: end RX_GET_MESSAGE

M

M Mon Dec 13 08:49:33 2010

M

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

M *

M * LOCATION SAP-Gateway on host q4de3gsy203 / sapgw00

M * ERROR program dbmrfc@sapdb not registered

M *

M * TIME Mon Dec 13 08:49:33 2010

M * RELEASE 700

M * COMPONENT SAP-Gateway

M * VERSION 2

M * RC 679

M * MODULE gwr3cpic.c

M * LINE 1835

M * DETAIL TP dbmrfc@sapdb not registered

M * COUNTER 60

M *

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

It is a bit large will this do ?

Regards,

Prasad

[former_member227283]

Hi Prasad,

Upgrade the kernel, it will resolve your problem.

Thanks

Anil

[prasad_shetty2]

Hi,

No other resolution for this.

I have put up a mail asking their permission to do the same

I will post once i get approval and complete it.

I think if i do operation modes and increase Batch process or dialog ?? will this work.

Regards,

Prasad Shetty

[Former Member]

>>The work process frequently go in run state

Have you checked whats running in SM50 for the WPs those status is running?

[prasad_shetty2]

Hi,

The Dialog work process go in run state.

Regards,

Prasad Shetty

[Former Member]

Thats ok but what you see under other colums? ie user, action, table?

[prasad_shetty2]

Hi ,

Can you a bit more specific ? I can chk all this monday.

Regards,

Prasad Shetty

[prasad_shetty2]

Hi Anil,

I have upgraded the kernel today since my system got hanged again after backup.

Lets see what the result is ?,but my Kernel was the latest one n-2.

Hope this work i saw all my diaolog and spool one in run state .

How can we see users table etc when all diaolog process in run state we cannot login na .

Regards,

Prasad Shetty