cancel
Showing results for 
Search instead for 
Did you mean: 

Problems with the table of lock is fills

Former Member
0 Kudos

Hello all

In my system in occasions repeated, the table of lock it is fills

Per this problem, I did open the message with SAP and in this message the sap support, I replied that increase the parameter value "enque/table_size" at 200 MB, this is the value for 200 MB (202752)

With the parameters implemented in my system, the table of lock to a is fills, this is not resolved my problem and continuos.

Other comment is that the value maximun is 200 MB for this lock table.

I think the problem is in the programs that executed this lock, when is executed some programs that sent the information at my stores, is when the lock table fills.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Thaks for you answer

Already enters in the transaction SM12 and see the registers in this table

with this information, I found the users that added lock in the system and the system table the which is locked.

But with this information, how can know few registers are locked per users in the SM12 and top file and history alone display this information

300 PRODUCCION1 30.11.2010 U 11/30 Nr_of_Locks: 4960 Scope: 2 0 4,960

300 PRODUCCION 30.11.2010 U 11/30 Nr_of_Locks: 5000 Scope: 2 0 5,000

300 PRODUCCION1 30.11.2010 U 11/30 Nr_of_Locks: 4918 Scope: 2 0 4,918

300 PRODUCCION1 30.11.2010 U 11/30 Nr_of_Locks: 4956 Scope: 2 0 4,956

300 PRODUCCION 30.11.2010 U 11/30 Nr_of_Locks: 5020 Scope: 2 0 5,020

300 PRODUCCION1 01.12.2010 U 12/01 Nr_of_Locks: 4911 Scope: 2 0 4,911

300 PRODUCCION1 01.12.2010 U 12/01 Nr_of_Locks: 5014 Scope: 2 0 5,014

300 PRODUCCION1 01.12.2010 U 12/01 Nr_of_Locks: 4939 Scope: 2 0 4,939

300 PRODUCCION1 01.12.2010 U 12/01 Nr_of_Locks: 190 Scope: 1 0 190

300 PRODUCCION1 01.12.2010 U 12/01 Nr_of_Locks: 191 Scope: 2 0 191

300 PRODUCCION1 01.12.2010 U 12/01 Nr_of_Locks: 4775 Scope: 2 0 4,775

300 PRODUCCION1 01.12.2010 U 12/01 Nr_of_Locks: 5022 Scope: 2 0 5,022

For my is important know which is the number of locks of this user,this I would give me an idea more clear the problem.

Former Member
0 Kudos

Hi Marco,

Did you check what program is holding so many locks in the system as I understand generally each lock is of a size of 1KB. so some program is trying to hold lock on the entire table with so many records. check with your ABAper if the logic can be corrected.

Former Member
0 Kudos

Hi Marco Gerardo ,

Lock table overflow happen due to update hangs, lock table is small or lot of locks set by user or application.

From transaction SM12, you will find program and user id to analyze further.

To obtain the raw information and particular selection data from transaction use below steps:

  • Table: "#01_002"

  • Argument: "#01_002"

  • Client: "#01"

  • User name: "#01_002"

Hope this will help you to fix your problem.

Thanks and Regards

Deepak R Patil