News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Interrupted batches

Microsoft Dynamics GP (Archived)

Interrupted batches

(0) Share

Report

Report

Posted on by Community Member

How can interrupted batches be cleared if ' batch recovery' procedure cannot clear?

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Richard Whaley 25,195 on at

Like (0)

Report

RE: Interrupted batches

Search for the batch ID in the SY00800 in the Dynamics database and change the Batch Status to 0. This has to be done in SQL Management Studio
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
RE: Interrupted batches

Check the Support article 850289 , the main essence of the article is the following:

With all the users logged out of Dynamics GP, run the following select statements

SELECT * FROM DYNAMICS..ACTIVITY

SELECT * FROM DYNAMICS..SY00800

SELECT * FROM DYNAMICS..SY00801

SELECT * FROM TEMPDB..DEX_LOCK

SELECT * FROM TEMPDB..DEX_SESSION

If any records are returned form the above, run the following delete statements;

DELETE DYNAMICS..ACTIVITY

DELETE DYNAMICS..SY00800

DELETE DYNAMICS..SY00801

DELETE TEMPDB..DEX_LOCK

DELETE TEMPDB..DEX_SESSION

UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 WHERE BACHNUMB = '#BachNumber'

Hope this helps,

Helpful resources

News and Announcements

Check out the New Agent Creator Community

Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans