SMS Error - Record Locked by Another User

Error Message

Can not edit record. Record Locked by Another User.

Explanation of Error

When you edit some records, SMS creates a temporary copy of the record (with a negative ID) so that it can work with it without changing the original copy. This error indicates that you are trying to do something that would place the record into edit mode, but there is already a temporary working copy of the record. SMS interprets this to mean another user (or window) is already editing the record.

This message can also occur when a related record can't be locked. (For example, to apply payments to an order the customer record must also be locked since customers track their balance outstanding.)

Note: Not all records use this type of locking.

Severity

Low. The user is not down. Only access to this particular record.

Possible Root Cause(s)

  1. Another user has the same record open.
  2. This user has the same record open in another window.
  3. A record was being edited when SMS was improperly closed (network failure, SSLIP failure, Ctrl-Alt-Del, or power off). This left a temporary copy of the record in the database but no user is actually using it.

Resolution 1

SMS contains a utility to remove all temporary lock files.

  1. Close ALL copies of Cyrious SMS.

**WARNING**: If any records are actually being edited (or inserted), running this utility may completely erase those records! Make sure all other users are out of SMS before running the utility.

  1. Run SMS from one computer only and close all windows in Cyrious
  2. Click on MGMT | Maintenance | Utilities | Database Cleanup.
  3. Click OK to run the utility.
  4. Confirm that you can now edit the previously locked record.
Resolution 2
  1. dbrebuild
Resolution 3
  1. Get everyone out of Cyrious and shut down the SSLIP
  2. Open the DBBrowser
  3. Navigate to the Customer table to ensure that the customer is still in the DB
  4. Navigate to the Contact table to ensure that the contacts for the customer are still the DB
  5. Open up a backup database to see if you can locate the customer and its contacts
  6. Copy the Customer and Contact tables from that folder and put in a folder called TempData
  7. Once you have found the customer in a backup, run the following two queries

SQL 1

INSERT INTO "Customer Database"
SELECT * FROM "C:\Program Files\Cyrious\SMS\TempData\Customer Database"
WHERE CustomerID = XXXX

SQL 2

INSERT INTO "Contact Database"
SELECT * FROM "C:\Program Files\Cyrious\SMS\TempData\Contact Database"
WHERE CustomerID = XXXX

Version Information

  • Reported : 06/2009
  • Version(s):
  • Fixed in : 06/2009

Related Errors

You could leave a comment if you were logged in.