Training
Module
Handle errors by using application language in Dynamics 365 Business Central - Training
Learn how to handle errors in Dynamics 365 Business Central by using application language (AL).
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
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 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.
SQLDELETE DEX_LOCK DELETE DEX_SESSIONSelect the DYNAMICS database. Then, run the following statement to delete any stuck users.
SQLDELETE ACTIVITY
Additional resources
Documentation
-
Discusses a problem that occurs if records are locked open on the server. Provides a resolution.
-
Errors when selecting a batch - Dynamics GP
Provides a solution to errors that occur when you select a batch in the Build Payroll Checks window in Microsoft Dynamics GP.
-
Errors when looking up a Purchasing batch - Dynamics GP
Provides a solution to errors that occur when trying to look up a Purchasing batch in Payables Management using Microsoft Dynamics GP.