Lock table overflow, increase -L on server

[ramyapriyacsit]

I am facing the error : Lock table overflow, increase -L on server

while running an upload program !

I tried increasing L- in parameter file of the DB and start up scripts.
I restarted the DBs.

Still i couldnt get recover from the error..

Could any one help in this !

That would be a great help !

Thanks in advance.

regards
ramya

 

[Casper]

Lock table overflow means that you have a transaction going on which locks more records then the # lock entries made available by the -L parameter.

What value does -L has now?
If it is rather low, then you could increase it. If not then maybe it is a better thing to find out why the transaction is that big and if it is really necessary to have such a big transaction.

BTW what Progress version do you have?

Regards,
Casper.

 

[ramyapriyacsit]

Casper ,

Nice to have quick reply !

I am using progress91D.
And I increased L- till 100000 still i couldn't recover from the error.

It is actually for an upload program am not aware of the no of records the develper trying load !

Please let know how i can proceed !

Thanks & Regards
Ramya

 

[Casper]

You are trying to load records in a database table?
I think you should look into make the transaction smaller in this program.
If records are related to each other then try to find the smallest repeating functional unit and use that as the transaction scope.
Otherwise try to make a transaction per 100/150 records. Then eveything should workout fine.
If an error occurs and you have to undo every loaded record then you can keep track of the records loaded and delete the records (again in a small transaction) already loaded.

HTH,

Casper.

 

[tamhas]

If this is an on-going requirement, then fix the program. If a one-time deal, you can load single-user.

 

[ramyapriyacsit]

ok thnq very much for your guidance !