We have trouble in running GP. It shows "One or more batchs were interrupted during normal processing has been recovery. Use batch recovery window to contine the process batchs"
*This post is locked for comments
Most welcome ..
I try it and it works. Thank you !
The batch (May/13 BMD Revenue Accruals never Reversed) is supposedly the corrupted batch, right ?
If so, update both values MKDTOPST=0, BCHSTTUS=0 only
UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 WHERE BACHNUMB = 'May/13 BMD Revenue Accruals never Reversed'
Then, Go back and check whether you would be able to check the batch at the originating batch window. The Batch Edit List report is a must in your case in order to check for errors.
we use SQL as
SELECT * FROM [PCONS].[dbo].[SY00500] WHERE MKDTOPST <> 0
get following
MKDTOPST=1, BCHSTTUS=1 BCHCOMNT="May/13 BMD Revenue Accruals never Reversed"
Should I need put MKDTOPST=0, BCHSTTUS=0, how about BCHCOMNT?
Nothing gets released and posting stops at 10% complete. Only way to kill the process to delete the user login thru admin. Anytime anyone tries to post it it does the same thing. Think there is problems with the transactions.
If you could see it back on the batch window, have you tried printing the "Batch Edit List" before posting the batch again ?
Like I said, we can’t get to the batch edit list because we can’t get back into the batch to print it.
Can you please illustrate further on what exactly occurs on the batch recovery window.
When you "continue" the batch from the Batch Recovery Window, does it get released and you can see it back on the originating module batch window ?
If you could see it back on the batch window, have you tried printing the "Batch Edit List" before posting the batch again ?
In case the batch freezes on the batch recovery window, I would suggest releasing the batch back on the database level by running the following update statement
UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 WHERE BACHNUMB='#BatchNumber'
Now go back to the originating module batch window, and print the "Batch Edit List" report to check for any potential errors on the top of the report. In case there are no associated errors, go for posting the batch
Your feedback is highly appreciated.
We did try the batch recovery window, and unfortunately it doesn’t help (if only it was this easy!); it just freezes the batch we’re trying to recover.
To access this window navigate to: Administration > Routines > Batch Recovery. You can also go to the Microsoft Dynamics GP icon (usually upper left) > Tools > Routines > Batch Recovery.
The Batch Recovery window will allow you to view issue batches by selected series or "All". You can then mark the batch and click continue. This will release the batch back to the originating module for review.
Remember to run a Batch Edit List from the batch window and this may provide insight into why the batch had issues.
When certain posting interruption occurs, the batch will be held in the Batch Recovery Window. Go to Microsoft Dynamics GP > Tools > Routines > Batch Recovery Mark the interrupted batch, and click "Continue".
It should be taken into consideration that the Status of the interrupted batch would give you a hint on why it was interrupted. For instance, "Transaction Error, Edit Required" Status implies that certain edit is to be done on the transaction level in order for the batch to continue.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156