Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

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

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

↑ Back to the top

Resolution

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

↑ Back to the top

Keywords: kbmbsgp10,, kbfreshness2007, kbmbspartner, kbmbsmigrate, kb

↑ Back to the top

Article Info
Article ID : 856971
Revision : 1
Created on : 1/7/2017
Published on : 7/12/2011
Exists online : False
Views : 146