on 12-01-2010 11:07 PM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.