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.
The following two tabs change content below.

Andy, Software Engineer

Andy is Software Engineer at Metaphorix