topic Table lock overflow in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/table-lock-overflow/m-p/3951684#M944659 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P>Can anyone please help me by telling the reasons and the corrective measures need to take to prevent this issue.</P></BODY></HTML> Thu, 05 Jun 2008 10:45:36 GMT Former Member 2008-06-05T10:45:36Z Table lock overflow https://community.sap.com/t5/application-development-and-automation-discussions/table-lock-overflow/m-p/3951684#M944659 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P>Can anyone please help me by telling the reasons and the corrective measures need to take to prevent this issue.</P></BODY></HTML> Thu, 05 Jun 2008 10:45:36 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-lock-overflow/m-p/3951684#M944659 Former Member 2008-06-05T10:45:36Z Re: Table lock overflow https://community.sap.com/t5/application-development-and-automation-discussions/table-lock-overflow/m-p/3951685#M944660 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>check this link Section Subsequent Analysis of Lock Table Overflows</P><P><A href="http://help.sap.com/saphelp_erp2005vp/helpdata/en/d3/43d2416d9c1c7be10000000a1550b0/frameset.htm" target="test_blank">http://help.sap.com/saphelp_erp2005vp/helpdata/en/d3/43d2416d9c1c7be10000000a1550b0/frameset.htm</A></P><P></P><P>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.</P></BODY></HTML> Fri, 06 Jun 2008 10:37:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-lock-overflow/m-p/3951685#M944660 mvoros 2008-06-06T10:37:06Z Re: Table lock overflow https://community.sap.com/t5/application-development-and-automation-discussions/table-lock-overflow/m-p/3951686#M944661 <HTML><HEAD></HEAD><BODY><P>Thanks a lot Martin.I will check this.</P></BODY></HTML> Mon, 09 Jun 2008 05:32:26 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-lock-overflow/m-p/3951686#M944661 Former Member 2008-06-09T05:32:26Z