topic Re: "Lock table overflow" error msg when trying to change a repot program in Application Development and Automation Discussions

"Lock table overflow" error msg when trying to change a repot program

Former Member — Wed, 02 Apr 2008 16:48:39 GMT

hi ABAP experts,

We are getting the following error msg

"Lock table overflow

Choose 'Display object' or 'Cancel'.".

Click the question mark on the same error msg window, then the detailed error msg would like this:


Message no. MC603

Diagnosis
This table overflowed when trying to enter SAP locks in the lock table.

System Response
The locks could not be set.

Procedure
Contact your system administrator. If this error occurs frequently, change the size of the profile parameter 'enque/table_size'. This parameter defines the size of the lock table in KByte.

What would be the reason and how to resolve this problem?

<REMOVED BY MODERATOR>

Edited by: Alvaro Tejada Galindo on Apr 2, 2008 1:03 PM

Re: "Lock table overflow" error msg when trying to change a repot program

Sm1tje — Wed, 02 Apr 2008 16:58:18 GMT

I'm not quite sure what exactly you're doing in your report, but obviously you are trying to lock numerous of objects. The lock table (transaction SM12) can no longer set new locks since there is an overflow. Check your report on what it is trying to lock.

Re: "Lock table overflow" error msg when trying to change a repot program

Former Member — Wed, 02 Apr 2008 16:59:38 GMT

Hi,

This could be bcos the lock table is getting overflowed beyond the allotted space. Check if any other program/BAPI is causing continuous creation of locks.

To analyze choose (SM12) Extras Statistics to display the statistics. These are the statistics that have been compiled since the last time the lock server was restarted.

Check the below link for more information on SAP Lock Concept.

http://help.sap.com/saphelp_nw04/helpdata/en/7b/f9813712f7434be10000009b38f8cf/content.htm

For details on Subsequent Analysis of Lock Table Overflows, check the below links.

http://help.sap.com/saphelp_nw2004s/helpdata/en/d3/43d2416d9c1c7be10000000a1550b0/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/f0/b57338788f4d72e10000009b38f8cf/content.htm

Hope this helps. <REMOVED BY MODERATOR>

Thanks,

Balaji

Edited by: Alvaro Tejada Galindo on Apr 2, 2008 1:03 PM