Error message when you try to post a batch that has a Posting Interrupted status in the Batch Recovery window in Microsoft Dynamics GP: "Batch Failed to Complete Posting"

Article ID: 923381 - View products that this article applies to.
Expand all | Collapse all

More information

Symptoms

When you try to post a batch that has a Posting Interrupted status in the Batch Recovery window in Microsoft Dynamics GP, you receive the following error message: Batch Failed to Complete Posting. Use the Batch Recovery Window to complete the posting process. Transaction not completed at initiating scripts exist, implicitly rolled back.


Cause

This problem occurs if records are locked open on the server.

Resolution

To resolve this problem, follow these steps:  

1. Instruct all users to exit Microsoft Dynamics GP.

2. Make a full backup of Microsoft Dynamics GP that does not overwrite an existing backup. 

3. Stop and then restart the computer that is running Microsoft SQL Server.

4. Run the Check Links procedure on the Sales table and on the Financial Series table. To do this, follow these steps:  

a.In Microsoft Dynamics GP, point to Maintenance on the Microsoft Dynamics GP menu, and then click Check Links.

b.  In the Series list, click Sales, and then click the All button.

c. In the Series list, click Financial Series, and then click the All button.

d. Click OK.

e. Print the report.


5. Print the report. Start SQL Server Management Studio, and then run the following command against the DYNAMICS database.

delete ACTIVITY

delete SY00800

delete SY00801


6. Start SQL Server Management Studio, and then run the following command against the TEMPDB database.


delete DEX_LOCK

delete DEX_SESSION


7. Verify that the MKDTOPST field and the BCHSTTUS field are set to 0 for all batches in the SY00500 table.













Properties

Article ID: 923381 - Last Review: December 19, 2012 - Revision: 8.0
Applies to
  • Microsoft Dynamics GP 2013
  • Microsoft Dynamics GP 2010
  • Microsoft Dynamics GP 10.0
  • Microsoft Dynamics GP 9.0, when used with:
    • Sales Order Processing with Advanced Invoicing
Keywords: 
kbexpertiseinter kbtshoot kbmbsmigrate kbprb KB923381

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com