Unhandled Database Exception: A save operation on table 'PM_Transaction_WORK' caused a sharing error EXCEPTION_CLASS_DB DB_ERR_LOCKED

This article provides a solution to an error that occurs after you try to print an edit list in Payables Management in Microsoft Dynamics GP.

Applies to:   Microsoft Dynamics GP
Original KB number:   856971

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 sign out of Microsoft Dynamics GP or sign out of Microsoft Business Solutions - Great Plains.

2. Start Microsoft SQL Query Analyzer.

3. Select the TempDB database. Then, run the following statements.

   SQL

   DELETE DEX_LOCK
   DELETE DEX_SESSION
   

4. Select the DYNAMICS database. Then, run the following statement to delete any stuck users.

   SQL

   DELETE ACTIVITY