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

(0) Share

Report

Posted on by GuruDofGP

248

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

I have the same question (0)

All responses (5)

Answers (0)

Heather Roggeveen 9,146 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (1)

Report

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

Was this reply helpful? Yes No
GuruDofGP 248 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
GuruDofGP 248 on at

Like (0)

Report

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."

Was this reply helpful? Yes No