web

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

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,854 Moderator on at

Like (1)

Report
Copy link

Link copied!

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 > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans