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
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.
- Select the DYNAMICS database. Then, run the following statement to delete any stuck users.