Lock Table is Full (7870)

Symptoms

When exporting data from the Progress database the “Lock table is full (7870)” error is returned.

Cause

By default, the PROGRESS ODBC uses READ COMMITTED isolation level that forces the row level locking for the connection. That means that for each record that you are working with in the database within one transaction the Lock Table is updated. As Lock Table is limited in number of rows that it can keep, it may be overfilled during the export.

Solution

During data export, SQLWays does not modify data in the Progress database, so you can set the READ UNCOMMITTED for the Default Isolation Level option in the PROGRESS ODBC Driver to avoid “Lock table is full (7870)” errors.

If you have any other questions, please contact us: support@ispirer.com