Skip to Content
0
Former Member
Oct 06, 2006 at 02:56 PM

Processes not ending in SM50

269 Views

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