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

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,848 Moderator 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

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