The above error is presented when the -L in openedge explorer had been exceeded.
β
In Openedge explorer there is an entry for "Lock entries" which has a value of 360000.
As the database grows, and labour intensive jobs are being run (i.e. month end) the number of lock entries get used.
β
This can be resolved increasing the lock entry value to 800000 in both Proclaim DB and Accounts DB.
β
Another way around this is to log most users out and then have the user run the month end or have them do the month end in batches.
Lock table overflow, increase -L on server (915) error when trying to run month end
A
Written by Antoine Larsen
Updated over 4 months ago