Error message when you perform the inventory reconcile procedure in Microsoft Dynamics GP: "You cannot complete this process while transactions are being edited"


Symptoms


When you perform the inventory reconcile procedure in the Reconcile Inventory Quantities window in Microsoft Dynamics GP, you receive the following error message:

You cannot complete this process while transactions are being edited.

Resolution


To resolve this problem, use one of the following methods.

Method 1

Remove the stuck activity by using Microsoft SQL Server. To do this, follow these steps:
  1. Open a query tool to run the statement. To select the appropriate tool, use the following guidelines:
    • If you are using Microsoft SQL Server 7.0 or Microsoft SQL Server 2000, run the statement in SQL Query Analyzer. To open Query Analyzer, click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.
    • If you are using Microsoft SQL Server 2000 Desktop Engine (also known as MSDE), run the statement in Support Administrator Console. To open Support Administrator Console, click Start, point to Programs, point to Microsoft Support Administrator Console, and then click Support Administrator Console.

      Note The Support Administrator Console requires a separate installation. If you do not have the program installed, you can install it by using the Microsoft Dynamics GP installation CD.
    • If you are using Microsoft SQL Server 2005 or Microsoft SQL Server 2008, run the statement in Microsoft SQL Server Management Studio. To open Management Studio, click Start, point to Programs, point to Microsoft SQL Server 2005 (or to Microsoft SQL Server 2008), and then click SQL Server Management Studio. To run a script, click New Query.
    • If you are using Microsoft SQL Server 2005 Express or Microsoft SQL Server 2008 Express, run the statement in Microsoft SQL Server Management Studio Express. To open Management Studio Express, click Start, point to Programs, point to Microsoft SQL Server 2005 (or to Microsoft SQL Server 2008), and then click SQL Server Management Studio Express. To run a script, click New Query.
  2. To run the script, follow these steps:
    1. Have all users log off from Microsoft Dynamics GP.
    2. View the contents of the following tables to verify that all users are logged off:
      • DYNAMICS..ACTIVITY
      • DYNAMICS..SY00800
      • DYNAMICS..SY00801
      • TEMPDB..DEX_LOCK
      • TEMPDB..DEX_SESSION
      To do this, run the following script.
      SELECT * FROM DYNAMICS..ACTIVITY
      SELECT * FROM DYNAMICS..SY00800
      SELECT * FROM DYNAMICS..SY00801

      SELECT * FROM TEMPDB..DEX_LOCK
      SELECT * FROM TEMPDB..DEX_SESSION
      Note When all users are logged off from Microsoft Dynamics GP, these tables do not contain any records.
    3. If results are returned, clear the stuck records by using any of the following scripts, as appropriate:
      • DELETE DYNAMICS..ACTIVITY

      • DELETE DYNAMICS..SY00800

      • DELETE DYNAMICS..SY00801


      • DELETE TEMPDB..DEX_LOCK

      • DELETE TEMPDB..DEX_SESSION

Method 2

Run the automated solution to clear the Batch Activity Table or to remove users who are locked in the Activity tables. (For more information, see "Cannot Post Batch and/or Clear Inactive Sessions" in the SYSTEM MANAGER module.)

To obtain automated solutions, visit one of the following Microsoft Web sites, depending on whether you are a partner or a customer:

Partners
Customers

References


For more information about how to install Support Administrator Console, click the following article number to view the article in the Microsoft Knowledge Base:

870052 How to install the Support Administrator Console utility in Microsoft Dynamics GP