Error message "User XX is busy with batch YYY" when trying to delete a Cashbook Bank Management batch using Microsoft Dynamics GP


Symptoms


You receive the following error message when you try to delete a Cashbook Bank Management batch:

        User XX is busy with batch YYY

Cause


The message can be caused by stuck records in the Cashbook Bank Management activity tables.

Resolution


To clear the stuck records, follow the steps below:
 
Note Before using the steps below, make sure to have a current backup of the company database in case you would need to restore for any reason.
 
1.  Clear the activity tables by using the Clear Activity routine.  To do this, point toTools on the Microsoft Dynamics GP menu, point Routines, point Financial, point Bank Management, and then clickClear Activity
 
2.  Click the Clear Activity button.
 
3.  Open SQL Server Management Studio using the appropriate method:
  • For SQL Server 2008 - Click Start, point toAll Programs, point to Microsoft SQL Server 2008, and then clickSQL Server Management Studio.
  • For SQL Server 2005 - Click Start, point toAll Programs, point to Microsoft SQL Server 2005, and then clickSQL Server Management Studio.
  • For SQL Server 2000 - Click Start, point toAll Programs, point to Microsoft SQL Server, and then clickQuery Analyzer.
4.  When all user are logged out of the company database, verify that there are no records in the CE Activity (CBEU1020) table by executing the statement below against the company database:

SELECT * FROM CBEU1020
 
5.  If there are any stuck records in the CE Activity (CBEU1020) table, remove them by executing the statement below against the company database:
 
DELETE CBEU1020