Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Batch stuck in batch r...
Microsoft Dynamics GP (Archived)

Batch stuck in batch recovery, won't recover - error message

(0) ShareShare
ReportReport
Posted on by GuruDofGP 240

I have a client who has a batch stuck in batch recovery, and it doesn't recover.  There was an interruption while trying to post remotely.  The error message below is what they get when trying to post.  I've tried the standard SQL queries for stuck batches, with no results.  I ran recons and CheckLinks.  When the CheckLinks was run, it referenced duplicate key errors in the RM00400 and/or RM00401 tables.  Can someone help with getting this fixed, batch recovered and posted?

Thank you!

 

*This post is locked for comments

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,142 on at
    RE: Batch stuck in batch recovery, won't recover - error message

    Hi

    To add to Richard's advice, and if you find the issue is still not resolved, you may find that you have some partially posted transactions in the batch.  If that is the case, then you need to get very detailed in what you do in the tables.

    It will be a case of comparing data between work and open tables and making sure all transactions are in the right place.  You may find things like the transaction has inserted into open but hasn't deleted from work.

    Use the Table Descriptions listing in Dynamics GP as a guide (Tools --> Resources --> Table Descriptions).  If you have never had to troubleshoot to this level before, and you feel you want to give it a go (we all have to learn somehow), then restore your live database into a test database and play in there first.

    Some general tips on it:

    - Always, always, always have a backup that you can restore to.

    - Always do all the investigation first.  Use select statements on the various tables to isolate the transactions and to be sure you know what needs to be deleted / moved / updated before you do so.

    - Use the "Edit top xxx row" option in SQL to do edits in the tables rather than delete or update statements - it is safer.

    Cheers

    Heather

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Batch stuck in batch recovery, won't recover - error message

    Step 1) Have everyone log out of GP

    Step 2) Perform a SQL backup of your company data using SSMS

    Step 3) Run this script against your company database

    DELETE RM00401

    Step 4) Launch GP and run Check Links on the Sales series and receivables open and historical transactions.

    Check links will return a voluminous amount of data. That is normal.

    Step 5) Try Batch Recovery again

  • GuruDofGP Profile Picture
    GuruDofGP 240 on at
    RE: Batch stuck in batch recovery, won't recover - error message

    The batch Is there in Batch Recovery when opening the window, but when you click to recover it doesn't recover.  

    The error in the previous post IS the error when trying to post.  The error that appears when trying to recover the batch references a SQL duplicate on tables RM00400 or RM00401.

    I have run the SQL queries for standard stuck batches:

    SELECT * FROM DYNAMICS..ACTIVITY

    SELECT * FROM DYNAMICS..SY00800

    SELECT * FROM DYNAMICS..SY00801

    SELECT * FROM TEMPDB..DEX_LOCK

    SELECT * FROM TEMPDB..DEX_SESSION

    If you get answers / results to any of the above, make sure everyone is in fact logged out of GP and then run the following scripts to clear the tables.

    DELETE DYNAMICS..ACTIVITY

    DELETE DYNAMICS..SY00800

    DELETE DYNAMICS..SY00801

    DELETE TEMPDB..DEX_LOCK

    DELETE TEMPDB..DEX_SESSION

    Then run the following against the company database:

    UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB=’SEP16CRS’

    With no fixing it.

    Anyone have any idea how to release this cash receipt batch?

    Thanks!

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Batch stuck in batch recovery, won't recover - error message

    So when you go to the Batch Recovery screen (1) do you see the batch? (2) is this the error after you attempt to recover?

    Can you tell us what the standard SQL Queries are?  Are you looking at the SY00800 SY00500 or what?

    If you need to or want to post a picture (1) make is a bit smaller (2) use Rich formatting and then the Insert Media icon - one to the right of the CHAIN icon.

  • GuruDofGP Profile Picture
    GuruDofGP 240 on at
    RE: Batch stuck in batch recovery, won't recover - error message

    The error is (since the jpeg doesn't seem to appear or display in the page.

    "Batch SEP16CRS failed to complete posting. Use the Batch Recovery window to complete the posting process.

    A save operation on table 'RM_OPEN' has created a duplicate key."

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans