Locking Issue

[former_member182034]

Dear Support,
some User are facing locking issue against Material, Document, Order, Reservation.

example:

SD: When SD user is trying to access the documents then he is facing that document is blocked by same user.
MM: Material does not exist and blocked by same MM user.
PP: Order Locked by same user, Reservation does not exist:
PM: Order is saved successfully but same  Order does not exist.

When I delete the old entries from SM12 than issue resolved.
but I am getting this issue again and again. How can i solve this issue please help me.

Regards,

[Former Member · Accepted solution]

You did not supply enough information. Which transaction are the users using, what exactly are they doing?

General advice:

- do not delete locks in SM12 manually, this could lead to inconsistencies

- check if the enqueue service works: SM12 -> Extras -> Diagnosis

- if this is a SAP standard transaction then search for SAP notes or open a support message

- if this is customer coding then ask a developer to fix the transaction logic

Cheers Michael

btw: this does not seem like a oracle database issue, thus a general basis forum or maybe the SD or MM forum would be more suitable for your problem.

Edit: Hm, maybe i was not so clear about that, you should not just open another discussion. Duplicate threads are not allowed. And you don't seem to have followed my advice but just copied your initial post to http://scn.sap.com/thread/3238821 -> requested a move of this discussion over to SAP Netweaver Administrator

[Former Member]

Hi Abdul,

As told my Michael, deleting locks from SM12 should be the last resort. Because if there are running processes it might cause inconsistency. Safe option is to log off the user from SM04 from the application server.

To fix this issue you have to get in touch with application team. If standard SAP program, check for any SAP note. If custom program, check with your ABAP team.

Thanks,

Samik

[former_member182034]

hi Michael and Samik,

today, some users complained me that they are getting locking issue. I checked the locked entries in SM12 which were running from last 5 hours, so i asked by users about the locked entries then they said me that right now we are not working. I checked sessions & work process in SM51/SM50 and there were not showing any process and session against concern users.

while there are showing some failed update in SM13 please check the screenshots.

what should I have to do with this update?

Regards,

[Former Member]

Hello Abdul,

Are the Update Error's timestamp and users same with SM12 lock entry ?

Can you correlate each lock entry with failed updates ?

If yes you need to engage Functional and ABAP team to investigate these update failures. As a Basis admin you are not supposed to restart the Failed updates on your own, however if your functional team gives Go Ahead you can do that. But in this case, I see 'No Retry' which means you will probably not able to reprocess. Double click on the V1 (No Retry) row and see if the pop up gives any error message.

You can also find the source code and check if its standard or custom.

Thanks,

Samik