I've updated the Lock Trace Utility for Dynamics GP with 2 new features.
The first enhancement will replace the standard "This batch is being edited by another user" prompt when attempting to post or delete a SOP Batch with the name of the user that has the batch locked with an activity record in SY00800.
The second enhancement will clear all records that are locked by users that are not actively logged in to GP. This will be executed when attempting to access a transaction locked by a user that is not actively logged in. After, the record will be available and the following prompt will be presented.
The basic delete statements executed by this feature are listed below:
delete tempdb.dbo.dex_lock where session_id not in (select SQLSESID from dynamics.dbo.activity)
delete tempdb.dbo.dex_session where session_id not in (select SQLSESID from dynamics.dbo.activity)
delete DYNAMICS.dbo.SY00800 where userid not in (select USERID from DYNAMICS.dbo.activity)
If you are not sure what version of the utility you have installed, since there isn't a GUI, I've updated the about message to include the version information.
Download Record Lock Trace for Dynamics GP here or view the product page for more information. Please leave a comment if there are other features or transaction types that you would like added to this utility.
This blog has been relocated from http://mbsguru.blogspot.com/ with authorization.