Unanswered: Progress 91D - ODBC - Error LOCK TABLE IS FULL
(PROGRESS 91D) I've done an application in VB and connected to progress by ADO (and ODBC) Some times when i try to execute a delete or update sql sentence, the error LOCK TALBE IS FULL (7870) appers.
It doesn't happend just when it's a large amount of records to update/delete, it also happend whit one record. But the problem is that it doesn't happend always; some times i try the sentence with one condition, it fails, and changing it, it doesn't work.
delete from pub.TABLE where FIELD=1 ---> OK
delete from pub.TABLE where FIELD=2 ---> ERROR )
I don't have experience with progress with odbc and i don't speak english realy (spanish speaker)
Try to increase -L parameter in your parameter file for starting Progress database server. This file (server.pf for example) is invoked by the command:
proserve -pf server.pf
where server.pf contains:
-L 20 000 <- default value is 8192
However error raised by Progress server tells you, that you are updating/deleting/inserting more that 8192 records during single transaction. It's better to avoid too large transactions.