Stuck Batch Correction

Posted on: September 26, 2019 | By: Michael Angel | Microsoft Dynamics GP, Professional Services, Microsoft Dynamics Manufacturing

One of the most common issues that occur in GP is the issue of a stuck batch. A stuck batch can occur due to connection issues that can occur due to various reasons (Network Issues, Workstation errors, massive data processing etc.). While users can attempt to correct the connection issues, it is likely that at some point users will be forced to deal with a stuck batch resulting from a connection issue, even if for a few seconds.

Identifying a Stuck Batch

A batch in GP typically is has two statuses (Avaliable or No transactions). GP will indicate if a batch is busy. Examples include being edited, posted, printed, or marked for posting. These busy statuses are only brief while a batch is being processed. Allow a few minutes to pass for the below statuses, then try again:

      • Posting
      • Receiving
      • Busy
      • Marked
      • Locked
      • Edited
      • Etc.

If a batch stays in one of the above states, the user should try to restart GP and check the batch again. If the batch is still stuck with any of the above statuses, the batch is stuck.

Another way to find a stuck batch is to check the Batch Recovery Window. Tools>Routines>Batch Recovery

In some cases, a batch in the Batch Recovery Window will indicate the issue. These would include but are not limited to:

  • Marked
  • Posting Interrupted
  • Journal Printing Interrupted
  • Transaction error-Edit Required

Example of error message that can be received

If you mark the batch and hit continue and receive an error that says the batch is Busy, Marked, or Posting you have as stuck batch.

Correcting a Stuck Batch

Once a batch has been Identified as stuck you will need to correct this issue using SQL. If at this point you have little to no experience with SQL it is time to reach out to a SQL expert. Since running something incorrectly can cause damage to data only do this if you have experience with SQL. Below are the steps needed to be done in SQL.

1.Have all users exit GP

2. Open the SQL Server Management Studio.

3.Create a backup of the database

4.Run SQL Script to validate that everyone is out of system:

 

SELECT * FROM DYNAMICS..ACTIVITY

SELECT * FROM DYNAMICS..SY00800

SELECT * FROM DYNAMICS..SY00801

SELECT * FROM TEMPDB..DEX_LOCK

SELECT * FROM TEMPDB..DEX_SESSION

 

5.If no results are returned skip this step. If results are returned validate no one is working on system and run the script:

 

DELETE DYNAMICS..ACTIVITY

DELETE DYNAMICS..SY00800

DELETE DYNAMICS..SY00801

DELETE TEMPDB..DEX_LOCK

DELETE TEMPDB..DEX_SESSION

 

6.Run the following script against the company database. Replace XXX with the batch number or the name of the batch that you are trying to post or select in Microsoft Dynamics GP.

 

UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB=’XXX’

 

7.Verify the accuracy of transactions in GP.

8.Verify that you can go into the batch and post.

9.Once you have posted you have corrected the stuck batch.

 

If you would like some assistance on errors like this or you want more information around Dynamics GP, please feel free to contact Logan Consulting.

 

For additional information please feel free to reach out to us at info@loganconsulting.com or (312) 345-8817.

Logan Consulting is a professional services firm committed to helping businesses get the most from their QAD SE, QAD EE, MFG/PRO and Microsoft Dynamics AX, Microsoft Dynamics GP and Microsoft Dynamics CRM investments.
Learn More About Our Services

Does it make sense to talk with us? Contact us  to start a dialog »