What Does Database Entry Locked Mean?
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.
Related Articles
Create a Comm Log Entry in a Sales Order
Overview It is possible to add a communication log entry from a sales order. This will then appear in the customer's Comm Log. This is useful if the customer has a query or if they want you to know something, for example changes to their ...Sales Order Data Import Mapping
Information This page contains the field mapping requirements for importing existing sales orders into Khaos Control Cloud (KCC). MANDATORY FIELDS Mandatory fields vary depending on the complexity of the data you are intending to import. Notes A ...Delete a Sales Order
Overview Sometimes you may need to delete a sales order that has been imported or created in error, or cancelled. This must be done one sales order at a time. Usage Move the sales order to any of the following stages in [Sales Invoice Manager]: ...Cancel a Sales Order
Overview You can cancel a sales order if the customer no longer wishes to purchase the items from you. See the video to show you how to do this. There are also step by step instructions below the video. Steps Ensure the payment for the order is ...Create a New Sales Order
Overview The following video explains how to create a new sales order. There are some basic instructions below the video with the steps to create a sales order. Steps Click New Sales Order in the blue button drop down. Search for the customer that ...