We recently had a customer inquire about how they could determine which user was currently locking their bank reconciliation window. After taking a step back and contemplating our approach, we realized that the lock record is found within the tempdb database.
A simple query would be needed to get this information:
SELECT A.USERID, L.* FROM tempdb.dbo.DEX_LOCK L, DYNAMICS.dbo.ACTIVITY A
WHERE L.session_id = A.SQLSESID
AND table_path_name like ‘%CM20500’
And knowing which tables are affected helps expedite the search.
In theory, this same query (referencing a different table) can be used when you encounter similar situations in Microsoft Dynamics GP.
Dynamics GP environments often continue running successfully for years but supportability, infrastructure, reporting, and staffing considerations eventually force longer-term planning conversations.
Whether your team needs GP support today or is beginning to evaluate Dynamics 365 Business Central, BCS helps organizations navigate both sides of that transition pragmatically.
