Lock in SM12
I have a problem with the lock entries in SM12 transaction. Some users forget querys in open sessions. These lock after blocks loads that feed cubes.
I need to find this locks and delete this locks entries. This process must be automatic as a previous job to the load job.
Is it possible? I know that delete entries in SM12 transaction could be create data inconsistences but in this case the user only see data in one query from one navigator.
Other solution could be update some system parameter in RZ10: rdisp/gui_auto_logout or other similar. But I do not like because this parameters could change for other development requirements.
Thanks and regards David Sánchez.
neverthe less I would rather killthe user sessions than just to delete to lock. You may risk some inconsistencies with the queries if you delete the lock only.
To be honst I don't know any other method than to read the locks, get the users and either delete the lock or kill the user sessions by ABAP oor WEbDynpro or PRocessType, what ever you prefer.