Dialog Process held by SAPSYS for days

[Former Member]

Hi Experts,

In my ECC6.0 EHP5 production system, we are getting a strange issue. In SM50, one dialog process is held by SAPSYS for many days.

It shows:

No.     Type     PID     Status     Start     Time     Report          Client      USer

6     DIA     720998     Running     Yes     817000     <AUTO TASKHANDLER PROCESSING>     000      SAPSYS

It is our production system so cannot cancel it .

One other things i notice is my background jobs are released by user SAPSYS but there is no such user in system.

Please provide a solution 

Regards

Deepak

[Former Member · Accepted solution]

Hello Deepak,

One other things i notice is my background jobs are released by user SAPSYS but there is no such user in system.

the SAP note 12000 explains that the internal user SAPSYS is used e.g. by the batch scheduler. SAP note 1567599 explains a situation when a workprocess might hang and shows user SAPSYS.

Check the developer trace dev_w6 and search in OSS for a solution.

Regards,

Mark

[Former Member · Accepted solution]

Hi Mark,

Note 12000 was really helpful . Thanks a lot.

But regarding my original problem, I am still stuck .

Note 1567599 says " This error may occur in all kernel releases with a patch level that is lower than the patch level specified on the 'SP Patch Level' tab page"

But I am not able to understand the "SP Patch Level" , what is it?? can u help??

and I have checked dev_w6 logs ,

*** ERROR => DbSlExeRead: missing private_ptr in descriptor area
[dbsloci.c    3550]
C  {root-id=4FDC3C106B3F00B0E1008000AC1000A5}_{conn-id=00000000000000000000000000000000}_0

