on 12-09-2011 6:44 AM
Hi Experts,
How to release SM12 Lock entries automatically in R/3, when it is released by another user, because of this managers unable to approve their team members request's. please advice, your help is highly appreciated.
Environment: SAP ECC 6.0 EHP 4, MSSQL 2008 R2, Win srv 2008 R2
Thanks in advance!
SathisKumar M R
Hi Sathish,
why you want to delete lock entries manually, Enque mechanism will take care of clearing lock entries once the work processes requests get completed. we have to delete long runing lock entries if you find any performance issues in system.
that tooo you have to check corresponding Update entries in SM13 before deleting lock entries.
in your case i dont think so you are doing correct thing.
-Srini
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Sathish,
As soon as the corresponding transaction or process is finished, the lock entry will be released automatically. No user intervention is required in this case.
If you have to delete it manually from SM12 transaction, please make sure no process and update record running with that user before you clear it. If you deleted the lock entry when process is active, then it will lead to data loss and inconsistencies in the system.
Hope your query is answered.
Thanks,
Siva Kumar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Satish,
When a user completes his transcation, SM12 lock entry created by that user automatically gets released.
This a standarad SAP behaviour.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
To add to Olivier's answer...
If the Locks are not been released as expected you should be monitoring the enque closely... check your developer traces for errors and or even replicate the issue while using a trace and post errors here. NEVER delete a lock without proper follow up and certainty that and update is not in progress..
Also if you had a problem with the enque locks your SM21 logs should be filled with errors.
Regards
Juan
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.