topic Re: Locking Issue in Application Development and Automation Discussions

Locking Issue

Former Member — Wed, 09 Jul 2008 05:58:10 GMT

Hi Experts,

Is there any chance to release locks explicitly set by SAP itself?

That means when we r accessing database locks are set by SAP.i need to release these locks explicitly.

Thanks in Advance

Re: Locking Issue

Former Member — Wed, 09 Jul 2008 06:08:13 GMT

Hi Siva,

The database objects or any programs can be released from locks by using transaction SM12

When u go to this transaction it lists you the objects being edited for a particular user given in the selection criteria. By selecting the objects in the list you can unlock the object.

Thanks,

Shailaja

Re: Locking Issue

Former Member — Wed, 09 Jul 2008 06:24:12 GMT

Ya, by the transaction SM12 we can unlock.

khadeer.

Re: Locking Issue

Former Member — Wed, 09 Jul 2008 06:30:47 GMT

Hi siva,

1. Go to SM12 transaction.

2. Click on List tab.

3. Then select the object whose lock u want to release.

4. then click on delete lock .

Lock will be relesed.

<REMOVED BY MODERATOR>

Thanks

Satyam

Edited by: Alvaro Tejada Galindo on Jul 9, 2008 12:01 PM

Re: Locking Issue

Former Member — Wed, 09 Jul 2008 06:35:18 GMT

Hi Siva,

To release the locks, go for the transaction code. SM12.

This transaction code will display all the LOCK entries.

Select the required lock entry.

Delete the lock record, it will deleted and lock will be released.

Using Programs:--

Go for SE11.....create one lock object with EY_ or EZ_ name convesion: eg EYLOCK1

Two function modules will be created

1) Enqueue (ENQUEUE_EYLOCK1 function module): to lock.

*2) Dequeue (DEQUEUE _EYLOCK1 function module)*: to release the lock.

call these function modules into your program and provide all the required parameters.

I think FIRST ONE will suit your requirement more.

With Regards,

Rupinder

Re: Locking Issue

Former Member — Wed, 09 Jul 2008 12:08:26 GMT

Hi All,

Thanks for ur Replies.

But enduser don't want to use SM12 every time. Is there any chance of releasing locks during runtime?

Thanks,

Re: Locking Issue

Former Member — Wed, 09 Jul 2008 12:44:42 GMT

Hi Siva.

GoTo->SE03(Transport Organizer Tools)->Request/Tasks->Unlock Objects.

Good Luck.

Harsh

Re: Locking Issue

Former Member — Wed, 09 Jul 2008 12:51:51 GMT

HI,

Write a custom program which will execute periodically!!!

Fist check at Fm ENQUEUE_READ to read locked arguments. In this it will return the lock arguments based on user level.

Call function ENQUEUE_READ by passing client no .Now it will return the lock arguments. If you want base on user level then pass Guname = sy-uname into FM. While return, it will return the table name in GNAME.

By using this GNAME call ENQUEUE Fm dynamically.

I hope this solves your problem.

Rgds,

Raghu

Re: Locking Issue

christine_evans — Wed, 09 Jul 2008 12:54:42 GMT

Locks are set by SAP for a reason ie to try and ensure data consistency. End users should not be manually releasing locks set by SAP on a regular basis. Or at all, really.