Processes not ending in SM50

[Former Member]

Hi,

There was a short dump in our dev instance which is due to the error message "A SELECT, UPDATE, or DELETE statement contains the invalid table name A577".

This table seems to be inactive but trying to update records.

Due to this, some processess are running for long time(with error) without ending. We tried to end those sessions, but they are not ending.

The workporcess overview is as below:

0 DIA 19900 running Yes 8104 SAPLSDB2 210 ABAP DB procedure DB-PROC ??

1 DIA 19901 running Yes 1684 SAPLSDB2 210 ABAP DB procedure DB-PROC ??

2 DIA 19902 running Yes 3210 SAPLSDB2 210 ABAP DB procedure DB-PROC ??

3 DIA 23930 running Yes 2599 SAPLSDB2 210 ABAP DB procedure DB-PROC ??

4 DIA 19904 running Yes

5 UPD 19907 waiting Yes

6 ENQ 19908 waiting Yes

7 BGD 23857 waiting Yes

8 BGD 22068 waiting Yes

9 SPO 19911 waiting Yes

Though their sessions were closed from the terminal, it shows active but disconnected status in SM04.

Please suggest me the solution for this.

Thanks,

Sailesh K

[Former Member]

if u want to force end the workprocess. Although not recommended.

for AS/400: you can use command ENDJOBABN

http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/cl/endjobab.htm

regards,

Laurence...

[Former Member]

Hi,

You can end the session in OS level by using the command

kill -9 <processid shown in sm50>

Regards

Jaya Ganesh

[Former Member]

For these kind of critical errors, u need to restart the DB Instance. This will surely solve your issue, since it is mainly related with DB Restart the DB Instance, also i see most of you workprocesses being taken over by this dump, so restart as early as possible.

Regards:-

Santosh.D