Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004

    Question 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.
    (for example:
    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)
    Thanks, Omar

  2. #2
    Join Date
    Nov 2003
    Lomza, POLAND
    Try to increase -L parameter in your parameter file for starting Progress database server. This file ( for example) is invoked by the command:

    proserve -pf

    where contains:

    -db your-db-file
    -S tcp-port-name
    -H host-machine-name
    -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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts