topic Re: Lock Table Overflow in Application Development and Automation Discussions

Lock Table Overflow

Former Member — Tue, 06 May 2008 09:33:30 GMT

Hi,

I am facing problem with Lock Table Overflow Error for a program. Can anyone plz let me know, how to resolve this error?

Re: Lock Table Overflow

manuel_bassani — Tue, 06 May 2008 10:00:43 GMT

Hi Heena,

which program is it? standard or a custom one ?

If you try to lock many records passing the primary key, the lock table will quickly overflow

Perhaps you can try one of the following:

1. lock records by partial key (if possible)

2. Contact your SPA administrator and ask to add space to lock table

Have a nice day

Manuel

Re: Lock Table Overflow

Former Member — Tue, 06 May 2008 10:12:48 GMT

Hi,

Thanks for the reply.

Its a custom program, it gave an error in the PCH Env.

So need to find the reason behind this overflow.

Re: Lock Table Overflow

Sm1tje — Tue, 06 May 2008 10:23:58 GMT

Since it is a custom program, try to make sure that you only do indiviual locking of objects and don not forget to unlock them, before creating a new lock.

Re: Lock Table Overflow

Former Member — Tue, 06 May 2008 10:31:06 GMT

hiii.

in case of a custom prg...if you lock many fields then this type of errors occur.

try to lock a less number of fields.....

and always use the enqueue and dequeue function modules and fix the scope to 2.

reward if helpful..

thanks...

Re: Lock Table Overflow

Former Member — Wed, 07 May 2008 06:40:43 GMT

Hi,

Can you plz elobarate on "Scope to 2". What this says?

thanx.

Re: Lock Table Overflow

Former Member — Wed, 07 May 2008 07:01:39 GMT

hii,

scope means that if you want to pass on the lock to the update work process also or not.

there r 3 type of scope.

1. 1-the lock only remains in the prg

2. 2-the lock remains in the prg and passed on to the lock process.

3. 3 -the lock remains remains both in the prg and also in the update work process.

if more details plz revert back.

reward if heplful.

thankssss.....