B  ***LOG BYK=> current SQL statement exceeds a database limit [dbtran       7606]
B  dbtran ERROR LOG (hdl_dbsl_error): DbSl 'FET'
B   RSLT: {dbsl=2, tran=16384}
B   FHDR: {tab='SECURITY_CONTEXT', fcode=225, mode=2, bpb=0, dbcnt=0, crsr=1,
B          hold=0, keep=0, xfer=0, pkg=0, upto=0, init:b=0,
B          init:p=(nil), init:#=0, wa:p=fffffffffffec78, wa:#=148}
B  dbtran ERROR LOG (hdl_dbsl_error): DbSl 'FET'
B   STMT: {stmt:#=1, bndfld:#=4937, prop=0, distinct=0,
B          fld:#=10, alias:p=(nil), fupd:#=0, tab:#=0, where:#=3,
B          groupby:#=0, having:#=0, order:#=4095, primary=0, hint:#=0}
B   CRSR: {tab='SECURITY_CONTEXT', id=1, hold=0, prop=0x10000, max.in@0=0, fae:blk=1,
B          con:id=0, con:vndr=5, val=2,
B          key:#=2, xfer=0, xin:#=0, row:#=0, upto=0, wa:p=fffffffffffec78}
C  *** ERROR => DbSlExeRead: missing private_ptr in descriptor area
[dbsloci.c    3550]
C  {root-id=4FDC3C106B3F00B0E1008000AC1000A5}_{conn-id=00000000000000000000000000000000}_0

B  ***LOG BYK=> current SQL statement exceeds a database limit [dbtran       7606]
B  dbtran ERROR LOG (hdl_dbsl_error): DbSl 'FET'
B   RSLT: {dbsl=2, tran=16384}
B   FHDR: {tab='SECURITY_CONTEXT', fcode=225, mode=2, bpb=0, dbcnt=0, crsr=1,
B          hold=0, keep=0, xfer=0, pkg=0, upto=0, init:b=0,
B          init:p=(nil), init:#=0, wa:p=fffffffffffec78, wa:#=148}
B  dbtran ERROR LOG (hdl_dbsl_error): DbSl 'FET'
B   STMT: {stmt:#=1, bndfld:#=4937, prop=0, distinct=0,
B          fld:#=10, alias:p=(nil), fupd:#=0, tab:#=0, where:#=3,
B          groupby:#=0, having:#=0, order:#=4095, primary=0, hint:#=0}
B   CRSR: {tab='SECURITY_CONTEXT', id=1, hold=0, prop=0x10000, max.in@0=0, fae:blk=1,
B          con:id=0, con:vndr=5, val=2,
B          key:#=2, xfer=0, xin:#=0, row:#=0, upto=0, wa:p=fffffffffffec78}
C  *** ERROR => DbSlExeRead: missing private_ptr in descriptor area
[dbsloci.c    3550]
C  {root-id=4FDC3C106B3F00B0E1008000AC1000A5}_{conn-id=00000000000000000000000000000000}_0

B  ***LOG BYK=> current SQL statement exceeds a database limit [dbtran       7606]
B  dbtran ERROR LOG (hdl_dbsl_error): DbSl 'FET'
B   RSLT: {dbsl=2, tran=16384}
B   FHDR: {tab='SECURITY_CONTEXT', fcode=225, mode=2, bpb=0, dbcnt=0, crsr=1,
B          hold=0, keep=0, xfer=0, pkg=0, upto=0, init:b=0,
B          init:p=(nil), init:#=0, wa:p=fffffffffffec78, wa:#=148}
B  dbtran ERROR LOG (hdl_dbsl_error): DbSl 'FET'
B   STMT: {stmt:#=1, bndfld:#=4937, prop=0, distinct=0,
B          fld:#=10, alias:p=(nil), fupd:#=0, tab:#=0, where:#=3,
B          groupby:#=0, having:#=0, order:#=4095, primary=0, hint:#=0}
B   CRSR: {tab='SECURITY_CONTEXT', id=1, hold=0, prop=0x10000, max.in@0=0, fae:blk=1,
B          con:id=0, con:vndr=5, val=2,
B          key:#=2, xfer=0, xin:#=0, row:#=0, upto=0, wa:p=fffffffffffec78}
C  *** ERROR => DbSlExeRead: missing private_ptr in descriptor area
[dbsloci.c    3550]
C  {root-id=4FDC3C106B3F00B0E1008000AC1000A5}_{conn-id=00000000000000000000000000000000}_0

B  ***LOG BYK=> current SQL statement exceeds a database limit [dbtran       7606]
B  dbtran ERROR LOG (hdl_dbsl_error): DbSl 'FET'
B   RSLT: {dbsl=2, tran=16384}
B   FHDR: {tab='SECURITY_CONTEXT', fcode=225, mode=2, bpb=0, dbcnt=0, crsr=1,
B          hold=0, keep=0, xfer=0, pkg=0, upto=0, init:b=0,
B          init:p=(nil), init:#=0, wa:p=fffffffffffec78, wa:#=148}
B  dbtran ERROR LOG (hdl_dbsl_error): DbSl 'FET'
B   STMT: {stmt:#=1, bndfld:#=4937, prop=0, distinct=0,
B          fld:#=10, alias:p=(nil), fupd:#=0, tab:#=0, where:#=3,
B          groupby:#=0, having:#=0, order:#=4095, primary=0, hint:#=0}
B   CRSR: {tab='SECURITY_CONTEXT', id=1, hold=0, prop=0x10000, max.in@0=0, fae:blk=1,
B          con:id=0, con:vndr=5, val=2,
B          key:#=2, xfer=0, xin:#=0, row:#=0, upto=0, wa:p=fffffffffffec78}
C  *** ERROR => DbSlExeRead: missing private_ptr in descriptor area
[dbsloci.c    3550]
C  {root-id=4FDC3C106B3F00B0E1008000AC1000A5}_{conn-id=00000000000000000000000000000000}_0

B  ***LOG BYK=> current SQL statement exceeds a database limit [dbtran       7606]
B  dbtran ERROR LOG (hdl_dbsl_error): DbSl 'FET'
B   RSLT: {dbsl=2, tran=16384}
B   FHDR: {tab='SECURITY_CONTEXT', fcode=225, mode=2, bpb=0, dbcnt=0, crsr=1,
B          hold=0, keep=0, xfer=0, pkg=0, upto=0, init:b=0,
B          init:p=(nil), init:#=0, wa:p=fffffffffffec78, wa:#=148}
B  dbtran ERROR LOG (hdl_dbsl_error): DbSl 'FET'
B   STMT: {stmt:#=1, bndfld:#=4937, prop=0, distinct=0,
B          fld:#=10, alias:p=(nil), fupd:#=0, tab:#=0, where:#=3,
B          groupby:#=0, having:#=0, order:#=4095, primary=0, hint:#=0}
B   CB  ***LOG BYK=> current SQL statement exceeds a database limit [dbtran       7606]
B  dbtran ERROR LOG (hdl_dbsl_error): DbSl 'FET'
B   RSLT: {dbsl=2, tran=16384}
B   FHDR: {tab='SECURITY_CONTEXT', fcode=225, mode=2, bpb=0, dbcnt=0, crsr=1,
B          hold=0, keep=0, xfer=0, pkg=0, upto=0, init:b=0,
B          init:p=(nil), init:#=0, wa:p=fffffffffffec78, wa:#=148}
B  dbtran ERROR LOG (hdl_dbsl_error): DbSl 'FET'
B   STMT: {stmt:#=1, bndfld:#=4937, prop=0, distinct=0,
B          fld:#=10, alias:p=(nil), fupd:#=0, tab:#=0, where:#=3,
B          groupby:#=0, having:#=0, order:#=4095, primary=0, hint:#=0}
B   CRSR: {tab='SECURITY_CONTEXT', id=1, hold=0, prop=0x10000, max.in@0=0, fae:blk=1,
B          con:id=0, con:vndr=5, val=2,
B          key:#=2, xfer=0, xin:#=0, row:#=0, upto=0, wa:p=fffffffffffec78}
C  *** ERROR => DbSlExeRead: missing private_ptr in descriptor area
[dbsloci.c    3550]
C  {root-id=4FDC3C106B3F00B0E1008000AC1000A5}_{conn-id=00000000000000000000000000000000}_0

B  ***LOG BYK=> current SQL statement exceeds a database limit [dbtran       7606]
B  dbtran ERROR LOG (hdl_dbsl_error): DbSl 'FET'
B   RSLT: {dbsl=2, tran=16384}
B   FHDR: {tab='SECURITY_CONTEXT', fcode=225, mode=2, bpb=0, dbcnt=0, crsr=1,
B          hold=0, keep=0, xfer=0, pkg=0, upto=0, init:b=0,
B          init:p=(nil), init:#=0, wa:p=fffffffffffec78, wa:#=148}
B  dbtran ERROR LOG (hdl_dbsl_error): DbSl 'FET'
B   STMT: {stmt:#=1, bndfld:#=4937, prop=0, distinct=0,
B          fld:#=10, alias:p=(nil), fupd:#=0, tab:#=0, where:#=3,
B          groupby:#=0, having:#=0, order:#=4095, primary=0, hint:#=0}
B   CRSR: {tab='SECURITY_CONTEXT', id=1, hold=0, prop=0x10000, max.in@0=0, fae:blk=1,
B          con:id=0, con:vndr=5, val=2,
B          key:#=2, xfer=0, xin:#=0, row:#=0, upto=0, wa:p=fffffffffffec78}
C  *** ERROR => DbSlExeRead: missing private_ptr in descriptor area
[dbsloci.c    3550]
C  {root-id=4FDC3C106B3F00B0E1008000AC1000A5}_{conn-id=00000000000000000000000000000000}_0

B  ***LOG BYK=> current SQL statement exceeds a database limit [dbtran       7606]
B  dbtran ERROR LOG (hdl_dbsl_error): DbSl 'FET'
B   RSLT: {dbsl=2, tran=16384}
B   FHDR: {tab='SECURITY_CONTEXT', fcode=225, mode=2, bpb=0, dbcnt=0, crsr=1,
B          hold=0, keep=0, xfer=0, pkg=0, upto=0, init:b=0,
B          init:p=(nil), init:#=0, wa:p=fffffffffffec78, wa:#=148}
B  dbtran ERROR LOG (hdl_dbsl_error): DbSl 'FET'
B   STMT: {stmt:#=1, bndfld:#=4937, prop=0, distinct=0,
B          fld:#=10, alias:p=(nil), fupd:#=0, tab:#=0, where:#=3,
B          groupby:#=0, having:#=0, order:#=4095, primary=0, hint:#=0}
B   CRSR: {tab='SECURITY_CONTEXT', id=1, hold=0, prop=0x10000, max.in@0=0, fae:blk=1,
B          con:id=0, con:vndr=5, val=2,
B          key:#=2, xfer=0, xin:#=0, row:#=0, upto=0, wa:p=fffffffffffec78}
C  *** ERROR => DbSlExeRead: missing private_ptr in descriptor area
[dbsloci.c    3550]
C  {root-id=4FDC3C106B3F00B0E1008000AC1000A5}_{conn-id=00000000000000000000000000000000}_0

B  ***LOG BYK=> current SQL statement exceeds a database limit [dbtran       7606]
B  dbtran ERROR LOG (hdl_dbsl_error): DbSl 'FET'
B   RSLT: {dbsl=2, tran=16384}
B   FHDR: {tab='SECURITY_CONTEXT', fcode=225, mode=2, bpb=0, dbcnt=0, crsr=1,
B          hold=0, keep=0, xfer=0, pkg=0, upto=0, init:b=0,
B          init:p=(nil), init:#=0, wa:p=fffffffffffec78, wa:#=148}
B  dbtran ERROR LOG (hdl_dbsl_error): DbSl 'FET'
B   STMT: {stmt:#=1, bndfld:#=4937, prop=0, distinct=0,
B          fld:#=10, alias:p=(nil), fupd:#=0, tab:#=0, where:#=3,
B          groupby:#=0, having:#=0, order:#=4095, primary=0, hint:#=0}
B   CRSR: {tab='SECURITY_CONTEXT', id=1, hold=0, prop=0x10000, max.in@0=0, fae:blk=1,
B          con:id=0, con:vndr=5, val=2,
B          key:#=2, xfer=0, xin:#=0, row:#=0, upto=0, wa:p=fffffffffffec78}
C  *** ERROR => DbSlExeRead: missing private_ptr in descriptor area
[dbsloci.c    3550]
C  {root-id=4FDC3C106B3F00B0E1008000AC1000A5}_{conn-id=00000000000000000000000000000000}_0

B  ***LOG BYK=> current SQL statement exceeds a database limit [dbtran       7606]

They are quite complicated.

Regards

Deepak

[Former Member · Accepted solution]

Check you kernel version and compare it with specified in note 1567599. If needed update the kernel with the link under Download column for you kernel version

To check you kernel version execute under <sid>adm user:

disp+work -v

Regards

Roman

[Former Member]

Hi Deepak,

This is the kernel task and stcuk because of a possible deadlock or something else. Can't you kill the process at OS level?

Additionally, you can check the log on sm50 or st11. One more thing that you can activate the trace on st01 and may identify what process is running.

Best regards,

Orkun Gedik

[Former Member]

Hi Orkun,

Tried to Kill the process at OS level using dpmon but no success . not able to kill the process.

Also we are not able to cancel the work process at R/3 level.

Regards

Deepak

[Former Member]

Hi,

Is the process forks when the system is restarted, again? Can't you kill the process by the task manager or kill -9 if you are running in unix.

Best regards,

Orkun Gedik