We have a AP batch that got stuck during a month end process. Every time we try to recover the batch, a notification pops up that says 'Microsoft Dynamics GP has stopped working'.
Has anyone else encountered this issue?
*This post is locked for comments
Thanks Richard, I worked this out last night. All seems to be good now!
Follow these steps while no one is logged into GP. The standard scripts are:
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 turn the SELECT statements into DELETE statements. You may want to show the results to your IT department in the event there is a GP process that should not be stopped.
After doing this run
SELECT * from MyCompany..SY00500
Look for the batch that is getting stuck. Try to paste the results into your reply and we will take a look at it.
Thanks Shawn, I will try this tonight when everyone is logged off.
You will need access to SQL:
Try this approach - this is usually my first approach if Batch Recovery fails:
If that works, don't try posting the batch, print the edit and see if you can find any issue.
Also, if you get any specific errors, capture them and post them here.
Have you tried looking at the batch status in SQL? Sometimes you can change the batch status to zero (0) and then open the batch to recover. support.microsoft.com/.../a-batch-is-held-in-the-posting-receiving-busy-marked-locked-or-edited
Because the batch is in an error state, we can't open it to see how many transactions are in the batch. The description says 'Journal Printing Interrupted'.
How many transactions in this batch? Does the edit list tell you what is wrong? There must a reason why it gets sent to batch recovery.
It says ‘stopped working’ and kicks me out.
It stops during batch recovery and doesn’t actually ‘recover’ anything.
The next time we log back in, the prompt that comes up mentions that a batch was stuck in processing during the previous session, and that batch recovery will need to be run. Which is what we do and then it happens all over again.
(thanks for the quick response!)
Does it actually say 'not working' or 'not responding'? After you recover the batch are you printing an edit list first to see what is the issue?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (