Question Re: How to delete lock entry ? in Technology Q&A

How to delete lock entry ?

Former Member — Sun, 01 May 2011 16:37:42 GMT

Hi.

We have many lock entry that created at yesterday.

I want to delete it but It's too many.

Is there any delete a lot of lock entry ?

Regards, Arnold.

Re: How to delete lock entry ?

Former Member — Sun, 01 May 2011 17:49:46 GMT

Hi,

You can delete lock entry using txn SM12-->Select all.

-Sanjay

Re: How to delete lock entry ?

Former Member — Mon, 02 May 2011 07:02:15 GMT

Hello Julie.

Check with the users / process owners before deleting it. Carefull. Deleting without checking results in instability of DB

Re: How to delete lock entry ?

Former Member — Mon, 02 May 2011 07:17:40 GMT

Hai Julie,

Before Deleting Lock Entries in SM12 ,u will take the Black and White Approval from the Project Manager OR U r Reporting Manager.

Thanks,

G.Rangarao

Re: How to delete lock entry ?

Former Member — Tue, 03 May 2011 11:51:14 GMT

Lock entries should only be deleted if you are sure that they are invalid and their deletion will not impair any active process (i.e user session)

To delete Lock Entries

1)Log on to respective Environment

2)Go to transaction SM12

3)Select Lock Entry

4)then select Delete All

Thanks.

Re: How to delete lock entry ?

Former Member — Thu, 05 May 2011 10:20:42 GMT

We can check the lock entries from SM12

Note the lock key of the relevant lock entry. Select this entry and choose Details to display the transaction code

so after the proper approval from the management you can delete the particular lock entry if required .

Regards

Shilpa

Re: How to delete lock entry ?

Former Member — Fri, 06 May 2011 07:53:24 GMT

Hi,

Always put the deletion of locked entry on second step. First of all always check whether you can achieve the same result by killing the user session. i always do the same sucessfully (no need to delete the entry from SM12).

- gaurav

Re: How to delete lock entry ?

naveen_kumar1 — Fri, 06 May 2011 11:58:41 GMT

Hi Arnold,

Before deleing the lock entries you should take care of the following.

Black locks are normal transaction locks. Blue locks are inherited by the update system and deleted with the corresponding update request. Blue locks are also saved in the file system and restored when the system is restarted.

SM12 -> Select All -> Delete

Regards,

Naveen.

Re: How to delete lock entry ?

JPReyes — Fri, 06 May 2011 14:07:15 GMT

I can see 7 similar answers in a row.

Posting without adding additional information is consider point-hunting.

@Julie, This is a very basic question, please research before posting.

Read the "Rules of Engagement"

Regards

Juan

Re: How to delete lock entry ?

former_member613174 — Sat, 05 Oct 2019 12:39:51 GMT

T-code - SM12

select entry which you want delete or select all.

click on delete button.