Lock Table Overflow

[Former Member]

When I entered transaction code UCWB (in SAP ECC 6.0 version), I got this error message "Lock Table Overflow". What is this and how to overcome this problem. Thanks for your feedback.

[Former Member · Accepted solution]

HI,

Check them below link to find out how to delete the lock entries.

http://help.sap.com/saphelp_erp2005vp/helpdata/en/d3/43d2416d9c1c7be10000000a1550b0/frameset.htm

Best Regards,

Sachin.

[Former Member]

Hi Adam,

Goto RZ10 T-Code increase the table size.

[Former Member]

Dilip,

OOP!! your solution works... I should have stopped and started SAP server instaed of just loff and log on... Thanks for your tips.

[Former Member]

Dilip, Thanks for the tip... I changed the enque/table size from 4096 to 8192 then 16384. Each time, I logoff / logon and test again with trx UCWB. However, the error "Lock table over flow" coming back each time. Any other idea... Thx.

[Former Member]

Adam,

I would appreciate if you could let me know how to change the enque/table size from 4096 to 16384. In RZ10, for profile ENQUE/TABLE_SIZE, I do not know what the version is. Thanks in advance for all your help.

[christian_wohlfahrt]

Hi,

select your profile and press F4 for the version - the last one should be the active one.

You might just change the parameter with RZ11, too - but it's not permanent, here only RZ10 will help.

Regards,

Christian

[Former Member]

The Parameter 'enque/table_size' determines the size of the lock table. Please check the size of the table vis a vis SAP recommended one and adjust the parameter accordingly.

Regards,

Dilip.