Managing Record Locks

When a Polaris record is open, an entry is automatically made in the Object Locks table so that no one else can change the record. When the record is closed, the entry is automatically removed from the Object Locks table. Occasionally a record remains locked when it does not close correctly, as may happen when there has been a computer problem. In this case, you can unlock the record and make it available for use by deleting the appropriate entry from the Object Locks table.

Object locks are automatically removed in certain situations:

• If the staff client has closed unexpectedly and the user logs back in, that user can resume working with the objects that he or she had opened when the staff client closed unexpectedly. The object locks are automatically cleared from the Object Locks table.
• A system process automatically clears any object locks remaining in the Object Locks table when MS SQL Server has stopped and is restarted. When clients reconnect to the restarted server, all object locks are cleared.

Note:
Polaris blocks staff members with the same login from accessing the same record at the same time. The record is locked when the first user opens it.

To remove a lock on a record that did not close correctly:

Important:
Do not use this procedure for records that are actually in use.

1. In the Administration Explorer tree view, expand an organization (system, library, or branch), and expand Database Tables under the organization.

Note:
The Objects Locks table is available only in the Administration Explorer (not from an organization workform). Changes affect all organizations.

2. Select Object Locks under Database Tables. A list of record lock entries appears in the details view. The entries are sorted by record type. (Click the Staff Member column heading to sort the entries by user name.)
3. Select the entry to unlock, and click  to remove the record lock entry. The record lock entry is removed from the Object Locks table.