Problem/Question:

When trying to edit a record the system is presenting and error message stating that there is a lock on the database, preventing you from proceeding.

Solutions:

This can manifest itself in 2 ways.

1.  Database entry Locked (Stale Lock)

This error is displayed when a user either is no longer logged in, or their old session is stale; meaning they have since logged into again with a different session. This can be cleared by any user by simply editing and saving the record affected and clearing the lock when prompted.

2. Database entry locked (Active Lock)

The system believes the user that locked this record is still logged in, therefore this lock cannot be overwritten.

In this scenario, the user is likely to be logged in, or has closed the browser without logging out correctly with records in edit mode. To resolve this problem the user who was last editing this record will need to ensure that they re-login to the system, clearing their existing session.

Notes:

All users need to either SAVE or CANCEL records that are in edit mode before closing their sessions. Users are encouraged to logout correctly from the application menu.