News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Batch Stuck in Printin...

Microsoft Dynamics GP (Archived)

Batch Stuck in Printing Stage - JE over 300+ lines - How Can We Recover Without Deleting?

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

We have a patch that is stuck printing - See below:

What are our options, beyond deleting and re-entering?

Thanks,

bj

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Richard Wheeler 75,730 on at

Like (1)

Report

RE: Batch Stuck in Printing Stage - JE over 300+ lines - How Can We Recover Without Deleting?

Please do this first.

1) Have everyone exit GP

2) Go into SSMS and run this script

SELECT * FROM DYNAMICS..ACTIVITY

SELECT * FROM DYNAMICS..SY00800

SELECT * FROM DYNAMICS..SY00801

SELECT * FROM TEMPDB..DEX_SESSION

SELECT * FROM TEMPDB..DEX_LOCK

There should be no records returned for any of these. If records are returned then run this script.

DELETE DYNAMICS..ACTIVITY

DELETE DYNAMICS..SY00800

DELETE DYNAMICS..SY00801

DELETE TEMPDB..DEX_SESSION

DELETE TEMPDB..DEX_LOCK

Try to post that batch now by going to batch recovery. Tools->Routines-Batch Recovery.

If this does not solve this issue please post and we will move onto the next step.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans