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

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

        User XX is busy with batch YYY

Symptoms

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

Cause

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

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.

×