Cause: Error within the lock operation ( Local Table Overflow)

[former_member69568]

Experts

W observed, Incidentally when user tries to peform some business transaction, suddently the Lock table get fills up with and all other users get "System Lock error"

either we log off user and after some time when user tried to perform same transaction.

the system and as well lock entries of that user is normal.

Why incidentally incidentally it is happening. We checked with user and they confirms they were doing normally nothing really change compare to their day to day activities.

Rgds

[Former Member · Accepted solution]

Hi,

Check Enqueue Statistics from sm12 is there are any Enqueue errors in your system. It will also show you the current status of the table. Since how long you getting this problem .. if its recent i suggest see if there is any big activity going on your system which is temperary ... if yes then see if this problem disappers after activity ..

You can do a dignosis check in sm12 too .. se if this contains any error.

Or if you want to have a permenant solution then enque/table_size increase this parameter from rz10 and restart your system.

Shailesh

Edited by: Shailesh Mamidwar on Jun 25, 2009 11:47 AM

[former_member69568 · Accepted solution]

Experts ...Thanks for all and everyone answered this message

Note 552289 - FAQ: R/3 Lock management
Note 746138 - Analyzing lock table overflows 
                       ( lock at ENQHISOVR file in the work directory )
Note 969073 - Dump due to error in lock management

Rgds

[markus_doehr2]

You may need to increase you enqueue/lock table sizes by increasing the instance parameter

enque/table_size

The default may just not be enough for your business.

Markus

[Former Member]

And if you see one single user consuming thousands of lock entries, he either has to restrict his selection or it is an application fault. If the transaction he uses is SAP standard look for SAP notes, or open a support message. If it is a customer program, then your developers will need to fix it.

Regards, Michael