Issue

Progress error message: 'Lock table overflow. Increase -L on server (915)'.

Solution

Reason of the error message:

Each transaction being done with Progress will use a number of record locks. Each entry that is being accessed by a user, will take one (lock entry). The above mentioned message indicates that the operation the user currently is performing in Exact Financials C/S, is exceeding the limits of the lock table. During the operation Progress has to open and process more records than it can. For example: posting entries, copying and deleting companies.

If this message occurs during working in Exact, Progress will stop the operation and undo the partial transactions. After having restarted the database with a higher value for the record locking, the process can be restarted.

Solution:

If no value is given for the number of locks during the startup of the database(s), Progress will use the standard of 500. For working with Exact Financials C/S, use a default of 50000 If the message keeps on popping up, you can gradually increase the amount of locks as high as needed for normal operations.

To activate this setting, startup the database using the parameter -L, for example in the next database starting command:

proserve {database_name} -H {Host_name} -S {Service_name} -L 50000

In this example the standard value 50000is used. The above mentioned command can be used on Unix and Windows NT servers. For Windows NT servers it is also possible to use this command in the Procontrol functionality.

Remarks:

• The minimim value that can be given to the -L parameter is 32. The maximum value is system dependant.
  
  
• If no lock table size was specified, the default of 500 locks is used.
  
  

• If wanted it is possible for the database operator to watch the number of records currently being locked in the Progress database. This can be done using the PROMON functionality by giving in the following command at the server: promon {database_name}
  
  
  Choose option 6 'Shared resources'. At the line 'Current size of locking table' you'll see the defined value for the locking table (5024 in the example). At the line 'Locking table entries in use' you'll see the number of records that currently are being locked.
  
  
  
  

• In the Progress Explorer Tool (from version 9) this setting for the lock table entries can be found at your database entry at the properties of the  'DefaultServerGroup'.