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

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

Symptoms

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

Resolution

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×