web

You’re offline. This is a read only version of the page.

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

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
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,

Was this reply helpful? Yes No
Suggested answer

Richard Whaley 25,195 on at

Like (0)

Report

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

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans