Locking Tables

Locking Tables

Note: This affects a wide range of tables, not just 'Sales Line' table. 

This error happens when a user is running a process heavy function. For example if a user is using the Adjust Cost / Performing lots of postings / running large reports. 

Normally you will have to wait until this user has stopped running the offending process. 

To tell whether or not a use is locking a table you can do the following :

1. Log into the database through the classic client. 

2. File >> Database >> Information 

3. Click the Sessions Tab >> Then the Drill Down Arrow 

 

4. This will give you a list of all the users logged in at the moment. You can then look at who is ‘Blocking’ a table using the ‘Blocked’ Column. If its ticked you should be able to see the ‘Blocking User ID’ as well & from this you can determine what the user is running.