Table lock overflow

[Former Member]

Hi,

During the performance monitoring, we observed lock table overflow occurred for T-Code VT01N(Shipment creation) in production system on 28-MAy-08 at 15:30:10 system time for user ID XXXXXXX. In the past two months, lock table overflow occurred twice, once on 11-Apr-08 for user ID YYYYYY and on 28-MAy-08 for user ID XXXXXXXX, both for T-Code VT01N.

Can anyone please help me by telling the reasons and the corrective measures need to take to prevent this issue.

[Former Member]

Hi,

During the performance monitoring, we observed lock table overflow occurred for T-Code VT01N(Shipment creation) in production system on 28-MAy-08 at 15:30:10 system time for user ID XXXXXXX. In the past two months, lock table overflow occurred twice, once on 11-Apr-08 for user ID YYYYYY and on 28-MAy-08 for user ID XXXXXXXX, both for T-Code VT01N.

Can anyone please help me by telling the reasons and the corrective measures need to take to prevent this issue.

[mvoros]

Hi,

check this link Section Subsequent Analysis of Lock Table Overflows

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

basically you can increase the maximum number of lock to prevent this situation. You should check and carefully analyse why the current limit was not enough.

[Former Member]

Thanks a lot Martin.I will check this.