lock for more than 24 hours?

[Former Member]

Hello All,

Appreciate your help on this question.

If a lock entry is holding more than 24 hours then what will you do? If another user wants to share that lock but the user using that lock haven’t released lock he went for holiday what will u do? This user wants lock ASAP then what will u do?

What will you do if u got Update failure?

I have seen the answer for this question as deleting lock using sm12. However, i think this is not sate as database can go into inconsistent mode.

what's best way of handling this issue?

Thanks.

[Former Member · Accepted solution]

hi,

If the another user wants the LOCKED object, for which the lock is too old, then, there is only 1 way to free it and that is to delete the lock by SM12. But, before doing that perform the following:

1. Check with SM37, if any background job, pertaining to the lock is running or not.

2. Check the user session with SM66 and SM50, if any WP is running or not.

After only confirming that there is no job running, you can delete the lock, otherwise inconsistency may arise.

Regards,

Avishek

[Former Member · Accepted solution]

Thanks Avishek for the help.

[Former Member]

If there is a lock on table by a user for a long time, the first thing to check is whether that user is active. you can go to Tcode al08 and check if the user is active and doing something. If there is some urgency then the lock should be definitely deleted. But when you delete a lock , the changes which are done by that user are gone and everything is rolled back. So the database would be in a consistent state only. But you always have to get a confirmation from the user as he could have done so many changes to the table.

When you have update error, you can actuallyget in touch with the person who was doing that update to know what was the error. in SM13 you can have a option to repeat the update if you want.

[Former Member]

Hello,

You have to delete the lock for the other users to access the same object. Keeping a lock from a user who is in holiday is going to affect the business which must be avoided. For the database to get into inconsistent mode you must take necessary actions depending on the kind of the object

Regards,

Anand

[Former Member]

Thanks Anand for your help.