Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Batch Recovery Error Loop
Finance | Project Operations, Human Resources, ...
Suggested answer

Batch Recovery Error Loop

(0) ShareShare
ReportReport
Posted on by Sunil Chhabra 1,930

A payables batch is stuck in batch recovery. When attempting to recover we get the message:

A save operation on Table PM_Transaction_Open has created a duplicate key.

Please advise.

Thanks

Categories:
Microsoft Dynamics GP
  • Suggested answer
    Hokuminaria Profile Picture
    Hokuminaria 2,950 on at
    RE: Batch Recovery Error Loop

    Hello Nrpacct,

    My name is Brandon. I am a support Engineer on the Microsoft GP Team and will address your question.

    This error tells us you have a duplicated in the PM Open Table. When we get a duplicate error, what it refers to is there is record in more than one of our Transaction Tables. These tables are:

    1. PM10000 Transaction work
    2. PM10300 Payment Work.
    3. PM10400 Manual Payment work.
    4. PM20000 Transaction Open.
    5. PM30200 Transaction History.

    GP expects a record in only one of these tables.

    Now, depending if this was a Transaction or a Check batch will determine what tables you need to look at.

    If this was a Check batch, you should be able to clean up the issue with the following KB. If the problematic batch is a check batch, please try the KB below in test and determine if it resolves your issue.

    https://support.microsoft.com/en-us/help/852064/how-to-continue-a-check-run-that-was-interrupted-in-payables-managemen

    If it was an invoice batch, you will need to review all the tables for the transaction to see where they sit and remove the duplicate record with SQL. Below is a brief overview of the table you will need to review.

    1. PM00400 - You will want to look at the DCSTATUS to determine where the Key Record sees the document should be in.
      1. 1 = Work
      2. 2 = Open
      3. 3 = History.
    2. Once you determine this, you can see what transaction tables have a record for the transactions in the batch. You can use a statement like the following:
      1. Transaction Batch.

        select * from PM10000 where bachnumb = 'Batch name here'
        select * from PM20000 where bachnumb = 'Batch name here'
        select * from PM30200 where bachnumb = 'Batch name here'
      2. Check Batch

        select * from PM10300 where bachnumb = 'Batch name here'
        select * from PM10400 where bachnumb = 'Batch name here'
        select * from PM20000 where bachnumb = 'Batch name here'
        select * from PM30200 where bachnumb = 'Batch name here'

    3. This should tell you where the duplicate is. Once you determine which record is the duplicate, you can remove that from SQL and then remove the batch if there are no other transaction in the batch.
      1. If there are additional transactions in the batch, each one will need to be reviewed.
    4. You will also want to verify that these transactions updated your GL. Also your Bank Rec if it is a Check Run.

    We have additional scripting that can help us locate the duplicates if you would like to create a support case and have us take a look. We might be able to address multiple transactions in the batch as well if the batch has multiple transactions and duplicated.

    I hope this helps!

    Brandon Jarrett | Microsoft Support Engineer

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Batch Recovery Error Loop

    As suggested this will require SSMS. Here is what you can try first:

    1) Backup company database

    2) In SSMS DELETE PM00400

    3) IN GP Maintenance Check Links -> Purchasing insert Payables History and Payables Transaction Logical tables

    4) Try to recover batch now

    Do this while no one else is in GP. Let us know if this works. If not, then are other steps to correct this.

  • Leng Papio Profile Picture
    Leng Papio 855 on at
    RE: Batch Recovery Error Loop

    Unfortunately, this is not something that can be resolved thru forums. Someone needs to remote connect to your SQL server and fix that. If you can allow remote connection, I can assist. Just message me directly.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,488 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans