Unhandled Database Exception: A Save Operation on Table 'PM_Transaction_WORK' Caused a Sharing Error EXCEPTION_CLASS_DB DB_ERR_LOCKED
After you try to print an edit list in Payables Management in Microsoft Dynamics GP or in Microsoft Business Solutions - Great Plains, you receive the following error message:
Unhandled database exception: A save operation on table 'PM_Transaction_WORK' caused a sharing error EXCEPTION_CLASS_DB DB_ERR_LOCKED
Symptoms
To resolve this problem, follow these steps:
-
Have all users log out of Microsoft Dynamics GP or log out of Microsoft Business Solutions - Great Plains.
-
Start Microsoft SQL Query Analyzer.
-
Select the TempDB database. Then, run the following statements.
DELETE DEX_LOCK DELETE DEX_SESSION
-
Select the DYNAMICS database. Then, run the following statement to delete any stuck users.
DELETE ACTIVITY