Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

lock table.

Former Member
0 Kudos

hii,

error in change of report

error:

lock table overflow..

how to remove it.

Edited by: aks on Oct 13, 2008 1:32 AM

2 REPLIES 2

Former Member
0 Kudos

Hi,

Use

The maximum number of locks in the lock table is subject to an upper limit, which can be defined in a profile parameter. Parameter enque/table_size (see also The Most Important Profile Parameters for the Lock Concept) determines the size of the lock table in KB. You can determine both the maximum number and the current number of entries in the transaction using Extras/Statistics.

A lock table overflow can occur if:

· The lock table is configured too small

· An application sets a large number of locks

· The update process is hanging and this is passing a lot of locks onto the update task.

Afterwards you can analyze which type of locks exist and which lock owners have contributed to the lock table overflow. A history function is provided for this purpose.

Features

The following information on the last 10 lock table overflows is saved:

· The three lock owners with the most locks

· The three lock arguments with the most locks

Activities

On the List of Lock Entries screen choose the menu option Extras ® Top Capacity Used ®

· Current:

The current capacity used status is displayed.

· History

The overflow history is displayed. The person responsible, his or her user name, the time, and the number of locks are listed.

. Delete History

The overflow history is deleted

Check it with BASIS.

Source SAP Help.

Regards,

Amit