Unhandled Database Exception: A Save Operation on Table 'PM_Transaction_WORK' Caused a Sharing Error EXCEPTION_CLASS_DB DB_ERR_LOCKED


Symptoms


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

Resolution


To resolve this problem, follow these steps:
  1. Have all users log out of Microsoft Dynamics GP or log out of Microsoft Business Solutions - Great Plains.
  2. Start Microsoft SQL Query Analyzer.
  3. Select the TempDB database. Then, run the following statements.
    DELETE DEX_LOCK
    DELETE DEX_SESSION
  4. Select the DYNAMICS database. Then, run the following statement to delete any stuck users.
    DELETE ACTIVITY