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:
Have all users sign out of Microsoft Dynamics GP or sign 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
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for